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/06/24 01:08


wikibot

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

Columns

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

Primary Key

Primary KeyColumns
PK_CountryRegion_CountryRegionCodeCountryRegionCode

Indexes

IndexTypeColumns
AK_CountryRegion_NameUniqueName

Detail Tables

Detail TableColumnReferencing Column
Sales.CountryRegionCurrencyCountryRegionCodeCountryRegionCode
Person.StateProvinceCountryRegionCodeCountryRegionCode

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaPerson

Dependencies

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.