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 |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Contact_Address_N_Address__Address__address_KEY | address_KEY | Contact_Address_N_Address |
FK_Tax_Agent_Payment_Address__Address__address_KEY | address_KEY | Tax_Agent_Payment_Address |
FK_Tax_Agent_Form_Filing_Address__Address__address_KEY | address_KEY | Tax_Agent_Form_Filing_Address |
FK_Bank_Transaction_Address__Address__address_KEY | address_KEY | Bank_Transaction_Address |