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 Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
I0000017 ATTACHMENTURL Unique Index
SQL050212031158680 ATTACHMENT_ID Primary Key
I0000290 ATTACHUSG_ID Non-Unique Index
I0000452 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_67 ATTACHUSG_ID ATTACHUSG ATTACHUSG_ID Cascade
F_68 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign 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

Feedback