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:

NameTypeDescription
ATTACHMENT_IDBIGINT NOT NULLAttachment ID (primary key).
ATTACHMENTURLVARCHAR (254) NOT NULLThe URL of the Attachment.
MEMBER_IDBIGINT NOT NULLThe owner of the Attachment.
ATTACHUSG_IDCHAR (64)Foreign key to the attachment usage (ATTACHUSG) table.
MIMETYPEVARCHAR (254)The Attachment mimeType.
MIMETYPEENCODINGVARCHAR (128)The Attachment encoding.
TIMECREATEDTIMESTAMPThe Attachment creation time.
TIMEUPDATEDTIMESTAMPThe last time the Attachment was updated.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this Attachment has been marked for deletion using the Database Cleanup utility. Valid values are as follows: 0 = No 1 = Yes
DESCRIPTIONVARCHAR (254)A brief description of the Attachment.
FILENAMEVARCHAR (254)Local file name from the client machine. May not be the same as ATTACHMENTURL.
FILESIZEBIGINTThe size of attachment file.
CREATEMETHODINTEGER DEFAULT 0The creation method for the Attachment. Valid values are as follows: 0 = Manual 1 = Upload
IMAGE1VARCHAR (254)The image or icon associated with the attachment.
IMAGE2VARCHAR (254)The image or icon associated with the attachment.
CONTENTBLOB (10000000)Attachment content that are in binary form.
RESERVEDVARCHAR (254)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ATTACHMENT_IDPrimary Key
I0000017ATTACHMENTURLUnique Index
I0000290ATTACHUSG_IDNon-Unique Index
I0000452MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_67ATTACHUSG_IDATTACHUSGATTACHUSG_IDCascade
F_68MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1004ATTACHMENT_IDPATTRVALUEATTACHMENT_IDCascade
F_1016ATTACHMENT_IDATTRVALUEATTACHMENT_IDCascade
F_868ATTACHMENT_IDTRDATTACHATTACHMENT_IDCascade