KNTA_SAVED_SEARCHES

This table stores all the saved searches.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_ENTITIES_NLS

ENTITY_ID

ENTITY_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_SEARCH_CATEGORIES

SEARCH_CATEGORY_ID

SEARCH_CATEGORY_ID

KNTA_SAVED_SEARCH_TYPES

SAVED_SEARCH_TYPE_ID

SEARCH_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SAVED_SEARCH_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

SAVED_SEARCH_NAME

NOT NULL

VARCHAR2(80)

Name of the saved search

SEARCH_CATEGORY_ID

NOT NULL

NUMBER

ID of the category to be searched

SEQ

NOT NULL

NUMBER

Order of the search in the category

ENTITY_ID

NOT NULL

NUMBER

ID of the entity being searched for

SEARCH_TYPE_ID

NOT NULL

NUMBER

ID of the search type this record is associated with

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_SAVED_SEARCHES_N1

NONUNIQUE

1

SEARCH_CATEGORY_ID

KNTA_SAVED_SEARCHES_U1

UNIQUE

1

SAVED_SEARCH_ID

Sequences

Sequence Name

Sequence Type

KNTA_SAVED_SEARCHES_S

SAVED_SEARCH_ID