www.tpgit.edu.in / 127.0.0.1 / tpgited1

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		tpgited1 caste
community : varchar(50)
caste_name : varchar(50)

v		tpgited1 distribution
sno : int(255)
date : date
item_name : varchar(100)
quantity : decimal(10,2)
price : decimal(10,2)
hostel : varchar(20)
editor : varchar(30)

v		tpgited1 faculty
dept : varchar(50)
username : varchar(20)
password : varchar(30)
year : varchar(5)

v		tpgited1 fb_result
regno : varchar(30)
subcode : varchar(30)
f1 : varchar(30)
f2 : varchar(30)
f3 : varchar(30)
f4 : varchar(30)
f5 : varchar(30)
f6 : varchar(30)
f7 : varchar(30)
f8 : varchar(30)
f9 : varchar(30)
ac : varchar(30)
batch : varchar(2)
dept : varchar(80)

v		tpgited1 fb_staff
user : varchar(20)
pass : varchar(20)
dept : varchar(80)
batch : varchar(2)

v		tpgited1 fb_student
regno : varchar(20)
name : varchar(50)
dob : date
dept : varchar(60)
sem : varchar(20)
ac : varchar(20)
batch : varchar(2)

v		tpgited1 fees
degree : varchar(3)
course : varchar(4)
community : varchar(5)
year : varchar(5)
first_g : varchar(3)
phy_h : varchar(3)
t_fees : decimal(7,0)
d_fees : decimal(7,0)
s_fees : decimal(7,0)
o_fees : decimal(7,0)
e_fees : decimal(7,0)
total : decimal(7,0)
h_fees : decimal(7,0)

v		tpgited1 hod
dept : varchar(50)
username : varchar(20)
password : varchar(30)
degree : varchar(4)

v		tpgited1 image_table
imagename : varchar(100)
imagepath : varchar(200)

v		tpgited1 office
username : varchar(20)
password : varchar(30)

v		tpgited1 pic
name : varchar(45)
img : longblob

v		tpgited1 product_list
sno : int(255)
products : varchar(255)
quantity_limit : decimal(10,2)

v		tpgited1 product_list_tamil
sno : int(255)
products : varchar(255)
quantity_limit : decimal(10,2)

v		tpgited1 purchase
sno : int(255)
date : date
item_name : varchar(50)
quantity : decimal(10,2)
price : decimal(10,2)
stock : decimal(10,2)
editor : varchar(30)

v		tpgited1 register
prefix : varchar(7)
id : int(5) unsigned zerofill
regno : varchar(30)
s_name : varchar(35)
f_name : varchar(35)
dept : varchar(50)
year : varchar(10)
purpose : longtext
p_details : longtext
sdate : date
faculty_verify : tinyint(1)
hod_verify : tinyint(1)
printed : tinyint(1)
rejected : tinyint(1)
degree : varchar(4)
fees_struct : varchar(20)

v		tpgited1 rkproduct_list
sno : int(255)
products : varchar(255)
category : varchar(50)
image : blob

v		tpgited1 rkpurchase
sno : int(255)
date : date
item_name : varchar(50)
quantity : decimal(10,2)
price : decimal(10,2)
trader : varchar(100)

v		tpgited1 rktraders
trader : varchar(150)

v		tpgited1 rkusers
username : varchar(20)

v		tpgited1 sample
id : int(10)
name : varchar(20)
faculty_verify : tinyint(1)
hod_verify : tinyint(1)
printed : tinyint(1)

v		tpgited1 smsdetails
dept : varchar(255)
smsid : varchar(255)
smskey : varchar(255)
senderid : varchar(255)

v		tpgited1 soiltest
fyear : varchar(7)
prefix : varchar(5)
id : int(4) unsigned zerofill
ttype : varchar(20)
oname : varchar(80)
lnum : varchar(10)
ldate : date
staff1 : varchar(40)
staff2 : varchar(40)
rldate : date
basic : float
gst : float
tot : float
rnum : varchar(10)
rdate : date
reportdate : date

v		tpgited1 soiltestlogin
username : varchar(20)
password : varchar(20)

v		tpgited1 stock
item_name : varchar(50)
quantity : decimal(10,2)

v		tpgited1 student
regno : varchar(30)
s_name : varchar(35)
f_name : varchar(30)
dob : date
community : varchar(5)
first_g : varchar(3)
phy_h : varchar(3)
dept : varchar(50)
degree : varchar(3)
hostel : varchar(4)
hostel_status : varchar(30)
batch : varchar(10)
time : timestamp

v		tpgited1 studentall
regno : varchar(30)
rollno : varchar(30)
s_name : varchar(35)
f_name : varchar(30)
dob : date
dept : varchar(52)
gender : varchar(15)
nationality : varchar(10)
religion : varchar(15)
community : varchar(5)
caste : varchar(20)
caddr : varchar(500)
paddr : varchar(500)
phoneno : bigint(10)
pphoneno : bigint(10)
email : varchar(40)
baccno : varchar(30)
ifsc : varchar(30)
aadhar : bigint(20)
first_g : varchar(3)
phy_h : varchar(3)
degree : varchar(3)
hostel : varchar(4)
hostel_status : varchar(30)
batch : varchar(20)
updated : varchar(3)
time : timestamp

