{"table_name":"hrp_employees","full_table_name":"wp_hrp_employees","description":"Stores hrp employees data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_hrp_employees`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) DEFAULT NULL, photo_id bigint(20) DEFAULT NULL, employee_id varchar(20) DEFAULT NULL, `name` varchar(40) DEFAULT NULL, date_of_hire date NULL DEFAULT NULL, termination_date date NULL DEFAULT NULL, date_of_birth date NULL DEFAULT NULL, department bigint(20) DEFAULT NULL, designation bigint(20) DEFAULT NULL, `location` varchar(50) DEFAULT NULL, `source_of_hire` varchar(50) DEFAULT NULL, `type` varchar(20) DEFAULT NULL, `status` varchar(10) DEFAULT NULL, reporting_to bigint(20) DEFAULT NULL, pay_rate decimal(20,2) unsigned DEFAULT NULL, pay_type varchar(20) DEFAULT NULL, mobile varchar(50) DEFAULT NULL, shift_id bigint(20) DEFAULT NULL, deleted_at datetime DEFAULT NULL, PRIMARY KEY (ID), KEY user_id (user_id), KEY designation (designation), KEY department (department), KEY `status` (`status`) ) ENGINE","columns":[{"name":"ID","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"photo_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"employee_id","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(40)","nullable":true,"primary_key":false},{"name":"date_of_hire","type":"date","nullable":true,"primary_key":false},{"name":"termination_date","type":"date","nullable":true,"primary_key":false},{"name":"date_of_birth","type":"date","nullable":true,"primary_key":false},{"name":"department","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"designation","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"location","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"source_of_hire","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"reporting_to","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"pay_rate","type":"decimal(20,2) unsigned","nullable":true,"primary_key":false},{"name":"pay_type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"mobile","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"shift_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"hr-press-lite","name":"HR Press Lite","active_installs":60,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/hr-press-lite/"}}