CREATE TABLE T_Patient (
	Name VARCHAR ( 255 ) NOT NULL,
	Phone VARCHAR ( 255 ) NOT NULL,
	InsuranceCompany VARCHAR ( 255 ) NOT NULL,
	InsuranceNumber VARCHAR ( 255 ) NOT NULL,
	T_Patient_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Patient1 PRIMARY KEY (T_Patient_ID)
	);

CREATE TABLE T_Prescription (
	Date SMALLINT NOT NULL,
	PrescriptionID VARCHAR ( 255 ) NOT NULL,
	Doctor VARCHAR ( 255 ) NOT NULL,
	Drug VARCHAR ( 255 ) NOT NULL,
	Quantity SMALLINT NOT NULL,
	T_Prescription_ID INTEGER NOT NULL,
	T_Patient_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Prescription0 PRIMARY KEY (T_Prescription_ID)
	);
ALTER TABLE T_Prescription ADD CONSTRAINT FK_T_Prescription0 FOREIGN KEY (T_Patient_ID) REFERENCES T_Patient (T_Patient_ID)  ON DELETE NO ACTION ON UPDATE NO ACTION;



CREATE TABLE T_Patient-copy (
	PatientInfo VARCHAR ( 255 ) NOT NULL,
	T_Patient-copy_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Patient-copy10 PRIMARY KEY (T_Patient-copy_ID)
	);

CREATE TABLE T_Prescription-copy (
	PrescriptionInfo VARCHAR ( 255 ) NOT NULL,
	T_Prescription-copy_ID INTEGER NOT NULL,
	T_Patient-copy_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Prescription-copy9 PRIMARY KEY (T_Prescription-copy_ID)
	);
ALTER TABLE T_Prescription-copy ADD CONSTRAINT FK_T_Prescription-copy6 FOREIGN KEY (T_Patient-copy_ID) REFERENCES T_Patient-copy (T_Patient-copy_ID)  ON DELETE NO ACTION ON UPDATE NO ACTION;




CREATE TABLE T_Project (
	ProjectName VARCHAR ( 255 ) NOT NULL,
	StartDate SMALLINT NOT NULL,
	EndDate SMALLINT NOT NULL,
	BudgetCode VARCHAR ( 255 ) NOT NULL,
	T_Project_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Project2 PRIMARY KEY (T_Project_ID)
	);
CREATE TABLE T_Assignment (
	TaskName VARCHAR ( 255 ) NOT NULL,
	TaskStart SMALLINT NOT NULL,
	EsitmatedHours SMALLINT NOT NULL,
	ActualHours SMALLINT NOT NULL,
	EmployeeName VARCHAR ( 255 ) NOT NULL,
	T_Project_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Assignment3 PRIMARY KEY (T_Project_ID)
	);
ALTER TABLE T_Assignment ADD CONSTRAINT FK_T_Assignment1 FOREIGN KEY (T_Project_ID) REFERENCES T_Project (T_Project_ID)  ON DELETE NO ACTION ON UPDATE NO ACTION;





CREATE TABLE T_Student (
	StudentNumber VARCHAR ( 255 ) NOT NULL,
	StudentName VARCHAR ( 255 ) NOT NULL,
	Phone VARCHAR ( 255 ) NOT NULL,
	T_Student_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Student7 PRIMARY KEY (T_Student_ID)
	);

CREATE TABLE T_Club (
	ClubNumber VARCHAR ( 255 ) NOT NULL,
	BudgetCode VARCHAR ( 255 ) NOT NULL,
	Description VARCHAR ( 255 ) NOT NULL,
	T_Club_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Club4 PRIMARY KEY (T_Club_ID)
	);

CREATE TABLE T_0 (
	T_Club_ID INTEGER NOT NULL,
	T_Student_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_011 PRIMARY KEY (T_Club_ID, T_Student_ID)
	);
ALTER TABLE T_0 ADD CONSTRAINT FK_T_02 FOREIGN KEY (T_Club_ID) REFERENCES T_Club (T_Club_ID)  ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE T_0 ADD CONSTRAINT FK_T_03 FOREIGN KEY (T_Student_ID) REFERENCES T_Student (T_Student_ID)  ON DELETE NO ACTION ON UPDATE NO ACTION;





CREATE TABLE T_Employee (
	EmployeeName VARCHAR ( 255 ) NOT NULL,
	T_Employee_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Employee18 PRIMARY KEY (T_Employee_ID)
	);

CREATE TABLE T_Proj (
	ProjName VARCHAR ( 255 ) NOT NULL,
	T_Proj_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_Proj6 PRIMARY KEY (T_Proj_ID)
	);
CREATE TABLE T_TimeCard (
	MondayOfWeek SMALLINT NOT NULL,
	Hours SMALLINT NOT NULL,
	T_Proj_ID INTEGER NOT NULL,
	T_Employee_ID INTEGER NOT NULL,
	CONSTRAINT PK_T_TimeCard12 PRIMARY KEY (MondayOfWeek, T_Proj_ID, T_Employee_ID)
	);
ALTER TABLE T_TimeCard ADD CONSTRAINT FK_T_TimeCard4 FOREIGN KEY (T_Proj_ID) REFERENCES T_Proj (T_Proj_ID)  ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE T_TimeCard ADD CONSTRAINT FK_T_TimeCard5 FOREIGN KEY (T_Employee_ID) REFERENCES T_Employee (T_Employee_ID)  ON DELETE NO ACTION ON UPDATE NO ACTION;