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

-- 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 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;


