SH COUNTRIES (table)

wikibot

TableSH.COUNTRIES
Descriptioncountry dimension table (snowflake)

Columns

ColumnData TypeNullableDefaultDescription
COUNTRY_IDNUMBERnot null primary key
COUNTRY_ISO_CODECHAR(2)not null  
COUNTRY_NAMEVARCHAR2(40)not null country name
COUNTRY_SUBREGIONVARCHAR2(30)not null e.g. Western Europe, to allow hierarchies
COUNTRY_SUBREGION_IDNUMBERnot null  
COUNTRY_REGIONVARCHAR2(20)not null e.g. Europe, Asia
COUNTRY_REGION_IDNUMBERnot null  
COUNTRY_TOTALVARCHAR2(11)not null  
COUNTRY_TOTAL_IDNUMBERnot null  
COUNTRY_NAME_HISTVARCHAR2(40)null  

Primary Key

Primary KeyColumns
COUNTRIES_PKCOUNTRY_ID

Check Constraints

Check ConstraintExpressionDescription
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 TableColumnReferencing Column
SH.CUSTOMERSCOUNTRY_IDCOUNTRY_ID