Database
Groundhogg settings are stored in the WordPress wp_options table
Groundhogg has its own set of tables. These are the core tables, extensions can add additional tables to the database.
| Table Name |
Description |
| gh_activity |
The activities are stored in the gh_activity table. |
| gh_activitymeta |
Activity metadata is stored in the gh_activitymeta table. |
| gh_background_tasks |
Background tasks for broadcasting, etc. are stored in the gh_background_tasks table. |
| gh_broadcastmeta |
Broadcast metadata is stored in the gh_broadcastmeta table. |
| gh_broadcasts |
Broadcasts are stored in the gh_broadcasts table. |
| gh_campaigns |
Campaigns are stored in the gh_campaigns table. |
| gh_contactmeta |
Contact metadata is stored in the gh_contactmeta table. |
| gh_contacts |
Contacts are stored in the gh_contacts table. |
| gh_emailmeta |
Email metadata is stored in the gh_emailmeta table. |
| gh_emails |
Emails are stored in the gh_emails table. |
| gh_email_log |
Email events are stored in the gh_email_log table. |
| gh_events |
Events are stored in the gh_events table. |
| gh_event_queue |
Events are queued in the gh_event_queue table. |
| gh_form_impressions |
Views/Impressions for web forms are stored in the gh_form_impressions table. |
| gh_funnelmeta |
Funnels metadata is stored in the gh_funnelmeta table. |
| gh_funnels |
Funnels are stored in the gh_funnels table. |
| gh_log |
??? are stored in the gh_log table. |
| gh_notes |
Contact notes are stored in the gh_notes table. |
| gh_object_relationships |
Campaigns are stored in the gh_object_relationships table. |
| gh_other_activity |
??? are stored in the gh_other_activity table. |
| gh_activity |
??? are stored in the gh_activity table. |
| gh_page_visits |
Page Visits are stored in the gh_page_visits table. |
| gh_permissions_keys |
??? are stored in the gh_permissions_keys table. |
| gh_stepmeta |
Step metadata is stored in the gh_stepmeta table. |
| gh_steps |
Steps are stored in the gh_steps table. |
| gh_submissionmeta |
Submission metadata is stored in the gh_submissionmeta table. |
| gh_submissions |
Web Form submissions are stored in the gh_submissions table. |
| gh_tags |
Tags are stored in the gh_tags table. |
| gh_tag_relationships |
Tag relationships with Contacts are stored in the gh_tag_relationships table. |
| gh_tasks |
Tasks are stored in the gh_tasks table. |
| gh_user_agents |
User agents are stored in the gh_user_agents table. |
gh_activity
Structure
| Column |
Type |
| ID |
bigint(20) unsigned Auto Increment |
| timestamp |
bigint(20) unsigned |
| contact_id |
bigint(20) unsigned |
| funnel_id |
bigint(20) unsigned |
| step_id |
bigint(20) unsigned |
| email_id |
bigint(20) unsigned |
| event_id |
bigint(20) unsigned |
| activity_type |
varchar(191) |
| referer |
textar(191) |
| referer_hash |
varchar(20) |
| value |
decimal(10,2) unsigned [0.00] |
| ip_address |
varbinary(16) |
| user_agent |
bigint(20) unsigned |
Indexes
| Primary |
ID |
| Index |
event_id |
| Index |
contact_id |
| Index |
timestamp |
| Index |
funnel_id, step_id, email_id |
Structure
| Column |
Type |
| meta_id |
bigint(20) unsigned Auto Increment |
| activity_id |
bigint(20) unsigned |
| meta_key |
varchar(191) NULL |
| meta_value |
longtext NULL |
Indexes
| Primary |
meta_id |
| Index |
meta_id |
| Index |
meta_key |
gh_background_tasks
Structure
| Column |
Type |
| ID |
bigint(20) unsigned Auto Increment |
| user_id |
bigint(20) unsigned |
| task |
longtext |
| time |
bigint(12) unsigned |
| status |
varchar(20) |
| claim |
varchar(20) |
| date_created |
datetime |
Indexes
