-- -- Map a photo into the collection. -- CREATE TABLE pa_collections ( collection_id integer PRIMARY KEY NOT NULL, owner_id integer NOT NULL, title varchar(255) NOT NULL, CONSTRAINT pa_collection_id_fk REFERENCES acs_objects (), CONSTRAINT pa_collections_owner_id_fk REFERENCES acs_objects (), CONSTRAINT pa_collections_pk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT pa_collections_pk REFERENCES users (), CONSTRAINT pa_collection_id_fk REFERENCES users (), CONSTRAINT pa_collections_owner_id_fk REFERENCES users () ); CREATE TRIGGER RI_ConstraintTrigger_c_342749 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342750 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342752 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342753 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342759 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342760 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to pa_collections: --pa_collection_photo_map(pa_collection_id_fk) --pa_collection_photo_map(pa_collections_owner_id_fk) --pa_collection_photo_map(pa_collections_pk) -- Table size: 8,192 bytes -- Table rows: 9
Begin main content
