-- -- Establishes a relationship between timespan_id and multiple time -- intervals. Represents a range of moments at which an event can occur. -- CREATE TABLE timespans ( timespan_id integer NOT NULL, interval_id integer, ON DELETE CASCADE, CONSTRAINT tm_ntrvl_sts_interval_id_fk REFERENCES time_intervals () ); CREATE INDEX timespans_idx ON timespans (timespan_id); CREATE INDEX timespans_interval_id_idx ON timespans (interval_id); CREATE TRIGGER RI_ConstraintTrigger_c_343009 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343010 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 203
Begin main content
