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 = 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 (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 |