{"table_name":"hrp_attendances","full_table_name":"wp_hrp_attendances","description":"Stores hrp attendances data created by this plugin.","detection_method":"static","confidence":"high","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","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}],"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/"}}