-- -- This table stores information about parameters on packages. Every package parameter -- is specific to a particular package instance and is queryable with the Tcl call -- ad_parameter. -- CREATE TABLE apm_parameters ( parameter_id integer PRIMARY KEY NOT NULL, package_key varchar(100) NOT NULL, -- -- This is the name of the parameter, for example "DebugP." -- parameter_name varchar(100) NOT NULL, -- -- A human readable description of what the parameter is used for. -- description varchar(2000), section_name varchar(200), -- -- Acceptable datatypes for parameters. Currently only numbers and strings. -- XXX (bquinn): Integrate with acs objects metadata system. It is not -- currently so integrated because of fluctuations with the general -- storage mechanism during development. -- datatype varchar(100) NOT NULL, -- -- The default value that any package instance will inherit unless otherwise -- specified. -- default_value text(-5), -- -- The minimum number of values that this parameter can take. Zero values means -- that the default is always enforced (but is somewhat pointless). One value means that -- it can only be set to one value. Increasing this number beyond one enables associating -- a list of values with a parameter. -- XXX (bquinn): More than one value is not supported by ad_parameter call at this time. -- min_n_values integer DEFAULT 1 NOT NULL, -- -- The maximum number of values that any attribute with this datatype -- can have. -- max_n_values integer DEFAULT 1 NOT NULL, scope varchar(10) DEFAULT 'instance'::character varying NOT NULL, CONSTRAINT apm_pack_param_type_fk REFERENCES apm_package_types (), CONSTRAINT apm_parameters_datatype_ck REFERENCES apm_package_types (), CONSTRAINT apm_parameters_fk REFERENCES apm_package_types (), CONSTRAINT apm_parameters_pk REFERENCES apm_package_types (), CONSTRAINT apm_parameters_scope_check REFERENCES apm_package_types (), CONSTRAINT apm_paramters_max_n_ck REFERENCES apm_package_types (), CONSTRAINT apm_paramters_min_n_ck REFERENCES apm_package_types (), CONSTRAINT apm_paramters_n_values_ck REFERENCES apm_package_types (), CONSTRAINT apm_paramters_n_values_ck REFERENCES acs_objects (), CONSTRAINT apm_pack_param_type_fk REFERENCES acs_objects (), CONSTRAINT apm_parameters_datatype_ck REFERENCES acs_objects (), CONSTRAINT apm_parameters_fk REFERENCES acs_objects (), CONSTRAINT apm_parameters_pk REFERENCES acs_objects (), CONSTRAINT apm_parameters_scope_check REFERENCES acs_objects (), CONSTRAINT apm_paramters_max_n_ck REFERENCES acs_objects (), CONSTRAINT apm_paramters_min_n_ck REFERENCES acs_objects () ); CREATE INDEX apm_parameters_package_idx ON apm_parameters (package_key); CREATE UNIQUE INDEX apm_paramters_attr_name_un ON apm_parameters (parameter_name, package_key); CREATE TRIGGER RI_ConstraintTrigger_c_340659 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340660 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340667 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340668 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340724 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340725 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to apm_parameters: --apm_parameter_values(apm_pack_param_type_fk) --apm_parameter_values(apm_parameters_datatype_ck) --apm_parameter_values(apm_parameters_fk) --apm_parameter_values(apm_parameters_pk) --apm_parameter_values(apm_parameters_scope_check) --apm_parameter_values(apm_paramters_max_n_ck) --apm_parameter_values(apm_paramters_min_n_ck) --apm_parameter_values(apm_paramters_n_values_ck) -- Table size: 147,456 bytes -- Table rows: 510
Begin main content
