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
Number of tables: 0
v tradition candidates
* id : int(11)
* name : varchar(255)
* category : enum('Male','Female')
v tradition candidates2
* id : int(11)
* name : varchar(255)
* category : enum('Male','Female')
v tradition judges
* id : int(11)
* name : varchar(255)
v tradition scores
* id : int(11)
* candidate_id : int(11)
* judge_id : int(11)
* Poise_and_Bearing : decimal(5,2)
* Mastery : decimal(5,2)
* Self_Introduction : decimal(5,2)
* Audience_Impact : decimal(5,2)
* Total_Score : decimal(5,2)
v tradition scores2
* id : int(11)
* candidate_id : int(11)
* judge_id : int(11)
* Beauty_and_Poise : decimal(5,2)
* Presentation_and_Neatness : decimal(5,2)
* total_score : decimal(5,2)
v tradition scores3
* id : int(11)
* candidate_id : int(11)
* judge_id : int(11)
* Poise_and_Bearing : decimal(5,2)
* Carriage : decimal(5,2)
* Beauty : decimal(5,2)
* Audience_Impact : decimal(5,2)
* Total_Score : decimal(5,2)
v tradition scores4
* id : int(11)
* candidate_id : int(11)
* judge_id : int(11)
* Design_and_Fitting : decimal(5,2)
* Stage_Deportment : decimal(5,2)
* Poise_and_Bearing : decimal(5,2)
* Overall_Impact : decimal(5,2)
* Total_Score : decimal(5,2)
v tradition scores5
* id : int(11)
* candidate_id : int(11)
* judge_id : int(11)
* Physical_Attributes : decimal(5,2)
* Poise_and_Bearing : decimal(5,2)
* Humanity : decimal(5,2)
* Wit_and_Audience_Impact : decimal(5,2)
* Total_Score : decimal(5,2)
v tradition scores6
* id : int(11)
* candidate_id : int(11)
* judge_id : int(11)
* Clarity_and_Relevance : decimal(5,2)
* Spontaneity_and_Confidence : decimal(5,2)
* Beauty_and_Physique : decimal(5,2)
* Total_Score : decimal(5,2)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship