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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.COUNTRIES |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...)
(No difference)

Revision as of 18:06, 2 May 2009

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 not null
COUNTRY_SUBREGION VARCHAR2 not null
COUNTRY_SUBREGION_ID NUMBER not null
COUNTRY_REGION VARCHAR2 not null
COUNTRY_REGION_ID NUMBER not null
COUNTRY_TOTAL VARCHAR2 not null
COUNTRY_TOTAL_ID NUMBER not null
COUNTRY_NAME_HIST VARCHAR2 null


Detail Table Column Referencing Column
SH.CUSTOMERS COUNTRY_ID COUNTRY_ID