wp_wc_order_fulfillments
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑fulfillment_id | bigint(20) unsigned | NO |
| entity_type | varchar(255) | NO |
| entity_id | bigint(20) unsigned | NO |
| status | varchar(255) | NO |
| is_fulfilled | tinyint(1) | NO |
| date_updated | datetime | NO |
| date_deleted | datetime | YES |
| fulfillment_id | bigint(20) unsigned | NO |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
| date_updated | datetime | NO |
| date_deleted | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_wc_order_fulfillments ( fulfillment_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, entity_type varchar(255) NOT NULL, entity_id bigint(20) unsigned NOT NULL, status varchar(255) NOT NULL, is_fulfilled tinyint(1) NOT NULL DEFAULT 0, date_updated datetime NOT NULL, date_deleted datetime NULL, PRIMARY KEY (fulfillment_id), KEY entity_type_id (entity_type({$max_index_length}), entity_id) ) $collate; CREATE TABLE wp_wc_order_fulfillment_meta ( meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, fulfillment_id bigint(20) unsigned NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, date_updated datetime NOT NULL, date_deleted datetime NULL, PRIMARY KEY (meta_id), KEY meta_key (meta_key({$max_index_length})), KEY fulfillment_id (fulfillment_id) ) $collate;"; $database_util->dbdelta( $schema );Safe to delete?
If you have uninstalled WooCommerce, 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_wc_order_fulfillments`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WooCommerce