This table is deprecated and is provided for
backward compatibility only.
Column Descriptions:
Name | Type | Description |
METAPHORID | INTEGER NOT NULL | Reserved for IBM internal use. |
CATEGORYID | BIGINT NOT NULL | Reserved for IBM internal use. |
STOREID | INTEGER NOT NULL | Reserved for IBM internal use. |
TREEID | INTEGER | Reserved for IBM internal use. |
EXPLREQ | INTEGER | Reserved for IBM internal use. |
METAPHORNAME | VARCHAR (128) NOT NULL | Reserved for IBM internal use. |
PUBLISH | INTEGER NOT NULL DEFAULT 0 | Reserved for IBM internal use. |
SYNC | INTEGER NOT NULL DEFAULT 1 | Reserved for IBM internal use. |
TEMPLATENAME | VARCHAR (254) | Reserved for IBM internal use. |
OPTCOUNTER | SMALLINT | Reserved for IBM 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 |