Table: dbo.Address | |||
Columns | |||
Name | Type | Constraints | Description |
address_KEY | int (4) | NOT NULL | Database assigned primary key for this table. |
address_1 | nvarchar (100) | NOT NULL | First line of address. |
address_2 | nvarchar (100) | NOT NULL | Second line of address. |
city | nvarchar (60) | NOT NULL | City. |
state_abbreviation | nvarchar (4) | NOT NULL | State. |
postal_code | nvarchar (20) | NOT NULL | ZipCode / postal code. |
county | nvarchar (50) | NOT NULL | County. |
country | nvarchar (50) | NOT NULL | Country. |
address_checksum | int (4) |
Primary key | |||
Name | Columns | Description | |
PK_Address | address_KEY |