Person.Address - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Person
Name	Address
Module	People

Street address information for customers, employees, and vendors.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		AddressID	int		Identity		Primary key for Address records.
Primary key for Address records. Identity
	2		AddressLine1	nvarchar(60)				First street address line.
First street address line.
	3		AddressLine2	nvarchar(60)				Second street address line.
Second street address line.
	4		City	nvarchar(30)				Name of the city.
Name of the city.
	5		StateProvinceID	int			Person.StateProvince	Unique identification number for the state or province. Foreign key to StateProvince table.
Unique identification number for the state or province. Foreign key to StateProvince table. References: Person.StateProvince
	6		PostalCode	nvarchar(15)				Postal code for the street address.
Postal code for the street address.
	7		SpatialLocation	geography				Latitude and longitude of this address.
Latitude and longitude of this address.
	8		rowguid	uniqueidentifier		Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	9		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Person.Address		Person.StateProvince	Person.Address.StateProvinceID = Person.StateProvince.StateProvinceID	FK_Address_StateProvince_StateProvinceID Foreign key constraint referencing StateProvince.StateProvinceID.
Person.Address.StateProvinceID = Person.StateProvince.StateProvinceID Name: FK_Address_StateProvince_StateProvinceID Foreign key constraint referencing StateProvince.StateProvinceID.
Person.BusinessEntityAddress		Person.Address	Person.BusinessEntityAddress.AddressID = Person.Address.AddressID	FK_BusinessEntityAddress_Address_AddressID Foreign key constraint referencing Address.AddressID.
Person.BusinessEntityAddress.AddressID = Person.Address.AddressID Name: FK_BusinessEntityAddress_Address_AddressID Foreign key constraint referencing Address.AddressID.
Sales.SalesOrderHeader		Person.Address	Sales.SalesOrderHeader.BillToAddressID = Person.Address.AddressID	FK_SalesOrderHeader_Address_BillToAddressID Foreign key constraint referencing Address.AddressID.
Sales.SalesOrderHeader.BillToAddressID = Person.Address.AddressID Name: FK_SalesOrderHeader_Address_BillToAddressID Foreign key constraint referencing Address.AddressID.
Sales.SalesOrderHeader		Person.Address	Sales.SalesOrderHeader.ShipToAddressID = Person.Address.AddressID	FK_SalesOrderHeader_Address_ShipToAddressID Foreign key constraint referencing Address.AddressID.
Sales.SalesOrderHeader.ShipToAddressID = Person.Address.AddressID Name: FK_SalesOrderHeader_Address_ShipToAddressID Foreign key constraint referencing Address.AddressID.

Unique keys

	Key name	Columns	Description
	PK_Address_AddressID	AddressID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_Address_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.
	IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode	AddressLine1, AddressLine2, City, StateProvinceID, PostalCode	Nonclustered index.
Nonclustered index.

Uses

Name
Person.Address
Person.StateProvince

Used by

Name
Person.Address
HumanResources.vEmployee
Purchasing.vVendorWithAddresses
Sales.vIndividualCustomer
Sales.vSalesPerson
Sales.vStoreWithAddresses
Person.BusinessEntityAddress
Sales.SalesOrderHeader
Sales.SalesOrderHeader

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56