ID

smallint

No

Identifier; primary key.

NTOPIC_ID

varchar

40

No

Natural key of topic.

PARENT_TOPIC_ID

integer

Yes

ID of parent topic from this table.

NAME

varchar

254

No

Topic name in the default language.

NAME_EN

varchar

254

Yes

Topic name in English.

DESCRIPTION

varchar

1000

Yes

Topic description in the default language.

DESCRIPTION_EN

varchar

1000

Yes

Topic description in English.

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.

RECORD_LAST_UPDATE

timestamp

Yes

Date this record was last updated.

MOST_RECENT

one-digit

No

Indicates that this record is the most recent.

0 = No

1 = Yes

Default value is 1.

DELETED

one-digit

No

Indicates that this record has been deleted.

0= No

1 = Yes

Default value is 0.

TOPIC_PATH

varchar

4000

Yes

Path to this topic in the topic taxonomy.