ACS3 Data Model

Main

Description

Columns

Primary key

GLOSSARY

Columns

Name	Type	Nullable	Default value
TERM	VARCHAR2(200.0)	N
DEFINITION	VARCHAR2(4000.0)	N
AUTHOR	NUMBER(38)	N
APPROVED_P	CHAR(1.0)	Y	'f'
CREATION_DATE	DATE	N
MODIFICATION_DATE	DATE	N

Primary key:

Constraint Name	Columns
SYS_C002087809	TERM

Check Constraints:

Constraint Name	Check Condition
SYS_C002087804	"DEFINITION" IS NOT NULL
SYS_C002087805	"AUTHOR" IS NOT NULL
SYS_C002087806	"CREATION_DATE" IS NOT NULL
SYS_C002087807	"MODIFICATION_DATE" IS NOT NULL
SYS_C002087808	approved_p in ('t','f')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
SYS_C002087810	AUTHOR	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_C002087809	NORMAL	UNIQUE	TERM

Triggers

Name: GLOSSARY_AUDIT_SQL
CREATE TRIGGER glossary_audit_sql before update on glossary for each row REFERENCING NEW AS NEW OLD AS OLD begin insert into glossary_audit (term, definition, author, modification_date) values (:old.term, :old.definition, :old.author, :old.modification_date); end;

Name: GLOSSARY_AUDIT_SQL

CREATE TRIGGER glossary_audit_sql
before update on glossary
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
  insert into glossary_audit (term, definition, author, modification_date)
  values
  (:old.term, :old.definition, :old.author, :old.modification_date);
end;

Name: GLOSSARY_MODIFIED
CREATE TRIGGER glossary_modified before insert or update on glossary for each row REFERENCING NEW AS NEW OLD AS OLD begin :new.modification_date := sysdate; end;

Name: GLOSSARY_MODIFIED
CREATE TRIGGER glossary_modified before insert or update on glossary for each row REFERENCING NEW AS NEW OLD AS OLD begin :new.modification_date := sysdate; end;

Generated by OraSchemaDoc, (c) Aram Kananov, 2002