TICKET_PRETTY_AUDIT
Columns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
MSG_ID | NUMBER(38) | N | YES | YES | YES | |
SUBMITTED_BY | VARCHAR2(100.0) | N | NO | NO | NO | |
PROJECT | VARCHAR2(100.0) | N | NO | NO | NO | |
FEATURE_AREA | VARCHAR2(100.0) | N | NO | NO | NO | |
VERSION | VARCHAR2(100.0) | Y | YES | YES | YES | |
SUBJECT | VARCHAR2(200.0) | Y | YES | YES | YES | |
FROM_URL | VARCHAR2(700.0) | Y | YES | YES | YES | |
SEVERITY | VARCHAR2(400.0) | Y | NO | NO | NO | |
PRIORITY | VARCHAR2(400.0) | Y | NO | NO | NO | |
STATUS | VARCHAR2(400.0) | Y | NO | NO | NO | |
CAUSE | VARCHAR2(400.0) | Y | NO | NO | NO | |
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 | |
DELETE_P | CHAR(1.0) | Y | YES | YES | YES | |
Query:
select
t.msg_id,
u.email as submitted_by,
tp.title_long as project,
td.title_long as feature_area,
t.version,
t.one_line as subject,
t.from_url as from_url,
t.severity_long as severity,
t.priority_long as priority,
t.status_long as status,
t.cause_long as cause,
t.LAST_MODIFIED,
t.LAST_MODIFYING_USER,
t.MODIFIED_IP_ADDRESS,
t.delete_p
from ticket_issues_audit t, users u, ticket_domains td, ticket_projects tp
where t.user_id = u.user_id
and td.domain_id = t.domain_id
and tp.project_id = t.project_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002