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...)
 
Line 34: Line 34:
 
|-
 
|-
 
| COUNTRY_NAME
 
| COUNTRY_NAME
| VARCHAR2
+
| VARCHAR2(40)
 
| not null
 
| not null
 
|  
 
|  
Line 41: Line 41:
 
|-
 
|-
 
| COUNTRY_SUBREGION
 
| COUNTRY_SUBREGION
| VARCHAR2
+
| VARCHAR2(30)
 
| not null
 
| not null
 
|  
 
|  
Line 55: Line 55:
 
|-
 
|-
 
| COUNTRY_REGION
 
| COUNTRY_REGION
| VARCHAR2
+
| VARCHAR2(20)
 
| not null
 
| not null
 
|  
 
|  
Line 69: Line 69:
 
|-
 
|-
 
| COUNTRY_TOTAL
 
| COUNTRY_TOTAL
| VARCHAR2
+
| VARCHAR2(11)
 
| not null
 
| not null
 
|  
 
|  
Line 83: Line 83:
 
|-
 
|-
 
| COUNTRY_NAME_HIST
 
| COUNTRY_NAME_HIST
| VARCHAR2
+
| VARCHAR2(40)
 
| null
 
| null
 
|  
 
|  

Revision as of 20:01, 24 August 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(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