DMP System & Source Tables
These tables handle data dictionaries, campaign data sources, currency conversions, and global mapping configurations for the Data Management Platform.
| Tables | Description |
|---|---|
| campaignencryptionkeymapping | Stores campaign encryption key |
| campaignunicoderangemapping | Stores campaign unicode range mapping data |
| cdpcustomerproperty | Stores customer properties info |
| cdpdestinationeventjsonmapping | Stores destination event json data mapping |
| cdpjsontemplate | Stores json template data |
| currency | Stores currency details |
| currencyconversion | Stores currency conversion |
| dmpairport | Stores airport data |
| dmpcampaigncategory | Stores dmp campaign category |
| dmpcampaigndatadictionary | Contains all the details of datapoints configured for each tenant at campaign level. |
| dmpcampaigndatasource | Contains details of all datasources for each tenant at campaign level. |
| dmpcampaigndatasourcemapping | Contains the details of mapping between metadata and datapoint at campaign level. |
| dmpcampaigndatasourceschema | Stores campaign data source schema data |
| dmpcampaignemaildetails | Stores campaign email details |
| dmpdataapicredentials | Stores data api credentials data |
| dmpdataapiparamsnode | Stores data api params node |
| dmpdataingestionapi | Stores API specific token information |
| dmpdatapoint | Stores data point information |
| dmpemaillandingpagejsonmacros | Stores email landing page json macros data |
| dmpglobaldatadictionary | Contains all the details of datapoints configured at global level. |
| dmpglobaldatasource | Contains details of all datasources at global level. |
| dmpglobaldatasourcemapping | Contains the details of mapping between metadata and datapoint at global level. |
| dmpjourneyversion | Stores journey version |
| dmpmasterdatasourcecampaignmapping | Stores master datasource campaign mapping data |
| dmpnbakeyformation | Stores nba key formation data |
| dmpreportautomation | Stores report automation data |
| dmpverticaldatadictionary | Contains all the details of datapoints configured for each tenant at vertical level. |
| dmpverticaldatasource | Contains details of all datasources for each tenant at vertical level. |
| dmpverticaldatasourcemapping | Contains the details of mapping between metadata and datapoint at vertical level. |
| flighttype | Stores flight type data |
| metaapiauth | Stores meta api authentication data |
| metaapiidtoengmapping | Stores meta api engine mapping data |
| productcategory | Stores product category data |