SH.COUNTRIES (table)

From dbscript Online Help
Revision as of 20:01, 24 August 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table SH.COUNTRIES


Column Data Type Nullable Default PK Index
COUNTRY_ID NUMBER not null COUNTRIES_PK
COUNTRY_ISO_CODE CHAR(2) not null
COUNTRY_NAME VARCHAR2(40) not null
COUNTRY_SUBREGION VARCHAR2(30) not null
COUNTRY_SUBREGION_ID NUMBER not null
COUNTRY_REGION VARCHAR2(20) not null
COUNTRY_REGION_ID NUMBER not null
COUNTRY_TOTAL VARCHAR2(11) not null
COUNTRY_TOTAL_ID NUMBER not null
COUNTRY_NAME_HIST VARCHAR2(40) null


Detail Table Column Referencing Column
SH.CUSTOMERS COUNTRY_ID COUNTRY_ID