|
|
| #Begin File... CREATE DATABASE suggestion; CREATE TABLE person ( person_id serial PRIMARY KEY CONSTRAINT pk_person, last_name varchar(30), first_name varchar(30), email varchar(80) UNIQUE CONSTRAINT unique_email, password varchar(20), date_time datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND ); CREATE TABLE category ( category_id serial PRIMARY KEY CONSTRAINT pk_category, name varchar(40), desc varchar(255), date_time datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND ); CREATE TABLE suggestion ( suggestion_id serial PRIMARY KEY CONSTRAINT pk_suggestion, person_id integer, category_id integer, short_desc varchar(255), long_desc text, date_time datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND, response text, resp_person_id integer, resp_date_time datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND, FOREIGN KEY (person_id) REFERENCES person (person_id), FOREIGN KEY (category_id) REFERENCES category (category_id) ); CREATE TABLE admin ( person_id integer, category_id integer, auth_person_id integer, date_time datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND, PRIMARY KEY (person_id, category_id) CONSTRAINT pk_admin, FOREIGN KEY (person_id) REFERENCES person (person_id), FOREIGN KEY (category_id) REFERENCES category (category_id) ); GRANT resource TO public; #End File |
               |
|
Modified Tuesday, November 02, 2010 Copyright @ 2010 by Fathers' Manifesto & Christian Party |
