1_create_table.sql

1_create_table.sql - REVIEWS 6.create table...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 PROJECT 1. create table project(Project_ID varchar(20) NOT NULL,Title varchar(30),Archived varchar(20),Project_Status varchar(20),P r m LANGUAGE 2. create table language(Project_ID varchar(20),Language varchar(20),primary key(Project_ID,Language),foreign key(Project _ INVESTIGATOR 3. create table investigator(SSN varchar(9),First_Name varchar(20) NOT NULL, Last_Name varchar(20) NOT NULL, Organiz a WORKS_ON 4. create table works_on(Project_ID varchar(20), SSN varchar(9), Inv_Role varchar(10), primary key(Project_ID, SSN), foreig n REVIEWER 5. create table reviewer(SSN varchar(9), First_Name varchar(20), Last_Name varchar(20), primary key(SSN))
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: REVIEWS 6.create table reviews(Project_ID varchar(20), SSN varchar(9), Reviewer_Role varchar(10), primary key(Project_ID,SSN), for e CONTACT HISTORY 7. create table contact_history(Contact_ID varchar(20),Project_ID varchar(20), CP_Name varchar(20), Contact_Type varchar ( 2 Contact_REMINDER 8. create table contact_remainder(Contact_ID varchar(20), Project_ID varchar(20),Contact_Remainders varchar(20), primary Key(Contact_ID, Project_ID,Contact_Remainders),Foreign Key(Contact_ID,Project_ID) references Contact_History(Contact_ID,Project_ID))...
View Full Document

This note was uploaded on 10/26/2009 for the course CSC CSC 134 taught by Professor Jinyin during the Spring '09 term at CSU Sacramento.

Ask a homework question - tutors are online