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
Showing 2 bookmarks (both private and shared)
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 emp_recruit awards
* row_number : int(11)
* Id : int(5)
* type_award : varchar(50)
* given_award : varchar(100)
* award_year : varchar(100)
* awards_title : varchar(50)
* file : varchar(100)
* score : int(10)
v emp_recruit bank_detail
* id : int(20)
* reg_id : varchar(50)
* acc_hname : varchar(50)
* accno : varchar(50)
* bname : varchar(100)
* ifsc_code : varchar(50)
* pan_no : varchar(11)
v emp_recruit basic_info
* reg_id : int(5)
* s_name : varchar(200)
* nationality : varchar(50)
* age : varchar(100)
* marital_status : varchar(50)
* gender : varchar(50)
* aadhaar : varchar(50)
* c_address : varchar(200)
* c_address1 : varchar(200)
* c_city : varchar(50)
* c_pin_code : int(50)
* c_state : varchar(200)
* c_district : varchar(200)
* p_address : varchar(200)
* p_address1 : varchar(200)
* p_city : varchar(50)
* p_pin_code : int(50)
* p_state : varchar(200)
* p_district : varchar(200)
* category : varchar(50)
* pwd : varchar(10)
* ex_service : varchar(10)
* age_relax : varchar(10)
* tpc : varchar(10)
* emp_nitttr : varchar(10)
* pwd_file : varchar(100)
* ex_file : varchar(100)
* age_file : varchar(100)
v emp_recruit district
* dis_id : int(5)
* state_id : int(5)
* dis_name : varchar(100)
v emp_recruit enclosure
* Id : int(5)
* Encl_name : varchar(100)
* Filename : varchar(200)
* Date : timestamp
v emp_recruit experience
* row_number : int(10)
* id : int(10)
* insti_name : varchar(100)
* post : varchar(100)
* fdate : date
* tdate : date
* total_exp : varchar(100)
* paylevel_gp : varchar(100)
* pay_scale : varchar(100)
* gross_pay : varchar(100)
* adhoc_reg : varchar(200)
* duties : varchar(100)
* employee_status : enum('yes','no')
* date : date
v emp_recruit final_submission
* id : int(50)
* status : enum('yes','no')
* date : date
v emp_recruit gate_qualified
* s.no : int(10)
* id : int(11)
* exam_type : varchar(50)
* yearof_qualified : varchar(20)
* roll_no : varchar(100)
* percentile : float
v emp_recruit log_table
* id : int(11)
* ipaddress : varchar(100)
v emp_recruit other_rel_info
* Id : int(5)
* Other_info : text
v emp_recruit paper_publish
* reg_id : int(5)
* no_paper : int(5)
v emp_recruit passing_exam
* id : int(10)
* quali_name : varchar(100)
v emp_recruit patents
* Id : int(5)
* No_patents : int(5)
v emp_recruit patents_publish
* Id : int(5)
* No_patents : int(5)
v emp_recruit patent_details
* row_number : int(11)
* Id : int(5)
* Patent_title : varchar(100)
* No_Inventor : int(11)
* Principal_Inventor : varchar(5)
* file : varchar(100)
v emp_recruit patent_publish_details
* row_number : int(100)
* Id : int(5)
* Patent_title : varchar(100)
* No_Inventor : int(11)
* Principal_Inventor : varchar(5)
* file : varchar(100)
v emp_recruit payment
* id : int(11)
* txnid : varchar(100)
* amount : varchar(100)
* status : varchar(200)
v emp_recruit payment_table
* Id : int(11)
* Name : varchar(200)
* Amount : int(5)
* Payment_status : varchar(50)
* Fee_date : date
* Tranx_id : varchar(50)
v emp_recruit payment_table_back
* Id : int(11)
* Name : varchar(200)
* Amount : int(5)
* Payment_status : varchar(50)
* Fee_date : date
* Tranx_id : varchar(50)
v emp_recruit photo_sign
* id : int(11)
* reg_id : int(20)
* photo : varchar(100)
* sign : varchar(100)
v emp_recruit PI_COPI
* Author : varchar(20)
v emp_recruit publication
* row_number : int(10)
* id : int(5)
* pub_type : varchar(200)
* title : varchar(200)
* name_jour : varchar(200)
* publisher : varchar(200)
* url : varchar(200)
* author : varchar(20)
* file : varchar(100)
* score : float
v emp_recruit qual
* row_number : int(10)
* id : int(11)
* exam_passed : varchar(100)
* other_exam : varchar(100)
* discipline : varchar(200)
* percentage_cgpa : float
* marks_cgpa : varchar(100)
* score : varchar(100)
* passing_year : int(11)
* univ_board : varchar(100)
* subjects : varchar(300)
v emp_recruit qualified_score
* id : int(10)
* reg_id : varchar(100)
* score : varchar(50)
* c_score : float
* total_score : float
v emp_recruit registeration
* reg_id : int(5)
* application_for : varchar(50)
* fname : varchar(200)
* lname : varchar(200)
* father_name : varchar(200)
* mother_name : varchar(200)
* dob : date
* mobile : varchar(10)
* pass : varchar(200)
* email : varchar(200)
* date_regt : date
* mark_reg_no : varchar(20)
v emp_recruit research_exp
* row_number : int(11)
* Id : int(11)
* res_exp_type : varchar(50)
* Type_res_org : varchar(50)
* Org_name : varchar(200)
* Rank_org : int(11)
* Rank_year : varchar(4)
* Num_yr_exp : int(11)
* file : varchar(100)
* Score : int(11)
v emp_recruit research_projects
* row_number : int(11)
* Id : int(5)
* Name_funding_agency : varchar(200)
* Name_project : varchar(200)
* Year_grant : int(5)
* Amount : bigint(11)
* PI_COPI : varchar(50)
* Status_Project : varchar(200)
v emp_recruit state
* state_id : int(5)
* state_name : varchar(100)
v emp_recruit undertaking
* Id : int(11)
* undertake : tinyint(1)
* place : varchar(200)
v emp_recruit year
* Year : int(5)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship