Here’s How SQL DDL Expresses the Two Tables
Here’s How SQL DDL Expresses the Two Tables
CREATE TABLE PATIENT DELIMITER 94
(PATIENT_ID INTEGER GLOBAL ^PAT( ,
NAME CHARACTER(30) PARENT PATIENT_ID
GLOBAL ,0) PIECE 1 ,
PRIMARY KEY (PATIENT_ID START AT 0 END IF ‘{KEY} ) )
CREATE TABLE VISIT DELIMITER 94
(PATIENT_ID INTEGER GLOBAL ^PAT( ,
VISIT_ID INTEGER PARENT PATIENT_ID
GLOBAL ,1, ,
VISIT_DATE DATE PARENT VISIT_ID
GLOBAL ,0) PIECE 1 ) ,
PRIMARY KEY (PATIENT_ID START AT 0 END IF ‘(KEY) ,
VISIT_ID START AT 0 END IF ‘{KEY} ) )
^PAT(1,0)=MEYN,JULE
^PAT(1,1,1,0)=2950915