KNTA_SEARCH_CATEGORIES

This table stores the groupings into which a user has placed saved searches.

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_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SEARCH_CATEGORY_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

SEARCH_CATEGORY_NAME

NOT NULL

VARCHAR2(80)

Name displayed to the user for the search category

USER_ID

NOT NULL

NUMBER

Identifier for the user who owns this search category

SEQ

NOT NULL

NUMBER

Relative order of this search category for a given user

EDITABLE_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the user can edit the name or delete the category

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_SEARCH_CATEGORIES_N1

NONUNIQUE

1

USER_ID

KNTA_SEARCH_CATEGORIES_U1

UNIQUE

1

SEARCH_CATEGORY_ID

Sequences

 

Sequence Name

Sequence Type

KNTA_SEARCH_CATEGORIES_S

SEARCH_CATEGORY_ID