Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATCHAST
This table holds the metadata for the attachment asset in the attachment target.
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.
Indexes Index Name Indexed Column Names Index Type I0000856 STOREENT_ID+ATCHTGT_ID+ATCHASTPATH Unique Index SQL100520030257040 ATCHAST_ID Primary Key I0000857 STOREENT_ID+DIRECTORYPATH Non-Unique Index I0000867 STOREENT_ID Non-Unique Index I0000868 ATCHTGT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1108 ATCHTGT_ID ATCHTGT ATCHTGT_ID Cascade F_1107 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1111 ATCHAST_ID ATCHASTLG ATCHAST_ID Cascade _vcc_freeselect_bottom_