| 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 (70) | NOT NULL | County. |
| country | nvarchar (50) | NOT NULL | Country. |
| address_checksum | int (4) | ||
| Primary key | |||
| Name | Columns | Description | |
| PK_Address | address_KEY | ||