 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 , 




CREATE TABLE STAFFER_DIM
  (
    STAFFER_ID INTEGER NOT NULL ,
    FIRST_NAME VARCHAR(45) ,
    LAST_NAME  VARCHAR(45) ,
    USERNAME   VARCHAR(25)
  );
ALTER TABLE STAFFER_DIM ADD CONSTRAINT STAFFER_DIM_PK PRIMARY KEY ( STAFFER_ID ) ;

  ) ;

  
DROP TABLE IF EXISTS PERSON_DIM;
CREATE TABLE PERSON_DIM
  (
    PERSON_ID     SERIAL NOT NULL PRIMARY KEY ,
    BIRTHDATE     DATE 
  ) ;

DROP SEQUENCE IF EXISTS PERSON_SEQUENCE;
CREATE SEQUENCE PERSON_SEQUENCE;


