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_3 | nvarchar (128) | NOT NULL | Third line of address. |
address_checksum | int | NOT NULL |
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 |