SH.COUNTRIES (table)

From dbscript Online Help
Jump to: navigation, search

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