ATCHAST

This table holds the metadata for the attachment asset in the attachment target.

Column Descriptions:

NameTypeDescription
ATCHAST_IDBIGINT NOT NULLThe primary key for the attachment asset.
STOREENT_IDINTEGER NOT NULL DEFAULT 0The store entity ID that owns the attachment asset.
ATCHTGT_IDBIGINT NOT NULLThe attachment target to which the attachment asset belongs.
ATCHASTPATHVARCHAR (256)The attachment asset path is the relative path of the attachment asset which includes the directory path and the file name of the attachment asset. For example, /image/a.gif
DIRECTORYPATHVARCHAR (128)The directory path of the attachment asset. This is a substring of the attachment asset path when the attachment asset is a file. For example, if the attachment asset path is /image/a.gif, then its directory path is /image.
MIMETYPEVARCHAR (254)The MIME type of the attachment asset. If the attachment asset is an image file, for example, a.gif, then the MIME type will be image/gif. If the attachment asset is an url, then the MIME type will be an empty string.
MIMETYPEENCODINGVARCHAR (128)The MIME type encoding of the attachment asset.
TIMECREATEDTIMESTAMPThe creation time of the attachment asset.
TIMEUPDATEDTIMESTAMPThe most recent update time for the attachment asset.
IMAGE1VARCHAR (254)Image 1 to represent the attachment asset.
IMAGE2VARCHAR (254)Image 2 to represent the attachment asset.
UP_ATCHASTPATHVARCHAR (256)The equivalent value of the ATCHASTPATH column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
OPTCOUNTERSMALLINTThe 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>ATCHAST_IDPrimary Key
I0000856STOREENT_ID+ATCHTGT_ID+ATCHASTPATHUnique Index
I0000857STOREENT_ID+DIRECTORYPATHNon-Unique Index
I0000867STOREENT_IDNon-Unique Index
I0000868ATCHTGT_IDNon-Unique Index
IPF00017UP_ATCHASTPATHNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1107STOREENT_IDSTOREENTSTOREENT_IDCascade
F_1108ATCHTGT_IDATCHTGTATCHTGT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1111ATCHAST_IDATCHASTLGATCHAST_IDCascade