Difference between revisions of "OE.CATEGORIES TAB (table)"

From dbscript Online Help
Jump to: navigation, search
Line 3: Line 3:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
|-
| '''table
+
| '''Table
 
| OE.CATEGORIES_TAB
 
| OE.CATEGORIES_TAB
 
|-
 
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''PK
 +
| '''Index
 +
 +
|-
 +
| CATEGORY_NAME
 +
| VARCHAR2(50)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| CATEGORY_DESCRIPTION
 +
| VARCHAR2(1000)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| CATEGORY_ID
 +
| NUMBER(2, 0)
 +
| not null
 +
|
 +
| SYS_C005251
 +
|
 +
|-
 +
| PARENT_CATEGORY_ID
 +
| NUMBER(2, 0)
 +
| null
 +
|
 +
|
 +
|
 
|}
 
|}

Revision as of 21:00, 24 August 2009

wikibot

Table OE.CATEGORIES_TAB


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