Inactive Comment TxtPrimary Ind
| Business Data Model Data Model |
| Description | The association between a resource and the study on which it is used. |
| Attributes | |
| Inactive Comment Txt |
|
| Primary Ind |
|
| Relationship | |
 usingStudyResource |
|
| usedStudyResource/1 |
|
| usedStudyResource |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Inactive Comment Txt
| Description | Additional description why the resource is no longer active. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Primary Ind
| Description | An indicator that specifies a main or principal study resource, distinguishing between an organization that is the primary funder or a funder who provides less money for a study. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
usingStudyResource
| Is Identifying Relationship | false |
| Child Table | Study Resource |
| Child Role Name | usedResource |
| 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 | Trial Resource |
| Parent Role Name | usingStudyResource |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | RESTRICT |
| Parent Referential Integrity: On Update | RESTRICT |
usedStudyResource/1
| Is Identifying Relationship | false |
| Child Table | Study Resource |
| Child Role Name | usingStudyExecution |
| 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 Execution |
| Parent Role Name | usedStudyResource |
| 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 |
usedStudyResource
| Description | |
| Is Identifying Relationship | false |
| Child Table | Study Resource |
| Child Role Name | usingStudyProtocolVersion |
| 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 Protocol |
| Parent Role Name | usedStudyResource |
| 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 |
| Business Data Model Data Model |