Person StateProvince (table)

Modified on 2011/08/27 11:17 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| Person.StateProvince
|- valign="top"
| '''Description'''
| State and province lookup table.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| StateProvinceID
| int
| not null
| &nbsp;
| Primary key for StateProvince records.
|- valign="top"
| StateProvinceCode
| nchar(3)
| not null
| &nbsp;
| ISO standard state or province code.
|- valign="top"
| CountryRegionCode
| nvarchar(3)
| not null
| &nbsp;
| ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. 
|- valign="top"
| IsOnlyStateProvinceFlag
| dbo.Flag
| not null
| ((1))
| 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
|- valign="top"
| Name
| dbo.Name
| not null
| &nbsp;
| State or province description.
|- valign="top"
| TerritoryID
| int
| not null
| &nbsp;
| ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
|- valign="top"
| rowguid
| uniqueidentifier
| not null
| (newid())
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (getdate())
| Date and time the record was last updated.
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| PK_StateProvince_StateProvinceID
| StateProvinceID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| AK_StateProvince_Name
| Unique
| Name
|- valign="top"
| AK_StateProvince_rowguid
| Unique
| rowguid
|- valign="top"
| AK_StateProvince_StateProvinceCode_CountryRegionCode
| Unique
| StateProvinceCode, CountryRegionCode
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[Person CountryRegion (table)|Person.CountryRegion]]
| CountryRegionCode
| CountryRegionCode
|- valign="top"
| [[Sales SalesTerritory (table)|Sales.SalesTerritory]]
| TerritoryID
| TerritoryID
|}

=== Detail Tables ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[Person Address (table)|Person.Address]]
| StateProvinceID
| StateProvinceID
|- valign="top"
| [[Sales SalesTaxRate (table)|Sales.SalesTaxRate]]
| StateProvinceID
| StateProvinceID
|}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type'''
| '''Object Type'''
| '''Referenced Object'''

|- valign="top"
| Data Type
| Type
| [[dbo Flag (type)|dbo.Flag]]

|- valign="top"
| Data Type
| Type
| [[dbo Name (type)|dbo.Name]]

|- valign="top"
| Schema
| Schema
| [[Person (schema)|Person]]

|}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type'''
| '''Object Type'''
| '''Referencing Object'''

|- valign="top"
| Select
| View
| [[HumanResources vEmployee (view)|HumanResources.vEmployee]]

|- valign="top"
| Select
| View
| [[Person vStateProvinceCountryRegion (view)|Person.vStateProvinceCountryRegion]]

|- valign="top"
| Select
| View
| [[Purchasing vVendor (view)|Purchasing.vVendor]]

|- valign="top"
| Select
| View
| [[Sales vIndividualCustomer (view)|Sales.vIndividualCustomer]]

|- valign="top"
| Select
| View
| [[Sales vSalesPerson (view)|Sales.vSalesPerson]]

|- valign="top"
| Select
| View
| [[Sales vStoreWithDemographics (view)|Sales.vStoreWithDemographics]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

Person StateProvince (table)
