ACS3 Data Model

Main

Description

Columns

Primary key

AD_PARAMETER_VALUES

Columns

Name	Type	Nullable
VALUE_ID	NUMBER(38)	N
ELEMENT_ID	NUMBER(38)	N
VALUE	VARCHAR2(4000.0)	N

Primary key:

Constraint Name	Columns
AD_PARAM_VALS_VAL_ID_PK	VALUE_ID

Check Constraints:

Constraint Name	Check Condition
AD_PARAM_VALS_ELTS_ID_NN	"ELEMENT_ID" IS NOT NULL
AD_PARAM_VALS_VAL_NN	"VALUE" IS NOT NULL

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
AD_PARAM_VALS_ELTS_ID_FK	ELEMENT_ID	AD_PARAMETER_ELEMENTS	AD_PARAM_ELTS_ID_PK	CASCADE

Options:

Option	Settings
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns
AD_PARAM_VALS_VAL_ID_PK	NORMAL	UNIQUE	VALUE_ID

Triggers

Name: APM_UNIQUE_PARAM_VALUE_CK
CREATE TRIGGER apm_unique_param_value_ck before insert on ad_parameter_values for each row REFERENCING NEW AS NEW OLD AS OLD declare multi_val_p char(1); begin select multiple_values_p into multi_val_p from ad_parameter_elements where element_id = :new.element_id; if multi_val_p = 'f' then delete from ad_parameter_values where element_id = :new.element_id; end if; end;

Name: APM_UNIQUE_PARAM_VALUE_CK

CREATE TRIGGER apm_unique_param_value_ck
before insert on ad_parameter_values for each row
REFERENCING NEW AS NEW OLD AS OLD
declare
  multi_val_p char(1);
begin
  select multiple_values_p into multi_val_p
    from ad_parameter_elements
    where element_id = :new.element_id;

  if multi_val_p = 'f' then

    delete from ad_parameter_values where element_id = :new.element_id;

  end if;

end;

Generated by OraSchemaDoc, (c) Aram Kananov, 2002