wp_erp_user_leaves
StaticStores erp user leaves data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| user_id | int(11) | YES |
| request_id | int(11) | YES |
| title | varchar(255) | YES |
| date | date | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| holiday_id | int(11) | YES |
| title | varchar(255) | YES |
| date | date | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| title | varchar(200) | NO |
| start | timestamp | NO |
| end | timestamp | NO |
| description | text | NO |
| range_status | varchar(5) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
| employee_id | int(11) | YES |
| company_name | varchar(100) | YES |
| job_title | varchar(100) | YES |
| from | date | YES |
| to | date | YES |
| description | text | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| employee_id | int(11) unsigned | YES |
| school | varchar(100) | YES |
| degree | varchar(100) | YES |
| field | varchar(100) | YES |
| result | varchar(50) | YES |
| result_type | enum('grade', 'percentage') | YES |
| finished | int(4) unsigned | YES |
| notes | text | YES |
| interest | text | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| employee_id | int(11) | YES |
| name | varchar(100) | YES |
| relation | varchar(100) | YES |
| dob | date | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| employee_id | int(11) unsigned | YES |
| reporting_to | int(11) unsigned | YES |
| job_knowledge | varchar(100) | YES |
| work_quality | varchar(100) | YES |
| attendance | varchar(100) | YES |
| communication | varchar(100) | YES |
| dependablity | varchar(100) | YES |
| reviewer | int(11) unsigned | YES |
| comments | text | YES |
| completion_date | datetime | YES |
| goal_description | text | YES |
| employee_assessment | text | YES |
| supervisor | int(11) unsigned | YES |
| supervisor_assessment | text | YES |
| type | text | YES |
| performance_date | datetime | YES |
| user_id | bigint(20) unsigned | NO |
| post_id | bigint(11) | NO |
| status | varchar(30) | NO |
| email_status | varchar(30) | NO |
| user_id | bigint(20) unsigned | YES |
| first_name | varchar(60) | YES |
| last_name | varchar(60) | YES |
| company | varchar(60) | YES |
| varchar(100) | YES | |
| phone | varchar(20) | YES |
| mobile | varchar(20) | YES |
| other | varchar(50) | YES |
| website | varchar(100) | YES |
| fax | varchar(20) | YES |
| notes | text | YES |
| street_1 | varchar(255) | YES |
| street_2 | varchar(255) | YES |
| city | varchar(80) | YES |
| state | varchar(50) | YES |
| postal_code | varchar(10) | YES |
| country | varchar(20) | YES |
| currency | varchar(5) | YES |
| life_stage | VARCHAR(100) | YES |
| contact_owner | bigint(20) | YES |
| hash | VARCHAR(40) | YES |
| created_by | BIGINT(20) | YES |
| created | datetime | YES |
| erp_people_id | bigint(20) | YES |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
| name | varchar(20) | YES |
| people_id | bigint(20) unsigned | YES |
| people_types_id | int(11) unsigned | YES |
| deleted_at | datetime | YES |
| component | varchar(50) | NO |
| sub_component | varchar(50) | NO |
| data_id | bigint(20) | YES |
| old_value | longtext | YES |
| new_value | longtext | YES |
| message | longtext | YES |
| changetype | varchar(10) | YES |
| created_by | bigint(20) unsigned | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| customer_id | bigint(20) | YES |
| company_id | bigint(50) | YES |
| user_id | int(11) | YES |
| type | varchar(255) | YES |
| message | longtext | YES |
| email_subject | text | YES |
| log_type | varchar(255) | YES |
| start_date | datetime | YES |
| end_date | datetime | YES |
| created_by | int(11) | YES |
| extra | longtext | YES |
| sent_notification | tinyint(4) | YES |
| done_at | datetime | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| activity_id | int(11) | YES |
| user_id | int(11) | YES |
| name | varchar(255) | YES |
| description | text | YES |
| private | TINYINT(1) | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| user_id | int(11) | YES |
| group_id | int(11) | YES |
| status | varchar(25) | YES |
| subscribe_at | datetime | YES |
| unsubscribe_at | datetime | YES |
| hash | VARCHAR(40) | YES |
| user_id | int(11) | YES |
| type | VARCHAR(255) | YES |
| global | tinyint(4) | YES |
| search_name | text | YES |
| search_val | text | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| name | text | YES |
| subject | text | YES |
| template | longtext | YES |
| type | varchar(255) | YES |
| currency | varchar(50) | YES |
| editable | tinyint | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| bill_no | int(11) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| vendor_id | int(11) | YES |
| vendor_name | varchar(255) | YES |
| address | varchar(255) | YES |
| trn_date | date | YES |
| due_date | date | YES |
| ref | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| particulars | varchar(255) | YES |
| status | int(11) | YES |
| attachments | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| slug | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| sign | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| invoice_no | int(11) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| product_id | int(11) | YES |
| qty | decimal(10,2) | YES |
| unit_price | decimal(20,2) | YES |
| discount | decimal(20,2) | YES |
| shipping | decimal(20,2) | YES |
| tax | decimal(20,2) | YES |
| tax_cat_id | int(11) | YES |
| item_total | decimal(20,2) | YES |
| ecommerce_type | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| customer_id | int(11) | YES |
| customer_name | varchar(255) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| transaction_charge | decimal(20,2) | YES |
| ref | varchar(255) | YES |
| particulars | varchar(255) | YES |
| attachments | varchar(255) | YES |
| status | int(11) | YES |
| trn_by | varchar(255) | YES |
| trn_by_ledger_id | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| invoice_no | int(11) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| customer_id | int(11) | YES |
| customer_name | varchar(255) | YES |
| trn_date | date | YES |
| due_date | date | YES |
| billing_address | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| discount | decimal(20,2) | YES |
| discount_type | varchar(255) | YES |
| shipping | decimal(20,2) | YES |
| shipping_tax | decimal(20,2) | YES |
| tax | decimal(20,2) | YES |
| tax_zone_id | int(11) | YES |
| estimate | boolean | YES |
| attachments | varchar(255) | YES |
| status | int(11) | YES |
| particulars | varchar(255) | YES |
| additional_notes | TEXT | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_date | date | YES |
| ref | varchar(255) | YES |
| voucher_no | int(11) | YES |
| voucher_amount | decimal(20,2) | YES |
| particulars | varchar(255) | YES |
| attachments | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| slug | varchar(255) | YES |
| chart_id | int(11) | YES |
| parent_id | int(11) | YES |
| system | tinyint(1) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| ledger_id | int(11) | YES |
| trn_no | int(11) | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| trn_date | date | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| ledger_id | int(11) | YES |
| short_code | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| chart_id | int(11) | YES |
| category_id | int(11) | YES |
| name | varchar(255) | YES |
| slug | varchar(255) | YES |
| code | int(11) | YES |
| unused | tinyint(1) | YES |
| system | tinyint(1) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| ledger_id | int(11) | YES |
| name | varchar(255) | YES |
| balance | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| ac_from | int(11) | YES |
| ac_to | int(11) | YES |
| particulars | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| financial_year_id | int(11) | YES |
| chart_id | int(11) | YES |
| ledger_id | int(11) | YES |
| type | varchar(50) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | VARCHAR(255) | YES |
| start_date | date | YES |
| end_date | date | YES |
| description | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| vendor_id | int(11) | YES |
| vendor_name | varchar(255) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| trn_by | varchar(255) | YES |
| trn_by_ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| ref | varchar(255) | YES |
| attachments | varchar(255) | YES |
| status | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| bill_no | int(11) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| vendor_id | int(11) | YES |
| vendor_name | varchar(255) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| trn_by | varchar(255) | YES |
| transaction_charge | decimal(20,2) | YES |
| ref | varchar(255) | YES |
| trn_by_ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| attachments | varchar(255) | YES |
| status | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| purchase_no | int(11) | YES |
| amount | decimal(20,2) | YES |
| tax_cat_id | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| people_id | varchar(255) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| trn_by | varchar(255) | YES |
| voucher_type | varchar(255) | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| people_id | varchar(255) | YES |
| voucher_no | int(11) | YES |
| amount | decimal(20,2) | YES |
| trn_date | date | YES |
| trn_by | varchar(255) | YES |
| particulars | varchar(255) | YES |
| voucher_type | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| people_id | varchar(255) | YES |
| voucher_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| parent | int(11) | NO |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| slug | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| product_type_id | int(11) | YES |
| category_id | int(11) | YES |
| tax_cat_id | int(11) | YES |
| vendor | int(11) | YES |
| cost_price | decimal(20,2) | YES |
| sale_price | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| product_id | int(11) | YES |
| trn_no | int(11) | YES |
| stock_in | int(11) | YES |
| stock_out | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| vendor_id | int(11) | YES |
| vendor_name | varchar(255) | YES |
| billing_address | varchar(255) | YES |
| trn_date | date | YES |
| due_date | date | YES |
| amount | decimal(20,2) | YES |
| tax | decimal(20,2) | YES |
| tax_zone_id | integer | YES |
| ref | varchar(255) | YES |
| status | int(11) | YES |
| purchase_order | boolean | YES |
| attachments | varchar(255) | YES |
| particulars | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| purchase_no | int(11) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| product_id | int(11) | YES |
| qty | decimal(10,2) | YES |
| price | decimal(20,2) | YES |
| amount | decimal(20,2) | YES |
| tax | decimal(20,2) | YES |
| tax_cat_id | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| invoice_details_id | int(20) | NO |
| agency_id | int(20) | YES |
| tax_rate | decimal(20,2) | NO |
| created_at | datetime | YES |
| created_by | int(20) | YES |
| updated_at | datetime | YES |
| updated_by | int(20) | YES |
| name | varchar(100) | YES |
| description | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| tax_rate_name | varchar(255) | YES |
| tax_number | varchar(100) | YES |
| default | boolean | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| tax_id | int(11) | YES |
| component_name | varchar(255) | YES |
| tax_cat_id | int(11) | YES |
| agency_id | int(11) | YES |
| tax_rate | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| ecommerce_type | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| voucher_type | varchar(255) | YES |
| trn_by | int(11) | YES |
| agency_id | int(11) | YES |
| ledger_id | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| agency_id | int(11) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20, 2) | YES |
| credit | decimal(20, 2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| invoice_details_id | int(11) | YES |
| agency_id | int(11) | YES |
| tax_rate | decimal(20,2) | YES |
| tax_amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| type_name | varchar(255) | YES |
| slug | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| system_id | bigint | NO |
| sync_id | bigint | YES |
| sync_slug | varchar(100) | YES |
| sync_type | varchar(100) | YES |
| sync_source | varchar(100) | YES |
| name | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| people_id | int(11) | YES |
| people_name | varchar(255) | YES |
| address | varchar(255) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| ref | varchar(255) | YES |
| particulars | varchar(255) | YES |
| status | int(11) | YES |
| trn_by | int(11) | YES |
| transaction_charge | decimal(20,2) | YES |
| trn_by_ledger_id | int(11) | YES |
| attachments | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| voucher_type | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| bank | varchar(255) | YES |
| name | varchar(255) | YES |
| pay_to | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
CREATE TABLE Statement
CREATE TABLE `wp_erp_user_leaves` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `request_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_holidays_indv` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `holiday_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_hr_holiday` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `description` text NOT NULL, `range_status` varchar(5) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_hr_work_exp` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) DEFAULT NULL, `company_name` varchar(100) DEFAULT NULL, `job_title` varchar(100) DEFAULT NULL, `from` date DEFAULT NULL, `to` date DEFAULT NULL, `description` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;", "CREATE TABLE `wp_erp_hr_education` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) unsigned DEFAULT NULL, `school` varchar(100) DEFAULT NULL, `degree` varchar(100) DEFAULT NULL, `field` varchar(100) DEFAULT NULL, `result` varchar(50) DEFAULT NULL, `result_type` enum('grade', 'percentage') DEFAULT NULL, `finished` int(4) unsigned DEFAULT NULL, `notes` text, `interest` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;", "CREATE TABLE `wp_erp_hr_dependents` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `relation` varchar(100) DEFAULT NULL, `dob` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;", "CREATE TABLE `wp_erp_hr_employee_performance` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) unsigned DEFAULT NULL, `reporting_to` int(11) unsigned DEFAULT NULL, `job_knowledge` varchar(100) DEFAULT NULL, `work_quality` varchar(100) DEFAULT NULL, `attendance` varchar(100) DEFAULT NULL, `communication` varchar(100) DEFAULT NULL, `dependablity` varchar(100) DEFAULT NULL, `reviewer` int(11) unsigned DEFAULT NULL, `comments` text, `completion_date` datetime DEFAULT NULL, `goal_description` text, `employee_assessment` text, `supervisor` int(11) unsigned DEFAULT NULL, `supervisor_assessment` text, `type` text, `performance_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;", "CREATE TABLE `wp_erp_hr_announcement` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `post_id` bigint(11) NOT NULL, `status` varchar(30) NOT NULL, `email_status` varchar(30) NOT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY `post_id` (`post_id`), KEY `status` (`status`) ) $charset_collate;", "CREATE TABLE `wp_erp_peoples` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT '0', `first_name` varchar(60) DEFAULT NULL, `last_name` varchar(60) DEFAULT NULL, `company` varchar(60) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `mobile` varchar(20) DEFAULT NULL, `other` varchar(50) DEFAULT NULL, `website` varchar(100) DEFAULT NULL, `fax` varchar(20) DEFAULT NULL, `notes` text, `street_1` varchar(255) DEFAULT NULL, `street_2` varchar(255) DEFAULT NULL, `city` varchar(80) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `postal_code` varchar(10) DEFAULT NULL, `country` varchar(20) DEFAULT NULL, `currency` varchar(5) DEFAULT NULL, `life_stage` VARCHAR(100) DEFAULT NULL, `contact_owner` bigint(20) DEFAULT NULL, `hash` VARCHAR(40) DEFAULT NULL, `created_by` BIGINT(20) DEFAULT NULL, `created` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `first_name` (`first_name`), KEY `last_name` (`last_name`), KEY `email` (`email`) ) $charset_collate;", "CREATE TABLE `wp_erp_peoplemeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `erp_people_id` bigint(20) DEFAULT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `erp_people_id` (`erp_people_id`), KEY `meta_key` (`meta_key`(191)) ) $charset_collate;", "CREATE TABLE `wp_erp_people_types` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) $charset_collate;", "CREATE TABLE `wp_erp_people_type_relations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `people_id` bigint(20) unsigned DEFAULT NULL, `people_types_id` int(11) unsigned DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `people_id` (`people_id`), KEY `people_types_id` (`people_types_id`) ) $charset_collate;", "CREATE TABLE `wp_erp_audit_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `component` varchar(50) NOT NULL DEFAULT '', `sub_component` varchar(50) NOT NULL DEFAULT '', `data_id` bigint(20) DEFAULT NULL, `old_value` longtext, `new_value` longtext, `message` longtext, `changetype` varchar(10) DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `component` (`component`), KEY `sub_component` (`sub_component`), KEY `changetype` (`changetype`), KEY `created_by` (`created_by`) ) $charset_collate;", "CREATE TABLE `wp_erp_crm_customer_companies` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `customer_id` bigint(20) DEFAULT NULL, `company_id` bigint(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `customer_id` (`customer_id`), KEY `company_id` (`company_id`) ) $charset_collate;", "CREATE TABLE wp_erp_crm_customer_activities ( id int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `message` longtext, email_subject text, log_type varchar(255) DEFAULT NULL, `start_date` datetime DEFAULT NULL, end_date datetime DEFAULT NULL, created_by int(11) DEFAULT NULL, extra longtext, sent_notification tinyint(4) DEFAULT '0', done_at datetime DEFAULT NULL, created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY `type` (`type`), KEY log_type (log_type), KEY created_by (created_by) ) $charset_collate;", "CREATE TABLE `wp_erp_crm_activities_task` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `activity_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_id` (`activity_id`), KEY `user_id` (`user_id`) ) $charset_collate;", "CREATE TABLE `wp_erp_crm_contact_group` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `description` text, `private` TINYINT(1) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_crm_contact_subscriber` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `group_id` int(11) DEFAULT NULL, `status` varchar(25) DEFAULT NULL, `subscribe_at` datetime DEFAULT NULL, `unsubscribe_at` datetime DEFAULT NULL, `hash` VARCHAR(40) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_group` (`user_id`,`group_id`), KEY `status` (`status`), KEY `hash` (`hash`) ) $charset_collate;", "CREATE TABLE `wp_erp_crm_save_search` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `type` VARCHAR(255) DEFAULT NULL, `global` tinyint(4) DEFAULT '0', `search_name` text, `search_val` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_crm_save_email_replies` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` text, `subject` text, `template` longtext, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_voucher_no` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(255) DEFAULT NULL, `currency` varchar(50) DEFAULT NULL, `editable` tinyint DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_bill_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bill_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_bill_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_bills` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `ref` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `particulars` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_chart_of_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_currency_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `sign` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_invoice_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE wp_erp_acct_invoice_details ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, product_id int(11) DEFAULT NULL, qty decimal(10,2) DEFAULT NULL, unit_price decimal(20,2) DEFAULT 0, discount decimal(20,2) DEFAULT 0, shipping decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT 0, tax_cat_id int(11) DEFAULT NULL, item_total decimal(20,2) DEFAULT 0, ecommerce_type varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_invoice_receipts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `transaction_charge` decimal(20,2) DEFAULT 0, `ref` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `trn_by` varchar(255) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_invoice_receipts_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `invoice_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_invoices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `billing_address` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `discount` decimal(20,2) DEFAULT 0, `discount_type` varchar(255) DEFAULT NULL, `shipping` decimal(20,2) DEFAULT 0, `shipping_tax` decimal(20,2) DEFAULT 0, `tax` decimal(20,2) DEFAULT 0, `tax_zone_id` int(11) DEFAULT NULL, `estimate` boolean DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `additional_notes` TEXT NULL DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_journal_details` ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, ledger_id int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_journals` ( id int(11) NOT NULL AUTO_INCREMENT, trn_date date DEFAULT NULL, ref varchar(255) DEFAULT NULL, voucher_no int(11) DEFAULT NULL, voucher_amount decimal(20,2) DEFAULT 0, particulars varchar(255) DEFAULT NULL, attachments varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_ledger_categories` ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, slug varchar(255) DEFAULT NULL, chart_id int(11) DEFAULT NULL, parent_id int(11) DEFAULT NULL, `system` tinyint(1) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_ledger_details` ( id int(11) NOT NULL AUTO_INCREMENT, ledger_id int(11) DEFAULT NULL, trn_no int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, trn_date date DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_ledger_settings` ( id int(11) NOT NULL AUTO_INCREMENT, ledger_id int(11) DEFAULT NULL, short_code varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_ledgers` ( id int(11) NOT NULL AUTO_INCREMENT, chart_id int(11) DEFAULT NULL, category_id int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, slug varchar(255) DEFAULT NULL, code int(11) DEFAULT NULL, unused tinyint(1) DEFAULT NULL, `system` tinyint(1) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_cash_at_banks` ( id int(11) NOT NULL AUTO_INCREMENT, ledger_id int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, balance decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_transfer_voucher` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, amount decimal(20,2) DEFAULT NULL, ac_from int(11) DEFAULT NULL, ac_to int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_opening_balances` ( id int(11) NOT NULL AUTO_INCREMENT, financial_year_id int(11) DEFAULT NULL, chart_id int(11) DEFAULT NULL, ledger_id int(11) DEFAULT NULL, `type` varchar(50) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_financial_years` ( id int(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) DEFAULT NULL, `start_date` date DEFAULT NULL, end_date date DEFAULT NULL, `description` varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_pay_bill` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, vendor_id int(11) DEFAULT NULL, vendor_name varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, trn_by varchar(255) DEFAULT NULL, trn_by_ledger_id int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, ref varchar(255) DEFAULT NULL, attachments varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_pay_bill_details` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, bill_no int(11) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_pay_purchase` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, vendor_id int(11) DEFAULT NULL, vendor_name varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, trn_by varchar(255) DEFAULT NULL, transaction_charge decimal(20,2) DEFAULT 0, ref varchar(255) DEFAULT NULL, trn_by_ledger_id int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, attachments varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE wp_erp_acct_pay_purchase_details ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, purchase_no int(11) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, tax_cat_id int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_people_account_details` ( id int(11) NOT NULL AUTO_INCREMENT, people_id varchar(255) DEFAULT NULL, trn_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, trn_by varchar(255) DEFAULT NULL, voucher_type varchar(255) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_people_trn` ( id int(11) NOT NULL AUTO_INCREMENT, people_id varchar(255) DEFAULT NULL, voucher_no int(11) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, trn_date date DEFAULT NULL, trn_by varchar(255) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, voucher_type varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_people_trn_details` ( id int(11) NOT NULL AUTO_INCREMENT, people_id varchar(255) DEFAULT NULL, voucher_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_product_categories` ( id int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, parent int(11) NOT NULL DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_product_types` ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, slug varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_products` ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, product_type_id int(11) DEFAULT NULL, category_id int(11) DEFAULT NULL, tax_cat_id int(11) DEFAULT NULL, vendor int(11) DEFAULT NULL, cost_price decimal(20,2) DEFAULT 0, sale_price decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_product_details` ( id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) DEFAULT NULL, trn_no int(11) DEFAULT NULL, stock_in int(11) DEFAULT NULL, stock_out int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_purchase` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, vendor_id int(11) DEFAULT NULL, vendor_name varchar(255) DEFAULT NULL, billing_address varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, due_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT NULL , tax_zone_id integer DEFAULT NULL, ref varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, purchase_order boolean DEFAULT NULL, attachments varchar(255) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_purchase_account_details` ( id int(11) NOT NULL AUTO_INCREMENT, purchase_no int(11) DEFAULT NULL, trn_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE wp_erp_acct_purchase_details ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, product_id int(11) DEFAULT NULL, qty decimal(10,2) DEFAULT NULL, price decimal(20,2) DEFAULT 0, amount decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT NULL, tax_cat_id int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE wp_erp_acct_purchase_details_tax ( id int(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_details_id int(20) NOT NULL, agency_id int(20) DEFAULT NULL, tax_rate decimal(20,2) NOT NULL, created_at datetime DEFAULT NULL, created_by int(20) DEFAULT NULL, updated_at datetime DEFAULT NULL, updated_by int(20) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_tax_categories` ( id int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_taxes` ( id int(11) NOT NULL AUTO_INCREMENT, tax_rate_name varchar(255) DEFAULT NULL, tax_number varchar(100) DEFAULT NULL, `default` boolean DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_tax_cat_agency` ( id int(11) NOT NULL AUTO_INCREMENT, tax_id int(11) DEFAULT NULL, component_name varchar(255) DEFAULT NULL, tax_cat_id int(11) DEFAULT NULL, agency_id int(11) DEFAULT NULL, tax_rate decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_tax_agencies` ( id int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, ecommerce_type varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_tax_pay` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, particulars varchar(255) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, voucher_type varchar(255) DEFAULT NULL, trn_by int(11) DEFAULT NULL, agency_id int(11) DEFAULT NULL, ledger_id int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_tax_agency_details` ( id int(11) NOT NULL AUTO_INCREMENT, agency_id int(11) DEFAULT NULL, trn_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20, 2) DEFAULT 0, credit decimal(20, 2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_invoice_details_tax` ( id int(11) NOT NULL AUTO_INCREMENT, invoice_details_id int(11) DEFAULT NULL, agency_id int(11) DEFAULT NULL, tax_rate decimal(20,2) DEFAULT 0, tax_amount decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_trn_status_types` ( id int(11) NOT NULL AUTO_INCREMENT, type_name varchar(255) DEFAULT NULL, slug varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE wp_erp_acct_synced_taxes ( id int NOT NULL AUTO_INCREMENT, system_id bigint NOT NULL, sync_id bigint DEFAULT NULL, sync_slug varchar(100) DEFAULT NULL, sync_type varchar(100) DEFAULT NULL, sync_source varchar(100) DEFAULT NULL, PRIMARY KEY (id), KEY system_id (system_id), KEY sync_id (sync_id), KEY sync_slug (sync_slug), KEY sync_type (sync_type), KEY sync_source (sync_source) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_payment_methods` ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_expenses` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, people_id int(11) DEFAULT NULL, people_name varchar(255) DEFAULT NULL, address varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, ref varchar(255) DEFAULT NULL, check_no varchar(255) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, status int(11) DEFAULT NULL, trn_by int(11) DEFAULT NULL, transaction_charge decimal(20,2) DEFAULT 0, trn_by_ledger_id int(11) DEFAULT NULL, attachments varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_expense_details` ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, ledger_id int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE `wp_erp_acct_expense_checks` ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, check_no varchar(255) DEFAULT NULL, voucher_type varchar(255) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, bank varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, pay_to varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { $erp_table_created = dbDelta( $table );Safe to delete?
If you have uninstalled ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support, 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_erp_user_leaves`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support