{"slug":"hr-press-lite","name":"HR Press Lite","description":"Track employee check-ins, breaks, attendance, and manage your entire team — all from your WordPress dashboard. Free forever.","author":"CODECLOVE","active_installs":60,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/hr-press-lite/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"hrp_announcements","full_table_name":"wp_hrp_announcements","description":"Stores hrp announcements data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"varchar(190)","nullable":true,"primary_key":false},{"name":"send_to","type":"varchar(190)","nullable":true,"primary_key":false},{"name":"announcement","type":"text","nullable":true,"primary_key":false},{"name":"announced_to","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hrp_announcements`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(190) DEFAULT NULL, send_to varchar(190) DEFAULT NULL, announcement text DEFAULT NULL, announced_to text DEFAULT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, `user_id` bigint(20) DEFAULT NULL, `status` tinyint(1) DEFAULT 1, PRIMARY KEY (ID), KEY send_to (send_to) ) ENGINE"},{"table_name":"hrp_attendances","full_table_name":"wp_hrp_attendances","description":"Stores hrp attendances data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"employee_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"checkin","type":"time","nullable":true,"primary_key":false},{"name":"checkout","type":"time","nullable":true,"primary_key":false},{"name":"breakin","type":"time","nullable":true,"primary_key":false},{"name":"breakout","type":"time","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"comment","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"ip_address","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hrp_attendances`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) DEFAULT NULL, `checkin` time DEFAULT NULL, `checkout` time DEFAULT NULL, `breakin` time DEFAULT NULL, `breakout` time DEFAULT NULL, `date` date NULL DEFAULT NULL, `comment` text DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, ip_address text DEFAULT NULL, PRIMARY KEY (ID), KEY employee_id (employee_id), KEY `date` (`date`) ) ENGINE"},{"table_name":"hrp_departments","full_table_name":"wp_hrp_departments","description":"Stores hrp departments data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"employee_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hrp_departments`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(200) DEFAULT NULL, `description` text DEFAULT NULL, `employee_id` int(11) unsigned DEFAULT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (ID) ) ENGINE"},{"table_name":"hrp_designations","full_table_name":"wp_hrp_designations","description":"Stores hrp designations data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hrp_designations`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(200) DEFAULT NULL, `description` text DEFAULT NULL, `status` tinyint(1) DEFAULT 1, created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (ID) ) ENGINE"},{"table_name":"hrp_employees","full_table_name":"wp_hrp_employees","description":"Stores hrp employees data created by this plugin.","detection_method":"static","confidence":"high","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}],"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"},{"table_name":"hrp_employees_work_detail","full_table_name":"wp_hrp_employees_work_detail","description":"Stores hrp employees work detail data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"hrp_holidays","full_table_name":"wp_hrp_holidays","description":"Stores hrp holidays data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"varchar(190)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"added_by_user_id","type":"bigint(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hrp_holidays`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(190) DEFAULT NULL, `start_date` date NULL DEFAULT NULL, `end_date` date NULL DEFAULT NULL, `description` text DEFAULT NULL, `added_by_user_id` bigint(20) DEFAULT NULL, PRIMARY KEY (ID) ) ENGINE"},{"table_name":"hrp_payroll","full_table_name":"wp_hrp_payroll","description":"Stores hrp payroll data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"hrp_reports","full_table_name":"wp_hrp_reports","description":"Stores hrp reports data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"hrp_settings","full_table_name":"wp_hrp_settings","description":"Stores hrp settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"setting_key","type":"varchar(190)","nullable":true,"primary_key":false},{"name":"setting_value","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hrp_settings`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, setting_key varchar(190) DEFAULT NULL, setting_value text DEFAULT NULL, PRIMARY KEY (ID), KEY setting_key (setting_key), UNIQUE (setting_key) ) ENGINE"},{"table_name":"hrp_shifts","full_table_name":"wp_hrp_shifts","description":"Stores hrp shifts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"start_time","type":"time","nullable":true,"primary_key":false},{"name":"end_time","type":"time","nullable":true,"primary_key":false},{"name":"holidays","type":"varchar(190)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_hrp_shifts`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(191) DEFAULT NULL, `start_time` time DEFAULT NULL, `end_time` time DEFAULT NULL, `holidays` varchar(190) DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (ID), KEY `title` (`title`), KEY `start_time` (`start_time`), KEY `end_time` (`end_time`), KEY `status` (`status`) ) ENGINE"}],"table_count":11}