|
OE |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
| 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 | Columns |
| SYS_C002445 | CATEGORY_ID |
| Unique key | Columns |
| SYS_C002446 | |
| SYS_C002447 | |
| SYS_C002448 |
| Index | Type | Uniqueness | Columns |
| SYS_C002445 | NORMAL | UNIQUE | CATEGORY_ID |
| SYS_C002446 | NORMAL | UNIQUE | |
| SYS_C002447 | NORMAL | UNIQUE | |
| SYS_C002448 | NORMAL | UNIQUE |