ACF to Custom Database Tables

Please Check here

Yes, the plugin supports custom post type along with built-in types of post and page

No. The table create/update process uses WordPress's dbDelta() function. dbDelta() function does not currently support remove column operation. You will have to manually delete the column, in case you want to delete it.

If you rename an ACF field, a new column will be added to the custom database table the next time you run the update process.

Yes, complex field type repeater and flexible content are supported in the pro version of the plugin. The plugin saves their values ​​in JSON format.

The plugin creates SQL table schema from ACF fields then passes this schema through WordPress's dbDelta() function which performs modifications to the database. During schema creation plugin uses acf_ct/set_sql_data_type filter to set column's data types.

To keep your WordPress site compatible with other plugins, by default the plugin saves ACF field data in the wp_postmeta table along with a custom table. You can disable this behavior using this filter.

Columns SQL datatype is decided based on ACF field type. You can override SQL data type using custom filter.

ACF to Custom Database Tables PRO is an extension of the free plugin. It includes support for:

• Repeater
• Flexible Content
• Gallery