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_nontech 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_nontech 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_nontech enclosure
* Id : int(11)
* Encl_name : varchar(100)
* Filename : varchar(200)
* Date : timestamp
v emp_nontech experience
* row_number : int(10)
* id : int(11)
* 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_nontech fees
* id : int(11)
v emp_nontech final_submission
* id : int(11)
* status : enum('yes','no')
* date : date
* time : time
v emp_nontech log_table
* id : int(11)
* ipaddress : varchar(100)
v emp_nontech other_rel_info
* Id : int(11)
* Other_info : text
v emp_nontech passing_exam
* id : int(11)
* quali_name : varchar(100)
v emp_nontech payment
* id : int(11)
* txnid : varchar(100)
* amount : varchar(100)
* status : varchar(200)
v emp_nontech payment_table
* Id : int(11)
* Name : varchar(200)
* Amount : int(5)
* Payment_status : varchar(50)
* Fee_date : date
* Tranx_id : varchar(50)
v emp_nontech photo_sign
* id : int(11)
* reg_id : int(20)
* photo : varchar(100)
* sign : varchar(100)
v emp_nontech preview_details
* s.no : int(10)
* reg_id : varchar(100)
* date : varchar(10)
v emp_nontech qual
* row_number : int(10)
* id : int(11)
* exam_passed : varchar(100)
* discipline : varchar(200)
* percentage_cgpa : float
* division_grade : varchar(50)
* duration : varchar(10)
* passing_year : int(11)
* univ_board : varchar(100)
* subjects : varchar(300)
v emp_nontech registeration
* reg_id : int(11)
* application_for : varchar(50)
* adv_no : 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_nontech state
* state_id : int(5)
* state_name : varchar(100)
v emp_nontech typing_mode
* id : int(10)
* reg_id : varchar(50)
* test_type : varchar(50)
v emp_nontech undertaking
* Id : int(11)
* undertake : tinyint(1)
* place : varchar(200)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship