Person.AddressType (table)

wikibot

Table

Person.AddressType

Column	Data Type	Nullable	Default	PK	Index
AddressTypeID	int	not null		PK_AddressType_AddressTypeID
Name	dbo.Name	not null			AK_AddressType_Name
rowguid	uniqueidentifier	not null	(newid())		AK_AddressType_rowguid
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Sales.CustomerAddress	AddressTypeID	AddressTypeID
Purchasing.VendorAddress	AddressTypeID	AddressTypeID

wikivalues

Table Values

Person.AddressType

AddressTypeID	Name
6	Archive
1	Billing
2	Home
3	Main Office
4	Primary
5	Shipping

automatically generated

Table	Person.AddressType
Description	Types of addresses stored in the Address table.

Column	Data Type	Nullable	Default	Description	PK / Index
AddressTypeID	int	not null		Primary key for AddressType records.	PK_AddressType_AddressTypeID
Name	Name	not null		Address type description. For example, Billing, Home, or Shipping.	AK_AddressType_Name
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.	AK_AddressType_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Sales.CustomerAddress	AddressTypeID	AddressTypeID
Purchasing.VendorAddress	AddressTypeID	AddressTypeID