wp_ea_accounts

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_ea_accounts ( id BIGINT(20) NOT NULL AUTO_INCREMENT, type VARCHAR(50) NOT NULL DEFAULT 'account', name VARCHAR(191) NOT NULL, number VARCHAR(100) NOT NULL, balance DOUBLE(15, 4) NOT NULL DEFAULT 0.00, currency VARCHAR(3) NOT NULL DEFAULT 'USD', date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_updated DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY number (number), KEY bank_name (name), KEY bank_type (type) ) $collate; CREATE TABLE wp_ea_contactmeta ( meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, ea_contact_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, meta_key VARCHAR(191) DEFAULT NULL, meta_value LONGTEXT, PRIMARY KEY (meta_id), KEY ea_contact_id (ea_contact_id), KEY meta_key (meta_key(191)) ) $collate; CREATE TABLE wp_ea_contacts ( id BIGINT(20) NOT NULL AUTO_INCREMENT, type VARCHAR(30) DEFAULT 'customer', name VARCHAR(100) NOT NULL, company VARCHAR(100) NOT NULL, email VARCHAR(100) DEFAULT NULL, phone VARCHAR(50) DEFAULT NULL, website VARCHAR(100) DEFAULT NULL, address VARCHAR(191) DEFAULT NULL, city VARCHAR(50) DEFAULT NULL, state VARCHAR(50) DEFAULT NULL, postcode VARCHAR(20) DEFAULT NULL, country VARCHAR(3) DEFAULT NULL, tax_number VARCHAR(50) DEFAULT NULL, currency VARCHAR(3) NOT NULL DEFAULT 'USD', user_id BIGINT(20) UNSIGNED DEFAULT NULL, created_via VARCHAR(20) DEFAULT 'manual', date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_updated DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY name (name(100)), KEY type (type), KEY email (email(100)), KEY phone (phone(50)), KEY currency (currency), KEY user_id (user_id) ) $collate; CREATE TABLE wp_ea_document_items ( id BIGINT(20) NOT NULL AUTO_INCREMENT, document_id BIGINT(20) UNSIGNED DEFAULT NULL, item_id BIGINT(20) UNSIGNED DEFAULT NULL, type VARCHAR(20) NOT NULL DEFAULT 'standard', name VARCHAR(191) NOT NULL, description VARCHAR(160) DEFAULT NULL, unit VARCHAR(20) DEFAULT NULL, price DOUBLE(15, 4) NOT NULL DEFAULT 0.00, quantity DOUBLE(7, 2) NOT NULL DEFAULT 1, subtotal DOUBLE(15, 4) NOT NULL DEFAULT 0.00, discount DOUBLE(15, 4) NOT NULL DEFAULT 0.00, tax DOUBLE(15, 4) NOT NULL DEFAULT 0.00, total DOUBLE(15, 4) NOT NULL DEFAULT 0.00, currency VARCHAR(3) NOT NULL DEFAULT 'USD', PRIMARY KEY (id), KEY type (type), KEY name (name), KEY price (price), KEY quantity (quantity), KEY subtotal (subtotal), KEY total (total) ) $collate; CREATE TABLE wp_ea_document_taxes ( id BIGINT(20) NOT NULL AUTO_INCREMENT, document_id BIGINT(20) UNSIGNED NOT NULL, document_item_id BIGINT(20) UNSIGNED NOT NULL, tax_id BIGINT(20) UNSIGNED NOT NULL, name VARCHAR(191) NOT NULL, rate DOUBLE(15, 4) NOT NULL, compound TINYINT(1) NOT NULL DEFAULT 0, amount DOUBLE(15, 4) NOT NULL DEFAULT 0.00, currency VARCHAR(3) NOT NULL DEFAULT 'USD', PRIMARY KEY (id), KEY document_id (document_id), KEY document_item_id (document_item_id), KEY tax_id (tax_id) ) $collate; CREATE TABLE wp_ea_documentmeta ( meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, ea_document_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, meta_key VARCHAR(191) DEFAULT NULL, meta_value LONGTEXT, PRIMARY KEY (meta_id), KEY ea_document_id (ea_document_id), KEY meta_key (meta_key(191)) ) $collate; CREATE TABLE wp_ea_documents ( id BIGINT(20) NOT NULL AUTO_INCREMENT, type VARCHAR(20) NOT NULL DEFAULT 'invoice', status VARCHAR(20) NOT NULL DEFAULT 'draft', number VARCHAR(30) NOT NULL, reference VARCHAR(191) DEFAULT NULL, issue_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, due_date DATETIME DEFAULT NULL, sent_date DATETIME DEFAULT NULL, payment_date DATETIME DEFAULT NULL, discount_value DOUBLE(15, 4) DEFAULT 0, discount_type ENUM('fixed', 'percentage') DEFAULT 'fixed', subtotal DOUBLE(15, 4) DEFAULT 0, discount DOUBLE(15, 4) DEFAULT 0, tax DOUBLE(15, 4) DEFAULT 0, total DOUBLE(15, 4) DEFAULT 0, currency VARCHAR(3) NOT NULL DEFAULT 'USD', exchange_rate DOUBLE(15, 4) NOT NULL DEFAULT 1.0, contact_name VARCHAR(100) NOT NULL, contact_company VARCHAR(100) NOT NULL, contact_email VARCHAR(100) DEFAULT NULL, contact_phone VARCHAR(50) DEFAULT NULL, contact_address TEXT DEFAULT NULL, contact_city VARCHAR(50) DEFAULT NULL, contact_state VARCHAR(50) DEFAULT NULL, contact_postcode VARCHAR(20) DEFAULT NULL, contact_country VARCHAR(3) DEFAULT NULL, contact_tax_number VARCHAR(50) DEFAULT NULL, note TEXT DEFAULT NULL, terms TEXT DEFAULT NULL, attachment_id BIGINT(20) UNSIGNED DEFAULT NULL, contact_id BIGINT(20) UNSIGNED NOT NULL, parent_id BIGINT(20) UNSIGNED DEFAULT NULL, author_id BIGINT(20) UNSIGNED DEFAULT NULL, editable TINYINT(1) NOT NULL DEFAULT 1, created_via VARCHAR(20) DEFAULT 'manual', uuid VARCHAR(36) DEFAULT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_updated DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY uuid (uuid), KEY type (type), KEY status (status), KEY total (total), KEY contact_id (contact_id), KEY contact_name (contact_name), KEY contact_email (contact_email), KEY contact_phone (contact_phone), KEY contact_city (contact_city) ) $collate; CREATE TABLE wp_ea_items ( id BIGINT(20) NOT NULL AUTO_INCREMENT, type VARCHAR(50) NOT NULL DEFAULT 'standard', name VARCHAR(191) NOT NULL, description TEXT DEFAULT NULL, unit VARCHAR(50) DEFAULT NULL, price DOUBLE(15, 4) NOT NULL, cost DOUBLE(15, 4) NOT NULL, tax_ids VARCHAR(191) DEFAULT NULL, category_id INT(11) DEFAULT NULL, created_via VARCHAR(20) DEFAULT 'manual', date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_updated DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY name (name), KEY type (type), KEY price (price), KEY cost (cost) ) $collate; CREATE TABLE wp_ea_itemmeta ( meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, ea_item_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, meta_key VARCHAR(191) DEFAULT NULL, meta_value LONGTEXT, PRIMARY KEY (meta_id), KEY ea_item_id (ea_item_id), KEY meta_key (meta_key(191)) ) $collate; CREATE TABLE wp_ea_notes ( id BIGINT(20) NOT NULL AUTO_INCREMENT, parent_id BIGINT(20) UNSIGNED NOT NULL, parent_type VARCHAR(20) NOT NULL, content TEXT DEFAULT NULL, author_id BIGINT(20) UNSIGNED DEFAULT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_updated DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY parent_id (parent_id), KEY parent_type (parent_type) ) $collate; CREATE TABLE wp_ea_terms ( id BIGINT(20) NOT NULL AUTO_INCREMENT, taxonomy VARCHAR(20) NOT NULL DEFAULT 'category', name VARCHAR(191) NOT NULL, description TEXT DEFAULT NULL, type VARCHAR(20) DEFAULT NULL, parent_id BIGINT(20) UNSIGNED DEFAULT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_updated DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY name (name), KEY type (type), KEY taxonomy (taxonomy), KEY parent_id (parent_id) ) $collate; CREATE TABLE wp_ea_termmeta ( meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, ea_term_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, meta_key VARCHAR(191) DEFAULT NULL, meta_value LONGTEXT, PRIMARY KEY (meta_id), KEY ea_term_id (ea_term_id), KEY meta_key (meta_key(191)) ) $collate; CREATE TABLE wp_ea_transactionmeta ( meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, ea_transaction_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, meta_key VARCHAR(191) DEFAULT NULL, meta_value LONGTEXT, PRIMARY KEY (meta_id), KEY ea_transaction_id (ea_transaction_id), KEY meta_key (meta_key(191)) ) $collate; CREATE TABLE wp_ea_transactions ( id BIGINT(20) NOT NULL AUTO_INCREMENT, type VARCHAR(20) DEFAULT NULL, number VARCHAR(30) NOT NULL, payment_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, amount DOUBLE(15, 4) NOT NULL, currency VARCHAR(3) NOT NULL DEFAULT 'USD', exchange_rate DOUBLE(15, 4) NOT NULL DEFAULT 1.0, reference VARCHAR(191) DEFAULT NULL, note TEXT DEFAULT NULL, payment_method VARCHAR(100) DEFAULT NULL, account_id BIGINT(20) UNSIGNED NOT NULL, contact_id BIGINT(20) UNSIGNED DEFAULT NULL, document_id BIGINT(20) UNSIGNED DEFAULT NULL, category_id BIGINT(20) UNSIGNED NOT NULL, attachment_id BIGINT(20) UNSIGNED DEFAULT NULL, author_id BIGINT(20) UNSIGNED DEFAULT NULL, parent_id BIGINT(20) UNSIGNED DEFAULT NULL, editable TINYINT(1) NOT NULL DEFAULT 1, created_via VARCHAR(20) DEFAULT 'manual', uuid VARCHAR(36) DEFAULT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_updated DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY uuid (uuid), KEY type (type), KEY number (number), KEY amount (amount), KEY currency (currency), KEY exchange_rate (exchange_rate), KEY account_id (account_id), KEY category_id (category_id), KEY contact_id (contact_id) ) $collate; CREATE TABLE wp_ea_transfers ( id BIGINT(20) NOT NULL AUTO_INCREMENT, payment_id BIGINT(20) UNSIGNED NOT NULL, expense_id BIGINT(20) UNSIGNED NOT NULL, transfer_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, amount DOUBLE(15, 4) NOT NULL DEFAULT 0.00, currency VARCHAR(3) NOT NULL DEFAULT 'USD', payment_method VARCHAR(100) DEFAULT NULL, reference VARCHAR(191) DEFAULT NULL, note TEXT DEFAULT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_updated DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY payment_id (payment_id), KEY expense_id (expense_id) ) $collate; "; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $tables );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_ea_accounts`;

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

Other tables from Ever Accounting – Accounting & Invoicing Solution for Small Businesses