COLLIMGMAPAREA
This table stores the image map information that are used in the store front pages.
Column Descriptions:
Name Type Description COLLIMGMAPAREA_ID BIGINT NOT NULL The primary key of the Collateral Image Map Area. COLLATERAL_ID INTEGER NOT NULL The collateral ID LANGUAGE_ID INTEGER NOT NULL The language ID COORDINATES VARCHAR (1024) The coordinate of the image map. For example, "10,20,62,126" TITLE VARCHAR (256) The title of the image map. ALT VARCHAR (256) An alternate text for the image map. SHAPE VARCHAR (32) Specify the shape of the image map. For example, default, rect, circle, poly. SEQUENCE DOUBLE NOT NULL DEFAULT 0 The sequence TARGET VARCHAR (128) Specify where to open the target URL. For example, _blank, _parent, _self, _top, and the frame name. URL VARCHAR (1024) link to the image, i.. IIA?partnumber=1234... HTMLDEF CLOB (1000000) The HTML definition. FIELD1 VARCHAR (256) Customizable field. Can be used to store other attributes. FIELD2 VARCHAR (256) Customizable field. Can be used to store other attributes. FIELD3 VARCHAR (256) Customizable field. Can be used to store other attributes. FIELD4 VARCHAR (256) Customizable field. Can be used to store other attributes. FIELD5 VARCHAR (256) Customizable field. Can be used to store other attributes. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type P_0016 COLLIMGMAPAREA_ID Primary Key I0001485 COLLATERAL_ID+LANGUAGE_ID+COORDINATES Unique Index I0001486 LANGUAGE_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_3742 COLLATERAL_ID COLLATERAL COLLATERAL_ID Cascade F_3743 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade