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 full-screen 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 hsah_training attendances
* id : int(10) unsigned
* enrollment_id : int(10) unsigned
* schedule_id : int(10) unsigned
* user_id : int(10) unsigned
* check_in_time : datetime
* check_out_time : datetime
* status : enum('present','absent','late','excused')
* method : enum('manual','qr','import')
* recorded_by : int(10) unsigned
* notes : text
* created_at : datetime
* updated_at : datetime
v hsah_training audit_logs
* id : bigint(20) unsigned
* user_id : int(10) unsigned
* action : varchar(100)
* table_name : varchar(50)
* record_id : int(10) unsigned
* old_values : longtext
* new_values : longtext
* ip_address : varchar(45)
* user_agent : varchar(255)
* created_at : datetime
v hsah_training categories
* id : int(10) unsigned
* name : varchar(100)
* description : text
* is_active : tinyint(1)
* created_at : datetime
v hsah_training certificates
* id : int(10) unsigned
* enrollment_id : int(10) unsigned
* user_id : int(10) unsigned
* schedule_id : int(10) unsigned
* certificate_no : varchar(50)
* issued_at : datetime
* file_path : varchar(255)
* cpd_points : decimal(5,2)
* created_at : datetime
v hsah_training courses
* id : int(10) unsigned
* department_id : int(10) unsigned
* category_id : int(10) unsigned
* code : varchar(30)
* title : varchar(255)
* description : text
* objectives : text
* target_audience : varchar(255)
* duration_hours : decimal(5,2)
* max_participants : int(10) unsigned
* is_cpd : tinyint(1)
* cpd_points : decimal(5,2)
* status : enum('draft','published','closed','archived')
* created_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v hsah_training course_schedules
* id : int(10) unsigned
* course_id : int(10) unsigned
* start_datetime : datetime
* end_datetime : datetime
* venue : varchar(255)
* trainer_name : varchar(150)
* trainer_user_id : int(10) unsigned
* max_seats : int(10) unsigned
* status : enum('open','full','closed','cancelled')
* notes : text
* created_at : datetime
* updated_at : datetime
v hsah_training departments
* id : int(10) unsigned
* code : varchar(20)
* name : varchar(150)
* description : text
* is_active : tinyint(1)
* created_at : datetime
* updated_at : datetime
v hsah_training enrollments
* id : int(10) unsigned
* schedule_id : int(10) unsigned
* user_id : int(10) unsigned
* status : enum('pending','approved','rejected','cancelled','waitlist','attended','absent')
* enrolled_at : datetime
* cancelled_at : datetime
* notes : text
* created_at : datetime
* updated_at : datetime
v hsah_training settings
* id : int(10) unsigned
* setting_key : varchar(100)
* setting_value : text
* description : varchar(255)
* updated_at : datetime
v hsah_training users
* id : int(10) unsigned
* staff_id : varchar(30)
* username : varchar(50)
* password : varchar(255)
* full_name : varchar(150)
* email : varchar(150)
* phone : varchar(30)
* department_id : int(10) unsigned
* position : varchar(100)
* level : tinyint(3) unsigned
* is_active : tinyint(1)
* last_login : datetime
* created_at : datetime
* updated_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship