Application.StateProvinces_Archive
Documentation | WideWorldImporters |
Schema | Application |
Name | StateProvinces_Archive |
Modules | Application, History tables |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | StateProvinceID | int | Numeric ID used for reference to a state or province within the database | |||||
Numeric ID used for reference to a state or province within the database |
||||||||
2 | StateProvinceCode | nvarchar(5) | Common code for this state or province (such as WA - Washington for the USA) | |||||
Common code for this state or province (such as WA - Washington for the USA) |
||||||||
3 | StateProvinceName | nvarchar(50) | Formal name of the state or province | |||||
Formal name of the state or province |
||||||||
4 | CountryID | int | Country for this StateProvince | |||||
Country for this StateProvince |
||||||||
5 | SalesTerritory | nvarchar(50) | Sales territory for this StateProvince | |||||
Sales territory for this StateProvince |
||||||||
6 | Border | geography | Geographic boundary of the state or province | |||||
Geographic boundary of the state or province |
||||||||
7 | LatestRecordedPopulation | bigint | Latest available population for the StateProvince | |||||
Latest available population for the StateProvince |
||||||||
8 | LastEditedBy | int | ||||||
9 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
10 | ValidTo | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51