 CREATE INDEX MAILING_ADDR_ZIP_IDX on MAILING_ADDRESS_DIM(ZIP_CODE);
 
 
-DROP TABLE IF EXISTS VOTER_REPORT_FACT;
+
 CREATE TABLE VOTER_REPORT_FACT
   (
     VOTER_REPORT_ID       	SERIAL NOT NULL PRIMARY KEY , 

-- National Voter File Database Tables
-- This file contains the DDL for creating the tables, views, and indexes for
-- the national voter file data warehouse

DROP TABLE IF EXISTS DATE_DIM;
CREATE TABLE DATE_DIM




DROP TABLE IF EXISTS STAFFER_DIM;
CREATE TABLE STAFFER_DIM
  (
    STAFFER_ID INTEGER NOT NULL PRIMARY KEY,
    FIRST_NAME VARCHAR(45) ,
    LAST_NAME  VARCHAR(45) ,
    USERNAME   VARCHAR(25)
  );
