Difference between revisions of "OE.CATEGORIES TAB (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
 
| OE.CATEGORIES_TAB
 
| OE.CATEGORIES_TAB
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| CATEGORY_NAME
 
| CATEGORY_NAME
 
| VARCHAR2(50)
 
| VARCHAR2(50)
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| CATEGORY_DESCRIPTION
 
| CATEGORY_DESCRIPTION
 
| VARCHAR2(1000)
 
| VARCHAR2(1000)
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| CATEGORY_ID
 
| CATEGORY_ID
 
| NUMBER(2, 0)
 
| NUMBER(2, 0)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| PARENT_CATEGORY_ID
 
| PARENT_CATEGORY_ID
 
| NUMBER(2, 0)
 
| NUMBER(2, 0)
Line 49: Line 47:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| SYS_C005251
 
| SYS_C005251
 
| CATEGORY_ID
 
| CATEGORY_ID
Line 60: Line 58:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| SYS_C005252
 
| SYS_C005252
 
| Unique
 
| Unique
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005254
 
| SYS_C005254
 
| Unique
 
| Unique
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005253
 
| SYS_C005253
 
| Unique
 
| Unique
 
|  
 
|  
 
|}
 
|}

Revision as of 06:15, 24 June 2010

wikibot

Table OE.CATEGORIES_TAB

Columns

Column Data Type Nullable Default Description
CATEGORY_NAME VARCHAR2(50) null
CATEGORY_DESCRIPTION VARCHAR2(1000) null
CATEGORY_ID NUMBER(2, 0) not null
PARENT_CATEGORY_ID NUMBER(2, 0) null

Primary Key

Primary Key Columns
SYS_C005251 CATEGORY_ID

Indexes

Index Type Columns
SYS_C005252 Unique
SYS_C005254 Unique
SYS_C005253 Unique