CREATE TABLE acs_reference_repositories ( repository_id integer PRIMARY KEY NOT NULL, table_name varchar(100) NOT NULL, internal_data_p bool, package_name varchar(100), last_update timestamptz, source varchar(1000), source_url varchar(255), effective_date timestamptz, expiry_date timestamptz, maintainer_id integer, lob integer, CONSTRAINT arr_maintainer_id_fk REFERENCES persons (), CONSTRAINT arr_repository_id_fk REFERENCES persons (), CONSTRAINT arr_repository_id_pk REFERENCES persons (), CONSTRAINT arr_repository_id_pk REFERENCES acs_objects (), CONSTRAINT arr_maintainer_id_fk REFERENCES acs_objects (), CONSTRAINT arr_repository_id_fk REFERENCES acs_objects () ); CREATE UNIQUE INDEX arr_package_name_uq ON acs_reference_repositories (package_name); CREATE UNIQUE INDEX arr_table_name_uq ON acs_reference_repositories (table_name); CREATE TRIGGER RI_ConstraintTrigger_c_340744 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340745 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340749 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340750 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 5
Begin main content
