Table that stores attachments exchanged in different chat conversations.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| content* | VARBINARY | File Contents |
| filesize | BIGINT | Attachment byte size |
| id* | INT | Unique identifier |
| isagent* | INT | Identifies whether the user sending the attachment is an agent, 0- not an agent, 1 - is an agent |
| name* | VARCHAR (300) | Attachment Name |
| personid* | INT | User code that sends the attachment |
| sessionid* | INT | Session code in which the file was attached, foreign key of AFW_CHAT_SESSION.sessionId |
| type* | VARCHAR (50) | Attachment extension |
| uploadeddate | DATETIME | Date the file is attached |
Primary Key
| PK_AFW_CHAT_ATTACHMENT |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| sessionid* | dbo.AFW_CHAT_SESSION | id | FK01_AFW_CHAT_ATTACHMENT |