| Column | Data Type | Nullable | Default | Description / PK / Index |
| AddressID | int | not null | | Primary key for Address records.
PK_Address_AddressID |
| AddressLine1 | nvarchar(60) | not null | | First street address line.
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| AddressLine2 | nvarchar(60) | null | | Second street address line.
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| City | nvarchar(30) | not null | | Name of the city.
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| StateProvinceID | int | not null | | Unique identification number for the state or province. Foreign key to StateProvince table.
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeIX_Address_StateProvinceID |
| PostalCode | nvarchar(15) | not null | | Postal code for the street address.
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Address_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|