-- -- This table indicates what services are provided or required by a particular version. -- CREATE TABLE apm_package_dependencies ( dependency_id integer PRIMARY KEY NOT NULL, version_id integer NOT NULL, dependency_type varchar(20) NOT NULL, service_uri varchar(1500) NOT NULL, -- -- The restrictions on service version should match those on apm_package_versions.version_name. -- service_version varchar(100) NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT apm_package_deps_id_pk REFERENCES apm_package_versions (), CONSTRAINT apm_package_deps_version_id_fk REFERENCES apm_package_versions (), CONSTRAINT apm_package_deps_type_ck REFERENCES apm_package_versions () ); CREATE UNIQUE INDEX apm_package_deps_un ON apm_package_dependencies (version_id, service_uri); CREATE TRIGGER RI_ConstraintTrigger_c_340679 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340680 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 491,520 bytes -- Table rows: 6,581
Begin main content
