Table: address

Previous: acct_org_access_parent

Unanet Data Model

Next: adhoc_criteria_set

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	address_key	decimal(15)
2.		street1	varchar(255)
3.		street2	varchar(255)
4.		street3	varchar(2000)
5.		city	varchar(60)
6.		state_province	varchar(60)
7.		postal_code	varchar(16)
8.		country	varchar(60)

Referenced from

Table	Column	Foreign Key Name
contact_address	address_key	fk_contact_address3
customer_address	address_key	fk_customer_address2

Check Constraints

Name	Definition
cc_address_empty	([street1] IS NOT NULL OR [street2] IS NOT NULL OR [street3] IS NOT NULL OR [city] IS NOT NULL OR [state_province] IS NOT NULL OR [postal_code] IS NOT NULL OR [country] IS NOT NULL)

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_address	true	address_key	Asc