-- -- A time interval is represented by two points in time. -- CREATE TABLE time_intervals ( interval_id integer PRIMARY KEY NOT NULL, start_date timestamptz, end_date timestamptz ); CREATE INDEX time_intervals_start_idx ON time_intervals (start_date); CREATE TRIGGER RI_ConstraintTrigger_a_343007 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343008 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to time_intervals: --timespans(time_interval_date_order_ck) --timespans(time_intervals_pk) -- Table size: 24,576 bytes -- Table rows: 397
Begin main content
