ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Person.StateProvince_(table)
== 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 | | Primary key for StateProvince records. |- valign="top" | StateProvinceCode | nchar(3) | not null | | ISO standard state or province code. |- valign="top" | CountryRegionCode | nvarchar(3) | not null | | 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 | | State or province description. |- valign="top" | TerritoryID | int | not null | | 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]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Person.StateProvince |- valign="top" | '''Description''' | State and province lookup table. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | StateProvinceID | int | not null | | Primary key for StateProvince records.<br />PK_StateProvince_StateProvinceID |- | StateProvinceCode | nchar(3) | not null | | ISO standard state or province code.<br />AK_StateProvince_StateProvinceCode_CountryRegionCode |- | CountryRegionCode | nvarchar(3) | not null | | ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. <br />AK_StateProvince_StateProvinceCode_CountryRegionCode |- | IsOnlyStateProvinceFlag | Flag | not null | (1) | 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.<br /> |- | Name | Name | not null | | State or province description.<br />AK_StateProvince_Name |- | TerritoryID | int | not null | | ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.<br /> |- | rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_StateProvince_rowguid |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- | [[Person.CountryRegion_(table)|Person.CountryRegion]] | CountryRegionCode | CountryRegionCode |- | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | TerritoryID | TerritoryID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- | [[Person.Address_(table)|Person.Address]] | StateProvinceID | StateProvinceID |- | [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]] | StateProvinceID | StateProvinceID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Data Type | Type | [[dbo.Flag_(type)|dbo.Flag]] |- | Data Type | Type | [[dbo.Name_(type)|dbo.Name]] |- | Schema | Schema | [[Person_(schema)|Person]] |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- | Select | View | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] |- | Select | View | [[Person.vStateProvinceCountryRegion_(view)|Person.vStateProvinceCountryRegion]] |- | Select | View | [[Purchasing.vVendor_(view)|Purchasing.vVendor]] |- | Select | View | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] |- | Select | View | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] |- | Select | View | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.