{"table_name":"erp_company_locations","full_table_name":"wp_erp_company_locations","description":"Stores erp company locations data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_erp_company_locations` ( id int(11) unsigned NOT NULL AUTO_INCREMENT, company_id int(11) unsigned DEFAULT NULL, name varchar(255) DEFAULT NULL, address_1 varchar(255) DEFAULT NULL, address_2 varchar(255) DEFAULT NULL, city varchar(100) DEFAULT NULL, state varchar(100) DEFAULT NULL, zip int(6) DEFAULT NULL, country varchar(5) DEFAULT NULL, fax varchar(20) DEFAULT NULL, phone varchar(20) DEFAULT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), KEY company_id (company_id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_depts` ( id int(11) unsigned NOT NULL AUTO_INCREMENT, title varchar(200) NOT NULL DEFAULT '', `description` text, `lead` int(11) unsigned DEFAULT '0', parent int(11) unsigned DEFAULT '0', `status` tinyint(1) unsigned DEFAULT '1', created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_designations` ( id int(11) unsigned NOT NULL AUTO_INCREMENT, title varchar(200) NOT NULL DEFAULT '', `description` text, `status` tinyint(1) DEFAULT '1', created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_employees` ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', employee_id varchar(20) DEFAULT NULL, designation int(11) unsigned NOT NULL DEFAULT '0', department int(11) unsigned NOT NULL DEFAULT '0', `location` int(10) unsigned NOT NULL DEFAULT '0', hiring_source varchar(20) NOT NULL, hiring_date date NOT NULL, termination_date date NOT NULL, date_of_birth date NOT NULL, reporting_to bigint(20) unsigned NOT NULL DEFAULT '0', pay_rate decimal(20,2) unsigned NOT NULL DEFAULT '0', pay_type varchar(20) NOT NULL DEFAULT '', `type` varchar(20) NOT NULL, `status` varchar(10) NOT NULL DEFAULT '', deleted_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY employee_id (employee_id), KEY designation (designation), KEY department (department), KEY `status` (`status`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_employee_history` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', `module` varchar(20) DEFAULT NULL, `category` varchar(20) DEFAULT NULL, `type` varchar(20) DEFAULT NULL, `comment` text, `data` longtext, `date` datetime NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `module` (`module`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_employee_notes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', `comment` text NOT NULL, `comment_by` bigint(20) unsigned NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leaves ( id smallint(6) NOT NULL AUTO_INCREMENT, name varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, description text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_policies ( id int(10) UNSIGNED NOT NULL AUTO_INCREMENT, leave_id smallint(5) UNSIGNED NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `days` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', color varchar(10) DEFAULT NULL, apply_limit tinyint(3) UNSIGNED NOT NULL DEFAULT '0', employee_type enum('-1','permanent','parttime','contract','temporary','trainee') NOT NULL DEFAULT 'permanent', department_id int(11) NOT NULL DEFAULT '-1', location_id int(11) NOT NULL DEFAULT '-1', designation_id int(11) NOT NULL DEFAULT '-1', gender enum('-1','male','female','other') NOT NULL DEFAULT '-1', marital enum('-1','single','married','widowed') NOT NULL DEFAULT '-1', f_year smallint(5) UNSIGNED DEFAULT NULL, apply_for_new_users tinyint(3) UNSIGNED NOT NULL DEFAULT '0', carryover_days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', carryover_uses_limit tinyint(3) UNSIGNED NOT NULL DEFAULT '0', encashment_days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', encashment_based_on enum('pay_rate','basic','gross') DEFAULT NULL, forward_default enum('encashment','carryover') NOT NULL DEFAULT 'encashment', applicable_from_days smallint(5) UNSIGNED NOT NULL DEFAULT '0', accrued_amount decimal(10,2) NOT NULL DEFAULT '0.00', accrued_max_days smallint(4) UNSIGNED NOT NULL DEFAULT '0', halfday_enable tinyint(3) UNSIGNED NOT NULL DEFAULT '0', created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_id (leave_id), KEY f_year (f_year) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_policies_segregation ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_policy_id bigint(20) UNSIGNED NOT NULL, jan tinyint(3) UNSIGNED NOT NULL DEFAULT '0', feb tinyint(3) UNSIGNED NOT NULL DEFAULT '0', mar tinyint(3) UNSIGNED NOT NULL DEFAULT '0', apr tinyint(3) UNSIGNED NOT NULL DEFAULT '0', may tinyint(3) UNSIGNED NOT NULL DEFAULT '0', jun tinyint(3) UNSIGNED NOT NULL DEFAULT '0', jul tinyint(3) UNSIGNED NOT NULL DEFAULT '0', aug tinyint(3) UNSIGNED NOT NULL DEFAULT '0', sep tinyint(3) UNSIGNED NOT NULL DEFAULT '0', oct tinyint(3) UNSIGNED NOT NULL DEFAULT '0', nov tinyint(3) UNSIGNED NOT NULL DEFAULT '0', decem tinyint(3) UNSIGNED NOT NULL DEFAULT '0', created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_policy_id (leave_policy_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_entitlements ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, created_by bigint(20) UNSIGNED DEFAULT NULL, trn_id bigint(20) UNSIGNED NOT NULL, trn_type enum('leave_policies','leave_approval_status','leave_encashment_requests','leave_entitlements','unpaid_leave','leave_encashment', 'leave_carryforward', 'manual_leave_policies', 'Accounts', 'others', 'leave_accrual', 'carry_forward_leave_expired') NOT NULL DEFAULT 'leave_policies', day_in decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', day_out decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, f_year smallint(6) NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY comp_key_1 (`user_id`,leave_id,f_year,trn_type), KEY trn_id (trn_id), KEY leave_id (leave_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_requests ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, leave_entitlement_id bigint(20) UNSIGNED NOT NULL default '0', day_status_id smallint(5) UNSIGNED NOT NULL DEFAULT '1', `days` decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', `start_date` int(11) NOT NULL, end_date int(11) NOT NULL, reason text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, last_status smallint(6) UNSIGNED NOT NULL DEFAULT '2', created_by bigint(20) UNSIGNED DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY user_leave (`user_id`,leave_id), KEY user_entitlement (`user_id`,leave_entitlement_id), KEY last_status (last_status), KEY leave_entitlement_id (leave_entitlement_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_approval_status ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_request_id bigint(20) UNSIGNED NOT NULL, approval_status_id tinyint(3) UNSIGNED NOT NULL DEFAULT '0', approved_by bigint(20) UNSIGNED DEFAULT NULL, `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_request_id (leave_request_id), KEY approval_status_id (approval_status_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_request_details ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_request_id bigint(20) UNSIGNED NOT NULL, leave_approval_status_id bigint(20) UNSIGNED NOT NULL, workingday_status tinyint(3) UNSIGNED NOT NULL DEFAULT '1', `user_id` bigint(20) UNSIGNED NOT NULL, f_year smallint(6) NOT NULL, leave_date int(11) NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_request_id (leave_request_id), KEY `user_id` (`user_id`), KEY user_fyear_leave (`user_id`,f_year,leave_date) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_encashment_requests ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, approved_by bigint(20) UNSIGNED DEFAULT NULL, approval_status_id tinyint(3) UNSIGNED NOT NULL DEFAULT '1', encash_days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', forward_days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', amount decimal(20,2) NOT NULL DEFAULT '0.00', total decimal(20,2) NOT NULL DEFAULT '0.00', f_year smallint(5) UNSIGNED NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY leave_id (leave_id), KEY f_year (f_year) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leaves_unpaid ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_id smallint(6) UNSIGNED NOT NULL, leave_request_id bigint(20) UNSIGNED NOT NULL, leave_approval_status_id bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `days` decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', amount decimal(20,2) NOT NULL DEFAULT '0.00', total decimal(20,2) NOT NULL DEFAULT '0.00', f_year smallint(5) UNSIGNED NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY leave_id (leave_id), KEY f_year (f_year), KEY leave_request_id (leave_request_id), KEY leave_approval_status_id (leave_approval_status_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_financial_years ( id int(11) UNSIGNED NOT NULL AUTO_INCREMENT, fy_name varchar(255) COLLATE","columns":[],"plugin":{"slug":"erp","name":"ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support","active_installs":5000,"version":"1.17.5","wp_org_url":"https://wordpress.org/plugins/erp/"}}