KCRT_REQUEST_SEARCH_COLUMNS

This table associates each user with their search column configuration per request type that the user had done a search on. A row from this table is associated with one or more rows in the KNTA_RESULT_COLUMNS table, representing a user's search column configuration for a request type.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KCRT_REQUEST_TYPES_LOC

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KNTA_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_SEARCH_COLUMN_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

USER_ID

NOT NULL

NUMBER

Identifier for the user who this search column configuration belongs to

REQUEST_TYPE_ID

NOT NULL

NUMBER

Identifier for the request type that this search column configuration is for

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_REQUEST_SEARCH_COLUMNS_U1

UNIQUE

1

REQUEST_SEARCH_COLUMN_ID

KCRT_REQUEST_SEARCH_COLUMNS_U2

UNIQUE

1

USER_ID

KCRT_REQUEST_SEARCH_COLUMNS_U2

UNIQUE

2

REQUEST_TYPE_ID

Sequences

Sequence Name

Sequence Type

KCRT_REQUEST_SEARCH_COLUMNS_S

REQUEST_SEARCH_COLUMN_ID