SQL Must Project Multiples as Tables With Primary Keys
SQL Must Project Multiples as Tables With Primary Keys
^DIC(22,0,0)=PATIENT
^DIC(22,0,”GL”)=^PAT(
^DD(22,.01,0)=NAME^RF^^0;1^K:$L(X)>30 X
^DD(22,1,0)=VISIT^22.01^^1;0
^DD(22.01,.01)=VISIT DATE^MD^^0;1^S %DT=...
PATIENT
PATIENT_ID INTEGER
NAME CHARACTER(30)
VISIT
PATIENT_ID INTEGER
VISIT ID INTEGER
VISIT_DATE DATE