Database structure

wpdatatables

Contains the tables with settings that exist within wpDataTables.

• id

  The unique table ID.

• title

  The table title.

• show_title

  Defines if the table title is shown or not. Stored as boolean.

• table_type

  Defines table type as a string (excel, csv, SQL…).

• file_location

  Contains parameter where the file is located on media lib or external URL.

• connection

  Contains a string of connections for an external database.

• content

  Contains data source (file URLs, SQL query, simple data, forms data…).

• filtering 

  Defines if the filtering is active or not. An integer is used as a boolean (0 is false, 1 is true).

• filtering_form 

  If the filtering form is applied (shown outside of the table). An integer is used as a boolean (0 is false, 1 is true).

• cache_source_data

  Defines if the table caching is active or not. An integer is used as a boolean (0 is false, 1 is true).

• auto_update_cache 

  If the auto-updating cache is applied. An integer is used as a boolean (0 is false, 1 is true).

• sorting 

  Defines if the sorting is active or not. An integer is used as a boolean (0 is false, 1 is true).

• tools 

  If the table tools are applied. An integer is used as a boolean (0 is false, 1 is true).

• server_side 

  Defines if the server side is active or not. An integer is used as a boolean (0 is false, 1 is true).

• editable 

  If the editing table is applied. An integer is used as a boolean (0 is false, 1 is true).

• inline_editing 

  If an inline editing table is applied. An integer is used as a boolean (0 is false, 1 is true).

• popover_tools 

  If a popover editing table is applied. An integer is used as a boolean (0 is false, 1 is true).

• editor_roles 

  Contains user roles that are assigned for the editing table.

• mysql_table_name 

  Contain database table name for editing.

• edit_only_own_rows 

  If editing only for user rows is applied. An integer is used as a boolean (0 is false, 1 is true).

• userid_column_id

  Contains user id for editing user’s rows.

• display_length 

  Contain a number of rows that will be displayed on load.

• auto_refresh

  Contain time for auto-refresh tables (only server-side tables).

• fixed_columns 

  Defines if the fixed columns are active or not. An integer is used as a boolean (0 is false, 1 is true).

• fixed_layout

  If a fixed table layout is applied. An integer is used as a boolean (0 is false, 1 is true).

• responsive

  Defines if the responsive is active or not. An integer is used as a boolean (0 is false, 1 is true).

• scrollable 

  Defines if the horizontal scroll is active or not. An integer is used as a boolean (0 is false, 1 is true).

• word_wrap

  Defines if the word wrap is active or not. An integer is used as a boolean (0 is false, 1 is true).

• hide_before_load

  If hide before the table is applied. An integer is used as a boolean (0 is false, 1 is true).

• var1 

  Contain value of placeholder var1.

• var2 

  Contain value of placeholder var2.

• var3 

  Contain value of placeholder var3.

• var4 

  Contain value of placeholder var4.

• var5 

  Contain value of placeholder var5.

• var6

  Contain value of placeholder var6.

• var7

  Contain value of placeholder var7.

• var8

  Contain value of placeholder var8.

• var9 

  Contain value of placeholder var9.

• tabletools_config 

  Contain serialized PHP array of chosen table tools (print, excel, csv, copy and pdf)

• advanced_settings

  Contain JSON with advanced table settings.

  • info_block

    If the info block under the table is applied. An integer is used as a boolean (0 is false, 1 is true).

  • showTableToolsIncludeHTML

    If include HTML for table tools is applied(only for CSV, Excel, Print, and Copy options). An integer is used as a boolean (0 is false, 1 is true).

  • showTableToolsIncludeTitle

    Defines if the title is included in exported files(Excel and Copy only). An integer is used as a boolean (0 is false, 1 is true).

  • responsiveAction

    Defines which action is set for the responsive option (icon, cell, or row). Saved as sting.

  • pagination

    Defines if the pagination is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • paginationAlign

    Defines which pagination position is set (left, right, or center). Saved as sting.

  • paginationLayout

    Defines which pagination layout is set (full_numbers, simple, simple_numbers, full, numbers, or first_last_numbers). Saved as sting.

  • paginationLayoutMobile

    Defines which pagination layout is set for mobile devices (full_numbers, simple, simple_numbers, full, numbers or first_last_numbers). Saved as sting.

  • global_search

    Defines if the global search is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • showRowsPerPage

    Defines if the display length is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • showAllRows

    Defines if is shown all rows in the admin area when is used option users can see only data. An integer is used as a boolean (0 is false, 1 is true).

  • clearFilters

    Defines if the clear filters button is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • simpleResponsive

    Defines if the responsive option for a simple table is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • simpleHeader

    Defines if the table header for a simple table is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • stripeTable

    Defines if the stripe table option for a simple table is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • cellPadding

    Defines the size of cell padding in a simple table.

  • removeBorders

    Defines if removing table borders for simple tables is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • borderCollapse

    Defines if table borders for simple tables are collapsed or not.

  • borderSpacing

    Defines value for border spacing for a simple table.

  • verticalScroll

    Defines if vertical scroll for simple table is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • verticalScrollHeight

    Defines value for vertical scroll height for a simple table.

  • editButtonsDisplayed

    Defines which edit button will be displayed.

  • enableDuplicateButton

    Defines if the duplicate edit button is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • language

    Defines language for table interface options.

  • tableSkin

    Defines table skin.

  • table_wcag

    Defines if WCAG settings are active or not. An integer is used as a boolean (0 is false, 1 is true).

  • tableBorderRemoval

    Defines if removing table borders for data table is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • tableBorderRemovalHeader

    Defines if removing table header borders for data table is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • tableCustomCss

    Defines custom CSS for a data table.

  • tableFontColorSettings

    Contains all font and color settings for a data table.

  • pdfPaperSize

    Contains size of PDF paper for export.

  • pdfPageOrientation

    Contain orientation of PDF paper for export.

  • customRowDisplay

    Contain custom order of display length.

  • table_description

    Contain table description.

  • show_table_description

    Defines if the table description is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • fixed_columns

    Defines if fixed columns are active or not. An integer is used as a boolean (0 is false, 1 is true).

  • fixed_left_columns_number

    Contain how many columns will be fixed from the left side of the table.

  • fixed_right_columns_number

    Contain how many columns will be fixed from the right side of the table.

  • fixed_header

    Defines if the fixed header is active or not. An integer is used as a boolean (0 is false, 1 is true).

  • fixed_header_offset

    Contain header offset for a fixed header.

  • simple_template_id

    Contains the ID of a template used for creating simple tables.

