This table contains object types that can be scheduled to E-Marketing Spot.
Column Name | Column Type | Description |
---|---|---|
ESMAPTYP_ID | INTEGER NOT NULL | The ID representing the object type. |
NAME | VARCHAR(20) NOT NULL | The name of the object type to be scheduled to an E-marketing spot. By default the possible values are: 1. Initiative 2. Content |
DESCRIPTION | VARCHAR(100) | The full description of the object type. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000832 | NAME | Unique Index |
SQL050212031226430 | ESMAPTYP_ID | Primary Key |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1093 | ESMAPTYP_ID | ESMAPOBJ | ESMAPTYP_ID | Cascade |