Integration.City_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | City_Staging |
City staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | City Staging Key | int | Identity | Row ID within the staging table | ||||
Row ID within the staging table Identity |
||||||||
2 | WWI City ID | int | Numeric ID used for reference to a city within the WWI database | |||||
Numeric ID used for reference to a city within the WWI database |
||||||||
3 | City | nvarchar(50) | Formal name of the city | |||||
Formal name of the city |
||||||||
4 | State Province | nvarchar(50) | State or province for this city | |||||
State or province for this city |
||||||||
5 | Country | nvarchar(60) | Country name | |||||
Country name |
||||||||
6 | Continent | nvarchar(30) | Continent that this city is on | |||||
Continent that this city is on |
||||||||
7 | Sales Territory | nvarchar(50) | Sales territory for this StateProvince | |||||
Sales territory for this StateProvince |
||||||||
8 | Region | nvarchar(30) | Name of the region | |||||
Name of the region |
||||||||
9 | Subregion | nvarchar(30) | Name of the subregion | |||||
Name of the subregion |
||||||||
10 | Location | geography | Geographic location of the city | |||||
Geographic location of the city |
||||||||
11 | Latest Recorded Population | bigint | Latest available population for the City | |||||
Latest available population for the City |
||||||||
12 | Valid From | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
13 | Valid To | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Integration_City_Staging | City Staging Key | Primary key (clustered) constraint. | |
Primary key (clustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59