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 |