Entity Patient Registry Diagnosis

DescriptionA diagnosis that specifies a disease patient registry.

For example:
ICD 9 code 250.92 specifies the diabetes patient registry

Attributes
Patient Registry Diagnosis CodePatient Registry Diagnosis Code

Relationship
Disease Patient Registry Diagnose_Disease Patient Registry_FKDisease Patient Registry Diagnose_Disease Patient Registry_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Patient Registry Diagnosis Code
DescriptionIndicates the diagnosis code specifying the registry.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Disease Patient Registry Diagnose_Disease Patient Registry_FK
Is Identifying Relationshiptrue
Child TablePatient Registry Diagnosis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableDisease Patient Registry
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE