Formidable Forms

Formidable Forms

  • Features
  • Pricing
  • Resources
    • Docs & Support
    • Blog
    • Community
  • Solutions
    • Web Applications
    • Calculators
    • Surveys
    • Directories
    • Payments
    • Contact forms
  • Login
  • Get Formidable Forms

Database Schema

Last Updated: November 18, 2019

Knowledge Base → Extend Formidable Forms → Database Schema

NOTE: In the wp_posts table, we have three different custom post types: frm_form_actions, frm_styles, and frm_display for Form Actions, Form Styles and Views respectively.

Formidable Forms is the best WordPress Form Builder plugin. Get it for free!

wp_frm_fields

id INT(11) auto_increment
field_key VARCHAR(100)
name TEXT
description TEXT
type TEXT
default_value LONGTEXT
options LONGTEXT
field_order INT(11)
required INT(1)
field_options LONGTEXT
form_id INT(11)
created_at DATETIME

wp_frm_forms

id INT(11) auto_increment
form_key VARCHAR(100)
name VARCHAR(225)
description TEXT
parent_form_id INT(11)
logged_in TINYINT(1)
editable TINYINT(1)
is_template TINYINT(1)
default_template TINYINT(1)
status VARCHAR(225)
options LONGTEXT
created_at DATETIME

wp_frm_items

id INT(11) auto_increment
item_key VARCHAR(100)
name VARCHAR(225)
description TEXT
ip TEXT
form_id INT(11)
post_id INT(11)
user_id INT(11)
parent_item_id int(11)
is_draft BOOLEAN
updated_by INT(11)
created_at DATETIME
updated_at DATETIME

wp_frm_item_metas

id INT(11) auto_increment
meta_value LONGTEXT
field_id INT(11)
item_id INT(11)
created_at DATETIME

wp_frm_payments

id bigint(20) NOT NULL auto_increment
meta_value longtext default NULL
receipt_id varchar(100) default NULL
invoice_id varchar(100) default NULL
sub_id varchar(100) default NULL
item_id bigint(20) NOT NULL
action_id bigint(20) NOT NULL
amount decimal(12,2) NOT NULL default '0.00'
status varchar(100) default NULL
begin_date date NOT NULL
expire_date date default NULL
paysys varchar(100) default NULL
created_at datetime NOT NULL

  • wp_frm_fields
  • wp_frm_forms
  • wp_frm_items
  • wp_frm_item_metas
  • wp_frm_payments
Categories
×

Categories

  • Installation & Getting Started
  • Account Management
  • Forms
  • Entries
  • Views
  • Styles
  • Importing & Exporting
  • Add-Ons
  • Extend Formidable Forms

Using WordPress and want to get Formidable Forms for free?

Get Formidable Forms Lite Now

This article may contain affiliate links. Once in a while, we earn commissions from those links. But we only recommend products we like, with or without commissions.

Take on bigger projects Right Now

Get the tools you need to revolutionize your workflow and architect a masterpiece. Build the most advanced WordPress forms and actually use the data you collect in meaningful ways.

Get the most advanced WordPress form plugin and the only form builder with integrated Views.

Get Formidable Forms Now

Resources

  • Community
  • Affiliates
  • Contact
  • Free Online Form Builder

Top Features

  • Application Builder
  • Calculator Forms
  • Surveys & Polls
  • Quiz Maker
  • Form Templates
  • Application Templates
  • Directories
  • Donation Plugin

Company

  • About Us
  • Giving Back
  • Careers
  • Newsletter
  • WP Tasty
  • Nutrifox

Copyright © 2023 Strategy11, LLC. Formidable Forms® is a registered trademark Strategy11, LLC.
Privacy Policy | Terms of Service | Sitemap

Join 300,000+ using Formidable Forms to create form-focused solutions fast. Get Started See User Reviews