| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| CODE_ID | NUMBER(38) | N | ||
| CODE_TYPE | VARCHAR2(20.0) | Y | ||
| CODE | VARCHAR2(100.0) | N | ||
| CODE_LONG | VARCHAR2(400.0) | N | ||
| CODE_SEQ | NUMBER(38) | N | ||
| CODE_HELP | VARCHAR2(4000.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087929 | CODE_ID |
| Constraint Name | Check Condition |
|---|---|
| C_TKT_CODE_TYPE | code_type in ('severity','priority','status','type','cause','source') |
| SYS_C002087924 | "CODE_ID" IS NOT NULL |
| SYS_C002087925 | "CODE" IS NOT NULL |
| SYS_C002087926 | "CODE_LONG" IS NOT NULL |
| SYS_C002087927 | "CODE_SEQ" IS NOT NULL |
| Constraint name | Columns |
|---|---|
| SYS_C002087930 | CODE_TYPE , CODE |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087929 | NORMAL | UNIQUE | CODE_ID |
| SYS_C002087930 | NORMAL | UNIQUE | CODE_TYPE , CODE |
| Table | Constraint |
|---|---|
| TICKET_CODE_SETS | SYS_C002087934 |
| TICKET_STATUS_INFO | SYS_C002087936 |
| TICKET_ISSUES_I | SYS_C002087992 |
| TICKET_ISSUES_I | SYS_C002087993 |
| TICKET_ISSUES_I | SYS_C002087994 |
| TICKET_ISSUES_I | SYS_C002087995 |
| TICKET_ISSUES_I | SYS_C002087996 |
| TICKET_ISSUES_I | SYS_C002087997 |