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 |