Entity Clinical Order / Orderable Item / Clinical Finding

DescriptionAn association between a clinical order and a clinical finding which identifies the clinical order a clinical finding relates to.

Attributes
Orderable ItemOrderable Item

Relationship
Clinical Order / Orderable Item / Clinical Finding_Clinical Finding_FKClinical Order / Orderable Item / Clinical Finding_Clinical Finding_FK
Clinical Order / Orderable Item / Clinical Finding_Clinical Order_FKClinical Order / Orderable Item / Clinical Finding_Clinical Order_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Orderable Item
DescriptionThe item ordered or requested on a Clinical Order or described in a Clinical Finding.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Clinical Order / Orderable Item / Clinical Finding_Clinical Finding_FK
Is Identifying Relationshiptrue
Child TableClinical Order / Orderable Item / Clinical Finding
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableClinical Finding
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Clinical Order / Orderable Item / Clinical Finding_Clinical Order_FK
Is Identifying Relationshiptrue
Child TableClinical Order / Orderable Item / Clinical Finding
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableClinical Order
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE