wp_ftbai_facturas
StaticStores ftbai facturas data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id_transaccion | INT(11) | NO |
| user_dni | VARCHAR(20) | NO |
| user_apikey | VARCHAR(20) | NO |
| fecha_transaccion | TIMESTAMP | NO |
| pedido_numero | INT(11) | NO |
| pedido_fecha | DATETIME | NO |
| factura_estado | VARCHAR(20) | YES |
| factura_tipo | VARCHAR(20) | NO |
| factura_rectificada_en | INT(11) | NO |
| factura_rectificativa_de | INT(11) | NO |
| factura_vista | DATETIME | NO |
| factura_serie | VARCHAR(50) | YES |
| factura_numero | VARCHAR(50) | YES |
| factura_fecha | DATETIME | NO |
| factura_total | DECIMAL(20,4) | NO |
| cliente_nombre | VARCHAR(50) | YES |
| cliente_nif | VARCHAR(20) | YES |
| tbai_num | VARCHAR(50) | YES |
| tbai_qr | VARCHAR(250) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_ftbai_facturas` ( `id_transaccion` INT(11) NOT NULL AUTO_INCREMENT, `user_dni` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `user_apikey` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `fecha_transaccion` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `pedido_numero` INT(11) NOT NULL DEFAULT '0', `pedido_fecha` DATETIME NOT NULL, `factura_estado` VARCHAR(20) NULL DEFAULT '' COLLATE 'utf8_general_ci', `factura_tipo` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `factura_rectificada_en` INT(11) NOT NULL DEFAULT '0', `factura_rectificativa_de` INT(11) NOT NULL DEFAULT '0', `factura_vista` DATETIME NOT NULL, `factura_serie` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8_general_ci', `factura_numero` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8_general_ci', `factura_fecha` DATETIME NOT NULL, `factura_total` DECIMAL(20,4) NOT NULL DEFAULT '0.0000', `cliente_nombre` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8_general_ci', `cliente_nif` VARCHAR(20) NULL DEFAULT '' COLLATE 'utf8_general_ci', `tbai_num` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8_general_ci', `tbai_qr` VARCHAR(250) NULL DEFAULT '' COLLATE 'utf8_general_ci', PRIMARY KEY (`id_transaccion`, `user_dni`, `user_apikey`) USING BTREE ) ".$charset_collate." ENGINE=InnoDB AUTO_INCREMENT=1; "; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );
Safe to delete?
If you have uninstalled TicketBAI Facturas para 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_ftbai_facturas`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.