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 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 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