Person Address (table)

wikibot

TablePerson.Address
DescriptionStreet address information for customers, employees, and vendors.

Columns

ColumnData TypeNullableDefaultDescription
AddressIDintnot null Primary key for Address records.
AddressLine1nvarchar(60)not null First street address line.
AddressLine2nvarchar(60)null Second street address line.
Citynvarchar(30)not null Name of the city.
StateProvinceIDintnot null Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCodenvarchar(15)not null Postal code for the street address.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_Address_AddressIDAddressID

Indexes

IndexTypeColumns
AK_Address_rowguidUniquerowguid
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeUniqueAddressLine1, AddressLine2, City, StateProvinceID, PostalCode
IX_Address_StateProvinceID StateProvinceID

Foreign Keys

RelationColumnReferenced Column
Person.StateProvinceStateProvinceIDStateProvinceID

Detail Tables

Detail TableColumnReferencing Column
Sales.CustomerAddressAddressIDAddressID
HumanResources.EmployeeAddressAddressIDAddressID
Sales.SalesOrderHeaderAddressIDBillToAddressID
Sales.SalesOrderHeaderAddressIDShipToAddressID
Purchasing.VendorAddressAddressIDAddressID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaPerson

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployee
SelectViewPurchasing.vVendor
SelectViewSales.vIndividualCustomer
SelectViewSales.vSalesPerson
SelectViewSales.vStoreWithDemographics