{"table_name":"wc_order_fulfillments","full_table_name":"wp_wc_order_fulfillments","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"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 );","columns":[{"name":"fulfillment_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"entity_type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"entity_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_fulfilled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"date_updated","type":"datetime","nullable":false,"primary_key":false},{"name":"date_deleted","type":"datetime","nullable":true,"primary_key":false},{"name":"fulfillment_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"date_updated","type":"datetime","nullable":false,"primary_key":false},{"name":"date_deleted","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"woocommerce","name":"WooCommerce","active_installs":7000000,"version":"10.7.0","wp_org_url":"https://wordpress.org/plugins/woocommerce/"}}