ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
SH.COUNTRIES_(table)
== 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 | | primary key |- valign="top" | COUNTRY_ISO_CODE | CHAR(2) | not null | | |- valign="top" | COUNTRY_NAME | VARCHAR2(40) | not null | | country name |- valign="top" | COUNTRY_SUBREGION | VARCHAR2(30) | not null | | e.g. Western Europe, to allow hierarchies |- valign="top" | COUNTRY_SUBREGION_ID | NUMBER | not null | | |- valign="top" | COUNTRY_REGION | VARCHAR2(20) | not null | | e.g. Europe, Asia |- valign="top" | COUNTRY_REGION_ID | NUMBER | not null | | |- valign="top" | COUNTRY_TOTAL | VARCHAR2(11) | not null | | |- valign="top" | COUNTRY_TOTAL_ID | NUMBER | not null | | |- valign="top" | COUNTRY_NAME_HIST | VARCHAR2(40) | null | | |} === 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 | |- valign="top" | SYS_C005181 | "COUNTRY_ISO_CODE" IS NOT NULL | |- valign="top" | SYS_C005182 | "COUNTRY_NAME" IS NOT NULL | |- valign="top" | SYS_C005183 | "COUNTRY_SUBREGION" IS NOT NULL | |- valign="top" | SYS_C005184 | "COUNTRY_SUBREGION_ID" IS NOT NULL | |- valign="top" | SYS_C005185 | "COUNTRY_REGION" IS NOT NULL | |- valign="top" | SYS_C005186 | "COUNTRY_REGION_ID" IS NOT NULL | |- valign="top" | SYS_C005187 | "COUNTRY_TOTAL" IS NOT NULL | |- valign="top" | SYS_C005188 | "COUNTRY_TOTAL_ID" IS NOT NULL | |} === 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 |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.