{"slug":"employee-management-system","name":"Employee Management System","description":"A comprehensive employee management system with sales tracking, reporting, and dashboard features for WordPress.","author":"Md. Maruf Khan","active_installs":10,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/employee-management-system/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"emplmasy_employee_sales","full_table_name":"wp_emplmasy_employee_sales","description":"Stores emplmasy employee sales data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_emplmasy_employee_sales ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, date date NOT NULL, amount decimal(10,2) NOT NULL, description text NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY date (date) ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"emplmasy_employees","full_table_name":"wp_emplmasy_employees","description":"Stores emplmasy employees data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"department","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"designation","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"join_date","type":"date","nullable":false,"primary_key":false},{"name":"leave_date","type":"date","nullable":true,"primary_key":false},{"name":"starting_salary","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"current_salary","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"street_address","type":"text","nullable":true,"primary_key":false},{"name":"city","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"state","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"postal_code","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"emergency_contact_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"emergency_contact_phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"emergency_contact_relation","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"marital_status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_emplmasy_employees ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, department varchar(100) NOT NULL, designation varchar(100) NOT NULL, join_date date NOT NULL, leave_date date NULL, starting_salary decimal(10,2) NOT NULL DEFAULT '0.00', current_salary decimal(10,2) NOT NULL DEFAULT '0.00', phone varchar(20) NULL, street_address text NULL, city varchar(100) NULL, state varchar(100) NULL, postal_code varchar(20) NULL, country varchar(100) NULL, emergency_contact_name varchar(100) NULL, emergency_contact_phone varchar(20) NULL, emergency_contact_relation varchar(50) NULL, marital_status varchar(20) DEFAULT 'single', status varchar(20) DEFAULT 'active', created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY department (department), KEY join_date (join_date), KEY leave_date (leave_date) ) $charset_collate;\"; dbDelta($sql);"}],"table_count":2}