ACS3 Data Model

Main

Description

Columns

Primary key

QUERIES

Columns

Name	Type	Nullable
QUERY_ID	NUMBER(38)	N
QUERY_NAME	VARCHAR2(100.0)	N
QUERY_OWNER	NUMBER(38)	N
DEFINITION_TIME	DATE	N
QUERY_SQL	VARCHAR2(4000.0)	Y

Primary key:

Constraint Name	Columns
SYS_C002087708	QUERY_ID

Check Constraints:

Constraint Name	Check Condition
SYS_C002087705	"QUERY_NAME" IS NOT NULL
SYS_C002087706	"QUERY_OWNER" IS NOT NULL
SYS_C002087707	"DEFINITION_TIME" IS NOT NULL

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
SYS_C002087709	QUERY_OWNER	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_C002087708	NORMAL	UNIQUE	QUERY_ID

Referenced by:

Table	Constraint
QUERY_COLUMNS	SYS_C002087713

Triggers

Name: QUERIES_AUDIT_SQL
CREATE TRIGGER queries_audit_sql before update on queries for each row REFERENCING NEW AS NEW OLD AS OLD When old.query_sql is not null and (new.query_sql is null or old.query_sql <> new.query_sql) begin insert into queries_audit (query_id, audit_time, query_sql) values (:old.query_id, sysdate, :old.query_sql); end;

Name: QUERIES_AUDIT_SQL

CREATE TRIGGER queries_audit_sql
before update on queries
for each row
REFERENCING NEW AS NEW OLD AS OLD
When old.query_sql is not null and (new.query_sql is null or old.query_sql <> new.query_sql)
begin
  insert into queries_audit (query_id, audit_time, query_sql)
  values
  (:old.query_id, sysdate, :old.query_sql);
end;

Generated by OraSchemaDoc, (c) Aram Kananov, 2002