Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

OE


Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

CATEGORIES_TAB

Columns

Column Datatype Nullable Default value Comment
CATEGORY_NAME VARCHAR2(50) Y    
CATEGORY_DESCRIPTION VARCHAR2(1000) Y    
CATEGORY_ID NUMBER(2,0) N    
PARENT_CATEGORY_ID NUMBER(2,0) Y    

Primary key

Primary key Columns
SYS_C002445 CATEGORY_ID

Unique keys

Unique key Columns
SYS_C002446  
SYS_C002447  
SYS_C002448  

Indexes

Index Type Uniqueness Columns
SYS_C002445 NORMAL UNIQUE CATEGORY_ID
SYS_C002446 NORMAL UNIQUE  
SYS_C002447 NORMAL UNIQUE  
SYS_C002448 NORMAL UNIQUE  


Generated by
OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005