Share this page
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 |
