Difference between revisions of "HR.REGIONS (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| HR.REGIONS
 
| HR.REGIONS
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| REGION_ID
 
| REGION_ID
 
| NUMBER
 
| NUMBER
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| REGION_NAME
 
| REGION_NAME
 
| VARCHAR2(25)
 
| VARCHAR2(25)
Line 37: Line 35:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| REG_ID_PK
 
| REG_ID_PK
 
| REGION_ID
 
| REGION_ID
Line 48: Line 46:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| REGION_ID_NN
 
| REGION_ID_NN
 
| "REGION_ID" IS NOT NULL
 
| "REGION_ID" IS NOT NULL
Line 61: Line 59:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[HR.COUNTRIES_(table)|HR.COUNTRIES]]
 
| [[HR.COUNTRIES_(table)|HR.COUNTRIES]]
 
| REGION_ID
 
| REGION_ID
 
| REGION_ID
 
| REGION_ID
 
|}
 
|}

Latest revision as of 06:14, 24 June 2010

wikibot[edit]

Table HR.REGIONS

Columns[edit]

Column Data Type Nullable Default Description
REGION_ID NUMBER not null
REGION_NAME VARCHAR2(25) null

Primary Key[edit]

Primary Key Columns
REG_ID_PK REGION_ID

Check Constraints[edit]

Check Constraint Expression Description
REGION_ID_NN "REGION_ID" IS NOT NULL

Detail Tables[edit]

Detail Table Column Referencing Column
HR.COUNTRIES REGION_ID REGION_ID