| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| COMMENT_ID | NUMBER(38) | N | ||
| ON_WHAT_ID | NUMBER(38) | N | ||
| ON_WHICH_TABLE | VARCHAR2(50.0) | Y | ||
| ONE_LINE_ITEM_DESC | VARCHAR2(200.0) | N | ||
| USER_ID | NUMBER(38) | N | ||
| SCOPE | VARCHAR2(20.0) | N | 'public' | |
| GROUP_ID | NUMBER(38) | Y | ||
| COMMENT_DATE | DATE | N | ||
| IP_ADDRESS | VARCHAR2(50.0) | N | ||
| MODIFIED_DATE | DATE | Y | ||
| ONE_LINE | VARCHAR2(200.0) | Y | ||
| CONTENT | CLOB | Y | ||
| HTML_P | CHAR(1.0) | Y | 'f' | |
| APPROVED_P | CHAR(1.0) | Y | 't' | |
| ATTACHMENT | BLOB | Y | ||
| CLIENT_FILE_NAME | VARCHAR2(500.0) | Y | ||
| FILE_TYPE | VARCHAR2(100.0) | Y | ||
| FILE_EXTENSION | VARCHAR2(50.0) | Y | ||
| CAPTION | VARCHAR2(4000.0) | Y | ||
| ORIGINAL_WIDTH | NUMBER(38) | Y | ||
| ORIGINAL_HEIGHT | NUMBER(38) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087881 | COMMENT_ID |
| Constraint Name | Check Condition |
|---|---|
| GENERAL_COMMENTS_SCOPE_CHECK | scope in ('public', 'group') |
| SYS_C002087872 | "ON_WHAT_ID" IS NOT NULL |
| SYS_C002087873 | "ONE_LINE_ITEM_DESC" IS NOT NULL |
| SYS_C002087874 | "USER_ID" IS NOT NULL |
| SYS_C002087875 | "SCOPE" IS NOT NULL |
| SYS_C002087876 | "COMMENT_DATE" IS NOT NULL |
| SYS_C002087877 | "IP_ADDRESS" IS NOT NULL |
| SYS_C002087879 | html_p in ('t','f') |
| SYS_C002087880 | approved_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087882 | USER_ID | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002087883 | GROUP_ID | USER_GROUPS | SYS_C002087305 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| GENERAL_COMMENTS_CIDX | NORMAL | NONUNIQUE | ON_WHICH_TABLE , ON_WHAT_ID |
| GENERAL_COMMENTS_UIDX | NORMAL | NONUNIQUE | USER_ID |
| SYS_C002087881 | NORMAL | UNIQUE | COMMENT_ID |
| SYS_IL0001976758C00012$$ | LOB | UNIQUE | |
| SYS_IL0001976758C00015$$ | LOB | UNIQUE |
| Table | Constraint |
|---|---|
| TICKET_ISSUES_I | SYS_C002087991 |
| Name: GENERAL_COMMENTS_MODIFIED |
|---|
CREATE TRIGGER general_comments_modified before insert or update on general_comments for each row REFERENCING NEW AS NEW OLD AS OLD begin :new.modified_date :=SYSDATE; end; |
| Name: TICKET_RESPONSE_MOD_TIME |
|---|
CREATE TRIGGER ticket_response_mod_time after insert or update on general_comments for each row REFERENCING NEW AS NEW OLD AS OLD begin update ticket_index set last_modified = SYSDATE where msg_id = :new.on_what_id and :new.on_which_table = 'ticket_issues'; end; |