Table: Address
Columns
Name | Type | Constraints | Description
address_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
address_1 | nvarchar (40) | NOT NULL | First line of address.
address_2 | nvarchar (40) | NOT NULL | Second line of address.
city | nvarchar (40) | NOT NULL | City.
state_abbreviation | nvarchar (2) | NOT NULL | State.
postal_code | nvarchar (10) | NOT NULL | ZipCode / postal code.
county | nvarchar (25) | NOT NULL | County.
country | nvarchar (25) | NOT NULL | Country.
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
address_checksum | int | NOT NULL | Checksum used for fast lookup based on address content

Primary key
Name | Columns | Description
PK_Address$address_KEY | address_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Address$address_checksum | address_checksum |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Credit_Card__Address__billing__address_KEY | billing__address_KEY | Credit_Card |