Table: Address
Columns
NameTypeConstraintsDescription
address_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
address_1nvarchar (40)NOT NULLFirst line of address.
address_2nvarchar (40)NOT NULLSecond line of address.
citynvarchar (40)NOT NULLCity.
state_abbreviationnvarchar (2)NOT NULLState.
postal_codenvarchar (10)NOT NULLZipCode / postal code.
countynvarchar (25)NOT NULLCounty.
countrynvarchar (25)NOT NULLCountry.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
address_3nvarchar (128)NOT NULLThird line of address.
address_checksumintNOT NULL
Primary key
NameColumnsDescription
PK_Address$address_KEYaddress_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Address$address_checksumaddress_checksum
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Credit_Card__Address__billing__address_KEYbilling__address_KEYCredit_Card

Schema diagram