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 Name | Column 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 | Attachment content that are in binary form. |
RESERVED | VARCHAR(254) | Customizable. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000017 | ATTACHMENTURL | Unique Index |
SQL050212031158680 | ATTACHMENT_ID | Primary Key |
I0000290 | ATTACHUSG_ID | Non-Unique Index |
I0000452 | MEMBER_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_67 | ATTACHUSG_ID | ATTACHUSG | ATTACHUSG_ID | Cascade |
F_68 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1016 | ATTACHMENT_ID | ATTRVALUE | ATTACHMENT_ID | Cascade |
F_1004 | ATTACHMENT_ID | PATTRVALUE | ATTACHMENT_ID | Cascade |
F_868 | ATTACHMENT_ID | TRDATTACH | ATTACHMENT_ID | Cascade |