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