Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Query Constraints Triggers

TICKET_PRETTY_AUDIT

Columns

NameTypeNullableInsertableUpdatableDeletableComment
MSG_IDNUMBER(38)NYESYESYES 
SUBMITTED_BYVARCHAR2(100.0)NNONONO 
PROJECTVARCHAR2(100.0)NNONONO 
FEATURE_AREAVARCHAR2(100.0)NNONONO 
VERSIONVARCHAR2(100.0)YYESYESYES 
SUBJECTVARCHAR2(200.0)YYESYESYES 
FROM_URLVARCHAR2(700.0)YYESYESYES 
SEVERITYVARCHAR2(400.0)YNONONO 
PRIORITYVARCHAR2(400.0)YNONONO 
STATUSVARCHAR2(400.0)YNONONO 
CAUSEVARCHAR2(400.0)YNONONO 
LAST_MODIFIEDDATENYESYESYES 
LAST_MODIFYING_USERNUMBER(38)NYESYESYES 
MODIFIED_IP_ADDRESSVARCHAR2(20.0)NYESYESYES 
DELETE_PCHAR(1.0)YYESYESYES 

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