Difference between revisions of "SH.COUNTRIES (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| SH.COUNTRIES
 
| SH.COUNTRIES
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| country dimension table (snowflake)
 
| country dimension table (snowflake)
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| COUNTRY_ID
 
| COUNTRY_ID
 
| NUMBER
 
| NUMBER
Line 27: Line 25:
 
|  
 
|  
 
| primary key
 
| primary key
|-
+
|- valign="top"
 
| COUNTRY_ISO_CODE
 
| COUNTRY_ISO_CODE
 
| CHAR(2)
 
| CHAR(2)
Line 33: Line 31:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| COUNTRY_NAME
 
| COUNTRY_NAME
 
| VARCHAR2(40)
 
| VARCHAR2(40)
Line 39: Line 37:
 
|  
 
|  
 
| country name
 
| country name
|-
+
|- valign="top"
 
| COUNTRY_SUBREGION
 
| COUNTRY_SUBREGION
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 45: Line 43:
 
|  
 
|  
 
| e.g. Western Europe, to allow hierarchies
 
| e.g. Western Europe, to allow hierarchies
|-
+
|- valign="top"
 
| COUNTRY_SUBREGION_ID
 
| COUNTRY_SUBREGION_ID
 
| NUMBER
 
| NUMBER
Line 51: Line 49:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| COUNTRY_REGION
 
| COUNTRY_REGION
 
| VARCHAR2(20)
 
| VARCHAR2(20)
Line 57: Line 55:
 
|  
 
|  
 
| e.g. Europe, Asia
 
| e.g. Europe, Asia
|-
+
|- valign="top"
 
| COUNTRY_REGION_ID
 
| COUNTRY_REGION_ID
 
| NUMBER
 
| NUMBER
Line 63: Line 61:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| COUNTRY_TOTAL
 
| COUNTRY_TOTAL
 
| VARCHAR2(11)
 
| VARCHAR2(11)
Line 69: Line 67:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| COUNTRY_TOTAL_ID
 
| COUNTRY_TOTAL_ID
 
| NUMBER
 
| NUMBER
Line 75: Line 73:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| COUNTRY_NAME_HIST
 
| COUNTRY_NAME_HIST
 
| VARCHAR2(40)
 
| VARCHAR2(40)
Line 88: Line 86:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| COUNTRIES_PK
 
| COUNTRIES_PK
 
| COUNTRY_ID
 
| COUNTRY_ID
Line 99: Line 97:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| SYS_C005180
 
| SYS_C005180
 
| "COUNTRY_ID" IS NOT NULL
 
| "COUNTRY_ID" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005181
 
| SYS_C005181
 
| "COUNTRY_ISO_CODE" IS NOT NULL
 
| "COUNTRY_ISO_CODE" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005182
 
| SYS_C005182
 
| "COUNTRY_NAME" IS NOT NULL
 
| "COUNTRY_NAME" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005183
 
| SYS_C005183
 
| "COUNTRY_SUBREGION" IS NOT NULL
 
| "COUNTRY_SUBREGION" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005184
 
| SYS_C005184
 
| "COUNTRY_SUBREGION_ID" IS NOT NULL
 
| "COUNTRY_SUBREGION_ID" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005185
 
| SYS_C005185
 
| "COUNTRY_REGION" IS NOT NULL
 
| "COUNTRY_REGION" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005186
 
| SYS_C005186
 
| "COUNTRY_REGION_ID" IS NOT NULL
 
| "COUNTRY_REGION_ID" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005187
 
| SYS_C005187
 
| "COUNTRY_TOTAL" IS NOT NULL
 
| "COUNTRY_TOTAL" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005188
 
| SYS_C005188
 
| "COUNTRY_TOTAL_ID" IS NOT NULL
 
| "COUNTRY_TOTAL_ID" IS NOT NULL
Line 144: Line 142:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[SH.CUSTOMERS_(table)|SH.CUSTOMERS]]
 
| [[SH.CUSTOMERS_(table)|SH.CUSTOMERS]]
 
| COUNTRY_ID
 
| COUNTRY_ID
 
| COUNTRY_ID
 
| COUNTRY_ID
 
|}
 
|}

Latest revision as of 06:16, 24 June 2010

wikibot[edit]

Table SH.COUNTRIES
Description country dimension table (snowflake)

Columns[edit]

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[edit]

Primary Key Columns
COUNTRIES_PK COUNTRY_ID

Check Constraints[edit]

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[edit]

Detail Table Column Referencing Column
SH.CUSTOMERS COUNTRY_ID COUNTRY_ID