Overview Top Package Entity

Business Data Model Data Model

---

Entity Address

Description

A postal address that is used to contact parties or describe a location.

Attributes

Address Line 1 Descr

Address Line 2 Descr

Address Line 3 Descr

Address Line 4 Descr

Address Status

City Name

Country Code

Country Name

County Code

County Name

Postal Code

State Province Code

Relationship

Address_User_FK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Address Line 1 Descr

Description	First line of the address. Use for Primary Street and Building Number
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Line 2 Descr

Description	Second line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Line 3 Descr

Description	Third line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Line 4 Descr

Description	Fourth line of the address
Data Type	Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Address Status

Description	Indicates the current state of an address. For example: Confirmed Unconfirmed
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 City Name

Description	Name for the city of the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Country Code

Description	Indicates the country for the address using a recognized set of codes or abbreviations.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Country Name

Description	Name of the country for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Area Name [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 County Code

Description	Indicates the county for the address using a recognized set of codes or abbreviations.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 County Name

Description	The name of the county for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Area Name [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Postal Code

Description	Postal code or international postal code for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 State Province Code

Description	Indicates the state or province for the address using a recognized set of codes or abbreviations.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relationship Details

 Address_User_FK

Is Identifying Relationship	false
Child Table	Address
Child Role Name	is contact address
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	User
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

Overview Top Package Entity

Business Data Model Data Model