Entity Specimen Condition

DescriptionThe mode or state of readiness that a collected specimen has.

For example: 
Autolyzed
Clotted
Contaminated
Frozen

Attributes
Specimen ConditionSpecimen Condition
Specimen IdSpecimen Id

Relationship
Specimen Condition_Biospecimen_FKSpecimen Condition_Biospecimen_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Specimen Condition
DescriptionDescribes the nature of the specimen or its condition at time of receipt at the lab.

For example: 
Hemolyzed
Icteric
Lipemic
Autolyzed
Clotted
Contaminated
Frozen
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Specimen Id
DescriptionIdentifies an instance of a specimen. A unique series of numbers and or letters assigned by the data provider that names one and only one specimen.
Data TypeStandards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Specimen Condition_Biospecimen_FK
Is Identifying Relationshipfalse
Child TableSpecimen Condition
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSpecimen
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE