ACS3 Data Model - Table-AD_PARAMETER_ELEMENTS

Main

Constraints

Sanity check

ACS3 Data Model

Check Constraints

AD_PARAMETER_ELEMENTS

Columns

Name	Type	Nullable	Default value	Comment
ELEMENT_ID	NUMBER(38)	N
VERSION_ID	NUMBER(38)	N
ELEMENT_NAME	VARCHAR2(100.0)	N
ELEMENT_TYPE	VARCHAR2(50.0)	N
DESCRIPTION	VARCHAR2(4000.0)	Y
DEFAULT_VALUE	VARCHAR2(4000.0)	Y
MODULE_KEY	VARCHAR2(100.0)	Y
PARAMETER_KEY	VARCHAR2(100.0)	N
CHANGE_ON_RESTART_P	CHAR(1.0)	N	'f'
MULTIPLE_VALUES_P	CHAR(1.0)	N	'f'
MANDATORY_P	CHAR(1.0)	N	'f'

Primary key:

Constraint Name	Columns
AD_PARAM_ELTS_ID_PK	ELEMENT_ID

Check Constraints:

Constraint Name	Check Condition
AD_PARAM_ELTS_MANDATORY_CK	mandatory_p in ('t','f')
AD_PARAM_ELTS_MANDATORY_NN	"MANDATORY_P" IS NOT NULL
AD_PARAM_ELTS_MULT_CK	multiple_values_p in ('t','f')
AD_PARAM_ELTS_MULT_NN	"MULTIPLE_VALUES_P" IS NOT NULL
AD_PARAM_ELTS_NAME_NN	"ELEMENT_NAME" IS NOT NULL
AD_PARAM_ELTS_PARAMETER_KEY_NN	"PARAMETER_KEY" IS NOT NULL
AD_PARAM_ELTS_RESTART_CK	change_on_restart_p in ('t','f')
AD_PARAM_ELTS_RESTART_NN	"CHANGE_ON_RESTART_P" IS NOT NULL
AD_PARAM_ELTS_TYPE_CK	element_type in ('text','integer','boolean')
AD_PARAM_ELTS_TYPE_NN	"ELEMENT_TYPE" IS NOT NULL
AD_PARAM_ELTS_VERSION_ID_NN	"VERSION_ID" IS NOT NULL

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
AD_PARAM_ELTS_VERSION_ID_FK	VERSION_ID	APM_PACKAGE_VERSIONS	APM_PACKAGE_VERS_ID_PK	CASCADE

Unique Keys:

Constraint name	Columns
AD_PARAM_ELTS_UN	VERSION_ID , MODULE_KEY , PARAMETER_KEY

Options:

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

Indexes:

Index Name	Type	Unuqueness	Columns
AD_PARAM_ELTS_ID_PK	NORMAL	UNIQUE	ELEMENT_ID
AD_PARAM_ELTS_UN	NORMAL	UNIQUE	VERSION_ID , MODULE_KEY , PARAMETER_KEY

Referenced by:

Table	Constraint
AD_PARAMETER_VALUES	AD_PARAM_VALS_ELTS_ID_FK

Generated by OraSchemaDoc, (c) Aram Kananov, 2002