ACS3 Data Model

Main

Description

Columns

Primary key

TICKET_ISSUES_I

Columns

Name	Type	Nullable	Default value
MSG_ID	NUMBER(38)	N
PROJECT_ID	NUMBER(38)	N
VERSION	VARCHAR2(100.0)	Y
DOMAIN_ID	NUMBER(38)	N
USER_ID	NUMBER(38)	Y
ONE_LINE	VARCHAR2(200.0)	Y
COMMENT_ID	NUMBER(38)	Y
FROM_HOST	VARCHAR2(200.0)	Y
FROM_URL	VARCHAR2(700.0)	Y
FROM_QUERY	VARCHAR2(4000.0)	Y
FROM_PROJECT	VARCHAR2(80.0)	Y
FROM_USER_AGENT	VARCHAR2(300.0)	Y
FROM_IP	VARCHAR2(50.0)	Y
TICKET_TYPE_ID	NUMBER(38)	Y
PRIORITY_ID	NUMBER(38)	Y
STATUS_ID	NUMBER(38)	Y
SEVERITY_ID	NUMBER(38)	Y
SOURCE_ID	NUMBER(38)	Y
CAUSE_ID	NUMBER(38)	Y
POSTING_TIME	DATE	N
LAST_STATUS_CHANGE	DATE	Y
CLOSED_DATE	DATE	Y
CLOSED_BY	NUMBER(38)	Y
DEADLINE	DATE	Y
LAST_NOTIFICATION	DATE	Y
PUBLIC_P	CHAR(1.0)	Y	('t')
NOTIFY_P	CHAR(1.0)	Y	('t')
LAST_MODIFIED	DATE	N
LAST_MODIFYING_USER	NUMBER(38)	N
MODIFIED_IP_ADDRESS	VARCHAR2(20.0)	N

Primary key:

Constraint Name	Columns
SYS_C002087987	MSG_ID

Check Constraints:

Constraint Name	Check 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_C002087985	public_p in ('t','f')
SYS_C002087986	notify_p in ('t','f')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
SYS_C002087988	PROJECT_ID	TICKET_PROJECTS	SYS_C002087945	NO ACTION
SYS_C002087989	DOMAIN_ID	TICKET_DOMAINS	SYS_C002087961	NO ACTION
SYS_C002087990	USER_ID	USERS	SYS_C002087135	NO ACTION
SYS_C002087991	COMMENT_ID	GENERAL_COMMENTS	SYS_C002087881	NO ACTION
SYS_C002087992	TICKET_TYPE_ID	TICKET_CODES_I	SYS_C002087929	NO ACTION
SYS_C002087993	PRIORITY_ID	TICKET_CODES_I	SYS_C002087929	NO ACTION
SYS_C002087994	STATUS_ID	TICKET_CODES_I	SYS_C002087929	NO ACTION
SYS_C002087995	SEVERITY_ID	TICKET_CODES_I	SYS_C002087929	NO ACTION
SYS_C002087996	SOURCE_ID	TICKET_CODES_I	SYS_C002087929	NO ACTION
SYS_C002087997	CAUSE_ID	TICKET_CODES_I	SYS_C002087929	NO ACTION
SYS_C002087998	CLOSED_BY	USERS	SYS_C002087135	NO ACTION
SYS_C002087999	LAST_MODIFYING_USER	USERS	SYS_C002087135	NO ACTION

Options:

Option	Settings
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns
SYS_C002087987	NORMAL	UNIQUE	MSG_ID

Referenced by:

Table	Constraint
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_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;

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