Entity Location Address

DescriptionAn association between a location and an address.

For example:
A postal address for an internal
A postal address for an outpatient clinic
A patient's home address

Attributes
Location Address TypeLocation Address Type

Relationship
Location Address_Location_FKLocation Address_Location_FK
Location Address_Address_FKLocation Address_Address_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Location Address Type
DescriptionIndicates the use of an address in relationship to the location.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Location Address_Location_FK
Is Identifying Relationshiptrue
Child TableLocation Address
Child Role Nameis address for
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



 Location Address_Address_FK
Is Identifying Relationshiptrue
Child TableLocation Address
Child Role Namereferences
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAddress
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE