Recent
`sgm_crm`.`users`
`sgm_crm`.`sample_table`
`surena_crm`.`auth_user_user_permissions`
`sgm_crm`.`auth_user_groups`
`sgm_crm`.`transaction_additional_charges`
`surena_crm`.`django_admin_log`
`sgm_crm`.`setting_allowed_ips`
`sgm_crm`.`user_roles`
`surena_crm`.`subsidy_scheme_documents`
`sgm_crm`.`gst_authcode`
Favourites
There are no favourite tables.
New
information_schema
mysql
payitsea_jnablr
performance_schema
phpmyadmin
rajkamal_crm
sgm_crm
surena
surena_code_editor
surena_crm
edbroad
surena_edbroad_1
surena_edbroad_old
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customise 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
).
main
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.
Favourite tables
Maximum number of favourite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customise 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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: payitsea_jnablr
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
sgm_crm
Queried time :
During current session
SELECT * FROM `auth_user_groups`
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
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
location_id
location_name
order_by
active_status
user
modified_at
*
s_id
school_code
location_id
*
sl_id
trust_name
institution_name
address1
address2
city
city_code
contact1
contact2
logo_1
logo_2
certified_no
certify_details
school_latitude
school_longitude
website
email
facebook
twitter
bank_current_ac
bank_ifsc_code
bank_name
bank_branch
bank_city
active_status
modified_at
*
yr_id
ac_year
start_date
end_date
present_year
default_year
user
upcoming_year
active_status
modified_at
*
inst_type_id
institution_type
yr_id
active_status
user
modified_at
*
cgroup_id
cgroup_name
inst_type_id
competitive_exam
user
status
modified_at
*
course_id
course_name
cgroup_id
eclass_id
test_resource
class_resoure
consolidated_format
consolidate_custom
marks_card_format
marks_card_attendance
marks_card_remarks
marks_card_custom
class_teacher_signature
user
status
age_eligibility
age_eligibility_in_months
page_orientation
modified_at
*
section_id
section_name
course_id
class_teacher_sign
principal_sign
admin_sign
coordinator_sign
user
status
modified_at
*
cs_id
course_id
start_date
end_date
user
modified_at
*
hgroup_id
head_group
*
header_id
hgroup_id
main_head
sub_head
address
contact_number
govt_approved_details
logo_one
logo_two
logo_three
modified_at
*
lc_id
lang_compit_type
user
modified_at
*
tid
template_name
user
modified_at
*
module_id
module_name
user
modified_at
*
lt_id
location_id
cgroup_id
module_id
section_id
template_id
user
modified_at
*
exam_gid
location_id
location
section_id
pa_group_id
delete_status
added_by
added_at
modified_by
modified_at
*
course_grp_id
location_id
location
section_id
user
modified_at
*
head_gid
location_id
location
header_id
section_id
user
modified_at
*
gd_gid
location_id
location
section_id
gradem_id
user
modified_at
*
pb_gd_gid
location_id
location
section_id
pb_gradem_id
user
modified_at
*
fee_gid
location_id
location
section_id
feegp_id
user
modified_at
*
rmid
location_id
cgroup_id
menu_id
user
modified_at
*
l_sclid
location_id
location
sl_id
course_id
user
modified_at
*
shift_id
shift_name
delete_status
added_by
added_at
modified_by
modified_at
*
cron_id
last_update_date
*
sd_id
days
start_time
end_time
excuse
weekend
shift_id
delete_status
added_by
added_at
modified_by
modified_at
*
hd_id
value
shift_id
delete_status
added_by
added_at
modified_by
modified_at
*
sg_id
salary_group_name
delete_status
added_by
added_at
modified_by
modified_at
*
sge_id
earnings
type
sg_id
delete_status
added_by
added_at
modified_by
modified_at
*
sgev_id
value
effective_date
sge_id
delete_status
added_by
added_at
modified_by
modified_at
*
sgd_id
deductions
type
sg_id
delete_status
added_by
added_at
modified_by
modified_at
*
sgdv_id
value
effective_date
sgd_id
delete_status
added_by
added_at
modified_by
modified_at
*
sgt_id
tax
value_from
value_to
sg_id
delete_status
added_by
added_at
modified_by
modified_at
*
sgtv_id
value
effective_date
sgd_id
delete_status
added_by
added_at
modified_by
modified_at
*
sa_id
emp_id
amount
payment_mode
effective_date
delete_status
added_by
added_at
modified_by
modified_at
*
bs_id
emp_id
salary_increment
effective_date
delete_status
added_by
added_at
modified_by
modified_at
*
ph_id
public_holiday
holiday_date
delete_status
added_by
added_at
modified_by
modified_at
*
lt_id
leave_type
short_name
valid_from
carry_forward
max_leave
monthly_limit
description
active_status
delete_status
added_by
added_at
modified_by
modified_at
*
as_id
empid
shift_id
shift_effective_start_date
shift_effective_end_date
delete_status
added_by
added_at
modified_by
modified_at
*
eld_id
empid
attend_date
login
logout
lt_id
short_name
value
pr_location_id
delete_status
approve_status
added_by
added_at
modified_by
modified_at
*
pd_id
start_date
end_date
delete_status
approve_status
added_by
added_at
modified_by
modified_at
*
w_id
weekend_date
pd_id
shift_id
delete_status
added_by
added_at
modified_by
modified_at
*
rf_id
format_type
format_name
delete_status
added_by
added_at
modified_by
modified_at
*
occupation_id
occupation_name
*
settings_id
description
settings_type
format
additional_info
current_value
*
DeviceLogId
DeviceId
Card_No
AttnDate
AttnTime
FunctionCode
DownloadDate
Status
processed
*
DeviceLogId
DeviceId
Card_No
AttnDate
AttnTime
FunctionCode
DownloadDate
Status
*
Card_No
AttnDate
Login
FunctionCode
DeviceID
short_name
value
*
Card_No
AttnDate
Logout
FunctionCode
DeviceID
short_name
value
*
pa_group_id
group_name
delete_status
added_by
added_at
modified_by
modified_at
*
terms_id
terms
pa_group_id
added_by
delete_status
added_at
modified_by
modified_at
*
pa_macty_id
mainactivity
format
category
terms_id
ecat_id
exam_end_date
publish_status
delete_status
added_by
added_at
modified_by
modified_at
*
pa_msubject_id
main_subject
pa_macty_id
delete_status
added_by
added_at
modified_by
modified_at
*
pa_coresubject_id
core_subject
pa_msubject_id
delete_status
added_by
added_at
modified_by
modified_at
*
pa_sacty_id
subactivity
max_mark
convert_percent
pa_coresubject_id
omr_exam_id
entry_type
delete_status
added_by
added_at
modified_by
modified_at
*
pb_type_id
pbexam_type
pa_macty_id
delete_status
added_by
added_at
modified_by
modified_at
*
pbcd_sub_id
pbcd_subjects
pb_type_id
delete_status
added_by
added_at
modified_by
modified_at
*
pb_acty_id
pbcd_sub_id
pbactivity
max_mark
convertion
entry_type
delete_status
added_by
added_at
modified_by
modified_at
*
gradem_id
grade_method
modified_at
*
pb_gradem_id
pb_grade_method
modified_at
*
gradem_id
grade_method
*
grade_id
percent_from
percent_to
grade
details
remarks
gradem_id
grade_cal_id
modified_at
*
pb_grade_id
pb_percent_from
pb_percent_to
pb_grade
pb_details
pb_gradem_id
pb_grade_cal_id
modified_at
*
grade_id
percent_from
percent_to
grade
details
remarks
gradem_id
grade_cal_id
*
cem_id
compit_exam
ecat_id
*
sub_id
subject
delete_status
added_by
added_at
modified_by
modified_at
*
tt_exam_id
tt_exam_name
section_id
instruction
verify_status
publish_by
yr_id
delete_status
added_by
added_at
modified_by
modified_at
*
tt_exam_did
tt_exam_id
tt_exam_sub_id
tt_exam_date
tt_exam_time
section_id
verify_status
publish_by
delete_status
added_by
added_at
modified_by
modified_at
*
exam_sub_id
exam_subject
delete_status
added_by
added_at
modified_by
modified_at
*
tt_notes_id
tt_notes
section_id
yr_id
delete_status
added_by
added_at
modified_by
modified_at
*
a_id
ref_number
sid
issued_date
issued_by
added_by
added_at
delete_status
modified_by
modified_at
*
sid
chatid
roll_number
admission_number
sts_number
first_name
last_name
date_of_birth
blood_group_id
gender
nationality_id
religion_id
caste_id
sub_caste_id
caste_category_id
father_guardian_name
father_guardian_qualification
father_guardian_occupation
mother_name
mother_qualification
mother_occupation
whatsapp_number
whatsapp_number_new
contact_one
contact_two
email_address
address_one
address_two
city
zipcode
country_code
student_image
std_profile_image
facility
previous_institution
mode_of_transport
user_id
password
account_number
bank_name
ifsc_code
mob_app_permit
eclass_id
menu_type_id
active_status
sibling_id
sibling_id_1
pr_location_id
pr_location_name
pr_yr_id
pr_ac_year
pr_inst_type_id
pr_institution_type
pr_cgroup_id
pr_cgroup_name
pr_course_id
pr_course_name
pr_section_id
pr_section_name
mobile_permission
added_by
device_type
device_token
added_at
modified_by
modified_at
lang_compit_type
omrexamtype
*
c_id
ref_number
sid
issued_date
issued_by
added_by
added_at
delete_status
modified_by
modified_at
*
tc_id
tc_number
sid
sc_st
higher_standard_status
promotion_std
current_std
languages_studied
medium_of_instruction
elective_paper
physically_challenged
last_attendance_date
tc_application_date
date_of_admission
transfer_certificate_issue_date
number_of_working_days
number_of_attendend_days
fee_paid_status
fee_concessions
scholarship_status
conduct
place_of_birth
student_status
tc_amount
taulk
district
state
tc_type
invoice_details
added_by
added_at
delete_status
modified_by
modified_at
*
id
sid
old_new_id
feecat_id
section_id
location_id
yr_id
active_status
added_by
added_at
modified_by
modified_at
*
id
sid
field1
field2
modified_at
*
id
sid
date
attend_type_id
delete_status
user
modified_at
*
id
sid
attend_date
attend_type_id
attend_sesn_id
yr_id
section_id
message_send
delete_status
added_by
sync_status
added_at
modified_at
*
auto_absent_all
send_message
message_type
session_wise_message
send_message_onsubmit
*
leave_id
sid
from_date
to_date
attend_type_id
reason
aprvd_status
aprvd_by
delete_status
yr_id
user
modified_at
added_at
*
vfy_id
verify_date
verify_by
verify_status
section_id
attend_sesn_id
yr_id
delete_status
is_holiday
user
created_at
modified_at
*
vfy_id
verify_date
verify_by
verify_status
department_id
yr_id
delete_status
user
modified_at
*
vfy_id
verify_date
verify_by
verify_status
section_id
yr_id
delete_status
user
modified_at
*
app_id
reg_number
issue_date
first_name
last_name
gender
guardian_first_name
guardian_last_name
occupation
address
city
pincode
mobile
whatsapp
other_contact
email
fee_amount
category
dependent_details
pre_inst_name
pre_inst_address
acadamic_year_id
course_id
course_batch_id
app_fee_id
mode_of_transport
transport_route
note
application_status
fee_status
fee_paid_date
added_by
added_at
modified_by
modified_at
*
app_id
fname
gender
dob
birth_place
bvillage_town
btaluk
bdistrict
m_tongue
father_name
mother_name
issue_date
guardian_last_name
whatsapp_number
contact_one
contact_two
religion
caste
category
caste_belogs
b_group
syllabus
admission_class
opt_stay
std_adhaar
std_sats
std_bhagyalakshmi
allergy
illness
address
address_city
address_pin
email
pre_inst_name
pre_inst_address
pre_inst_city
pre_inst_pin
application_status
transactionid
fee_status
fee_paid_date
added_by
added_at
modified_by
modified_at
*
pay_id
link_id
payment_id
status
currency
amount
mac
fee_paid_date
*
appfee_id
fee_amount
group_id
batch_id
yr_id
delete_status
total_number_seats
added_by
added_at
modified_by
modified_at
*
mevent_id
event_name
start_date
start_time
end_date
end_time
description
attachment
remaind_date
location_id
yr_id
cgroup_id
user
delete_status
modified_at
*
sevent_id
sub_event_name
sub_start_date
sub_start_time
sub_end_time
sub_event_details
mevent_id
user
delete_status
modified_at
*
hw_id
homework_type
attachment
homework_content
date_of_home_work
location_id
subject_id
course_id
course_name
section_id
section_name
chapter_id
publish_status
publish_by
publish_teacher
verified_by
verify_status
veryfied_date
yr_id
added_by
added_at
modified_by
modified_at
delete_status
*
chapter_id
chapter_name
subject_id
subject
batch_id
batch_name
group_id
group
delete_status
added_by
added_at
modified_by
modified_at
*
hwdone_id
attachment
std_id
hw_id
uploaded_at
correction_by
correction_at
modified_by
modified_at
yr_id
delete_status
*
subject_id
subject_name
eclass_sub_id
course_id
status
added_by
added_at
*
album_id
cgroup_id
album_name
album_date
location_id
yr_id
added_by
added_at
delete_status
modified_by
modified_at
*
merge_id
attachment
hw_id
yr_id
merged_by
merged_at
modified_by
modified_at
delete_status
*
gal_id
album_id
photo_path
added_by
delete_status
added_at
status
modified_by
modified_at
*
vgal_id
album_id
video_path
cgroup_id
added_by
delete_status
added_at
status
modified_by
modified_at
*
video_id
video_link
youtube_video_id
album_id
delete_status
added_by
added_at
modified_by
modified_at
*
cir_id
circular_head
attachment_path
posted_date
location_id
cgroup_id
delete_status
added_by
added_at
modified_by
modified_at
*
holiday_id
holiday
holiday_date
h_type_id
section_id
cgroup_id
yr_id
delete_status
added_by
modified_at
*
paid
sid
marks
pa_sacty_id
added_by
added_at
modified_by
modified_at
*
pbid
sid
pb_acty_id
marks
added_by
modified_by
added_at
modified_at
*
abid
sid
pa_sacty_id
absent_status
added_by
modified_by
added_at
modified_at
*
pbabid
sid
pb_acty_id
added_by
added_at
absent_status
delete_status
modified_by
modified_at
*
hid
sid
terms_id
height
weight
v_left
v_right
section_id
added_by
remarks
added_at
delete_status
modified_at
*
remark_id
sid
section_id
pa_acty_id
remarks
working_days
present_days
added_by
added_at
delete_status
modified_by
modified_at
*
history_id
course_id
type
activity_id
marks_update_at
is_consolidate_report_created
consolidated_report_created_at
is_progress_report_created
progress_report_created_at
*
achivement_id
sid
portfolio_id
level_id
position_id
comments
achieve_date
yr_id
added_by
added_at
remark_status
delete_status
modified_by
modified_at
*
level_id
level_type
added_by
added_at
delete_status
modified_by
modified_at
*
position_id
position
added_by
added_at
delete_status
modified_by
modified_at
*
portfolio_id
portfolio
added_by
added_at
delete_status
modified_by
modified_at
*
category_id
category
added_by
added_at
delete_status
modified_by
modified_at
*
remark_id
sid
category
remarks
added_by
added_at
remark_status
yr_id
delete_status
modified_by
modified_at
*
attendance_id
sid
section_id
pa_macty_id
working_days
present_days
added_by
added_at
delete_status
modified_by
modified_at
*
sub_id
sub_name
delete_status
added_by
added_at
modified_by
modified_at
*
exam_group_id
group_name
delete_status
added_by
added_at
modified_by
modified_at
*
exam_type_id
exam_type
delete_status
added_by
added_at
modified_by
modified_at
*
sub_id
sub_name
delete_status
added_by
added_at
modeified_by
modified_at
*
DeviceId
DeviceName
IPAddress
CommPassword
SerialNumber
Location
PingDelay
TransactionTimestamp
UserTimestamp
DeleteTimestamp
LastPingTimestamp
TimeZoneDiffMins
*
feegp_id
fee_group
is_transport_fee
receipt_header
account_number
ifsc
modified_at
*
feecatid
fee_category
status
modified_at
*
mfee_id
main_fee
feegp_id
delete_status
*
pac_id
account_name
account_number
ifsc_code
bank_name
delete_status
*
psplit_id
account_numberid
paid_date
amount
added_by
added_at
modified_by
modified_at
*
sfee_id
sub_fee
mfee_id
delete_status
*
feecat_id
fee_category
sfee_id
status
modified_at
*
mfeetypeid
mfee_type
no_of_months
months_start
feegp_id
status
modified_at
*
monthid
months
modified_at
*
mfeealotid
old_new
gender_id
feecatid
section_id
amount
modified_at
*
hfeetypeid
hfee_type
delete_status
add_by
add_at
modified_by
modified_at
*
min_id
number_of_days
delete_status
*
hfeealotid
old_new
gender_id
feecatid
section_id
amount
modified_at
*
assign_id
student_id
hostel_type_id
room_id
added_by
added_at
modified_by
delete_status
modified_at
*
hostel_id
hostel_type
room_number
warden_name
supervision
warden_contact
supervision_contact
added_by
added_at
modified_by
delete_status
modified_at
*
hallot_id
sid
section_id
modified_at
*
indfeetypeid
indfee_type
fee_start_date
fee_due_Date
add_by
add_at
delete_status
modified_by
modified_at
*
fee_id
group_id
class_id
individual_fee_id
fee_category_id
old_boy_amount
old_girl_amount
new_boy_amount
new_girl_amount
assign_to_all
delete_status
added_by
added_at
modified_by
modified_at
*
fee_id
group_id
class_id
hostel_fee_id
fee_category_id
old_boy_amount
old_girl_amount
new_boy_amount
new_girl_amount
delete_status
added_by
added_at
modified_by
modified_at
*
fee_id
group_id
course_id
fee_monthly_type_id
feecatid
old_boy_amount
old_girl_amount
new_boy_amount
new_girl_amount
num_of_month
month_starts
delete_status
added_by
added_at
modified_by
modified_at
*
afee_id
sfee_id
course_id
feecat_id
old_new
boy_girl
amount
delete_status
added_by
added_at
modified_by
modified_at
*
indfeealotid
sid
indfeeid
section_id
modified_at
*
tgroup_id
group_name
location_id
delete_status
*
min_id
number_of_days
delete_status
*
month_id
month_name
delete_status
*
tarea_id
area_name
group_id
delete_status
user
*
areaamt_id
one_two_way
month_year_amt
tarea_id
delete_status
added_by
added_at
modified_by
modified_at
*
assn_id
sid
tarea_id
up_and_down
start_date
inactive_date
changed_area_count
added_by
added_at
modified_by
modified_at
*
feetrn_id
receipt_no
transcation_no
sid
fee_id
is_hostal_or_transport
fee_desc_type
fee_amount
received_date
year
user
added_at
modified_at
*
c_id
fee_id
is_hostal_or_transport
concession_amount
added_at
year
added_by
modified_by
modified_at
*
blood_group_id
blood_group
*
gender_id
gender
atype
delete_status
*
caste_id
caste
*
sub_caste_id
caste_id
subcaste
*
caste_category_id
caste_category
*
old_new_id
old_new
*
nationality_id
nationality
*
religion_id
religion
*
attend_sesn_id
session_type
att_short_name
week_day
attend_value
batch_id
order_no
delete_status
*
attend_type_id
attend_type
attend_value
*
data_fetch_id
data_fetch_type
*
appt_id
app_type
*
menu_id
link_name
display_name
*
amenu_id
menu_id
appt_id
*
empcatid
emp_category
short_name
active_status
modified_at
*
pstnid
position
empcatid
active_status
modified_at
*
deptid
emp_department
active_status
added_by
added_at
modified_by
modified_at
*
empid
chatid
role
first_name
last_name
date_of_birth
designation
department
date_of_joining
confirmation_date
employement_status
teaching_experience
other_experience
notice_period
unique_id
biometric_id
languages_known
languages_type
blood_group_id
religion_id
caste_id
gender_id
sub_caste_id
caste_category_id
father_guardian_name
father_guardian_qualification
father_guardian_occupation
mother_name
mother_qualification
mother_occupation
account_number
bank_name
ifsc_code
facility
com_address_one
com_address_two
com_city
com_zipcode
country_code
marital_status
qualification
whatsapp_number
contact_one
contact_two
email_address
address_one
address_two
city
zipcode
submenu_permition
mob_app_permit
menu_type_id
pr_location_id
pr_inst_type_id
pr_institution_type
pr_yr_id
active_status
added_by
modified_by
modified_at
employee_image
authorization
*
docid
empid
document_type
document_path
added_by
added_at
delete_status
modified_by
modified_at
*
langid
empid
languages
reading
writing
speaking
added_by
added_at
modified_by
modified_at
*
epermit_id
empid
cgroup_id
course_id
section_id
subject
cgroup_name
course_name
section_name
ac_year
yr_id
eclass_id
delete_status
added_by
added_at
modified_by
modified_at
*
empoffid
emp_id
location_id
empcatid
pstnid
category_id
deptid
salcat_id
user_name
password
sign
role
status
special_permission
host_user
host_password
zoom_cred_id
created_by
created_at
modified_by
modified_at
*
atnd_id
empid
attend_date
attend_type_id
attend_sesn_id
yr_id
delete_status
added_by
added_at
modified_by
modified_at
*
attend_sesn_id
session_type
week_day
attend_value
department_id
delete_status
*
evfy_id
verify_date
verify_by
verify_status
department_id
yr_id
delete_status
user
modified_at
*
tleave_id
empid
from_date
to_date
attend_type_id
reason
aprvd_status
aprvd_by
delete_status
yr_id
user
modified_at
added_at
*
eleave_id
empid
from_date
to_date
attend_type_id
reason
aprvd_status
aprvd_by
delete_status
yr_id
user
modified_at
added_at
*
lopid
lop_type
working_days
salcat_id
active_status
modified_at
*
leavetypeid
leave_type
short_name
valid_from
carry_forward
max_leave
active_status
modified_at
*
psetid
payroll_settings
active_status
modified_at
*
salcat_id
salcategory_name
*
components_id
components_name
short_name
type
value_type
calc_a
calc_b
calc_c
calc_d
calc_e
calc_f
salcat_id
*
salary_id
emp_id
type
amount
effective_date
*
smscat_id
smscategory_name
status
add_by
add_at
modify_by
modified_at
*
message_id
smscat_id
message_template
message_format
variable_details
status
template_id
dlt_id
msg_category
active_status
add_by
added_at
modify_by
modified_at
*
s_id
sender_id
status
add_by
add_at
modify_by
modified_at
*
g_id
api_key
status
add_by
add_at
modify_by
modified_at
*
smenu_id
sms_menu
active_status
add_by
add_at
modify_by
modified_at
*
smsid
sms_gateway
message_id
campaign
section_id
department_id
schedule
mode_of_transport
schedule_date
schedule_status
message
yr_id
sent_by
sent_date
modify_by
modified_at
*
smsid
sms_gateway
message_id
campaign
section_id
department_id
student_id
mobile_number
schedule
mode_of_transport
schedule_date
schedule_status
message
yr_id
sent_by
sent_date
modify_by
modified_at
*
msg_del_id
campaign_id
mobile
del_status
message_type
delivary_status
modified_at
*
id
barcode
roll_no
exam_id
qtn_id
bubble1
bubble2
bubble3
bubble4
image_path
*
id
barcode
regist_no
exam_id
qtn_id
field1
field2
field3
field4
field5
field6
field7
field8
field9
field10
field11
field12
field13
field14
field15
field16
field17
field18
field19
field20
field21
field22
field23
field24
field25
field26
field27
field28
field29
field30
field31
field32
field33
field34
field35
field36
field37
field38
field39
field40
field41
field42
field43
field44
field45
field46
field47
field48
field49
field50
exam_subject
image_path
*
id
barcode
d0
d1
d2
d3
d4
d5
d6
d7
d8
d9
m0
m1
m2
m3
m4
m5
m6
m7
m8
m9
y0
y1
y2
y3
y4
y5
y6
y7
y8
y9
sid
p1
p2
p3
p4
p5
p6
p7
p8
p9
*
id
barcode
date
subject_id
section_id
img_link
*
menu_id
menu_name
order_by
*
mid
type
mandatory_fields
added_by
added_at
modified_by
modified_at
*
menu_id
app_type
menu_type
menu
permission
modified_at
*
id
app_type
menu_title
menu_id
permission
user_id
modified_at
*
message_id
message_format
variable_details
status
template_id
dlt_id
sender_id
instance_id
access_token
msg_category
active_status
add_by
added_at
modify_by
modified_at
*
id
response
added_at
*
id
otpmobile
otp
send_date_time
status
verified_at
*
pmenu_id
pmennu_link
parent_menu_name
smenu_id
height
status
*
id
oem_id
empID
file_name
creatingDate
*
login_id
username
password
*
user_id
username
password
group_id
first_name
last_name
active_status
*
id
first_name
second_name
first_number
second_number
*
classid
Class
ClassName
Section
Boys_Regular_limit
Girls_Regular_limit
Boys_Hostel_limit
Girls_Hostel_limit
Boys_Transport_limit
Girls_Transport_limit
ClassNamefordoc
Promotedclassname
Promotedwordclassname
SyllabusType
AcademicYear
SerialNo
ClassName1
Status
modified_at
*
fmid
Fee
DisplayName
Active
AcademicYear
SyllabusType
monthly_fee
groupby
groupname
receipt_head
account_number
account_name
ifsc_code
set_readonly
is_mandatory
receipt_format
modified_at
order_by
*
htreceipt_id
Fee
receipt_format
account_number
ifsc
description
account_name
*
ftrid
AcademicYear
SID
Fee1
Fee2
Fee3
Fee4
Fee5
Fee6
Fee7
Fee8
Fee9
Fee10
Fee11
Fee12
Fee13
Fee14
Fee15
Fee16
Fee17
Fee18
Fee19
Fee20
Fee21
Fee22
Fee23
Fee24
Fee25
Fee26
Fee27
Fee28
Fee29
Fee30
Transport
Hostel
Hostel_Deposit
Fine_Fee
DOP
User
ModifiedUser
rnd
hostel_rno
df_rno
sfrno
cfrno
Ed
SyllabusType
Class
PaymentType
Bank
PayStatus
CheckClearanceDate
ChequeNo
CCReferenceNo
Reason
bounce_amount
wrongaccountdeposite
modified_at
*
S_NO
AcademicYear
SyllabusType
SyllabusDisplayName
SyllabusDisplayName1
Class
ClassName
TrustName
InstitutionName
ShortName
Address
City
Zipcode
ContactNo
Email
Logo_1
Logo_2
Logo_3
Descriptions
DiceCode
Signature
TeacherSignature
PresidentSignature
SecretorySignature
Active
Managing
PB1
PB2
PB3
PB4
PB5
PB6
PB7
PB8
PB9
PB10
PB11
PB12
PB13
PB14
PB15
PB16
PB17
PB18
PB19
PB20
AutoAttendance
AcademicYearDisplay
InstitutionShortName
TC_DiceCode
TC_Descriptions
TC_SchoolCode
school_college_code
school_latitude
school_longitude
stock_receipt_heading
stock_address
stock_receipt_logo
GSTNo
Website
TransportNote
HostelNote
RegularNote
TransportInstallments
accountnumber
schoofee_head
schoofee_address
developmentfee_head
developmentfee_address
governmentfee_head
governmentfee_address
otherfee_head
otherfee_address
hostelfee_head
hostelfee_address
transportfee_head
transportfee_address
ifsc
account_name
modified_at
*
SYID
Syllabus
DisplayName
Status
modified_at
*
id
mobilenumber
randomString
template_id
update_at
status
*
id
SmsDate
Message
Mobile
AcademicYear
SentType
SMSHZID
Status
sms_gateway
Message_Resend
SID_Emp_ID
Name
Class
Section
send_by
modified_at
*
smenu_id
smenu_link
submenu_name
menu_id
status
*
n
*
prmsn_id
role_id
menu_id
access
modified_by
modified_at
*
role_id
role_name
super_admin
dashboard
delete_status
*
prmsn_id
role_id
smenu_id
read
add
edit
delete
print
added_by
added_at
modified_by
modified_at
*
wpid
Date
Message
Mobile
AcademicYear
SentType
SubType
attachment
WPSID
Status
output
werror
gateway
SID_Emp_ID
Name
Class
Section
msg_send
send_by
modified_at
*
ecat_id
ecategory
delete_status
added_by
added_at
modified_by
modified_at
*
eclass_id
eclass
cgroup_id
delete_status
added_by
added_at
modified_by
modified_at
*
subject_id
subject
eclass_id
eclass
cgroup
ecat_id
class_resoure
test_resource
delete_status
added_by
added_at
modified_by
modified_at
*
chapter_id
chapter_name
subject_id
subject
eclass
eclass_id
group_name
delete_status
added_by
added_at
modified_by
modified_at
*
c_video_id
video_name
video_link
chapter_id
delete_status
added_by
added_at
modified_by
modified_at
*
c_video_id
video_name
video_link
youtube_video_id
chapter_id
delete_status
added_by
added_at
modified_by
modified_at
*
c_notes_id
notes_head
notes_link
chapter_id
delete_status
added_by
added_at
modified_by
modified_at
*
c_textbook_id
textbook_head
textbook_link
chapter_id
delete_status
added_by
added_at
modified_by
modified_at
*
qtn_id
question
chapter_id
priority
medium
delete_status
yr_id
modified_by
modified_at
*
ans_id
choice
qtn_id
correct_answer
*
tokenid
cred_id
access_token
refresh_token
modifiedat
*
cred_id
user_group_id
host_user
host_password
client_id
client_secret
active_status
modifiedat
*
cred_id
user_group_id
host_user
host_password
client_id
client_secret
active_status
modifiedat
*
flash_id
wishing_head
wishing_date
file_path
cgroup_id
yr_id
delete_status
added_by
modified_by
modified_at
addedat
*
abt_id
attachment_link
location_id
delete_status
added_by
added_at
modified_at
*
feedbk_id
ratings
comment
sid
feedcat_id
modified_at
*
ct_id
week_day
periods
timings
subject
asigd_teacher
section_id
yr_id
added_by
added_at
*
period_id
period_name
delete_status
added_by
added_at
*
ct_id
update_date
week_day
periods
timings
subject
asigd_teacher
section_id
yr_id
added_by
added_at
*
emenu_id
emenu
emenu_link_id
permission
app_type
tab_type
order_by
user
modified_at
*
eid
empid
date_of_birth
blood_group_id
father_guardian_name
father_guardian_qualification
father_guardian_occupation
mother_name
mother_qualification
com_address_one
com_address_two
com_city
com_zipcode
country_code
marital_status
whatsapp_number
contact_one
contact_two
modified_at
email_address
address_one
address_two
city
zipcode
pr_inst_type_id
modified_by
employee_image
*
smenu_id
sub_menu
submenu_link_id
order_by
permission
user
modified_at
*
ecat_id
exam_category
*
r_id
mainactivity
exam_date
sid
pa_macty_id
ecat_id
section_id
yr_id
pdf_link
percentage
view_permit
publish_by
remark
posted_date
added_by
added_at
modified_by
modified_at
delete_status
*
agreegator_id
agreegator
active_status
added_at
added_by
*
ocfee_id
cal_type
conveyance_fee
description
school_account_no
ifsc_code
upi_address
payee_name
vpa_address
school_code
added_by
added_at
modified_by
modified_at
*
did
ref_id
std_id
link
short_link
link_creation_date_time
link_access_date_time
added_at
is_expired
moved_at
added_by
link_status
yr_id
moved_by
*
ofee_tid
unique_id
reference_id
transactionId
school_code
amount
dop
tran_status
agreegator
fund_trans_status
fund_trans_date_time
fund_trans_by
fee_desc
update_status
yr_id
added_at
added_by
*
id
session_id
biller_id
student_id
payingamount
processed_at
yr_id
added_at
added_by
*
transactionId
merchantTxnId
transactionDate
merchantId
merchantName
commissionPercentage
commissionFlat
postingAmount
mdr
gstOnMdr
netSettlementAmount
refundAmount
refundType
bankRefNo
isGenerated
utrNo
settlementDate
emailId
udf1
udf2
udf3
udf4
udf5
instrumentId
spName
productId
*
tid
session_id
transaction_id
platformBillID
student_id
paidamount
payment_mode
card_name
conveyance_fee
conveyance_fee_type
payer_vpa
sender_ifsc
sender_account_number
status
moved_status
transaction_at
payment_type
upi_ref
remarks
schoolCode
yr_id
added_at
moved_at
added_by
moved_by
*
flash_id
flash_head
flash_description
image_link
app_type
*
help_id
video_link
video_id
heading
description
app_type
active_status
add_by
add_at
modify_by
modified_at
*
hmenu_id
hmenu_type_id
hmenu_type
hmenu_link_id
hmenu_name
hmenu_icon
permission
app_type
order_by
modified_at
*
lc_gid
group_name
active_status
delete_status
added_by
added_at
modified_by
modified_at
*
lc_pid
sid
empid
participant_name
contact_no
lc_gid
section_id
delete_status
active_status
added_by
added_at
modified_by
modified_at
*
host_id
host_name
contact_no
host_image
delete_status
added_by
added_at
modified_by
modified_at
*
schdle_id
subject
schdle_date
connect_id
password
meeting_id
start_time
duration
lc_gid
host_id
host_user_login
host_user_password
is_an_host
added_by
added_at
delete_status
modified_by
modified_at
*
log_id
std_id
date
logout_status
yr_id
*
s_id
max_date
*
menu_id
menu_type_id
menu_type
menu_link_id
menu_name
menu_icon
permission
app_type
order_by
modified_at
*
notify_id
notification_head
notification_details
batch_id
section_id
delete_status
added_by
added_at
modified_by
modified_at
*
notify_id
notification_head
notification_details
batch_id
section_id
student_id
mobile_number
delete_status
added_by
added_at
modified_by
modified_at
*
apdf_id
pdf_link
anwser_pdf_link
omr_pdf_link
oem_id
yr_id
delete_status
added_by
added_at
modified_by
modify_at
*
aqtn_id
qtn_id
chosen_ans
oem_id
yr_id
delete_status
added_by
added_at
modified_by
modified_at
*
oem_catid
category_type
delete_status
added_by
added_at
modified_by
modified_at
*
oem_id
online_exam
template
subject
e_class_sub_id
exam_date
start_time
end_time
duration
no_of_questions
exam_category_id
max_marks
exam_type_id
exam_type
instructions
passage
group_id
course_id
section_id
yr_id
assign_status
assigned_by
publish_status
publish_by
delete_status
added_by
added_at
modified_by
modified_at
*
oem_id
online_exam
template
subject
e_class_sub_id
exam_date
start_time
end_time
duration
no_of_questions
exam_category_id
max_marks
exam_type_id
exam_type
instructions
passage
group_id
course_id
section_id
yr_id
assign_status
assigned_by
publish_status
publish_by
delete_status
pdf_path
added_by
added_at
modified_by
modified_at
*
oem_id
online_exam
omr_test
template
exam_date
exam_type
instructions
yr_id
delete_status
pdf_url
key_answer_update
key_answer_update_datetime
std_answer_update
added_by
added_at
modified_by
modified_at
*
sub_id
subject
no_of_question
oem_id
subject_order_by
grace_mark_questions
delete_status
added_by
added_at
modified_by
modified_at
*
sub_id
subject
active_status
*
anspdf_id
ans_pdf_link
oem_id
std_id
uploaded_at
started_time
ended_time
correction_by
no_of_qtns_or_maxm
correct_ans
skipped
obtained_marks
correction_at
publish_status
publish_by
sms_status
sms_send_date_time
modified_by
modified_at
yr_id
delete_status
*
anspdf_id
ans_pdf_link
oem_id
std_id
uploaded_at
started_time
ended_time
correction_by
no_of_qtns_or_maxm
correct_ans
skipped
obtained_marks
correction_at
publish_status
publish_by
sms_status
sms_send_date_time
report_url
modified_by
modified_at
yr_id
delete_status
*
omrtmp_id
anspdf_id
ans_pdf_link
oem_id
template
subjects
correction_by
no_of_qtns_or_maxm
correct_ans
skipped
obtained_marks
except_right
modified_by
modified_at
yr_id
delete_status
*
sans_id
std_id
qtn_id
ans_id
oem_id
*
frid
sid
remarks
dueamount
status
created_at
modified_at
*
fixedfee_id
std_id
sfee_id
sub_fee
fee_category
is_mandatory
development_fee_mandatory
is_edit
discount_applicable
due_date
fixed_fee
due_amount
paid
concession
total_paid
yr_id
order_by
delete_status
added_by
added_at
modified_by
modify_at
*
fixedfee_id
std_id
sfee_id
sub_fee
is_mandatory
fixed_fee
due_amount
paid
concession
total_paid
yr_id
order_by
delete_status
added_by
added_at
modified_by
modify_at
*
did
year
fee_category
fee_type
discount_applicable
*
ofid
yr_id
pac_id
sfee_id
is_mandatory
is_edit
fee_name
amount
display
display_parent_app
*
fixedfee_id
std_id
sfee_id
sub_fee
is_mandatory
fixed_fee
due_amount
paid
concession
total_paid
yr_id
order_by
delete_status
added_by
added_at
modified_by
modify_at
*
recent_id
oem_id
template_id
answer_sheet
*
recent_id
oem_id
template_id
answer_sheet
grace_marks
answer_key_issue
number_of_student_answer_processed
*
pamount_id
std_id
paying_amount
delete_status
added_by
added_at
modified_by
modify_at
*
fee_id
order_id
transaction_id
sub_fee
batch_name
amount
discount
added_by
added_at
*
qr_id
std_id
unique_id
due_amount
qr_url
yr_id
order_by
delete_status
added_by
added_at
modified_by
modify_at
*
aqtn_id
qtn_id
mq_type_id
oem_id
chapter_id
yr_id
delete_status
added_by
added_at
modified_by
modified_at
*
oem_id
online_exam
subject
e_class_sub_id
exam_date
start_time
end_time
duration
no_of_questions
instructions
course_id
section_id
yr_id
assign_status
assigned_by
delete_status
added_by
added_at
modified_by
modified_at
*
mq_id
main_question
e_class_sub_id
delete_status
added_by
added_at
modified_by
modified_at
*
qtn_id
question
chapter_id
mq_id
priority
medium
delete_status
modified_by
modified_at
*
report_id
report_link
report_menu
active_status
add_by
add_at
modify_by
modified_at
*
group_id
group_name
read
update
add_by
active_status
*
m_id
sid
father_guardian_name
added_by
added_at
modified_by
modified_at
*
feedcat_id
feedbackcat_name
status
add_by
add_at
modify_by
modified_at
select table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
.
select column
select table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
.
select column
select table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
.
select column
select table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
.
select column