-- -- This table holds the values of parameters for package instances. -- CREATE TABLE apm_parameter_values ( value_id integer PRIMARY KEY NOT NULL, package_id integer, parameter_id integer, -- -- This column holds the value for the instance parameter. -- attr_value text(-5), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT apm_pack_values_obj_id_fk REFERENCES apm_packages (), CONSTRAINT apm_pack_values_parm_id_fk REFERENCES apm_packages (), CONSTRAINT apm_parameter_values_fk REFERENCES apm_packages (), CONSTRAINT apm_parameter_values_pk REFERENCES apm_packages (), CONSTRAINT apm_parameter_values_pk REFERENCES apm_parameters (), CONSTRAINT apm_parameter_values_fk REFERENCES apm_parameters (), CONSTRAINT apm_pack_values_parm_id_fk REFERENCES apm_parameters (), CONSTRAINT apm_pack_values_obj_id_fk REFERENCES apm_parameters (), CONSTRAINT apm_parameter_values_pk REFERENCES acs_objects (), CONSTRAINT apm_pack_values_obj_id_fk REFERENCES acs_objects (), CONSTRAINT apm_pack_values_parm_id_fk REFERENCES acs_objects (), CONSTRAINT apm_parameter_values_fk REFERENCES acs_objects () ); CREATE INDEX apm_par_vals_parameter_idx ON apm_parameter_values (parameter_id); CREATE UNIQUE INDEX apm_parameter_values_un ON apm_parameter_values (package_id, parameter_id); CREATE TRIGGER RI_ConstraintTrigger_c_340664 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340665 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340669 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340670 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340719 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340720 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 188,416 bytes -- Table rows: 2,400
Begin main content