wpdatatables_columns

Contains the columns with settings that exist within wpDataTables.

• id

  The unique column ID.

• table_id

  Data table ID.

• orig_header

  Contain original column header used for manipulation.

• display_header

  Contain a custom header name defined by a user.

• column_type

  Contain the type of the column(int, string, link…).

• filter_type

  Contain type of the filter(none, text, number…).

• input_type

  Contain the type of the column for editing.(none, text, textarea …).

• input_mandatory

  Defines if input on editing is mandatory or not. An integer is used as a boolean (0 is false, 1 is true).

• id_column

  Defines if column id is used for editing. An integer is used as a boolean (0 is false, 1 is true).

• group_column

  Defines if a column is used for grouping. An integer is used as a boolean (0 is false, 1 is true).

• sort_column

  Defines if a column is used for predefined sorting. An integer is used as a boolean (0 is false, 1 is true).

• hide_on_phones

  Defines if a column is hidden in responsive mode for mobile devices. An integer is used as a boolean (0 is false, 1 is true).

• hide_on_tablets

  Defines if a column is hidden in responsive mode for tablet devices. An integer is used as a boolean (0 is false, 1 is true).

• visible

  Defines column visibility. An integer is used as a boolean (0 is false, 1 is true).

• sum_column

  Defines if column uses sum calculation. An integer is used as a boolean (0 is false, 1 is true).

• skip_thousands_separator

  Defines if thousands separator is active or not. An integer is used as a boolean (0 is false, 1 is true).

• width

  Contain custom column width.

• possible_values

  Contain possible values option for column filters(read from the table, define custom or foreign key relation).

• default_value

  Contain default value for column filter.

• css_class

  Contain CSS class name for the column.

• text_before

  Contain cell content prefix.

• text_after

  Contain cell content suffix.

• formatting_rules

  Contain rules for conditional formatting.

• calc_formula

  Contain calculation formula for formula column.

• color

  Contain the color of the column.

• pos

  Contain column position in the table.

• advanced_settings

  Contains advanced settings for columns.

wpdatacharts

Contains the charts with settings that exist within wpDataTables.

• id

  The unique chart ID

• wpdatatable_id

  Id of the table connected to the chart.

• title

  Title of the chart.

• engine

  Type of the chart engine.

• json_render_data

  Object with all options for the chart.

wpdatatables_rows

Contains the table settings and data for simple tables.

• id

  The unique row ID

• table_id

  Id of the simple table.

• data

  Cell JSON data.

wpdatatables_cache

Contains cache data for non-server-side tables.

• id

  The unique row ID

• table_id

  Id of the data table which is using caching.

• table_type

  Type of the table.

• table_content

  Contains data source (file URLs, JSON API…).

• auto_update

  Defines if auto-update data is active or not. An integer is used as a boolean (0 is false, 1 is true).

• updated_time

  Defines datetime when data is cached.

• data

  Contains cache data from a source file.

• log_errors

  Contain an error log for each caching attempt with errors.

wpdatatables_templates

Contains the templates for simple tables.

• id

  The unique template ID

• table_type

  Type of the table.

• table_id

  Id of the wpdatatable.

• content

  Contains predefined data for a simple table.

• data

  Contains predefined data source (simple table content).

• settings

  Contains predefined table settings.

wpdatatable_{ID}

Dynamically created tables (Created for manual tables and tables imported from files). {ID} represents the ID of the wpDataTable.