This table contains information about Attachments.
An Attachment is a supporting document for a trading document. For
example, it can be a specification of a product, or a price list
spreadsheet.
Column Descriptions:
| Name | Type | Description |
| ATTACHMENT_ID | BIGINT NOT NULL | Attachment ID (primary key). |
| ATTACHMENTURL | VARCHAR (254) NOT NULL | The URL of the Attachment. |
| MEMBER_ID | BIGINT NOT NULL | The owner of the Attachment. |
| ATTACHUSG_ID | CHAR (64) | Foreign key to the attachment usage (ATTACHUSG)
table. |
| MIMETYPE | VARCHAR (254) | The Attachment mimeType. |
| MIMETYPEENCODING | VARCHAR (128) | The Attachment encoding. |
| TIMECREATED | TIMESTAMP | The Attachment creation time. |
| TIMEUPDATED | TIMESTAMP | The last time the Attachment was updated. |
| MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates if this Attachment has been marked for
deletion using the Database Cleanup utility. Valid values are as
follows:
0 = No
1 = Yes |
| DESCRIPTION | VARCHAR (254) | A brief description of the Attachment. |
| FILENAME | VARCHAR (254) | Local file name from the client machine. May not
be the same as
ATTACHMENTURL. |
| FILESIZE | BIGINT | The size of attachment file. |
| CREATEMETHOD | INTEGER DEFAULT 0 | The creation method for the Attachment. Valid
values are as follows:
0 = Manual
1 = Upload |
| IMAGE1 | VARCHAR (254) | The image or icon associated with the
attachment. |
| IMAGE2 | VARCHAR (254) | The image or icon associated with the
attachment. |
| CONTENT | BLOB (10000000) | Attachment content that are in binary form. |
| RESERVED | VARCHAR (254) | Customizable. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ATTACHMENT_ID | Primary Key |
| I0000017 | ATTACHMENTURL | Unique Index |
| I0000290 | ATTACHUSG_ID | Non-Unique Index |
| I0000452 | MEMBER_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_67 | ATTACHUSG_ID | ATTACHUSG | ATTACHUSG_ID | Cascade |
| F_68 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1004 | ATTACHMENT_ID | PATTRVALUE | ATTACHMENT_ID | Cascade |
| F_1016 | ATTACHMENT_ID | ATTRVALUE | ATTACHMENT_ID | Cascade |
| F_868 | ATTACHMENT_ID | TRDATTACH | ATTACHMENT_ID | Cascade |