Difference between revisions of "Person.AddressType (table)"

From dbscript Online Help
Jump to: navigation, search
Line 65: Line 65:
 
| AddressTypeID
 
| AddressTypeID
 
|}
 
|}
 
 
 
 
== wikivalues ==
 
== wikivalues ==
  

Revision as of 15:34, 3 January 2009

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