This table is deprecated and is provided for
backward compatibility only. This table is replaced by px_promotion
related tables.
Column Descriptions:
Name | Type | Description |
CPPMN_ID | INTEGER NOT NULL | Reserved for IBM internal use. |
USERS_ID | BIGINT NOT NULL | Reserved for IBM internal use. |
STATE | CHAR (4) NOT NULL | Reserved for IBM internal use. |
FIRSTTIMESEEN | TIMESTAMP | Reserved for IBM internal use. |
FIELD1 | VARCHAR (64) | Reserved for IBM internal use. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | CPPMN_ID+USERS_ID | Primary Key |
I0000545 | USERS_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_263 | USERS_ID | USERS | USERS_ID | Cascade |
F_264 | CPPMN_ID | CPPMN | CPPMN_ID | Cascade |