Entity LOINC Test Hierarchy

DescriptionA hierarchy of LOINC Test Records.

Attributes
LOINC Code Short NameLOINC Code Short Name
LOINC Test Hierarchy SeqLOINC Test Hierarchy Seq
Path To Root TxtPath To Root Txt

Relationship
LOINC Test Hierarchy_LOINC Test Record_FKLOINC Test Hierarchy_LOINC Test Record_FK
LOINC Test Hierarchy_LOINC Test Record_FK1LOINC Test Hierarchy_LOINC Test Record_FK1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 LOINC Code Short Name
DescriptionShort Name for this LOINC Code.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 LOINC Test Hierarchy Seq
DescriptionA sequence number within a LOINC Test Record Hierarchy.
Data TypeStandards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Path To Root Txt
DescriptionThe text for the LOINC Test hierarchy association.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 LOINC Test Hierarchy_LOINC Test Record_FK
Is Identifying Relationshiptrue
Child TableLOINC Test Hierarchy
Child Role Nameis parent
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableLOINC Test Record
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 LOINC Test Hierarchy_LOINC Test Record_FK1
Is Identifying Relationshiptrue
Child TableLOINC Test Hierarchy
Child Role Nameis child
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableLOINC Test Record
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE