--
--  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),
	CONSTRAINT apm_parameter_values_fk REFERENCES acs_objects () ON DELETE CASCADE,
	CONSTRAINT apm_parameter_values_pk_id_fk REFERENCES apm_packages (),
	CONSTRAINT apm_parameter_values_pm_id_fk REFERENCES apm_parameters ()
);

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);

-- Table size: 32,768 bytes
-- Table rows: 410

Tables: