1. Tables and Views for Sales, Fusion Service, and Field Service
  2. FFS_CHAT_MSG_ATTACHMENT

FFS_CHAT_MSG_ATTACHMENT

Entity to store the actual content and thumbnail of chat message attachments.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

FFS_CHAT_MSG_ATTACHMENT_PK

ATTACH_ID

Columns

Name Datatype Length Precision Not-null Comments
ATTACH_ID NUMBER 18 Yes Unique identifier for the chat message attachment.
MESSAGE_ID NUMBER 19 Yes Identifier of the chat message for which the attachment is related.
ATTACH_TYPE VARCHAR2 32 Yes Represent the type of the attachment content.
ATTACH_CONTENT BLOB Yes Binary content of the original attachment data.
THUMBNAIL BLOB Binary content of the compressed attachment data.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ATTACH_FILENAME VARCHAR2 512 Yes The name of the uploaded attachment file as provided by the user or the source system. If the file name is not provided, a default file name ('attachment') is assigned.
ATTACH_MIME_TYPE VARCHAR2 128 Stores the MIME type of the attached file, representing its format and content type (for example, image/png, application/pdf, text/plain). Used for attachment validation, handling, and rendering. All standard MIME types are supported.

Indexes

Index Uniqueness Tablespace Columns
FFS_CHAT_MSG_ATTACHMENT_N1 Non Unique Default MESSAGE_ID
FFS_CHAT_MSG_ATTACHMENT_PK Unique Default ATTACH_ID