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
| 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.
|