This table contains information about the Search environments used to index content and return answers to end-users.

Column Name

Type

Length

Null Allowed

Description

ID

smallint

No

Identifier; primary key.

NENVIRONMENT_ID

varchar

40

No

Natural key of environment.

NAME

varchar

254

No

Environment name in the default language.

NAME_EN

varchar

254

Yes

Environment name in English.

RECORD_LAST_UPDATE

timestamp

Yes

Date the record was last updated.

RECORD_START_DATE

timestamp

Yes

Date when the information in this warehouse record became effective

RECORD_END_DATE

timestamp

Yes

Date when the information in this warehouse record is no longer effective.

MOST_RECENT

one-digit

No

Indicates that this record is the most recent.

0 = No

1 = Yes

DELETED

one-digit

No

Indicates that this record has been deleted.

0= No

1 = Yes

PROJECT_ID

smallint

No

Foreign key to ARF_SEARCH_PROJECT.ID.

 
loading table of contents...