MKT_C_CONSUMER
This table stores the cache data for Consumers Real Time target level. Specifically it saves the Consumer IDs of complex segmentation criteria which can be used to minimize repetitive complex query operations
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MKT_C_CONSUMER_PK |
GUID, QUALIFIED_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| GUID | VARCHAR2 | 50 | Yes | Unique identifier to identify the cache result set |
| QUALIFIED_ID | VARCHAR2 | 30 | Yes | Target level ID that qualified for this cache result set |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MKT_C_CONSUMER_N1 | Non Unique | Default | GUID | Obsolete |
| MKT_C_CONSUMER_PK | Unique | Default | GUID, QUALIFIED_ID |