v		tpgited1 sub_allocation
dept : varchar(60)
sem : varchar(30)
subcode : varchar(30)
faculty : varchar(90)
ac : varchar(30)
batch : varchar(2)

v		tpgited1 sub_details
regulation : varchar(30)
semester : varchar(30)
sub_code : varchar(30)
sub_name : varchar(255)
credits : varchar(30)
dept : varchar(60)

v		tpgited1 users
username : varchar(20)
password : varchar(20)
job_role : varchar(30)

v		tpgited1 wp_commentmeta
meta_id : bigint(20) unsigned
comment_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		tpgited1 wp_comments
comment_ID : bigint(20) unsigned
comment_post_ID : bigint(20) unsigned
comment_author : tinytext
comment_author_email : varchar(100)
comment_author_url : varchar(200)
comment_author_IP : varchar(100)
comment_date : datetime
comment_date_gmt : datetime
comment_content : text
comment_karma : int(11)
comment_approved : varchar(20)
comment_agent : varchar(255)
comment_type : varchar(20)
comment_parent : bigint(20) unsigned
user_id : bigint(20) unsigned

v		tpgited1 wp_ea11y_scanner_results
id : int(11) unsigned
url : varchar(2048)
results : text
summary : text
created_at : datetime
updated_at : datetime

v		tpgited1 wp_e_events
id : bigint(20) unsigned
event_data : text
created_at : datetime

v		tpgited1 wp_huge_itgallery_gallerys
id : int(11) unsigned
name : varchar(200)
sl_height : int(11) unsigned
sl_width : int(11) unsigned
pause_on_hover : text
gallery_list_effects_s : text
description : text
hover_effect : int(1)
param : text
sl_position : text
ordering : int(11)
published : text
huge_it_sl_effects : text
display_type : int(11)
content_per_page : int(11)
rating : varchar(15)
autoslide : varchar(15)

v		tpgited1 wp_huge_itgallery_images
id : int(11) unsigned
name : varchar(100)
gallery_id : varchar(200)
description : text
image_url : text
sl_url : text
sl_type : text
link_target : text
ordering : int(11)
published : tinyint(4) unsigned
published_in_sl_width : tinyint(4) unsigned
like : int(11)
dislike : int(11)

v		tpgited1 wp_huge_itgallery_like_dislike
id : int(11)
image_id : int(11)
image_status : varchar(10)
ip : varchar(35)
cook : varchar(15)

v		tpgited1 wp_links
link_id : bigint(20) unsigned
link_url : varchar(255)
link_name : varchar(255)
link_image : varchar(255)
link_target : varchar(25)
link_description : varchar(255)
link_visible : varchar(20)
link_owner : bigint(20) unsigned
link_rating : int(11)
link_updated : datetime
link_rel : varchar(255)
link_notes : mediumtext
link_rss : varchar(255)

v		tpgited1 wp_options
option_id : bigint(20) unsigned
option_name : varchar(191)
option_value : longtext
autoload : varchar(20)

v		tpgited1 wp_postmeta
meta_id : bigint(20) unsigned
post_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		tpgited1 wp_posts
ID : bigint(20) unsigned
post_author : bigint(20) unsigned
post_date : datetime
post_date_gmt : datetime
post_content : longtext
post_title : text
post_excerpt : text
post_status : varchar(20)
comment_status : varchar(20)
ping_status : varchar(20)
post_password : varchar(255)
post_name : varchar(200)
to_ping : text
pinged : text
post_modified : datetime
post_modified_gmt : datetime
post_content_filtered : longtext
post_parent : bigint(20) unsigned
guid : varchar(255)
menu_order : int(11)
post_type : varchar(20)
post_mime_type : varchar(100)
comment_count : bigint(20)

v		tpgited1 wp_termmeta
meta_id : bigint(20) unsigned
term_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		tpgited1 wp_terms
term_id : bigint(20) unsigned
name : varchar(200)
slug : varchar(200)
term_group : bigint(10)

v		tpgited1 wp_term_relationships
object_id : bigint(20) unsigned
term_taxonomy_id : bigint(20) unsigned
term_order : int(11)

v		tpgited1 wp_term_taxonomy
term_taxonomy_id : bigint(20) unsigned
term_id : bigint(20) unsigned
taxonomy : varchar(32)
description : longtext
parent : bigint(20) unsigned
count : bigint(20)

v		tpgited1 wp_usermeta
umeta_id : bigint(20) unsigned
user_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		tpgited1 wp_users
ID : bigint(20) unsigned
user_login : varchar(60)
user_pass : varchar(255)
user_nicename : varchar(50)
user_email : varchar(100)
user_url : varchar(100)
user_registered : datetime
user_activation_key : varchar(255)
user_status : int(11)
display_name : varchar(250)

v		tpgited1 wp_verticalmarquee
vm_id : int(11)
vm_text : text
vm_link : varchar(1024)
vm_group : varchar(10)
vm_date : datetime

v		tpgited1 wp_wpfm_backup
id : int(11)
backup_name : text
backup_date : text

Create relationship
FOREIGN KEY
on delete
on update