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

From dbscript Online Help
Jump to: navigation, search
Line 97: Line 97:
 
| 5
 
| 5
 
| Shipping
 
| Shipping
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Person.AddressType
 +
|-
 +
 +
| '''Description
 +
| Types of addresses stored in the Address table.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]]
 +
| AddressTypeID
 +
| AddressTypeID
 +
|-
 +
| [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
 +
| AddressTypeID
 +
| AddressTypeID
 
|}
 
|}

Revision as of 00:26, 27 November 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

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Person.AddressType_(table)&oldid=1075"