WebSphere Commerce database table: ATTACHMENT

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.

Indexes
Index Name Indexed Column Names Index Type
I0000017 ATTACHMENTURL Unique Index
SQL060903235127390 ATTACHMENT_ID Primary Key
I0000290 ATTACHUSG_ID Non-Unique Index
I0000452 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Names 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
Related reference