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