Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: it
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:
1
it
{"j_tabs":{"it.department":1,"it.device":1,"it.device_type":1,"it.employee":1,"it.job":1,"it.job_type":1,"it.migration":1,"it.software_detail":1,"it.software_type":1,"it.system":1,"it.user":1},"h_tabs":{"it.department":1,"it.device":1,"it.device_type":1,"it.employee":1,"it.job":1,"it.job_type":1,"it.migration":1,"it.software_detail":1,"it.software_type":1,"it.system":1,"it.user":1}}
[]
[]
-1
1
Untitled *
v Show/Hide tables list View in fullscreen New page Open page Save page Save page as Delete pages Create table Create relation Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relation lines Export schema > Move Menu > Pin text
v it department
* id : int(11)
* department_name : varchar(255)
v it device
* id : int(11)
* device_id : varchar(50)
* serial_no : varchar(50)
* device_brand : varchar(255)
* device_model : varchar(255)
* device_name : varchar(255)
* memory : varchar(50)
* cpu : varchar(100)
* harddisk : varchar(100)
* monitor : varchar(100)
* mouse : varchar(255)
* keyboard : varchar(255)
* ex_drive : varchar(255)
* hardware_other : text
* other_detail : varchar(255)
* device_ip : varchar(100)
* date_use : date
* date_expire : date
* device_price : double(22,2)
* device_docs : varchar(50)
* vender : varchar(255)
* warranty : varchar(255)
* device_status : varchar(100)
* device_type_id : int(11)
* department_id : int(11)
* employee_id : int(11)
* image : varchar(255)
* mac : varchar(255)
* software : varchar(1000)
* software_sn : text
* software_detail : varchar(1000)
v it device_type
* id : int(11)
* device_type : varchar(45)
v it employee
* id : int(11)
* user_fullname : varchar(45)
* user_position : varchar(100)
* user_email : varchar(255)
* user_phone : varchar(100)
* department_id : int(11)
* username : varchar(255)
* password_hash : varchar(255)
* role : varchar(100)
* auth_key : varchar(255)
* created_at : int(11)
* updated_at : int(11)
v it job
* id : int(11)
* job_number : varchar(100)
* job_date : datetime
* job_detail : varchar(1000)
* job_start_date : datetime
* job_success_date : datetime
* job_how_to_fix : varchar(1000)
* price : int(11)
* job_status : varchar(45)
* job_employee_id : int(11)
* job_type_id : int(11)
* device_id : int(11)
* user_id : int(11)
* phone : varchar(100)
* request_file : varchar(255)
* success_file : varchar(255)
v it job_type
* id : int(11)
* job_type_name : varchar(45)
v it migration
* version : varchar(180)
* apply_time : int(11)
v it software_detail
* id : int(11)
* software_type_id : int(11)
* software_detail : varchar(255)
v it software_type
* id : int(11)
* software_type : varchar(100)
v it system
* id : int(11)
* line_token : varchar(255)
* login_required : int(11)
v it user
* id : int(11)
* fullname : varchar(255)
* username : varchar(255)
* position : varchar(255)
* email : varchar(60)
* password_hash : varchar(60)
* auth_key : varchar(255)
* created_at : int(11)
* updated_at : int(11)
* role : varchar(45)