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:
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 = YesDESCRIPTION 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 = UploadIMAGE1 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 NOT NULL DEFAULT 0 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
Related reference
Contract data model
Request for Quote (RFQ) data model