Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Person CountryRegion (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 18:00


wikibot

TablePerson.CountryRegion
DescriptionLookup table containing the ISO standard codes for countries and regions.

ColumnData TypeNullableDefaultDescription / PK / Index
CountryRegionCodenvarchar(3)not null ISO standard code for countries and regions.
PK_CountryRegion_CountryRegionCode
Namedbo.Namenot null Country or region name.
AK_CountryRegion_Name
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



Detail TableColumnReferencing Column
Sales.CountryRegionCurrencyCountryRegionCodeCountryRegionCode
Person.StateProvinceCountryRegionCodeCountryRegionCode

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployee
SelectViewPerson.vStateProvinceCountryRegion
SelectViewPurchasing.vVendor
SelectViewSales.vIndividualCustomer
SelectViewSales.vSalesPerson
SelectViewSales.vStoreWithDemographics

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