KNTA_USERS_AVATAR

This table stores profile pictures of users.

Foreign Keys

This table has no foreign keys.

Column Descriptions

Column Name Null? Data Type Description
AVATAR_ID NOT NULL NUMBER(19,0) The system-generated profile ID.
USER_ID NOT NULL NUMBER(19,0) The system-generated identifier for the user.
AVATAR_IMAGE NOT NULL CLOB Profile picture content in Base64 format.
CREATED_BY NOT NULL NUMBER(19,0) Identifier for the user who created the record.
CREATION_DATE NOT NULL DATE The date when the record was created.
LAST_UPDATED_BY NOT NULL NUMBER(19,0) Identifier for the user who last updated the record.
LAST_UPDATE_DATE NOT NULL DATE The date when the record was last updated.

Indexes

Index Name Index Type Sequence Column Name
KNTA_USERS_AVATAR_N1 NORMAL 1 USER_ID
PK_KNTA_USERS_AVATAR NORMAL 2 AVATAR_ID

Sequences

Sequence Name Sequence Type
KNTA_USERS_AVATAR_S Number