Entity Resource Provider

DescriptionAn organization or person that provides financial or other resources for the conduct of research.

For example:
National Cancer Institute
National Institutes of Health
Pharmaceutical companies

Attributes
Identification NumIdentification Num

Relationship
ResourceProvider_Person_FKResourceProvider_Person_FK
ResourceProvider_Organization_FKResourceProvider_Organization_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Identification Num
DescriptionA unique symbol that establishes identity of the resource provider.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 ResourceProvider_Person_FK
Is Identifying Relationshipfalse
Child TableResource Provider
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePerson
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 ResourceProvider_Organization_FK
Is Identifying Relationshipfalse
Child TableResource Provider
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE