Entity Organization Location

DescriptionAn association between an organization and a location.

For example:
Hospital A is located on 5th street

Attributes
Relationship TypeRelationship Type

Relationship
identifiesidentifies
belongsbelongs

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Relationship Type
DescriptionIdentifies the type of the relationship between organization and location.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 identifies
Is Identifying Relationshiptrue
Child TableOrganization Location
Child Role Nameidentifies
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableLocation
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 belongs
Is Identifying Relationshiptrue
Child TableOrganization Location
Child Role Namebelongs to
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE