Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table HELP_TEXT | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | FORM_NAME1 | VARCHAR2(30 BYTE) | Y | ||
2 | BLOCK_NAME2 | VARCHAR2(30 BYTE) | Y | ||
3 | ITEM_NAME3 | VARCHAR2(30 BYTE) | Y | ||
4 | DESCRIPTION | VARCHAR2(40 BYTE) | |||
5 | TEXT | VARCHAR2(2000 BYTE) |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
UNIQUE | PK_HELPTEXT | NORMAL | FORM_NAME, BLOCK_NAME, ITEM_NAME | <none> |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_HELPTEXT_BLOCKNAME | Check | "BLOCK_NAME" IS NOT NULL | ENABLED | BLOCK_NAME |
NN_HELPTEXT_FORMNAME | Check | "FORM_NAME" IS NOT NULL | ENABLED | FORM_NAME |
NN_HELPTEXT_ITEMNAME | Check | "ITEM_NAME" IS NOT NULL | ENABLED | ITEM_NAME |
PK_HELPTEXT | Primary Key | ENABLED | FORM_NAME, BLOCK_NAME, ITEM_NAME |
Comments |
Partitions |
Foreign Key Constraints |
Redaction Policies |