Welcome Guest, you are in: <root> • Login

Page History: Person CountryRegion (table)

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

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

Page Revision: 2010/01/09 18:00

wikibot ¶

Table	Person.CountryRegion
Description	Lookup table containing the ISO standard codes for countries and regions.

Column	Data Type	Nullable	Default	Description / PK / Index
CountryRegionCode	nvarchar(3)	not null		ISO standard code for countries and regions. PK_CountryRegion_CountryRegionCode
Name	dbo.Name	not null		Country or region name. AK_CountryRegion_Name
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Sales.CountryRegionCurrency	CountryRegionCode	CountryRegionCode
Person.StateProvince	CountryRegionCode	CountryRegionCode

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployee
Select	View	Person.vStateProvinceCountryRegion
Select	View	Purchasing.vVendor
Select	View	Sales.vIndividualCustomer
Select	View	Sales.vSalesPerson
Select	View	Sales.vStoreWithDemographics