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

ACS3 Data Model

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

TICKET_ISSUES_I

Columns

NameTypeNullableDefault valueComment
MSG_IDNUMBER(38)N  
PROJECT_IDNUMBER(38)N  
VERSIONVARCHAR2(100.0)Y  
DOMAIN_IDNUMBER(38)N  
USER_IDNUMBER(38)Y  
ONE_LINEVARCHAR2(200.0)Y  
COMMENT_IDNUMBER(38)Y  
FROM_HOSTVARCHAR2(200.0)Y  
FROM_URLVARCHAR2(700.0)Y  
FROM_QUERYVARCHAR2(4000.0)Y  
FROM_PROJECTVARCHAR2(80.0)Y  
FROM_USER_AGENTVARCHAR2(300.0)Y  
FROM_IPVARCHAR2(50.0)Y  
TICKET_TYPE_IDNUMBER(38)Y  
PRIORITY_IDNUMBER(38)Y  
STATUS_IDNUMBER(38)Y  
SEVERITY_IDNUMBER(38)Y  
SOURCE_IDNUMBER(38)Y  
CAUSE_IDNUMBER(38)Y  
POSTING_TIMEDATEN  
LAST_STATUS_CHANGEDATEY  
CLOSED_DATEDATEY  
CLOSED_BYNUMBER(38)Y  
DEADLINEDATEY  
LAST_NOTIFICATIONDATEY  
PUBLIC_PCHAR(1.0)Y('t')  
NOTIFY_PCHAR(1.0)Y('t')  
LAST_MODIFIEDDATEN  
LAST_MODIFYING_USERNUMBER(38)N  
MODIFIED_IP_ADDRESSVARCHAR2(20.0)N  

Primary key:

Constraint NameColumns
SYS_C002087987MSG_ID

Check Constraints:

Constraint NameCheck 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_C002087985public_p in ('t','f')
SYS_C002087986notify_p in ('t','f')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002087988PROJECT_ID TICKET_PROJECTS SYS_C002087945 NO ACTION
SYS_C002087989DOMAIN_ID TICKET_DOMAINS SYS_C002087961 NO ACTION
SYS_C002087990USER_ID USERS SYS_C002087135 NO ACTION
SYS_C002087991COMMENT_ID GENERAL_COMMENTS SYS_C002087881 NO ACTION
SYS_C002087992TICKET_TYPE_ID TICKET_CODES_I SYS_C002087929 NO ACTION
SYS_C002087993PRIORITY_ID TICKET_CODES_I SYS_C002087929 NO ACTION
SYS_C002087994STATUS_ID TICKET_CODES_I SYS_C002087929 NO ACTION
SYS_C002087995SEVERITY_ID TICKET_CODES_I SYS_C002087929 NO ACTION
SYS_C002087996SOURCE_ID TICKET_CODES_I SYS_C002087929 NO ACTION
SYS_C002087997CAUSE_ID TICKET_CODES_I SYS_C002087929 NO ACTION
SYS_C002087998CLOSED_BY USERS SYS_C002087135 NO ACTION
SYS_C002087999LAST_MODIFYING_USER USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002087987NORMALUNIQUEMSG_ID

Referenced by:

TableConstraint
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

Triggers

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;



Generated by OraSchemaDoc, (c) Aram Kananov, 2002