Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Person AddressType (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:02


wikibot

TablePerson.AddressType
DescriptionTypes of addresses stored in the Address table.

ColumnData TypeNullableDefaultDescription / PK / Index
AddressTypeIDintnot null Primary key for AddressType records.
PK_AddressType_AddressTypeID
Namedbo.Namenot null Address type description. For example, Billing, Home, or Shipping.
AK_AddressType_Name
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_AddressType_rowguid
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



Detail TableColumnReferencing Column
Sales.CustomerAddressAddressTypeIDAddressTypeID
Purchasing.VendorAddressAddressTypeIDAddressTypeID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name

Reference TypeObject TypeReferencing Object
SelectViewSales.vIndividualCustomer
SelectViewSales.vStoreWithDemographics

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.