Drop files here

SQL upload ( 0 ) x -

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
Restore default values
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
Number of tables: 0
v hr countries
* country_id : char(2)
* country_name : varchar(40)
* region_id : int(11) unsigned
v hr departments
* department_id : int(11) unsigned
* department_name : varchar(30)
* manager_id : int(11) unsigned
* location_id : int(11) unsigned
v hr employees
* employee_id : int(11) unsigned
* first_name : varchar(20)
* last_name : varchar(25)
* email : varchar(25)
* phone_number : varchar(20)
* hire_date : date
* job_id : varchar(10)
* salary : decimal(8,2)
* commission_pct : decimal(2,2)
* manager_id : int(11) unsigned
* department_id : int(11) unsigned
v hr jobs
* job_id : varchar(10)
* job_title : varchar(35)
* min_salary : decimal(8,0) unsigned
* max_salary : decimal(8,0) unsigned
v hr job_history
* employee_id : int(11) unsigned
* start_date : date
* end_date : date
* job_id : varchar(10)
* department_id : int(11) unsigned
v hr locations
* location_id : int(11) unsigned
* street_address : varchar(40)
* postal_code : varchar(12)
* city : varchar(30)
* state_province : varchar(25)
* country_id : char(2)
v hr regions
* region_id : int(11) unsigned
* region_name : varchar(25)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship