ACS3 Data Model

Main

Description

Columns

Primary key

CALENDAR

Columns

Name	Type	Nullable	Default value
CALENDAR_ID	NUMBER(38)	N
CATEGORY_ID	NUMBER(38)	N
TITLE	VARCHAR2(100.0)	N
BODY	VARCHAR2(4000.0)	N
HTML_P	CHAR(1.0)	Y	'f'
START_DATE	DATE	N
END_DATE	DATE	N
EXPIRATION_DATE	DATE	N
EVENT_URL	VARCHAR2(200.0)	Y
EVENT_EMAIL	VARCHAR2(100.0)	Y
COUNTRY_CODE	CHAR(2.0)	Y
USPS_ABBREV	CHAR(2.0)	Y
ZIP_CODE	VARCHAR2(10.0)	Y
APPROVED_P	CHAR(1.0)	Y	'f'
CREATION_DATE	DATE	N
CREATION_USER	NUMBER(38)	N
CREATION_IP_ADDRESS	VARCHAR2(50.0)	N

Primary key:

Constraint Name	Columns
SYS_C002087482	CALENDAR_ID

Check Constraints:

Constraint Name	Check Condition
SYS_C002087471	"CATEGORY_ID" IS NOT NULL
SYS_C002087472	"TITLE" IS NOT NULL
SYS_C002087473	"BODY" IS NOT NULL
SYS_C002087474	"START_DATE" IS NOT NULL
SYS_C002087475	"END_DATE" IS NOT NULL
SYS_C002087476	"EXPIRATION_DATE" IS NOT NULL
SYS_C002087477	"CREATION_DATE" IS NOT NULL
SYS_C002087478	"CREATION_USER" IS NOT NULL
SYS_C002087479	"CREATION_IP_ADDRESS" IS NOT NULL
SYS_C002087480	html_p in ('t','f')
SYS_C002087481	approved_p in ('t','f')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
SYS_C002087483	CATEGORY_ID	CALENDAR_CATEGORIES	SYS_C002087467	NO ACTION
SYS_C002087484	COUNTRY_CODE	COUNTRY_CODES	SYS_C002087047	NO ACTION
SYS_C002087485	USPS_ABBREV	STATES	SYS_C002087049	NO ACTION
SYS_C002087486	CREATION_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_C002087482	NORMAL	UNIQUE	CALENDAR_ID

Triggers

Name: CALENDAR_DATES
CREATE TRIGGER calendar_dates before insert on calendar for each row REFERENCING NEW AS NEW OLD AS OLD begin if :new.creation_date is null then :new.creation_date := sysdate; end if; if :new.end_date is null then :new.end_date := :new.start_date; end if; if :new.expiration_date is null then :new.expiration_date := :new.end_date; end if; end;

Name: CALENDAR_DATES

CREATE TRIGGER calendar_dates
before insert on calendar
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
 if :new.creation_date is null then
   :new.creation_date := sysdate;
 end if;
 if :new.end_date is null then
   :new.end_date := :new.start_date;
 end if;
 if :new.expiration_date is null then
   :new.expiration_date := :new.end_date;
 end if;
end;

Name: CALENDAR_GC_DELETE
CREATE TRIGGER calendar_gc_delete after DELETE ON calendar FOR each row REFERENCING NEW AS NEW OLD AS OLD BEGIN DELETE FROM general_comments WHERE on_which_table = 'calendar' AND on_what_id = :old.calendar_id; END;

Name: CALENDAR_GC_DELETE
CREATE TRIGGER calendar_gc_delete after DELETE ON calendar FOR each row REFERENCING NEW AS NEW OLD AS OLD BEGIN DELETE FROM general_comments WHERE on_which_table = 'calendar' AND on_what_id = :old.calendar_id; END;

Generated by OraSchemaDoc, (c) Aram Kananov, 2002