-- -- This table stores the actual download repositories. Each repository has a title -- and description of the repository. Meta information about what can be stored in -- the repository is keyed to this table CREATE TABLE download_repository ( repository_id integer PRIMARY KEY NOT NULL, ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT download_repository_id_fk REFERENCES cr_items (), CONSTRAINT download_repository_id_pk REFERENCES cr_items () ); CREATE TRIGGER RI_ConstraintTrigger_a_341592 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341593 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341627 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341628 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341642 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341643 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341649 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341650 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to download_repository: --download_archive_metadata(download_repository_id_fk) --download_archive_metadata(download_repository_id_pk) --download_archive_types(download_repository_id_fk) --download_archive_types(download_repository_id_pk) --download_reasons(download_repository_id_fk) --download_reasons(download_repository_id_pk) -- Table size: 8,192 bytes -- Table rows: 7
Begin main content
