Entity Specimen Role

DescriptionThe characteristics or function that a collected specimen has.

For example:
Blind sample
Group sample
Pool of aliquots
Control specimen

Attributes
Specimen IdSpecimen Id
Specimen RoleSpecimen Role

Relationship
Specimen Role_Biospecimen_FKSpecimen Role_Biospecimen_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 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



 Specimen Role
DescriptionIndicates the characteristics or function of the specimen collected.

For example:
Blind sample
Group sample
Pool of aliquots
Control specimen
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Specimen Role_Biospecimen_FK
Is Identifying Relationshipfalse
Child TableSpecimen Role
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