* id user_id machine_id type timestamp lat lng ip_address distance_meter

* id name lat lng radius iframe_map location_iframe created_at

* id user_id date manual_in manual_out remark ot_type ot_amount ot_day ot_hour status row_color is_night_shift is_holiday

* id title file_path file_type category user_id uploaded_by created_at

* id document_request_id user_id notification_type title message is_read read_at created_at

* id user_id document_type_id request_data status rejection_reason approved_by approved_at pickup_date approved_file_path picked_up_at picked_up_by created_at submitted_at updated_at

* id document_request_id file_name file_path file_size mime_type uploaded_at

* id name description required_fields is_active created_at

* id user_id id_card_type id_card_number id_card_issue_date id_card_expiry_date bank_name bank_account_number account_holder_name bank_branch social_security_number street_address subdistrict district province postal_code phone_number emergency_contact_name emergency_contact_phone emergency_contact_relation is_verified verified_by verified_at created_at updated_at

* id user_id date shift_id

* id user_id shift_id date created_at

* id user_id original_date new_date reason status approved_by created_at

* id user_id sick_limit personal_limit vacation_limit year total_days

* id user_id leave_type start_date end_date reason status approver_id created_at

* id user_id leave_type start_date end_date reason status reject_reason approver_id created_at attachment

* id user_id action ip_address user_agent created_at

* id machine_name machine_number connection_type is_android ip_address port comm_key created_at

* id sender_id receiver_id message attachment is_read created_at

* id user_id title message link type is_read created_at

* id user_id month_year base_salary allowance ot_total deduction bonus net_total status note slip_file created_at

* id type amount title receipt_img transaction_date created_by created_at

* id date name created_at

* id user_id check_in_time latitude longitude photo_path distance_meter status rejection_reason approved_by approved_at remarks created_at updated_at

* id shift_name start_time end_time color is_active

* id user_id title message link type is_read created_at

* setting_key setting_value setting_label is_visible

* id employee_id name nickname email profile_pic password role department branch_id base_salary position start_date is_custom_quota wage_amount wage_type weekly_holidays pay_on_holiday

* user_id lat lng updated_at

* id name start_time end_time color

select table attendance_logs branches daily_adjustments documents document_notifications document_requests document_request_attachments document_types employee_profiles employee_schedule employee_schedules holiday_swaps leave_quotas leave_requests leave_type login_history machines messages notifications payrolls petty_cash public_holidays remote_attendance shifts system_notifications system_settings users user_realtime_locations work_shifts . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table attendance_logs branches daily_adjustments documents document_notifications document_requests document_request_attachments document_types employee_profiles employee_schedule employee_schedules holiday_swaps leave_quotas leave_requests leave_type login_history machines messages notifications payrolls petty_cash public_holidays remote_attendance shifts system_notifications system_settings users user_realtime_locations work_shifts .	select column