ICMETAPHOR

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

Name	Type	Description
METAPHORID	INTEGER NOT NULL	Reserved for HCL internal use.
CATEGORYID	BIGINT NOT NULL	Reserved for HCL internal use.
STOREID	INTEGER NOT NULL	Reserved for HCL internal use.
TREEID	INTEGER	Reserved for HCL internal use.
EXPLREQ	INTEGER	Reserved for HCL internal use.
METAPHORNAME	VARCHAR (128) NOT NULL	Reserved for HCL internal use.
PUBLISH	INTEGER NOT NULL DEFAULT 0	Reserved for HCL internal use.
SYNC	INTEGER NOT NULL DEFAULT 1	Reserved for HCL internal use.
TEMPLATENAME	VARCHAR (254)	Reserved for HCL internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for HCL internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	METAPHORID	Primary Key
I0000125	METAPHORNAME+CATEGORYID+STOREID	Unique Index
I0000127	STOREID	Non-Unique Index
I0000580	CATEGORYID	Non-Unique Index
I0000581	TREEID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_372	CATEGORYID	ICROOTCAT	ROOTCATEGORYID	Cascade
F_947	STOREID	STORE	STORE_ID	Cascade
F_972	TREEID	ICMERTREE	TREEID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_353	METAPHORID	ICCNCPTLNK	METAPHORID	Cascade
F_369	METAPHORID	ICMERTREE	METAPHORID	Cascade
F_371	METAPHORID	ICMETAFEAT	METAPHORID	Cascade
F_373	METAPHORID	ICMETAPROP	METAPHORID	Cascade