-- -- This table stores information about all metadata stored for each archive in a given -- repository. CREATE TABLE download_archive_metadata ( metadata_id integer PRIMARY KEY NOT NULL, repository_id integer, archive_type_id integer, sort_key integer NOT NULL, pretty_name varchar(100) NOT NULL, data_type varchar(30), required_p bool, linked_p bool, mainpage_p bool, computed_p bool, CONSTRAINT download_data_type_ck REFERENCES download_repository (), CONSTRAINT download_ma_pk REFERENCES download_repository (), CONSTRAINT download_ma_rep_id_fk REFERENCES download_repository (), CONSTRAINT download_ma_type_fk REFERENCES download_repository (), CONSTRAINT download_ma_type_fk REFERENCES download_archive_types (), CONSTRAINT download_data_type_ck REFERENCES download_archive_types (), CONSTRAINT download_ma_pk REFERENCES download_archive_types (), CONSTRAINT download_ma_rep_id_fk REFERENCES download_archive_types () ); CREATE TRIGGER RI_ConstraintTrigger_c_341629 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341630 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341634 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341635 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341637 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341638 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341662 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341663 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to download_archive_metadata: --download_metadata_choices(download_data_type_ck) --download_metadata_choices(download_ma_pk) --download_metadata_choices(download_ma_rep_id_fk) --download_metadata_choices(download_ma_type_fk) --download_revision_data(download_data_type_ck) --download_revision_data(download_ma_pk) --download_revision_data(download_ma_rep_id_fk) --download_revision_data(download_ma_type_fk) -- Table size: 0 bytes -- Table rows: 0
Begin main content
