Table: dbo.Address
Columns
NameTypeConstraintsDescription
address_KEYint (4)NOT NULLDatabase assigned primary key for this table.
address_1nvarchar (100)NOT NULLFirst line of address.
address_2nvarchar (100)NOT NULLSecond line of address.
citynvarchar (60)NOT NULLCity.
state_abbreviationnvarchar (4)NOT NULLState.
postal_codenvarchar (20)NOT NULLZipCode / postal code.
countynvarchar (50)NOT NULLCounty.
countrynvarchar (50)NOT NULLCountry.
address_checksumint (4)
Primary key
NameColumnsDescription
PK_Addressaddress_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Contact_Address_N_Address__Address__address_KEYaddress_KEYContact_Address_N_Address
FK_Tax_Agent_Payment_Address__Address__address_KEYaddress_KEYTax_Agent_Payment_Address
FK_Tax_Agent_Form_Filing_Address__Address__address_KEYaddress_KEYTax_Agent_Form_Filing_Address
FK_Bank_Transaction_Address__Address__address_KEYaddress_KEYBank_Transaction_Address

Schema diagram