Entity Clinical Finding / Specimen

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

Attributes
Specimen Description TxtSpecimen Description Txt

Relationship
Clinical Finding Specimen_Specimen_FKClinical Finding Specimen_Specimen_FK
Clinical Finding Specimen_Clinical Finding_FKClinical Finding Specimen_Clinical Finding_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Specimen Description Txt
DescriptionNarrative text to provide additional information describing the collected specimen.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Clinical Finding Specimen_Specimen_FK
Is Identifying Relationshiptrue
Child TableClinical Finding / Specimen
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSpecimen
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Clinical Finding Specimen_Clinical Finding_FK
Is Identifying Relationshiptrue
Child TableClinical Finding / Specimen
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