| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| TABLE_NAME | VARCHAR2(30.0) | N | ||
| COLUMN_NAME | VARCHAR2(50.0) | N | ||
| COLUMN_PRETTY_NAME | VARCHAR2(50.0) | N | ||
| DISPLAY_ORDINAL | NUMBER(38) | N | ||
| IS_DATE_P | CHAR(1.0) | Y | 'f' | |
| USE_AS_LINK_P | CHAR(1.0) | Y | 'f' |
| Constraint Name | Columns |
|---|---|
| SYS_C002088610 | TABLE_NAME , COLUMN_NAME |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002088605 | "COLUMN_NAME" IS NOT NULL |
| SYS_C002088606 | "COLUMN_PRETTY_NAME" IS NOT NULL |
| SYS_C002088607 | "DISPLAY_ORDINAL" IS NOT NULL |
| SYS_C002088608 | is_date_p in ('t','f') |
| SYS_C002088609 | use_as_link_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002088611 | TABLE_NAME | GENERAL_TABLE_METADATA | SYS_C002088604 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002088610 | NORMAL | UNIQUE | TABLE_NAME , COLUMN_NAME |