WAY1i62D

1-- FileName: TradeDDL.sql
2-- April 02 2019
3DROP TABLE IF EXISTS PatientBloodGroup_T;
4DROP TABLE IF EXISTS Patient_T;
5
6
7CREATE TABLE Patient_T (
8    PatientId CHAR( 6 ) NOT NULL,
9    Patient_FirstName VARCHAR( 30 ), -- COMMENT 'Trade Person Name',
10    Patient_LirstName VARCHAR( 30 ),
11    PatientBloodGroup CHAR( 2 ) NOT NULL,
12    Donor VARCHAR (1),
13    CONSTRAINT Patient_PK PRIMARY KEY( PatientId )
14);
15  
16  CREATE TABLE PatientBloodGroup_T (
17  PatientId CHAR( 6 ) NOT NULL,
18     RecipientBloodGroupID CHAR( 2 ) NOT NULL,
19     DonorBloodGroup CHAR (2) NOT NULL,
20    CONSTRAINT PatientBloodGroup_PK PRIMARY KEY( RecipientBloodGroupID ),
21    CONSTRAINT PatientBloodGroup_FK FOREIGN KEY( PatientId ) REFERENCES Patient_T (PatientId)
22);
23
24-- eof: TradeDDL.sql