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 Name | Column Type | Column Description |
---|---|---|
ATTACHMENTURL | VARCHAR (254) NOT NULL |
The URL of the Attachment. |
ATTACHMENT_ID | BIGINT NOT NULL |
Attachment ID (primary key). |
ATTACHUSG_ID | CHARACTER (64) NULL |
Foreign key to the attachment usage (ATTACHUSG) table. |
CONTENT | BLOB (10000000) NULL |
Attachment content that are in binary form. |
CREATEMETHOD | INTEGER NULL, DEFAULT 0 |
The creation method for the Attachment: 0 = Manual. 1 = Upload. |
DESCRIPTION | VARCHAR (254) NULL |
A brief description of the Attachment. |
FILENAME | VARCHAR (254) NULL |
Local file name from the client machine. May not be the same as ATTACHMENTURL. |
FILESIZE | BIGINT NULL |
The size of attachment file. |
IMAGE1 | VARCHAR (254) NULL |
The image or icon associated with the attachment. |
IMAGE2 | VARCHAR (254) NULL |
The image or icon associated with the attachment. |
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
Indicates if this Attachment has been marked for deletion using the
Database Cleanup utility: 0 = No. 1 = Yes. |
MEMBER_ID | BIGINT NOT NULL |
The owner of the Attachment. |
MIMETYPE | VARCHAR (254) NULL |
The Attachment mimeType. |
MIMETYPEENCODING | VARCHAR (128) NULL |
The Attachment encoding. |
RESERVED | VARCHAR (254) NULL |
Customizable. |
TIMECREATED | TIMESTAMP NULL |
The Attachment creation time. |
TIMEUPDATED | TIMESTAMP NULL |
The last time the Attachment was updated. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000017 | ATTACHMENTURL | Unique Index |
I0000290 | ATTACHUSG_ID | Non-Unique Index |
SQL030416034837200 | ATTACHMENT_ID | Primary Key |
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_1004 | ATTACHMENT_ID | PATTRVALUE | ATTACHMENT_ID | Cascade |
F_1016 | ATTACHMENT_ID | ATTRVALUE | ATTACHMENT_ID | Cascade |
F_868 | ATTACHMENT_ID | TRDATTACH | ATTACHMENT_ID | Cascade |