This table holds the metadata for the attachment asset in the attachment target.
Column Descriptions
| Column Name
| Column Type
| Description
|
| ATCHAST_ID
| BIGINT NOT NULL
| The primary key for the attachment asset.
|
| STOREENT_ID
| INTEGER NOT NULL DEFAULT 0
| The store entity ID that owns the attachment asset.
|
| ATCHTGT_ID
| BIGINT NOT NULL
| The attachment target to which the attachment asset belongs.
|
| ATCHASTPATH
| VARCHAR(128)
| 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
|
| DIRECTORYPATH
| VARCHAR(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.
|
| MIMETYPE
| VARCHAR(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.
|
| MIMETYPEENCODING
| VARCHAR(128)
| The MIME type encoding of the attachment asset.
|
| TIMECREATED
| TIMESTAMP
| The creation time of the attachment asset.
|
| TIMEUPDATED
| TIMESTAMP
| The most recent update time for the attachment asset.
|
| IMAGE1
| VARCHAR(254)
| Image 1 to represent the attachment asset.
|
| IMAGE2
| VARCHAR(254)
| Image 2 to represent the attachment asset.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|