Attachment definition table.
| Column Name | Type | Length | Nullable | Unicode | Description |
|---|---|---|---|---|---|
| attachmentID | bigint | N/A | false | Attachment ID. Primary key. | |
| contentType | varchar | 100 | false | MIME-type of attachment. | |
| creationDate | bigint | N/A | false | Creation date. | |
| documentID | varchar | 255 | true | true | The ID of the (temporary) parent document. |
| fileName | varchar | 255 | false | true | Name of attachment. |
| fileSize | int | N/A | false | Size of attachment in bytes. | |
| modificationDate | bigint | N/A | false | Last modified date. | |
| objectID | bigint | N/A | true | ID of object the attachment belongs to. | |
| objectType | int | N/A | false | Type of object the attachment belongs to. |