KNTA_PARAMETER_SETS

This table stores all the parameters sets that are available when you need parameters for something. Each row include table which connect this set to the list of values. A parameter set is a collection of parameters associated with an entity. A parameter set can have many contexts (determined by the value of the column identified by CONTEXT_COLUMN) and each context has a separate set of parameters.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_ENTITY_TOKENS_NLS	ENTITY_TOKEN_ID	TOKEN_PREFIX_ENTITY_ID

Column Descriptions

Column Name	Null?	Data Type	Description
PARAMETER_SET_ID	NOT NULL	NUMBER	System-generated identifier
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
ENTITY_LAST_UPDATE_DATE	NOT NULL	DATE	Date a record in the entity was last updated
PARAMETER_SET_NAME	NOT NULL	VARCHAR2(80)
PARAMETER_SET_TITLE	NULLABLE	VARCHAR2(50)
DESCRIPTION	NULLABLE	VARCHAR2(240)
PRODUCT_CODE	NULLABLE	VARCHAR2(30)
PARAMETER_SET_TYPE	NOT NULL	VARCHAR2(30)
NUM_COLUMNS	NOT NULL	NUMBER
TABLE_NAME	NOT NULL	VARCHAR2(30)
CONTEXT_COLUMN	NULLABLE	VARCHAR2(30)
ORIGINAL_CONTEXT_COLUMN	NULLABLE	VARCHAR2(30)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
TOKEN_PREFIX_ENTITY_ID	NULLABLE	NUMBER
SECURITY_ENABLED_FLAG	NOT NULL	VARCHAR2(1)
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_PARAMETER_SETS_N1	NONUNIQUE	1	TABLE_NAME
KNTA_PARAMETER_SETS_N1	NONUNIQUE	2	CONTEXT_COLUMN
KNTA_PARAMETER_SETS_U1	UNIQUE	1	PARAMETER_SET_ID
SYS_C005198439	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.