Entity Study Subject Relationship

DescriptionAn association between two study subjects that can identify the relationship between the two.

Attributes
Relationship TypeRelationship Type

Relationship
Relationship_Subject_FKRelationship_Subject_FK
Relationship_Subject_FK1Relationship_Subject_FK1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Relationship Type
DescriptionIdentifies the nature of any relationship that exists between study subjects.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Relationship_Subject_FK
Is Identifying Relationshipfalse
Child TableStudy Subject Relationship
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableStudy Subject
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Relationship_Subject_FK1
Is Identifying Relationshipfalse
Child TableStudy Subject Relationship
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableStudy Subject
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE