Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v library_access_db admins
* id : int(11)
* name : varchar(100)
* username : varchar(50)
* password_hash : varchar(255)
* last_login : datetime
* role : enum('admin','supervisor','user','backup_restore','manage_borrowings')
* status : enum('active','inactive')
* manage_borrowings : tinyint(1)
v library_access_db audit_logs
* id : int(11)
* table_name : varchar(100)
* record_id : varchar(50)
* action : enum('INSERT','UPDATE','DELETE')
* performed_by : varchar(50)
* performed_at : timestamp
* details : text
v library_access_db backup_history
* id : int(11)
* filename : varchar(255)
* filepath : varchar(255)
* backup_size : varchar(20)
* created_at : datetime
* created_by : int(11)
v library_access_db books
* id : int(11)
* title : varchar(255)
* author : varchar(255)
* isbn : varchar(50)
* category : varchar(100)
* available_copies : int(11)
* created_at : timestamp
* barcode : varchar(100)
* publisher : varchar(100)
v library_access_db borrowings
* id : int(11)
* student_id : varchar(255)
* book_id : int(11)
* borrow_date : datetime
* expected_return_date : date
* return_date : date
* status : enum('borrowed','returned')
* book_barcode : varchar(100)
v library_access_db clearance_requests
* id : int(11)
* student_id : varchar(20)
* request_date : datetime
* decision_date : datetime
* notes : text
* status : enum('جديد','قيد المراجعة','معتمد','مرفوض')
* approved_at : datetime
* reviewed_by : varchar(100)
* created_at : datetime
* person_id : varchar(50)
* person_type : enum('student','visitor')
v library_access_db complaints
* id : int(11)
* reference_code : varchar(30)
* full_name : varchar(150)
* phone : varchar(20)
* email : varchar(150)
* person_type : enum('student','visitor','other')
* person_id : varchar(50)
* category : enum('شكوى','مقترح','استفسار')
* subject : varchar(200)
* message : text
* status : enum('جديد','قيد المراجعة','تم الرد','مغلق')
* admin_response : text
* responded_by : int(11)
* responded_at : datetime
* created_at : datetime
* ip_address : varchar(45)
v library_access_db entry_logs
* id : int(11)
* student_id : varchar(20)
* entry_time : datetime
* source : enum('بوابة الدخول')
v library_access_db faculties
* id : int(11)
* name : varchar(255)
* university_id : int(11)
v library_access_db halls
* id : int(11)
* name : varchar(100)
* capacity : int(11)
v library_access_db hall_logs
* id : int(11)
* person_type : enum('student','visitor')
* person_id : varchar(50)
* hall_name : varchar(100)
* entry_time : datetime
* exit_time : datetime
v library_access_db logout_log
* id : int(11)
* logout_time : datetime
v library_access_db roles_permissions
* role : varchar(20)
* permission : varchar(50)
* allowed : tinyint(1)
v library_access_db services
* id : int(11)
* name : varchar(100)
v library_access_db settings
* id : int(11)
* setting_key : varchar(50)
* setting_value : text
* site_name : varchar(255)
* logo_path : varchar(255)
* secondary_logo_path : varchar(255)
* welcome_text : text
* created_at : timestamp
v library_access_db students
* student_id : varchar(20)
* name : varchar(100)
* university : varchar(100)
* faculty : varchar(100)
* level : varchar(50)
* gender : enum('ذكر','أنثى')
* national_id : varchar(14)
* phone : varchar(20)
* photo : varchar(255)
* subscription_start : date
* subscription_end : date
* created_at : timestamp
* start_date : date
* end_date : date
* subscription_type : varchar(20)
* subscription_amount : decimal(10,2)
* receipt_number : varchar(50)
* updated_at : timestamp
v library_access_db study_levels
* id : int(11)
* name : varchar(255)
v library_access_db system_settings
* id : int(11)
* max_borrow_days : int(11)
* max_books_per_user : int(11)
* fine_per_day : decimal(10,2)
* updated_at : timestamp
v library_access_db theses
* id : int(11)
* student_id : varchar(50)
* student_name : varchar(255)
* university : varchar(255)
* faculty : varchar(255)
* level : varchar(100)
* national_id : varchar(20)
* thesis_title : text
* supervisor : varchar(255)
* submission_date : date
* degree_type : varchar(50)
* department : varchar(100)
* file_path : varchar(255)
* created_at : timestamp
v library_access_db universities
* id : int(11)
* name : varchar(255)
v library_access_db visitors
* visitor_id : varchar(50)
* name : varchar(255)
* university : int(11)
* faculty : int(11)
* level : int(11)
* start_date : date
* end_date : date
* gender : varchar(10)
* national_id : varchar(20)
* phone : varchar(20)
* photo_path : varchar(255)
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship