From dbscript Online Help
wikibot
| Table
|
SH.COUNTRIES
|
| Description
|
country dimension table (snowflake)
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| COUNTRY_ID
|
NUMBER
|
not null
|
|
primary key
|
| COUNTRY_ISO_CODE
|
CHAR(2)
|
not null
|
|
|
| COUNTRY_NAME
|
VARCHAR2(40)
|
not null
|
|
country name
|
| COUNTRY_SUBREGION
|
VARCHAR2(30)
|
not null
|
|
e.g. Western Europe, to allow hierarchies
|
| COUNTRY_SUBREGION_ID
|
NUMBER
|
not null
|
|
|
| COUNTRY_REGION
|
VARCHAR2(20)
|
not null
|
|
e.g. Europe, Asia
|
| COUNTRY_REGION_ID
|
NUMBER
|
not null
|
|
|
| COUNTRY_TOTAL
|
VARCHAR2(11)
|
not null
|
|
|
| COUNTRY_TOTAL_ID
|
NUMBER
|
not null
|
|
|
| COUNTRY_NAME_HIST
|
VARCHAR2(40)
|
null
|
|
|
Primary Key
| Primary Key
|
Columns
|
| COUNTRIES_PK
|
COUNTRY_ID
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| SYS_C005180
|
"COUNTRY_ID" IS NOT NULL
|
|
| SYS_C005181
|
"COUNTRY_ISO_CODE" IS NOT NULL
|
|
| SYS_C005182
|
"COUNTRY_NAME" IS NOT NULL
|
|
| SYS_C005183
|
"COUNTRY_SUBREGION" IS NOT NULL
|
|
| SYS_C005184
|
"COUNTRY_SUBREGION_ID" IS NOT NULL
|
|
| SYS_C005185
|
"COUNTRY_REGION" IS NOT NULL
|
|
| SYS_C005186
|
"COUNTRY_REGION_ID" IS NOT NULL
|
|
| SYS_C005187
|
"COUNTRY_TOTAL" IS NOT NULL
|
|
| SYS_C005188
|
"COUNTRY_TOTAL_ID" IS NOT NULL
|
|
Detail Tables
| Detail Table
|
Column
|
Referencing Column
|
| SH.CUSTOMERS
|
COUNTRY_ID
|
COUNTRY_ID
|
