Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
MSG_ID | NUMBER(38) | N | ||
PROJECT_ID | NUMBER(38) | N | ||
VERSION | VARCHAR2(100.0) | Y | ||
DOMAIN_ID | NUMBER(38) | N | ||
USER_ID | NUMBER(38) | Y | ||
ONE_LINE | VARCHAR2(200.0) | Y | ||
COMMENT_ID | NUMBER(38) | Y | ||
FROM_HOST | VARCHAR2(200.0) | Y | ||
FROM_URL | VARCHAR2(700.0) | Y | ||
FROM_QUERY | VARCHAR2(4000.0) | Y | ||
FROM_PROJECT | VARCHAR2(80.0) | Y | ||
FROM_USER_AGENT | VARCHAR2(300.0) | Y | ||
FROM_IP | VARCHAR2(50.0) | Y | ||
TICKET_TYPE_ID | NUMBER(38) | Y | ||
PRIORITY_ID | NUMBER(38) | Y | ||
STATUS_ID | NUMBER(38) | Y | ||
SEVERITY_ID | NUMBER(38) | Y | ||
SOURCE_ID | NUMBER(38) | Y | ||
CAUSE_ID | NUMBER(38) | Y | ||
POSTING_TIME | DATE | N | ||
LAST_STATUS_CHANGE | DATE | Y | ||
CLOSED_DATE | DATE | Y | ||
CLOSED_BY | NUMBER(38) | Y | ||
DEADLINE | DATE | Y | ||
LAST_NOTIFICATION | DATE | Y | ||
PUBLIC_P | CHAR(1.0) | Y | ('t') | |
NOTIFY_P | CHAR(1.0) | Y | ('t') | |
LAST_MODIFIED | DATE | N | ||
LAST_MODIFYING_USER | NUMBER(38) | N | ||
MODIFIED_IP_ADDRESS | VARCHAR2(20.0) | N |
Constraint Name | Columns |
---|---|
SYS_C002087987 | MSG_ID |
Constraint Name | Check Condition |
---|---|
SYS_C002087978 | "MSG_ID" IS NOT NULL |
SYS_C002087979 | "PROJECT_ID" IS NOT NULL |
SYS_C002087980 | "DOMAIN_ID" IS NOT NULL |
SYS_C002087981 | "POSTING_TIME" IS NOT NULL |
SYS_C002087982 | "LAST_MODIFIED" IS NOT NULL |
SYS_C002087983 | "LAST_MODIFYING_USER" IS NOT NULL |
SYS_C002087984 | "MODIFIED_IP_ADDRESS" IS NOT NULL |
SYS_C002087985 | public_p in ('t','f') |
SYS_C002087986 | notify_p in ('t','f') |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
SYS_C002087988 | PROJECT_ID | TICKET_PROJECTS | SYS_C002087945 | NO ACTION |
SYS_C002087989 | DOMAIN_ID | TICKET_DOMAINS | SYS_C002087961 | NO ACTION |
SYS_C002087990 | USER_ID | USERS | SYS_C002087135 | NO ACTION |
SYS_C002087991 | COMMENT_ID | GENERAL_COMMENTS | SYS_C002087881 | NO ACTION |
SYS_C002087992 | TICKET_TYPE_ID | TICKET_CODES_I | SYS_C002087929 | NO ACTION |
SYS_C002087993 | PRIORITY_ID | TICKET_CODES_I | SYS_C002087929 | NO ACTION |
SYS_C002087994 | STATUS_ID | TICKET_CODES_I | SYS_C002087929 | NO ACTION |
SYS_C002087995 | SEVERITY_ID | TICKET_CODES_I | SYS_C002087929 | NO ACTION |
SYS_C002087996 | SOURCE_ID | TICKET_CODES_I | SYS_C002087929 | NO ACTION |
SYS_C002087997 | CAUSE_ID | TICKET_CODES_I | SYS_C002087929 | NO ACTION |
SYS_C002087998 | CLOSED_BY | USERS | SYS_C002087135 | NO ACTION |
SYS_C002087999 | LAST_MODIFYING_USER | USERS | SYS_C002087135 | NO ACTION |
Option | Settings |
---|---|
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns |
---|---|---|---|
SYS_C002087987 | NORMAL | UNIQUE | MSG_ID |
Table | Constraint |
---|---|
TICKET_INDEX | SYS_C002088011 |
TICKET_EMAIL_ALERTS | SYS_C002088017 |
TICKET_ISSUE_ASSIGNMENTS | SYS_C002088024 |
TICKET_XREFS | SYS_C002088026 |
TICKET_XREFS | SYS_C002088027 |
TICKET_ISSUE_NOTIFICATIONS | SYS_C002088031 |
Name: TICKET_ISSUES_I_AUDIT_TR |
---|
CREATE TRIGGER TICKET_ISSUES_I_audit_tr before update or delete on TICKET_ISSUES_I for each row REFERENCING NEW AS NEW OLD AS OLD begin insert into TICKET_ISSUES_I_audit ( MSG_ID, PROJECT_ID, VERSION, DOMAIN_ID, USER_ID, ONE_LINE, COMMENT_ID, FROM_HOST, FROM_URL, FROM_QUERY, FROM_PROJECT, FROM_USER_AGENT, FROM_IP, TICKET_TYPE_ID, PRIORITY_ID, STATUS_ID, SEVERITY_ID, SOURCE_ID, CAUSE_ID, POSTING_TIME, LAST_STATUS_CHANGE, CLOSED_DATE, CLOSED_BY, DEADLINE, LAST_NOTIFICATION, PUBLIC_P, NOTIFY_P, LAST_MODIFIED, LAST_MODIFYING_USER, MODIFIED_IP_ADDRESS ) values ( :old.MSG_ID, :old.PROJECT_ID, :old.VERSION, :old.DOMAIN_ID, :old.USER_ID, :old.ONE_LINE, :old.COMMENT_ID, :old.FROM_HOST, :old.FROM_URL, :old.FROM_QUERY, :old.FROM_PROJECT, :old.FROM_USER_AGENT, :old.FROM_IP, :old.TICKET_TYPE_ID, :old.PRIORITY_ID, :old.STATUS_ID, :old.SEVERITY_ID, :old.SOURCE_ID, :old.CAUSE_ID, :old.POSTING_TIME, :old.LAST_STATUS_CHANGE, :old.CLOSED_DATE, :old.CLOSED_BY, :old.DEADLINE, :old.LAST_NOTIFICATION, :old.PUBLIC_P, :old.NOTIFY_P, :old.LAST_MODIFIED, :old.LAST_MODIFYING_USER, :old.MODIFIED_IP_ADDRESS); end; |
Name: TICKET_MODIFICATION_TIME |
---|
CREATE TRIGGER ticket_modification_time before insert or update on ticket_issues_i for each row REFERENCING NEW AS NEW OLD AS OLD When new.last_modified is null begin :new.last_modified := SYSDATE; end; |