SH.COUNTRIES (table) - Revision history

Bot at 05:16, 24 June 2010

2010-06-24T05:16:34Z

Bot at 07:29, 11 February 2010

2010-02-11T07:29:30Z

Bot at 19:01, 24 August 2009

2009-08-24T19:01:27Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.COUNTRIES |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...

2009-05-02T17:06:28Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.COUNTRIES |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| SH.COUNTRIES
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''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
|
|
|
|}

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

|-
| [[SH.CUSTOMERS_(table)|SH.CUSTOMERS]]
| COUNTRY_ID
| COUNTRY_ID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | SH.COUNTRIES
@@ Line 8: / Line 8: @@
 | '''Description
 | country dimension table (snowflake)
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | COUNTRY_ID
 | NUMBER
@@ Line 27: / Line 25: @@
+|
 | primary key
-|-
+|- valign="top"
 | COUNTRY_ISO_CODE
 | CHAR(2)
@@ Line 33: / Line 31: @@
+|
+|
-|-
+|- valign="top"
 | COUNTRY_NAME
 | VARCHAR2(40)
@@ Line 39: / Line 37: @@
+|
 | country name
-|-
+|- valign="top"
 | COUNTRY_SUBREGION
 | VARCHAR2(30)
@@ Line 45: / Line 43: @@
+|
 | e.g. Western Europe, to allow hierarchies
-|-
+|- valign="top"
 | COUNTRY_SUBREGION_ID
 | NUMBER
@@ Line 51: / Line 49: @@
+|
+|
-|-
+|- valign="top"
 | COUNTRY_REGION
 | VARCHAR2(20)
@@ Line 57: / Line 55: @@
+|
 | e.g. Europe, Asia
-|-
+|- valign="top"
 | COUNTRY_REGION_ID
 | NUMBER
@@ Line 63: / Line 61: @@
+|
+|
-|-
+|- valign="top"
 | COUNTRY_TOTAL
 | VARCHAR2(11)
@@ Line 69: / Line 67: @@
+|
+|
-|-
+|- valign="top"
 | COUNTRY_TOTAL_ID
 | NUMBER
@@ Line 75: / Line 73: @@
+|
+|
-|-
+|- valign="top"
 | COUNTRY_NAME_HIST
 | VARCHAR2(40)
@@ Line 88: / Line 86: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | COUNTRIES_PK
 | COUNTRY_ID
@@ Line 99: / Line 97: @@
 | '''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
@@ Line 144: / Line 142: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[SH.CUSTOMERS_(table)|SH.CUSTOMERS]]
 | COUNTRY_ID
 | COUNTRY_ID
 |}