wp_digages_direct_invoices_invoices

Column Definitions

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_invoices ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_id VARCHAR(50) NOT NULL UNIQUE, access_key VARCHAR(128) DEFAULT NULL, title VARCHAR(255) NOT NULL DEFAULT '', customer_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, currency VARCHAR(10) NOT NULL DEFAULT 'USD', subtotal DECIMAL(15,2) NOT NULL DEFAULT 0.00, discount DECIMAL(15,2) NOT NULL DEFAULT 0.00, discount_type VARCHAR(10) NOT NULL DEFAULT 'fixed', tax DECIMAL(15,2) NOT NULL DEFAULT 0.00, tax_rate DECIMAL(5,2) NOT NULL DEFAULT 0.00, stripe_platform_fee DECIMAL(15,2) NOT NULL DEFAULT 0.00, total DECIMAL(15,2) NOT NULL DEFAULT 0.00, status VARCHAR(30) NOT NULL DEFAULT 'draft', note TEXT, payment_accounts TEXT, enable_woocommerce_checkout TINYINT(1) NOT NULL DEFAULT 0, enable_stripe_payment TINYINT(1) NOT NULL DEFAULT 0, stripe_payment_mode VARCHAR(10) DEFAULT NULL, stripe_payment_intent_id VARCHAR(255) DEFAULT NULL, stripe_customer_id VARCHAR(255) DEFAULT NULL, stripe_payment_method_id VARCHAR(255) DEFAULT NULL, stripe_next_charge_at DATETIME DEFAULT NULL, stripe_last_charge_at DATETIME DEFAULT NULL, stripe_recurring_error TEXT DEFAULT NULL, stripe_recurring_retry_count SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, stripe_recurring_cancelled_at DATETIME DEFAULT NULL, woo_product_id BIGINT(20) UNSIGNED DEFAULT NULL, woo_order_id BIGINT(20) UNSIGNED DEFAULT NULL, recurring TINYINT(1) NOT NULL DEFAULT 0, frequency VARCHAR(20) DEFAULT NULL, end_date DATE DEFAULT NULL, sent_date DATETIME DEFAULT NULL, due_date DATETIME DEFAULT NULL, paid_date DATETIME DEFAULT NULL, sent_payment_account_id BIGINT(20) UNSIGNED DEFAULT NULL, sent_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; $items = "CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_invoice_items ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_id VARCHAR(50) NOT NULL, item_type VARCHAR(30) NOT NULL DEFAULT 'custom', name VARCHAR(255) NOT NULL, quantity DECIMAL(10,2) NOT NULL DEFAULT 1, unit_price DECIMAL(15,2) NOT NULL DEFAULT 0.00, total DECIMAL(15,2) NOT NULL DEFAULT 0.00, sort_order INT NOT NULL DEFAULT 0, PRIMARY KEY (id) ) $charset_collate;"; $customers = "CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_customers ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, wp_user_id BIGINT(20) UNSIGNED DEFAULT NULL, full_name VARCHAR(255) NOT NULL DEFAULT '', email VARCHAR(255) NOT NULL DEFAULT '', business_name VARCHAR(255) DEFAULT NULL, use_business TINYINT(1) NOT NULL DEFAULT 0, phone VARCHAR(50) DEFAULT NULL, whatsapp VARCHAR(50) DEFAULT NULL, telegram VARCHAR(100) DEFAULT NULL, address TEXT DEFAULT NULL, state VARCHAR(100) DEFAULT NULL, zip_code VARCHAR(20) DEFAULT NULL, country VARCHAR(100) DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; $activity = "CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_activity ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_id VARCHAR(50) NOT NULL, action VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; $payment_accounts = "CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_payment_accounts ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, account_type VARCHAR(30) NOT NULL, currency VARCHAR(10) NOT NULL DEFAULT 'USD', name VARCHAR(255) NOT NULL DEFAULT '', account_name VARCHAR(255) DEFAULT NULL, account_number VARCHAR(100) DEFAULT NULL, sort_code VARCHAR(50) DEFAULT NULL, iban VARCHAR(100) DEFAULT NULL, bic_swift VARCHAR(50) DEFAULT NULL, routing_number VARCHAR(50) DEFAULT NULL, phone_number VARCHAR(50) DEFAULT NULL, wallet_address VARCHAR(255) DEFAULT NULL, network_name VARCHAR(100) DEFAULT NULL, platform_name VARCHAR(100) DEFAULT NULL, account_id VARCHAR(255) DEFAULT NULL, id_type VARCHAR(50) DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $invoices );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_digages_direct_invoices_invoices`;

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

Other tables from Direct Invoices – Invoicing & Payment Requests for WordPress