* id name username password_hash last_login role status manage_borrowings

* id table_name record_id action performed_by performed_at details

* id filename filepath backup_size created_at created_by

* id title author isbn category available_copies created_at barcode publisher

* id student_id book_id borrow_date expected_return_date return_date status book_barcode

* id student_id request_date decision_date notes status approved_at reviewed_by created_at person_id person_type

* id reference_code full_name phone email person_type person_id category subject message status admin_response responded_by responded_at created_at ip_address

* id student_id entry_time source

* id name university_id

* id name capacity

* id person_type person_id hall_name entry_time exit_time

* id logout_time

* role permission allowed

* id name

* id setting_key setting_value site_name logo_path secondary_logo_path welcome_text created_at

* student_id name university faculty level gender national_id phone photo subscription_start subscription_end created_at start_date end_date subscription_type subscription_amount receipt_number updated_at

* id name

* id max_borrow_days max_books_per_user fine_per_day updated_at

* id student_id student_name university faculty level national_id thesis_title supervisor submission_date degree_type department file_path created_at

* id name

* visitor_id name university faculty level start_date end_date gender national_id phone photo_path updated_at

select table admins audit_logs backup_history books borrowings clearance_requests complaints entry_logs faculties halls hall_logs logout_log roles_permissions services settings students study_levels system_settings theses universities visitors . 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 admins audit_logs backup_history books borrowings clearance_requests complaints entry_logs faculties halls hall_logs logout_log roles_permissions services settings students study_levels system_settings theses universities visitors .	select column