{"table_name":"emr_leave_balances","full_table_name":"wp_emr_leave_balances","description":"Stores emr leave balances data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_emr_leave_balances ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, leave_type VARCHAR(20) NOT NULL, year SMALLINT UNSIGNED NOT NULL, accrued DECIMAL(8,2) NOT NULL DEFAULT '0.00', used DECIMAL(8,2) NOT NULL DEFAULT '0.00', adjustment DECIMAL(8,2) NOT NULL DEFAULT '0.00', last_accrual_date DATE DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY uq_user_type_year (user_id, leave_type, year), KEY idx_user (user_id) ) $c;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"leave_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"year","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"accrued","type":"DECIMAL(8,2)","nullable":false,"primary_key":false},{"name":"used","type":"DECIMAL(8,2)","nullable":false,"primary_key":false},{"name":"adjustment","type":"DECIMAL(8,2)","nullable":false,"primary_key":false},{"name":"last_accrual_date","type":"DATE","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}],"plugin":{"slug":"employee-roster","name":"EmpRoster","active_installs":0,"version":"2.8.35","wp_org_url":"https://wordpress.org/plugins/employee-roster/"}}