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 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.
Indexes:
Index Name Indexed Column Names Index Type
I0000017 ATTACHMENTURL Unique Index
I0000290 ATTACHUSG_ID Non-Unique Index
SQL030416034837200 ATTACHMENT_ID Primary Key
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

Referenced By:
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