CREATE TABLE acs_data_links ( rel_id integer PRIMARY KEY NOT NULL, object_id_one integer NOT NULL, object_id_two integer NOT NULL, relation_tag varchar(100), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_data_links_one_fk REFERENCES acs_objects (), CONSTRAINT acs_data_links_pk REFERENCES acs_objects (), CONSTRAINT acs_data_links_two_fk REFERENCES acs_objects (), CONSTRAINT acs_data_links_un REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_data_links_un REFERENCES acs_objects (), CONSTRAINT acs_data_links_one_fk REFERENCES acs_objects (), CONSTRAINT acs_data_links_pk REFERENCES acs_objects (), CONSTRAINT acs_data_links_two_fk REFERENCES acs_objects () ); CREATE INDEX acs_data_links_id_one_idx ON acs_data_links (object_id_one); CREATE INDEX acs_data_links_id_two_idx ON acs_data_links (object_id_two); CREATE INDEX acs_data_links_rel_tag_idx ON acs_data_links (relation_tag); CREATE UNIQUE INDEX acs_data_links_un ON acs_data_links (object_id_one, object_id_two, relation_tag); CREATE TRIGGER RI_ConstraintTrigger_c_340299 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340300 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340304 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340305 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 1
Begin main content
