| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| MENU_ID | NUMBER(38) | N | ||
| MENU_KEY | VARCHAR2(20.0) | N | ||
| DEFAULT_P | CHAR(1.0) | Y | 'f' | |
| ORIENTATION | VARCHAR2(20.0) | N | ||
| X_OFFSET | NUMBER(38) | N | ||
| Y_OFFSET | NUMBER(38) | N | ||
| ELEMENT_HEIGHT | NUMBER(38) | N | ||
| ELEMENT_WIDTH | NUMBER(38) | N | ||
| MAIN_MENU_FONT_STYLE | VARCHAR2(4000.0) | Y | ||
| SUB_MENU_FONT_STYLE | VARCHAR2(4000.0) | Y | ||
| SUB_SUB_MENU_FONT_STYLE | VARCHAR2(4000.0) | Y | ||
| MAIN_MENU_BG_IMG_URL | VARCHAR2(200.0) | Y | ||
| MAIN_MENU_BG_COLOR | VARCHAR2(12.0) | Y | ||
| MAIN_MENU_HL_IMG_URL | VARCHAR2(200.0) | Y | ||
| MAIN_MENU_HL_COLOR | VARCHAR2(12.0) | Y | ||
| SUB_MENU_BG_IMG_URL | VARCHAR2(200.0) | Y | ||
| SUB_MENU_BG_COLOR | VARCHAR2(12.0) | Y | ||
| SUB_MENU_HL_IMG_URL | VARCHAR2(200.0) | Y | ||
| SUB_MENU_HL_COLOR | VARCHAR2(12.0) | Y | ||
| SUB_SUB_MENU_BG_IMG_URL | VARCHAR2(200.0) | Y | ||
| SUB_SUB_MENU_BG_COLOR | VARCHAR2(12.0) | Y | ||
| SUB_SUB_MENU_HL_IMG_URL | VARCHAR2(200.0) | Y | ||
| SUB_SUB_MENU_HL_COLOR | VARCHAR2(12.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002088335 | MENU_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002088327 | "MENU_KEY" IS NOT NULL |
| SYS_C002088328 | "ORIENTATION" IS NOT NULL |
| SYS_C002088329 | "X_OFFSET" IS NOT NULL |
| SYS_C002088330 | "Y_OFFSET" IS NOT NULL |
| SYS_C002088331 | "ELEMENT_HEIGHT" IS NOT NULL |
| SYS_C002088332 | "ELEMENT_WIDTH" IS NOT NULL |
| SYS_C002088333 | default_p in ('t','f') |
| SYS_C002088334 | orientation in ('horizontal','vertical') |
| Constraint name | Columns |
|---|---|
| SYS_C002088336 | MENU_KEY |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002088335 | NORMAL | UNIQUE | MENU_ID |
| SYS_C002088336 | NORMAL | UNIQUE | MENU_KEY |
| Table | Constraint |
|---|---|
| PDM_MENU_ITEMS | SYS_C002088341 |