KNTA_HELP_CONTENTS

This table stores the help content provided by the administrator, which allows customers to enter custom help information.

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_ENTITIES_NLS

ENTITY_ID

PARENT_ENTITY_ID

Column Descriptions

Column Name

Null?

Data Type

Description

HELP_CONTENT_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

ENTITY_ID

NOT NULL

NUMBER

 

ENTITY_PRIMARY_KEY

NOT NULL

NUMBER

 

PARENT_ENTITY_ID

NOT NULL

NUMBER

 

PARENT_ENTITY_PRIMARY_KEY

NOT NULL

NUMBER

 

HELP_CONTENTS

NOT NULL

CLOB

 

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

 

SOURCE

NULLABLE

VARCHAR2(100)

 

DEFINITION_LANGUAGE

NOT NULL

VARCHAR2(40)

 

REFERENCE_CODE

NOT NULL

VARCHAR2(200)

 

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_HELP_CONTENTS_N1

NONUNIQUE

1

PARENT_ENTITY_ID

KNTA_HELP_CONTENTS_N1

NONUNIQUE

2

PARENT_ENTITY_PRIMARY_KEY

KNTA_HELP_CONTENTS_U1

UNIQUE

1

HELP_CONTENT_ID

SYS_C00109352332

UNIQUE

1

REFERENCE_CODE

Sequences

This table uses no sequences.