wp_jbusinessdirectory_offer_attributes

Static

Stores jbusinessdirectory offer attributes data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idintNO
offer_idintNO
attribute_idintNO
valuevarchar(250)YES
option_idintYES

CREATE TABLE Statement

CREATE TABLE `wp_jbusinessdirectory_offer_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `offer_id` int NOT NULL, `attribute_id` int NOT NULL, `value` varchar(250) DEFAULT NULL, `option_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `event_UNIQUE` (`offer_id`,`attribute_id`,`value`), KEY `idx_option` (`option_id`) ) ENGINE

Safe to delete?

If you have uninstalled WP-BusinessDirectory – Business directory plugin for WordPress, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_jbusinessdirectory_offer_attributes`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from WP-BusinessDirectory – Business directory plugin for WordPress