MKT_C_ACCOUNT
This table stores the cache data for Customers (Accounts) Real Time target level. Specifically, it saves the customer identifiers 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_ACCOUNT_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_ACCOUNT_N1 | Non Unique | FUSION_TS_TX_DATA | GUID | Obsolete |
| MKT_C_ACCOUNT_U1 | Unique | Default | GUID, QUALIFIED_ID |