Person.StateProvince (table) - Revision history

Bot at 08:55, 27 August 2011

2011-08-27T08:55:06Z

Bot at 22:16, 23 June 2010

2010-06-23T22:16:23Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:33Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:37Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:21Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:43Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:59Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:12Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:24Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:36Z

@@ Line 90: / Line 90: @@
 | Unique
 | Name
 |- valign="top"
 | AK_StateProvince_StateProvinceCode_CountryRegionCode
 | Unique
 | StateProvinceCode, CountryRegionCode
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Person.StateProvince
@@ Line 8: / Line 8: @@
 | '''Description
 | State and province lookup table.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | StateProvinceID
@@ Line 76: / Line 74: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_StateProvince_StateProvinceID
 | StateProvinceID
@@ Line 87: / Line 85: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_StateProvince_Name
 | Unique
 | Name
-|-
+|- valign="top"
 | AK_StateProvince_StateProvinceCode_CountryRegionCode
 | Unique
 | StateProvinceCode, CountryRegionCode
-|-
+|- valign="top"
 | AK_StateProvince_rowguid
 | Unique
@@ Line 108: / Line 106: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Person.CountryRegion_(table)|Person.CountryRegion]]
 | CountryRegionCode
 | CountryRegionCode
-|-
+|- valign="top"
 | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 | TerritoryID
@@ Line 125: / Line 123: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Person.Address_(table)|Person.Address]]
 | StateProvinceID
 | StateProvinceID
-|-
+|- valign="top"
 | [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 | StateProvinceID
@@ Line 143: / Line 141: @@
 | '''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
@@ Line 167: / Line 165: @@
 | '''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

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for StateProvince records.<br />PK_StateProvince_StateProvinceID
+| Primary key for StateProvince records.
 |- valign="top"
 | StateProvinceCode
@@ Line 31: / Line 32: @@
 | not null
+|
-| ISO standard state or province code.<br />AK_StateProvince_StateProvinceCode_CountryRegionCode
+| ISO standard state or province code.
 |- valign="top"
 | CountryRegionCode
@@ Line 37: / Line 38: @@
 | not null
+|
-| ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. <br />AK_StateProvince_StateProvinceCode_CountryRegionCode
+| ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
 |- valign="top"
 | IsOnlyStateProvinceFlag
@@ Line 43: / Line 44: @@
 | not null
 | ((1))
-| 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.<br />
+| 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
 |- valign="top"
 | Name
@@ Line 49: / Line 50: @@
 | not null
+|
-| State or province description.<br />AK_StateProvince_Name
+| State or province description.
 |- valign="top"
 | TerritoryID
@@ Line 55: / Line 56: @@
 | not null
+|
-| ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.<br />
+| ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
 |- valign="top"
 | rowguid
@@ Line 61: / Line 62: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_StateProvince_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 67: / Line 68: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 88: / Line 119: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 105: / Line 136: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 121: / Line 152: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 162: / Line 198: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Person.StateProvince
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | StateProvinceID
 | int
 | not null
+|
-| PK_StateProvince_StateProvinceID
+| Primary key for StateProvince records.<br />PK_StateProvince_StateProvinceID
+|- valign="top"
 | StateProvinceCode
 | nchar(3)
 | not null
+|
+| ISO standard state or province code.<br />AK_StateProvince_StateProvinceCode_CountryRegionCode
-| AK_StateProvince_StateProvinceCode_CountryRegionCode
+|- valign="top"
 | CountryRegionCode
 | nvarchar(3)
 | not null
+|
+| ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. <br />AK_StateProvince_StateProvinceCode_CountryRegionCode
-| AK_StateProvince_StateProvinceCode_CountryRegionCode
+|- valign="top"
 | IsOnlyStateProvinceFlag
 | dbo.Flag
 | not null
 | ((1))
+| 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.<br />
+|- valign="top"
 | Name
 | dbo.Name
 | not null
+|
+| State or province description.<br />AK_StateProvince_Name
-| AK_StateProvince_Name
+|- valign="top"
 | TerritoryID
 | int
 | not null
+|
+| ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.<br />
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_StateProvince_rowguid
-| AK_StateProvince_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 110: / Line 104: @@
 | StateProvinceID
 |}
 == automatically generated ==

@@ Line 117: / Line 117: @@
 | Person.StateProvince
 |- valign="top"
 | '''Description
 | State and province lookup table.
 |-
 |}

@@ Line 224: / Line 224: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[dbo.Flag_(type)|dbo.Flag]]
@@ Line 233: / Line 233: @@
 | Type
 | Data Type
 |}
@@ Line 241: / Line 245: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]