Person Address (table)
wikibot
¶
Table
Person.Address
Description
Street address information for customers, employees, and vendors.
Columns
¶
Column
Data Type
Nullable
Default
Description
AddressID
int
not null
Primary key for Address records.
AddressLine1
nvarchar(60)
not null
First street address line.
AddressLine2
nvarchar(60)
null
Second street address line.
City
nvarchar(30)
not null
Name of the city.
StateProvinceID
int
not null
Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCode
nvarchar(15)
not null
Postal code for the street address.
rowguid
uniqueidentifier
not null
(newid())
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate
datetime
not null
(getdate())
Date and time the record was last updated.
Primary Key
¶
Primary Key
Columns
PK_Address_AddressID
AddressID
Indexes
¶
Index
Type
Columns
AK_Address_rowguid
Unique
rowguid
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
Unique
AddressLine1, AddressLine2, City, StateProvinceID, PostalCode
IX_Address_StateProvinceID
StateProvinceID
Foreign Keys
¶
Relation
Column
Referenced Column
Person.StateProvince
StateProvinceID
StateProvinceID
Detail Tables
¶
Detail Table
Column
Referencing Column
Sales.CustomerAddress
AddressID
AddressID
HumanResources.EmployeeAddress
AddressID
AddressID
Sales.SalesOrderHeader
AddressID
BillToAddressID
Sales.SalesOrderHeader
AddressID
ShipToAddressID
Purchasing.VendorAddress
AddressID
AddressID
References
¶
Dependency Type
Object Type
Referenced Object
Schema
Schema
Person
Dependencies
¶
Reference Type
Object Type
Referencing Object
Select
View
HumanResources.vEmployee
Select
View
Purchasing.vVendor
Select
View
Sales.vIndividualCustomer
Select
View
Sales.vSalesPerson
Select
View
Sales.vStoreWithDemographics