SH COUNTRIES (table)

Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| SH.COUNTRIES
|- valign="top"
| '''Description'''
| country dimension table (snowflake)
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| COUNTRY_ID
| NUMBER
| not null
| &nbsp;
| primary key
|- valign="top"
| COUNTRY_ISO_CODE
| CHAR(2)
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| COUNTRY_NAME
| VARCHAR2(40)
| not null
| &nbsp;
| country name
|- valign="top"
| COUNTRY_SUBREGION
| VARCHAR2(30)
| not null
| &nbsp;
| e.g. Western Europe, to allow hierarchies
|- valign="top"
| COUNTRY_SUBREGION_ID
| NUMBER
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| COUNTRY_REGION
| VARCHAR2(20)
| not null
| &nbsp;
| e.g. Europe, Asia
|- valign="top"
| COUNTRY_REGION_ID
| NUMBER
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| COUNTRY_TOTAL
| VARCHAR2(11)
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| COUNTRY_TOTAL_ID
| NUMBER
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| COUNTRY_NAME_HIST
| VARCHAR2(40)
| null
| &nbsp;
| &nbsp;
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| COUNTRIES_PK
| COUNTRY_ID
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| SYS_C005180
| "COUNTRY_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005181
| "COUNTRY_ISO_CODE" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005182
| "COUNTRY_NAME" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005183
| "COUNTRY_SUBREGION" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005184
| "COUNTRY_SUBREGION_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005185
| "COUNTRY_REGION" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005186
| "COUNTRY_REGION_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005187
| "COUNTRY_TOTAL" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005188
| "COUNTRY_TOTAL_ID" IS NOT NULL
| &nbsp;
|}

=== Detail Tables ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[SH CUSTOMERS (table)|SH.CUSTOMERS]]
| COUNTRY_ID
| COUNTRY_ID
|}
devio dbscript ScrewTurn Wiki

Navigation¶

SH COUNTRIES (table)
