describedStudySiteProtocolVersionRelationshipexecutedStudySiteProtocolVersionRelationshipexecutingStudySiteProtocolVersionRelationship
| Business Data Model Data Model |
| Description | The link that exists between a study site and a version of the study protocol used or available for use at that site. Even if a study site's IRB has not reviewed the study protocol version, if there is a new version for the study protocol, then there is the potential for a relationship between the site and the version. |
| Relationship | |
| describedStudySiteProtocolVersionRelationship |
|
| executedStudySiteProtocolVersionRelationship |
|
| executingStudySiteProtocolVersionRelationship |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Relationship Details |
describedStudySiteProtocolVersionRelationship
| Is Identifying Relationship | false |
| Child Table | Study Site / Protocol |
| Child Role Name | describingStudySiteOversightStatus |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | SET_NULL |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | SET_NULL |
| Parent Table | Study Site Oversight Status |
| Parent Role Name | describedStudySiteProtocolVersionRelationship |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | SET_NULL |
| Parent Referential Integrity: On Update | SET_NULL |
executedStudySiteProtocolVersionRelationship
| Description | |
| Is Identifying Relationship | false |
| Child Table | Study Site / Protocol |
| Child Role Name | executingStudySite |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | RESTRICT |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | RESTRICT |
| Parent Table | Study Site |
| Parent Role Name | executedStudySiteProtocolVersionRelationship |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | RESTRICT |
| Parent Referential Integrity: On Update | RESTRICT |
executingStudySiteProtocolVersionRelationship
| Is Identifying Relationship | false |
| Child Table | Study Site / Protocol |
| Child Role Name | executedStudyProtocolVersion |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | RESTRICT |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | RESTRICT |
| Parent Table | Study Protocol |
| Parent Role Name | executingStudySiteProtocolVersionRelationship |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | RESTRICT |
| Parent Referential Integrity: On Update | RESTRICT |
| Business Data Model Data Model |