COLLIMGMAPAREA

This table stores the image map information that are used in the store front pages.

Column Descriptions:

NameTypeDescription
COLLIMGMAPAREA_IDBIGINT NOT NULLThe primary key of the Collateral Image Map Area.
COLLATERAL_IDINTEGER NOT NULLThe collateral ID
LANGUAGE_IDINTEGER NOT NULLThe language ID
COORDINATESVARCHAR (1024)The coordinate of the image map. For example, "10,20,62,126"
TITLEVARCHAR (256)The title of the image map.
ALTVARCHAR (256)An alternate text for the image map.
SHAPEVARCHAR (32)Specify the shape of the image map. For example, default, rect, circle, poly.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence
TARGETVARCHAR (128)Specify where to open the target URL. For example, _blank, _parent, _self, _top, and the frame name.
URLVARCHAR (1024)link to the image, i.. IIA?partnumber=1234...
HTMLDEFCLOB (1000000)The HTML definition.
FIELD1VARCHAR (256)Customizable field. Can be used to store other attributes.
FIELD2VARCHAR (256)Customizable field. Can be used to store other attributes.
FIELD3VARCHAR (256)Customizable field. Can be used to store other attributes.
FIELD4VARCHAR (256)Customizable field. Can be used to store other attributes.
FIELD5VARCHAR (256)Customizable field. Can be used to store other attributes.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0016COLLIMGMAPAREA_IDPrimary Key
I0001485COLLATERAL_ID+LANGUAGE_ID+COORDINATESUnique Index
I0001486LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3742COLLATERAL_IDCOLLATERALCOLLATERAL_IDCascade
F_3743LANGUAGE_IDLANGUAGELANGUAGE_IDCascade