TICKET_ISSUES
Columns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
MSG_ID | NUMBER(38) | N | YES | YES | YES | |
PROJECT_ID | NUMBER(38) | N | YES | YES | YES | |
VERSION | VARCHAR2(100.0) | Y | YES | YES | YES | |
DOMAIN_ID | NUMBER(38) | N | YES | YES | YES | |
USER_ID | NUMBER(38) | Y | YES | YES | YES | |
ONE_LINE | VARCHAR2(200.0) | Y | YES | YES | YES | |
COMMENT_ID | NUMBER(38) | Y | YES | YES | YES | |
FROM_HOST | VARCHAR2(200.0) | Y | YES | YES | YES | |
FROM_URL | VARCHAR2(700.0) | Y | YES | YES | YES | |
FROM_QUERY | VARCHAR2(4000.0) | Y | YES | YES | YES | |
FROM_PROJECT | VARCHAR2(80.0) | Y | YES | YES | YES | |
FROM_USER_AGENT | VARCHAR2(300.0) | Y | YES | YES | YES | |
FROM_IP | VARCHAR2(50.0) | Y | YES | YES | YES | |
TICKET_TYPE_ID | NUMBER(38) | Y | YES | YES | YES | |
PRIORITY_ID | NUMBER(38) | Y | YES | YES | YES | |
STATUS_ID | NUMBER(38) | Y | YES | YES | YES | |
SEVERITY_ID | NUMBER(38) | Y | YES | YES | YES | |
SOURCE_ID | NUMBER(38) | Y | YES | YES | YES | |
CAUSE_ID | NUMBER(38) | Y | YES | YES | YES | |
POSTING_TIME | DATE | N | YES | YES | YES | |
LAST_STATUS_CHANGE | DATE | Y | YES | YES | YES | |
CLOSED_DATE | DATE | Y | YES | YES | YES | |
CLOSED_BY | NUMBER(38) | Y | YES | YES | YES | |
DEADLINE | DATE | Y | YES | YES | YES | |
LAST_NOTIFICATION | DATE | Y | YES | YES | YES | |
PUBLIC_P | CHAR(1.0) | Y | YES | YES | YES | |
NOTIFY_P | CHAR(1.0) | Y | YES | YES | YES | |
LAST_MODIFIED | DATE | N | YES | YES | YES | |
LAST_MODIFYING_USER | NUMBER(38) | N | YES | YES | YES | |
MODIFIED_IP_ADDRESS | VARCHAR2(20.0) | N | YES | YES | YES | |
MODIFICATION_MDY | VARCHAR2(8.0) | Y | NO | NO | NO | |
CREATION_MDY | VARCHAR2(8.0) | Y | NO | NO | NO | |
CLOSE_MDY | VARCHAR2(8.0) | Y | NO | NO | NO | |
DEADLINE_MDY | VARCHAR2(8.0) | Y | NO | NO | NO | |
PASTDUE_DAYS | VARCHAR2(40.0) | Y | NO | NO | NO | |
SEVERITY | VARCHAR2(100.0) | Y | NO | NO | NO | |
SEVERITY_SEQ | NUMBER(38) | Y | NO | NO | NO | |
SEVERITY_LONG | VARCHAR2(400.0) | Y | NO | NO | NO | |
PRIORITY | VARCHAR2(100.0) | Y | NO | NO | NO | |
PRIORITY_SEQ | NUMBER(38) | Y | NO | NO | NO | |
PRIORITY_LONG | VARCHAR2(400.0) | Y | NO | NO | NO | |
STATUS | VARCHAR2(100.0) | Y | NO | NO | NO | |
STATUS_SEQ | NUMBER(38) | Y | NO | NO | NO | |
STATUS_LONG | VARCHAR2(400.0) | Y | NO | NO | NO | |
SOURCE | VARCHAR2(100.0) | Y | NO | NO | NO | |
SOURCE_SEQ | NUMBER(38) | Y | NO | NO | NO | |
SOURCE_LONG | VARCHAR2(400.0) | Y | NO | NO | NO | |
CAUSE | VARCHAR2(100.0) | Y | NO | NO | NO | |
CAUSE_SEQ | NUMBER(38) | Y | NO | NO | NO | |
CAUSE_LONG | VARCHAR2(400.0) | Y | NO | NO | NO | |
TICKET_TYPE | VARCHAR2(100.0) | Y | NO | NO | NO | |
TICKET_TYPE_SEQ | NUMBER(38) | Y | NO | NO | NO | |
TICKET_TYPE_LONG | VARCHAR2(400.0) | Y | NO | NO | NO | |
STATUS_CLASS | VARCHAR2(30.0) | Y | NO | NO | NO | |
STATUS_SUBCLASS | VARCHAR2(30.0) | Y | NO | NO | NO | |
RESPONSIBILITY | VARCHAR2(30.0) | Y | NO | NO | NO | |
Query:
select
ti.*, -- FIX THIS IN PROD no select star
to_char(ti.last_modified, 'mm/dd/yy') as modification_mdy,
to_char(ti.posting_time, 'mm/dd/yy') as creation_mdy,
to_char(ti.closed_date, 'mm/dd/yy') as close_mdy,
to_char(ti.deadline, 'mm/dd/yy') as deadline_mdy,
to_char(trunc(sysdate - deadline)) as pastdue_days,
sev.code as severity, sev.code_seq as severity_seq, sev.code_long as severity_long,
pri.code as priority, pri.code_seq as priority_seq, pri.code_long as priority_long,
stat.code as status, stat.code_seq as status_seq, stat.code_long as status_long,
src.code as source, src.code_seq as source_seq, src.code_long as source_long,
def.code as cause, def.code_seq as cause_seq, def.code_long as cause_long,
type.code as ticket_type, type.code_seq as ticket_type_seq, type.code_long as ticket_type_long,
tsi.status_class, tsi.status_subclass, tsi.responsibility
from
ticket_issues_i ti,
ticket_codes_i sev,
ticket_codes_i pri,
ticket_codes_i stat,
ticket_codes_i src,
ticket_codes_i def,
ticket_codes_i type,
ticket_status_info tsi
where
sev.code_id(+) = ti.severity_id
and pri.code_id(+) = ti.priority_id
and stat.code_id(+) = ti.status_id
and src.code_id(+) = ti.source_id
and def.code_id(+) = ti.cause_id
and type.code_id(+) = ti.ticket_type_id
and tsi.code_id(+) = ti.status_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002