Recent
`phpmyadmin`.`pma__recent`
`performance_schema`.`setup_instruments`
`enterprise_workflow`.`system_settings`
`information_schema`.`TABLE_STATISTICS`
`phpmyadmin`.`pma__usergroups`
`performance_schema`.`setup_objects`
`performance_schema`.`host_cache`
`workflow`.`workflows`
`workflow`.`cache`
`workflow`.`request_attachments`
Favourites
There are no favourite tables.
X
New
alnaqeeb_charity
bagisto
biotimedb
charity
charity
charity_test
delivery_db
delivery_db
delivery_db_new
ecommerce_db
emp_track_db
enjazi_db
enjaz_workflow
enterprise_workflow
goal_tracker
hr_complaint_app
icehrm_db
ims
information_schema
inventory_management
invoice_db
jobapplications
kalkun
mysql
opencart_db
performance_schema
phpmyadmin
sales
sales_inventory_db
sales_management
supermarket_app
test
the_old_database
ticket_app_db
ticket_app_db
ticket_app_db_test
velstore
warehouse
warehouse_inventory
warehouse_management
warehouse_supplychain
workflow
zk_attendance
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: biotimedb
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
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
*
id
create_time
create_user
change_time
change_user
status
bio_tmp
bio_no
bio_index
bio_type
major_ver
minor_ver
bio_format
valid
duress
admin_id
*
id
encrypt_key
encrypt_iv
expire_time
encrypt_time
encrypt_email
encrypt_type
request_time
user_key
applied
applied_time
*
id
content
send_time
read_time
status
user_id
category
event
employee_id
*
id
create_time
create_user
change_time
change_user
status
combination_no
combination_name
group1
group2
group3
group4
group5
remark
update_time
area_id
*
id
create_time
create_user
change_time
change_user
status
group_no
group_name
verify_mode
timezone1
timezone2
timezone3
is_include_holiday
update_time
area_id
*
id
create_time
create_user
change_time
change_user
status
update_time
area_id
holiday_id
timezone_id
*
id
create_time
create_user
change_time
change_user
status
is_group_timezone
timezone1
timezone2
timezone3
is_group_verifycode
verify_mode
update_time
area_id
employee_id
group_id
*
id
create_time
create_user
change_time
change_user
status
door_name
door_lock_delay
door_sensor_delay
door_sensor_type
door_alarm_delay
retry_times
valid_holiday
nc_time_period
no_time_period
speaker_alarm
duress_fun_on
alarm_1_1
alarm_1_n
alarm_password
duress_alarm_delay
anti_passback_mode
anti_door_direction
verify_mode_485
push_time
terminal_id
*
id
create_time
create_user
change_time
change_user
status
timezone_no
timezone_name
sun_start
sun_end
sun_on
mon_start
mon_end
mon_on
tue_start
tue_end
tue_on
wed_start
wed_end
wed_on
thu_start
thu_end
thu_on
fri_start
fri_end
fri_on
sat_start
sat_end
sat_on
remark
update_time
area_id
*
id
paraname
paratype
paravalue
*
id
dept_id
emp_id
start_date
end_date
update_time
log_type
*
id
code
alias
display_format
symbol
round_off
min_val
symbol_only
order
color_setting
*
id
create_time
create_user
change_time
change_user
status
enable_attendance
enable_schedule
enable_overtime
enable_holiday
emp_id
group_id
enable_compensatory
ip_address
*
id
create_time
create_user
change_time
change_user
status
code
name
company_id
*
id
create_time
create_user
change_time
change_user
status
use_ot
weekend1
weekend2
start_of_week
max_hrs
day_change
paring_rule
punch_period
daily_ot
daily_ot_rule
weekly_ot
weekly_ot_rule
weekend_ot
weekend_ot_rule
holiday_ot
holiday_ot_rule
late_in2absence
early_out2absence
miss_in
late_in_hrs
miss_out
early_out_hrs
require_capture
require_work_code
require_punch_state
email_send_time
global_frequency
global_send_day
max_absent
max_early_out
max_late_in
sending_day
weekend1_color_setting
weekend2_color_setting
ot_pay_code_id
overtime_policy
enable_compensatory
bot_uid
enable_workcode_calculation
enable_workcode_punch_state
*
id
resign_emp
short_date
short_time
filter_by_hire_date
auto_calculate
*
param_name
param_value
*
id
start_date
end_date
employee_id
shift_id
*
id
alias
cycle_unit
shift_cycle
work_weekend
weekend_type
work_day_off
day_off_type
auto_shift
enable_ot_rule
frequency
ot_rule
company_id
*
id
alias
period_start
duration
end_margin
func_key
available_interval_type
available_interval
multiple_punch
calc_type
minimum_duration
early_in
late_in
profit_rule
min_early_in
loss_rule
min_late_in
loss_code_id
profit_code_id
company_id
*
id
last_date
*
id
emp
start_date
end_date
event
*
workflowinstance_ptr_id
att_date
previous_timeinterval
apply_time
apply_reason
attachment
timeinterval_id
*
id
create_time
create_user
change_time
change_user
status
use_ot
weekend1
weekend2
start_of_week
max_hrs
day_change
paring_rule
punch_period
daily_ot
daily_ot_rule
weekly_ot
weekly_ot_rule
weekend_ot
weekend_ot_rule
holiday_ot
holiday_ot_rule
late_in2absence
early_out2absence
miss_in
late_in_hrs
miss_out
early_out_hrs
require_capture
require_work_code
require_punch_state
department_id
dept_frequency
dept_send_day
email_send_time
max_absent
max_early_out
max_late_in
sending_day
weekend1_color_setting
weekend2_color_setting
ot_pay_code_id
overtime_policy
enable_compensatory
bot_uid
enable_workcode_calculation
enable_workcode_punch_state
*
id
create_time
create_user
change_time
change_user
status
start_date
end_date
department_id
shift_id
*
id
alias
rule
department_id
*
id
create_time
create_user
change_time
change_user
status
use_ot
weekend1
weekend2
start_of_week
max_hrs
day_change
paring_rule
punch_period
daily_ot
daily_ot_rule
weekly_ot
weekly_ot_rule
weekend_ot
weekend_ot_rule
holiday_ot
holiday_ot_rule
late_in2absence
early_out2absence
miss_in
late_in_hrs
miss_out
early_out_hrs
require_capture
require_work_code
require_punch_state
group_id
email_send_time
group_frequency
group_send_day
max_absent
max_early_out
max_late_in
sending_day
weekend1_color_setting
weekend2_color_setting
ot_pay_code_id
overtime_policy
enable_compensatory
bot_uid
enable_workcode_calculation
enable_workcode_punch_state
*
id
create_time
create_user
change_time
change_user
status
start_date
end_date
group_id
shift_id
*
id
alias
start_date
duration_day
enable_ot_rule
ot_rule
department_id
att_group_id
color_setting
end_date
*
workflowinstance_ptr_id
start_time
end_time
apply_reason
apply_time
attachment
pay_code_id
leave_day
*
id
create_time
create_user
change_time
change_user
status
code
name
company_id
*
id
create_time
create_user
change_time
change_user
status
leave_type
allow_leave_day
min_leave_day
deduct_holiday_day
leave_entitlement
leave_interval
leave_distribution_time
start_day
set_hire_day
allow_exceed_limit
allow_balance
max_balance
entitlement_detail
leave_group_id
pay_code_id
*
id
create_time
create_user
change_time
change_user
status
leave_type
year
entitlement_days
leave_day
pre_balance
employee_id
pay_code_id
*
workflowinstance_ptr_id
punch_time
punch_state
work_code_id
apply_reason
apply_time
attachment
*
workflowinstance_ptr_id
overtime_type
start_time
end_time
apply_reason
apply_time
attachment
pay_code_id
*
id
create_time
create_user
change_time
change_user
status
mode
hrs_from
hrs_to
master
overnight_pay_code_id
pay_code_id
*
id
create_time
create_user
change_time
change_user
status
code
name
code_type
tag
fixed_code
is_work
fixed_hours
is_paid
is_benefit
round_off
min_val
display_format
symbol
display_order
desc
is_display
is_default
color_setting
*
id
att_date
week
weekday
att_code_alias
att_code_symbol
duration
workday
hours
minutes
is_weekly
att_code_id
emp_id
shift_id
time_card_id
*
uuid
att_date
weekday
check_in
check_out
duration
duty_duration
work_day
clock_in
clock_out
total_time
duty_worked
actual_worked
unscheduled
remaining
total_worked
late
early_leave
short
absent
leave
exception
day_off
break_time_id
emp_id
overtime_id
timetable_id
*
uuid
break_out
break_in
duration
taken
actual_duration
early_in
late_in
late
early_leave
absent
work_time
overtime
weekend_ot
holiday_ot
*
id
att_date
punch_datetime
punch_date
punch_time
week
weekday
work_code
punch_state
adjust_state
emp_id
time_card_id
trans_id
*
uuid
start_time
end_time
duration
days
data_type
description
item_id
skd_id
*
id
att_date
weekday
data_index
clock_in
in_id
clock_out
out_id
total_time
worked_time
data_type
emp_id
timetable_id
*
uuid
normal_wt
normal_ot
weekend_ot
holiday_ot
ot_lv1
ot_lv2
ot_lv3
total_ot
*
id
stamp
att_date
week
weekday
data_type
clock_in
in_date
in_time
clock_out
out_date
out_time
duration
worked_duration
data_index
workday
emp_id
in_trans_id
out_trans_id
pay_code_id
time_card_id
*
id
att_date
week
weekday
pay_code_alias
pay_code_symbol
duration
workday
hours
minutes
is_weekly
emp_id
pay_code_id
shift_id
time_card_id
is_exception
year
*
uuid
att_date
correct_state
emp_id
orig_id
skd_id
*
id
att_date
week
weekday
date_type
time_table_alias
check_in
check_out
work_day
clock_in
clock_out
break_out
break_in
lock_down
emp_id
time_table_id
present
full_attendance
payload
*
id
stamp
att_date
week
weekday
clock_in
clock_out
duration
worked_duration
work_code
pay_code
workday
emp_id
time_card_id
*
param_name
param_value
*
id
report
template_name
template_value
is_share
is_auto_export
builder_id
change_time
change_user
create_time
create_user
fixed_date_period
language
status
employee_id
*
id
in_time
out_time
day_index
shift_id
time_interval_id
*
id
create_time
create_user
change_time
change_user
status
att_date
employee_id
time_interval_id
*
id
att_date
start_time
end_time
rule_flag
work_type
employee_id
time_interval_id
*
id
alias
use_mode
in_time
in_ahead_margin
in_above_margin
out_ahead_margin
out_above_margin
duration
in_required
out_required
allow_late
allow_leave_early
work_day
early_in
min_early_in
late_out
min_late_out
overtime_lv
overtime_lv1
overtime_lv2
overtime_lv3
multiple_punch
available_interval_type
available_interval
work_time_duration
func_key
work_type
day_change
enable_early_in
enable_late_out
enable_overtime
ot_rule
color_setting
enable_max_ot_limit
max_ot_limit
count_early_in_interval
count_late_out_interval
ot_pay_code_id
overtime_policy
company_id
*
id
timeinterval_id
breaktime_id
*
workflowinstance_ptr_id
start_time
end_time
apply_time
apply_reason
attachment
pay_code_id
*
workflowinstance_ptr_id
punch_time
punch_state
work_code
apply_reason
apply_time
verify_type
*
key
created
user_id
*
id
name
*
id
group_id
permission_id
*
id
name
content_type_id
codename
*
id
username
password
update_time
first_name
last_name
emp_pin
email
tele_phone
auth_time_dept
login_id
login_type
login_count
is_staff
is_active
is_superuser
is_public
can_manage_all_dept
del_flag
date_joined
last_login
session_key
login_ip
photo
assign_company
password_reset
*
id
myuser_id
area_id
*
id
myuser_id
department_id
*
id
myuser_id
group_id
*
id
login_name
pin_tabs
disabled_fields
column_order
preferences
pwd_update_time
user_id
employee_fields
*
id
myuser_id
permission_id
*
id
action
targets
targets_repr
action_status
description
ip_address
can_routable
op_time
content_type_id
user_id
*
id
rulename
deptid
operator
optime
*
id
create_time
create_user
change_time
change_user
status
task_code
task_name
params
enable
process_time
*
id
create_time
create_user
change_time
change_user
status
task_code
task_name
params
enable
process_time
*
id
create_time
create_user
change_time
change_user
status
task_code
task_name
params
enable
process_time
company_id
*
id
title
filters
is_share
time_saved
content_type_id
user_id
*
id
create_time
create_user
change_time
change_user
status
db_type
db_name
operator
backup_file
backup_time
backup_status
remark
*
id
create_time
create_user
change_time
change_user
status
category
sub_category
event
receiver
subject
template
enable
*
id
create_time
create_user
change_time
change_user
status
event_id
event
module
sub_module
email_alert
app_alert
sms_alert
whatapp_alert
facebook_alert
lineapp_alert
*
id
line_notify_token
send_photo
push_time
is_valid
remark
message_type
message_head
message_tail
employee_id
*
id
include_sub_department
line_notify_token
message_type
message_head
message_tail
push_time
is_valid
remark
line_notify_dept_id
send_photo
*
id
action
targets
targets_repr
action_status
description
ip_address
can_routable
op_time
bot_uid
content_type_id
emp_id
user_id
*
id
agreement_message_id
report_name
agreement_message
*
id
single_login
security_code
code_length
valid_duration
failed_locked
lock_failed_count
lock_duration
enforce_pwd_change
enforce_pwd_expiration
validity_period
password_level
is_default
app_single_user_login
session_timeout
export_encryption
export_encryption_password
failed_times
backup_encryption
backup_encryption_password
reset_password_frequency
reset_password_validity
fp_login
*
id
purpose
email_to
email_cc
email_bcc
email_subject
email_content
send_time
send_status
*
id
host
port
user_name
user_password
user_key
is_sftp
*
id
para_name
para_type
para_value
*
id
rule_name
dept_id
operator
op_time
*
id
execute_time
operation
execute_status
description
*
id
create_time
create_user
change_time
change_user
status
name
value
*
id
jwt_token
zoom_user_email
zoom_enable
*
id
action_time
object_id
object_repr
action_flag
change_message
content_type_id
user_id
*
id
clocked_time
*
id
minute
hour
day_of_week
day_of_month
month_of_year
timezone
*
id
every
period
*
id
name
task
args
kwargs
queue
exchange
routing_key
expires
enabled
last_run_at
total_run_count
date_changed
description
crontab_id
interval_id
solar_id
one_off
start_time
priority
headers
clocked_id
expire_seconds
*
ident
last_update
*
id
event
latitude
longitude
*
id
app_label
model
*
id
app
name
applied
*
session_key
session_data
expire_date
*
id
create_time
create_user
change_time
change_user
status
temp_alarm
temp_warning
temp_warning_F
temp_unit
mask_alarm
is_default
*
id
create_time
create_user
change_time
change_user
status
area
check_datetime
check_date
check_time
temperature
is_mask
upload_time
source
terminal_sn
emp_id
terminal_id
emp_code
*
id
create_time
create_user
change_time
change_user
status
bio_tmp
bio_no
bio_index
bio_type
major_ver
minor_ver
bio_format
valid
duress
update_time
sn
employee_id
*
id
create_time
create_user
change_time
change_user
status
first_name
last_name
email
enroll_sn
register_photo
register_time
approval_photo
approval_state
approval_time
remark
employee_id
*
id
create_time
create_user
change_time
change_user
status
enable_registration
enable_resigned_filter
enable_auto_add
enable_name_upload
enable_name_download
enable_card_upload
encryption
timezone
global_setup
heartbeat
transfer_mode
transfer_interval
transfer_time
transaction_retention
command_retention
dev_log_retention
upload_log_retention
edit_policy
import_policy
mobile_policy
device_policy
api_policy
sync_mode
sync_time
visitor_policy
*
id
error_code
error_msg
data_origin
cmd
additional
upload_time
terminal_id
*
id
create_time
create_user
change_time
change_user
status
last_send
employee_id
message_id
*
id
create_time
create_user
change_time
change_user
status
last_send
message_id
terminal_id
*
id
message
start_time
duration
msg_type
*
id
create_time
create_user
change_time
change_user
status
sn
alias
ip_address
real_ip
state
terminal_tz
heartbeat
transfer_mode
transfer_interval
transfer_time
product_type
is_attendance
is_registration
purpose
controller_type
authentication
style
upload_flag
fw_ver
push_protocol
push_ver
language
is_tft
terminal_name
platform
oem_vendor
log_stamp
op_log_stamp
capture_stamp
user_count
transaction_count
fp_count
fp_alg_ver
face_count
face_alg_ver
fv_count
fv_alg_ver
palm_count
palm_alg_ver
lock_func
last_activity
upload_time
push_time
is_access
area_id
*
id
content
commit_time
transfer_time
return_time
return_value
package
terminal_id
*
id
content
commit_time
transfer_time
return_time
return_value
package
terminal_id
*
id
terminal_sn
emp_code
privilege
*
id
terminal_tz
admin
action_name
action_time
object
param1
param2
param3
upload_time
terminal_id
*
id
param_type
param_name
param_value
terminal_id
*
id
event
content
upload_count
error_count
upload_time
terminal_id
*
id
create_time
create_user
change_time
change_user
status
code
alias
last_activity
company_id
pay_code_id
*
id
emp_code
punch_time
punch_state
verify_type
work_code
terminal_sn
terminal_alias
area_alias
longitude
latitude
gps_location
mobile
source
purpose
crc
is_attendance
reserved
upload_time
sync_status
sync_time
is_mask
temperature
emp_id
terminal_id
company_code
*
id
action_time
start_time
end_time
terminal_count
server_count
flag
reserved_init
reserved_float
reserved_char
terminal_id
*
workflowinstance_ptr_id
code
alias
content
meeting_date
start_time
end_time
duration
in_required
in_start
in_end
out_required
out_start
out_end
apply_reason
apply_time
calculation_time
sync_time
room_id
auto_recording
enable_virtual
enable_waiting_room
host_video
jbh_anytime
link_data
mute_upon_entry
participant_video
preferences
time_zone
view_date
virutal_uuid
zoom_id
*
id
meetingentity_id
employee_id
*
workflowinstance_ptr_id
punch_time
punch_state
apply_reason
apply_time
meeting_id
*
id
start_time
end_time
duration
meeting_date
clock_in
clock_out
attended_duration
late_in
early_out
absent
emp_id
meeting_id
*
id
create_time
create_user
change_time
change_user
status
code
alias
capacity
location
remark
state
enable_room
*
id
device_id
room_id
*
id
emp_code
punch_datetime
punch_date
punch_time
punch_state
source
upload_time
emp_id
meeting_id
terminal_id
*
id
subject
content
category
sender
system_sender
create_time
admin_id
init_sender_id
receiver_id
*
id
user
client
action
params
describe
request_status
action_time
remote_ip
*
id
username
login_time
last_active
token
device_token
client_id
client_category
active
enable
*
id
sender
system_sender
category
sub_category
content
payload
source
notification_time
read_status
read_time
admin_id
init_sender_id
receiver_id
*
id
create_time
create_user
change_time
change_user
status
distance
start_date
end_date
department_id
*
id
gpsfordepartment_id
gpslocation_id
*
id
create_time
create_user
change_time
change_user
status
distance
start_date
end_date
employee_id
*
id
gpsforemployee_id
gpslocation_id
*
id
create_time
create_user
change_time
change_user
status
alias
location
longitude
latitude
*
id
username_persistent
requested_at
response_ms
path
view
view_method
remote_addr
host
method
query_params
data
response
errors
status_code
user_id
*
id
name
formula
remark
*
id
exemption_name
amount
issued_time
remark
year
employee_id
*
id
create_time
create_user
change_time
change_user
status
loan_amount
loan_time
refund_cycle
per_cycle_refund
loan_clean_time
remark
employee_id
*
id
payment_mode
payment_type
bank_name
bank_account
personnel_id
agent_id
agent_account
employee_id
internal_emp_num
national_num
payroll_num
*
id
name
formula
remark
pay_code_id
*
id
create_time
create_user
change_time
change_user
status
amount
issued_time
remark
employee_id
special_type_id
*
id
create_time
create_user
change_time
change_user
status
amount
issued_time
remark
employee_id
special_type_id
*
id
name
formula
remark
apply_mode
special_type_id
*
id
name
formula
remark
pay_code_id
*
id
name
formula
remark
pay_code_id
*
id
calc_time
basic_salary
effective_date
format_dict
payment_mode
increase
deduction
increase_formula
deduction_formula
increase_formula_name
deduction_formula_name
extra_increase
extra_deduction
total_loan_amount
refund_loan_amount
unrefund_loan_amount
loan_deduction
loan_increase
advance_increase
advance_deduction
reimbursement
total_increase_formula
total_increase_formula_name
total_increase_expression
total_increase
total_deduction_formula
total_deduction_formula_name
total_deduction_expression
total_deduction
total_salary_expression
total_salary
employee_id
calc_end_time
net_pay
social_security_deduction
tax_deduction
total_income_per_year
total_tax_deduction_per_year
*
id
exemption_id
payload_id
*
id
amount
formula
formula_name
pay_code_id
payload_id
*
id
rmb_amount
rmb_time
rmb_file
rmb_remark
employee_id
*
id
advance_amount
advance_time
advance_remark
employee_id
*
id
create_time
create_user
change_time
change_user
status
salary_amount
effective_date
salary_remark
employee_id
*
id
salarystructure_id
deductionformula_id
*
id
salarystructure_id
exceptionformula_id
*
id
salarystructure_id
increasementformula_id
*
id
salarystructure_id
leaveformula_id
*
id
salarystructure_id
overtimeformula_id
*
id
country_code
used
data
*
id
name
remark
created_at
updated_at
*
id
country_code
used
data
*
id
area_code
area_name
is_default
parent_area_id
company_id
device_count
employee_count
*
id
assigned_time
area_id
employee_id
*
id
cert_code
cert_name
company_id
*
id
company_code
company_name
is_default
address
address2
change_time
change_user
city
country
create_time
create_user
email
fax
logo
logo_pos
name_pos
phone
postal_code
state
status
website
*
id
dept_code
dept_name
is_default
parent_dept_id
dept_manager_id
company_id
*
id
create_time
create_user
change_time
change_user
status
emp_code
first_name
last_name
nickname
passport
driver_license_automobile
driver_license_motorcycle
photo
self_password
device_password
dev_privilege
card_no
acc_group
acc_timezone
gender
birthday
address
postcode
office_tel
contact_tel
mobile
national
religion
title
enroll_sn
ssn
update_time
hire_date
verify_mode
city
emp_type
enable_payroll
app_status
app_role
email
last_login
is_active
session_key
login_ip
department_id
position_id
leave_group
emp_code_digit
superior_id
company_id
password_reset
*
id
create_time
create_user
change_time
change_user
status
calendar
employee_id
*
id
expire_on
email_alert
before
certification_id
employee_id
certification_code
file
file_name
*
id
attr_name
attr_type
attr_value
enable
is_unique
*
id
value
employee_id
*
id
column_order
preferences
pwd_update_time
emp_id
disabled_fields
*
id
employee_id
area_id
*
id
employee_id
area_id
*
id
employee_id
workflowrole_id
*
id
employment_type
start_date
end_date
active_time
inactive_time
employee_id
*
id
position_code
position_name
is_default
parent_position_id
company_id
*
id
resign_date
resign_type
disableatt
reason
employee_id
*
id
requested_at
response_ms
path
remote_addr
host
method
query_params
data
response
status_code
user_id
view
view_method
errors
username_persistent
*
key
created
user_id
*
id
post_time
flag
update_time
sync_ret
area_code
area_name
*
id
post_time
flag
update_time
sync_ret
dept_code
dept_name
*
id
post_time
flag
update_time
sync_ret
emp_code
first_name
last_name
dept_code
dept_name
job_code
job_name
area_code
area_name
card_no
multi_area
hire_date
gender
birthday
email
active_status
*
id
post_time
flag
update_time
sync_ret
job_code
job_name
*
id
create_time
create_user
change_time
change_user
status
visit_reason
*
workflowinstance_ptr_id
vis_first_name
vis_last_name
cert_no
gender
company
update_time
visit_quantity
visit_date
apply_time
apply_reason
cert_type_id
visit_department_id
visit_reason_id
email
*
id
create_time
create_user
change_time
change_user
status
visitor_code
first_name
last_name
cert_no
photo
password
card_no
gender
company
ssn
update_time
email
mobile
visit_quantity
entry_carrying_goods
start_time
end_time
exit_time
exit_carrying_goods
remark
cert_type_id
visit_department_id
visit_reason_id
visited_id
*
id
create_time
create_user
change_time
change_user
status
bio_tmp
bio_no
bio_index
bio_type
major_ver
minor_ver
bio_format
valid
duress
update_time
sn
visitor_id
*
id
create_time
create_user
change_time
change_user
status
first_name
last_name
email
enroll_sn
register_photo
register_time
approval_photo
approval_state
approval_time
remark
visitor_id
*
id
cert_code
cert_name
*
id
create_time
create_user
change_time
change_user
status
qr_code_policy
code_prefix
code_width
code_start
access_limited
auto_delete_data
data_retention
*
id
create_time
create_user
change_time
change_user
status
visitor_status
visitor_id
*
id
create_time
create_user
change_time
change_user
status
visitor_code
area
punch_time
punch_state
verify_type
temperature
is_mask
upload_time
source
terminal_sn
terminal_alias
terminal_id
visitor_id
*
id
visitor_id
accgroups_id
*
id
visitor_id
area_id
*
id
node_name
order_id
approval_status
approval_time
approval_remark
active
targeted
approver_employee_id
workflow_instance_id
workflow_node_id
*
id
workflow_code
workflow_name
start_date
end_date
description
workflow_type
applicant_position_id
content_type_id
departments_id
is_leave
leave_type_id
company_id
*
id
workflowengine_id
employee_id
*
id
approval_time
approval_status
approval_remark
approver
approver_instance
employee_id
workflow_engine_id
*
id
node_name
order_id
approver_by_overall
notify_by_overall
workflow_engine_id
from_day
to_day
*
id
workflownode_id
workflowrole_id
*
id
workflownode_id
workflowrole_id
*
id
role_code
role_name
description
company_id
parent_role_id
select table
accounts_adminbiodata
accounts_passwordresetkey
accounts_usernotification
acc_acccombination
acc_accgroups
acc_accholiday
acc_accprivilege
acc_accterminal
acc_acctimezone
attparam
att_attcalclog
att_attcode
att_attemployee
att_attgroup
att_attpolicy
att_attreportsetting
att_attrule
att_attschedule
att_attshift
att_breaktime
att_calculatelastdate
att_calculatetask
att_changeschedule
att_departmentpolicy
att_departmentschedule
att_deptattrule
att_grouppolicy
att_groupschedule
att_holiday
att_leave
att_leavegroup
att_leavegroupdetail
att_leaveyearbalance
att_manuallog
att_overtime
att_overtimepolicy
att_paycode
att_payloadattcode
att_payloadbase
att_payloadbreak
att_payloadeffectpunch
att_payloadexception
att_payloadmulpunchset
att_payloadovertime
att_payloadparing
att_payloadpaycode
att_payloadpunch
att_payloadtimecard
att_payloadworkcodeparing
att_reportparam
att_reporttemplate
att_shiftdetail
att_temporaryschedule
att_tempschedule
att_timeinterval
att_timeinterval_break_time
att_training
att_webpunch
authtoken_token
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_auth_area
auth_user_auth_dept
auth_user_groups
auth_user_profile
auth_user_user_permissions
base_adminlog
base_attparamdepts
base_autoattexporttask
base_autoexporttask
base_autoimporttask
base_bookmark
base_dbbackuplog
base_emailtemplate
base_eventalertsetting
base_linenotifyforemployee
base_linenotifysetting
base_messengersentlog
base_reportoutputsetting
base_securitypolicy
base_sendemail
base_sftpsetting
base_sysparam
base_sysparamdept
base_systemlog
base_systemsetting
base_zoomsetting
django_admin_log
django_celery_beat_clockedschedule
django_celery_beat_crontabschedule
django_celery_beat_intervalschedule
django_celery_beat_periodictask
django_celery_beat_periodictasks
django_celery_beat_solarschedule
django_content_type
django_migrations
django_session
ep_epsetup
ep_eptransaction
iclock_biodata
iclock_biophoto
iclock_devicemoduleconfig
iclock_errorcommandlog
iclock_privatemessage
iclock_publicmessage
iclock_shortmessage
iclock_terminal
iclock_terminalcommand
iclock_terminalcommandlog
iclock_terminalemployee
iclock_terminallog
iclock_terminalparameter
iclock_terminaluploadlog
iclock_terminalworkcode
iclock_transaction
iclock_transactionproofcmd
meeting_meetingentity
meeting_meetingentity_attender
meeting_meetingmanuallog
meeting_meetingpayloadbase
meeting_meetingroom
meeting_meetingroomdevice
meeting_meetingtransaction
mobile_announcement
mobile_appactionlog
mobile_applist
mobile_appnotification
mobile_gpsfordepartment
mobile_gpsfordepartment_location
mobile_gpsforemployee
mobile_gpsforemployee_location
mobile_gpslocation
mobile_mobileapirequestlog
payroll_deductionformula
payroll_empexpenseexemption
payroll_emploan
payroll_emppayrollprofile
payroll_exceptionformula
payroll_extradeduction
payroll_extraincrease
payroll_increasementformula
payroll_leaveformula
payroll_overtimeformula
payroll_payrollpayload
payroll_payrollpayloadexpenseexemption
payroll_payrollpayloadpaycode
payroll_reimbursement
payroll_salaryadvance
payroll_salarystructure
payroll_salarystructure_deductionformula
payroll_salarystructure_exceptionformula
payroll_salarystructure_increasementformula
payroll_salarystructure_leaveformula
payroll_salarystructure_overtimeformula
payroll_socialsecuritydeduction
payroll_specialpayment
payroll_taxdeduction
personnel_area
personnel_assignareaemployee
personnel_certification
personnel_company
personnel_department
personnel_employee
personnel_employeecalendar
personnel_employeecertification
personnel_employeecustomattribute
personnel_employeeextrainfo
personnel_employeeprofile
personnel_employee_area
personnel_employee_area_privilege
personnel_employee_flow_role
personnel_employment
personnel_position
personnel_resign
rest_framework_tracking_apirequestlog
staff_stafftoken
sync_area
sync_department
sync_employee
sync_job
visitor_reason
visitor_reservation
visitor_visitor
visitor_visitorbiodata
visitor_visitorbiophoto
visitor_visitorcertification
visitor_visitorconfig
visitor_visitorlog
visitor_visitortransaction
visitor_visitor_acc_groups
visitor_visitor_area
workflow_nodeinstance
workflow_workflowengine
workflow_workflowengine_employee
workflow_workflowinstance
workflow_workflownode
workflow_workflownode_approver
workflow_workflownode_notifier
workflow_workflowrole
.
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
accounts_adminbiodata
accounts_passwordresetkey
accounts_usernotification
acc_acccombination
acc_accgroups
acc_accholiday
acc_accprivilege
acc_accterminal
acc_acctimezone
attparam
att_attcalclog
att_attcode
att_attemployee
att_attgroup
att_attpolicy
att_attreportsetting
att_attrule
att_attschedule
att_attshift
att_breaktime
att_calculatelastdate
att_calculatetask
att_changeschedule
att_departmentpolicy
att_departmentschedule
att_deptattrule
att_grouppolicy
att_groupschedule
att_holiday
att_leave
att_leavegroup
att_leavegroupdetail
att_leaveyearbalance
att_manuallog
att_overtime
att_overtimepolicy
att_paycode
att_payloadattcode
att_payloadbase
att_payloadbreak
att_payloadeffectpunch
att_payloadexception
att_payloadmulpunchset
att_payloadovertime
att_payloadparing
att_payloadpaycode
att_payloadpunch
att_payloadtimecard
att_payloadworkcodeparing
att_reportparam
att_reporttemplate
att_shiftdetail
att_temporaryschedule
att_tempschedule
att_timeinterval
att_timeinterval_break_time
att_training
att_webpunch
authtoken_token
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_auth_area
auth_user_auth_dept
auth_user_groups
auth_user_profile
auth_user_user_permissions
base_adminlog
base_attparamdepts
base_autoattexporttask
base_autoexporttask
base_autoimporttask
base_bookmark
base_dbbackuplog
base_emailtemplate
base_eventalertsetting
base_linenotifyforemployee
base_linenotifysetting
base_messengersentlog
base_reportoutputsetting
base_securitypolicy
base_sendemail
base_sftpsetting
base_sysparam
base_sysparamdept
base_systemlog
base_systemsetting
base_zoomsetting
django_admin_log
django_celery_beat_clockedschedule
django_celery_beat_crontabschedule
django_celery_beat_intervalschedule
django_celery_beat_periodictask
django_celery_beat_periodictasks
django_celery_beat_solarschedule
django_content_type
django_migrations
django_session
ep_epsetup
ep_eptransaction
iclock_biodata
iclock_biophoto
iclock_devicemoduleconfig
iclock_errorcommandlog
iclock_privatemessage
iclock_publicmessage
iclock_shortmessage
iclock_terminal
iclock_terminalcommand
iclock_terminalcommandlog
iclock_terminalemployee
iclock_terminallog
iclock_terminalparameter
iclock_terminaluploadlog
iclock_terminalworkcode
iclock_transaction
iclock_transactionproofcmd
meeting_meetingentity
meeting_meetingentity_attender
meeting_meetingmanuallog
meeting_meetingpayloadbase
meeting_meetingroom
meeting_meetingroomdevice
meeting_meetingtransaction
mobile_announcement
mobile_appactionlog
mobile_applist
mobile_appnotification
mobile_gpsfordepartment
mobile_gpsfordepartment_location
mobile_gpsforemployee
mobile_gpsforemployee_location
mobile_gpslocation
mobile_mobileapirequestlog
payroll_deductionformula
payroll_empexpenseexemption
payroll_emploan
payroll_emppayrollprofile
payroll_exceptionformula
payroll_extradeduction
payroll_extraincrease
payroll_increasementformula
payroll_leaveformula
payroll_overtimeformula
payroll_payrollpayload
payroll_payrollpayloadexpenseexemption
payroll_payrollpayloadpaycode
payroll_reimbursement
payroll_salaryadvance
payroll_salarystructure
payroll_salarystructure_deductionformula
payroll_salarystructure_exceptionformula
payroll_salarystructure_increasementformula
payroll_salarystructure_leaveformula
payroll_salarystructure_overtimeformula
payroll_socialsecuritydeduction
payroll_specialpayment
payroll_taxdeduction
personnel_area
personnel_assignareaemployee
personnel_certification
personnel_company
personnel_department
personnel_employee
personnel_employeecalendar
personnel_employeecertification
personnel_employeecustomattribute
personnel_employeeextrainfo
personnel_employeeprofile
personnel_employee_area
personnel_employee_area_privilege
personnel_employee_flow_role
personnel_employment
personnel_position
personnel_resign
rest_framework_tracking_apirequestlog
staff_stafftoken
sync_area
sync_department
sync_employee
sync_job
visitor_reason
visitor_reservation
visitor_visitor
visitor_visitorbiodata
visitor_visitorbiophoto
visitor_visitorcertification
visitor_visitorconfig
visitor_visitorlog
visitor_visitortransaction
visitor_visitor_acc_groups
visitor_visitor_area
workflow_nodeinstance
workflow_workflowengine
workflow_workflowengine_employee
workflow_workflowinstance
workflow_workflownode
workflow_workflownode_approver
workflow_workflownode_notifier
workflow_workflowrole
.
select column
select table
accounts_adminbiodata
accounts_passwordresetkey
accounts_usernotification
acc_acccombination
acc_accgroups
acc_accholiday
acc_accprivilege
acc_accterminal
acc_acctimezone
attparam
att_attcalclog
att_attcode
att_attemployee
att_attgroup
att_attpolicy
att_attreportsetting
att_attrule
att_attschedule
att_attshift
att_breaktime
att_calculatelastdate
att_calculatetask
att_changeschedule
att_departmentpolicy
att_departmentschedule
att_deptattrule
att_grouppolicy
att_groupschedule
att_holiday
att_leave
att_leavegroup
att_leavegroupdetail
att_leaveyearbalance
att_manuallog
att_overtime
att_overtimepolicy
att_paycode
att_payloadattcode
att_payloadbase
att_payloadbreak
att_payloadeffectpunch
att_payloadexception
att_payloadmulpunchset
att_payloadovertime
att_payloadparing
att_payloadpaycode
att_payloadpunch
att_payloadtimecard
att_payloadworkcodeparing
att_reportparam
att_reporttemplate
att_shiftdetail
att_temporaryschedule
att_tempschedule
att_timeinterval
att_timeinterval_break_time
att_training
att_webpunch
authtoken_token
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_auth_area
auth_user_auth_dept
auth_user_groups
auth_user_profile
auth_user_user_permissions
base_adminlog
base_attparamdepts
base_autoattexporttask
base_autoexporttask
base_autoimporttask
base_bookmark
base_dbbackuplog
base_emailtemplate
base_eventalertsetting
base_linenotifyforemployee
base_linenotifysetting
base_messengersentlog
base_reportoutputsetting
base_securitypolicy
base_sendemail
base_sftpsetting
base_sysparam
base_sysparamdept
base_systemlog
base_systemsetting
base_zoomsetting
django_admin_log
django_celery_beat_clockedschedule
django_celery_beat_crontabschedule
django_celery_beat_intervalschedule
django_celery_beat_periodictask
django_celery_beat_periodictasks
django_celery_beat_solarschedule
django_content_type
django_migrations
django_session
ep_epsetup
ep_eptransaction
iclock_biodata
iclock_biophoto
iclock_devicemoduleconfig
iclock_errorcommandlog
iclock_privatemessage
iclock_publicmessage
iclock_shortmessage
iclock_terminal
iclock_terminalcommand
iclock_terminalcommandlog
iclock_terminalemployee
iclock_terminallog
iclock_terminalparameter
iclock_terminaluploadlog
iclock_terminalworkcode
iclock_transaction
iclock_transactionproofcmd
meeting_meetingentity
meeting_meetingentity_attender
meeting_meetingmanuallog
meeting_meetingpayloadbase
meeting_meetingroom
meeting_meetingroomdevice
meeting_meetingtransaction
mobile_announcement
mobile_appactionlog
mobile_applist
mobile_appnotification
mobile_gpsfordepartment
mobile_gpsfordepartment_location
mobile_gpsforemployee
mobile_gpsforemployee_location
mobile_gpslocation
mobile_mobileapirequestlog
payroll_deductionformula
payroll_empexpenseexemption
payroll_emploan
payroll_emppayrollprofile
payroll_exceptionformula
payroll_extradeduction
payroll_extraincrease
payroll_increasementformula
payroll_leaveformula
payroll_overtimeformula
payroll_payrollpayload
payroll_payrollpayloadexpenseexemption
payroll_payrollpayloadpaycode
payroll_reimbursement
payroll_salaryadvance
payroll_salarystructure
payroll_salarystructure_deductionformula
payroll_salarystructure_exceptionformula
payroll_salarystructure_increasementformula
payroll_salarystructure_leaveformula
payroll_salarystructure_overtimeformula
payroll_socialsecuritydeduction
payroll_specialpayment
payroll_taxdeduction
personnel_area
personnel_assignareaemployee
personnel_certification
personnel_company
personnel_department
personnel_employee
personnel_employeecalendar
personnel_employeecertification
personnel_employeecustomattribute
personnel_employeeextrainfo
personnel_employeeprofile
personnel_employee_area
personnel_employee_area_privilege
personnel_employee_flow_role
personnel_employment
personnel_position
personnel_resign
rest_framework_tracking_apirequestlog
staff_stafftoken
sync_area
sync_department
sync_employee
sync_job
visitor_reason
visitor_reservation
visitor_visitor
visitor_visitorbiodata
visitor_visitorbiophoto
visitor_visitorcertification
visitor_visitorconfig
visitor_visitorlog
visitor_visitortransaction
visitor_visitor_acc_groups
visitor_visitor_area
workflow_nodeinstance
workflow_workflowengine
workflow_workflowengine_employee
workflow_workflowinstance
workflow_workflownode
workflow_workflownode_approver
workflow_workflownode_notifier
workflow_workflowrole
.
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
accounts_adminbiodata
accounts_passwordresetkey
accounts_usernotification
acc_acccombination
acc_accgroups
acc_accholiday
acc_accprivilege
acc_accterminal
acc_acctimezone
attparam
att_attcalclog
att_attcode
att_attemployee
att_attgroup
att_attpolicy
att_attreportsetting
att_attrule
att_attschedule
att_attshift
att_breaktime
att_calculatelastdate
att_calculatetask
att_changeschedule
att_departmentpolicy
att_departmentschedule
att_deptattrule
att_grouppolicy
att_groupschedule
att_holiday
att_leave
att_leavegroup
att_leavegroupdetail
att_leaveyearbalance
att_manuallog
att_overtime
att_overtimepolicy
att_paycode
att_payloadattcode
att_payloadbase
att_payloadbreak
att_payloadeffectpunch
att_payloadexception
att_payloadmulpunchset
att_payloadovertime
att_payloadparing
att_payloadpaycode
att_payloadpunch
att_payloadtimecard
att_payloadworkcodeparing
att_reportparam
att_reporttemplate
att_shiftdetail
att_temporaryschedule
att_tempschedule
att_timeinterval
att_timeinterval_break_time
att_training
att_webpunch
authtoken_token
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_auth_area
auth_user_auth_dept
auth_user_groups
auth_user_profile
auth_user_user_permissions
base_adminlog
base_attparamdepts
base_autoattexporttask
base_autoexporttask
base_autoimporttask
base_bookmark
base_dbbackuplog
base_emailtemplate
base_eventalertsetting
base_linenotifyforemployee
base_linenotifysetting
base_messengersentlog
base_reportoutputsetting
base_securitypolicy
base_sendemail
base_sftpsetting
base_sysparam
base_sysparamdept
base_systemlog
base_systemsetting
base_zoomsetting
django_admin_log
django_celery_beat_clockedschedule
django_celery_beat_crontabschedule
django_celery_beat_intervalschedule
django_celery_beat_periodictask
django_celery_beat_periodictasks
django_celery_beat_solarschedule
django_content_type
django_migrations
django_session
ep_epsetup
ep_eptransaction
iclock_biodata
iclock_biophoto
iclock_devicemoduleconfig
iclock_errorcommandlog
iclock_privatemessage
iclock_publicmessage
iclock_shortmessage
iclock_terminal
iclock_terminalcommand
iclock_terminalcommandlog
iclock_terminalemployee
iclock_terminallog
iclock_terminalparameter
iclock_terminaluploadlog
iclock_terminalworkcode
iclock_transaction
iclock_transactionproofcmd
meeting_meetingentity
meeting_meetingentity_attender
meeting_meetingmanuallog
meeting_meetingpayloadbase
meeting_meetingroom
meeting_meetingroomdevice
meeting_meetingtransaction
mobile_announcement
mobile_appactionlog
mobile_applist
mobile_appnotification
mobile_gpsfordepartment
mobile_gpsfordepartment_location
mobile_gpsforemployee
mobile_gpsforemployee_location
mobile_gpslocation
mobile_mobileapirequestlog
payroll_deductionformula
payroll_empexpenseexemption
payroll_emploan
payroll_emppayrollprofile
payroll_exceptionformula
payroll_extradeduction
payroll_extraincrease
payroll_increasementformula
payroll_leaveformula
payroll_overtimeformula
payroll_payrollpayload
payroll_payrollpayloadexpenseexemption
payroll_payrollpayloadpaycode
payroll_reimbursement
payroll_salaryadvance
payroll_salarystructure
payroll_salarystructure_deductionformula
payroll_salarystructure_exceptionformula
payroll_salarystructure_increasementformula
payroll_salarystructure_leaveformula
payroll_salarystructure_overtimeformula
payroll_socialsecuritydeduction
payroll_specialpayment
payroll_taxdeduction
personnel_area
personnel_assignareaemployee
personnel_certification
personnel_company
personnel_department
personnel_employee
personnel_employeecalendar
personnel_employeecertification
personnel_employeecustomattribute
personnel_employeeextrainfo
personnel_employeeprofile
personnel_employee_area
personnel_employee_area_privilege
personnel_employee_flow_role
personnel_employment
personnel_position
personnel_resign
rest_framework_tracking_apirequestlog
staff_stafftoken
sync_area
sync_department
sync_employee
sync_job
visitor_reason
visitor_reservation
visitor_visitor
visitor_visitorbiodata
visitor_visitorbiophoto
visitor_visitorcertification
visitor_visitorconfig
visitor_visitorlog
visitor_visitortransaction
visitor_visitor_acc_groups
visitor_visitor_area
workflow_nodeinstance
workflow_workflowengine
workflow_workflowengine_employee
workflow_workflowinstance
workflow_workflownode
workflow_workflownode_approver
workflow_workflownode_notifier
workflow_workflowrole
.
select column
select table
accounts_adminbiodata
accounts_passwordresetkey
accounts_usernotification
acc_acccombination
acc_accgroups
acc_accholiday
acc_accprivilege
acc_accterminal
acc_acctimezone
attparam
att_attcalclog
att_attcode
att_attemployee
att_attgroup
att_attpolicy
att_attreportsetting
att_attrule
att_attschedule
att_attshift
att_breaktime
att_calculatelastdate
att_calculatetask
att_changeschedule
att_departmentpolicy
att_departmentschedule
att_deptattrule
att_grouppolicy
att_groupschedule
att_holiday
att_leave
att_leavegroup
att_leavegroupdetail
att_leaveyearbalance
att_manuallog
att_overtime
att_overtimepolicy
att_paycode
att_payloadattcode
att_payloadbase
att_payloadbreak
att_payloadeffectpunch
att_payloadexception
att_payloadmulpunchset
att_payloadovertime
att_payloadparing
att_payloadpaycode
att_payloadpunch
att_payloadtimecard
att_payloadworkcodeparing
att_reportparam
att_reporttemplate
att_shiftdetail
att_temporaryschedule
att_tempschedule
att_timeinterval
att_timeinterval_break_time
att_training
att_webpunch
authtoken_token
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_auth_area
auth_user_auth_dept
auth_user_groups
auth_user_profile
auth_user_user_permissions
base_adminlog
base_attparamdepts
base_autoattexporttask
base_autoexporttask
base_autoimporttask
base_bookmark
base_dbbackuplog
base_emailtemplate
base_eventalertsetting
base_linenotifyforemployee
base_linenotifysetting
base_messengersentlog
base_reportoutputsetting
base_securitypolicy
base_sendemail
base_sftpsetting
base_sysparam
base_sysparamdept
base_systemlog
base_systemsetting
base_zoomsetting
django_admin_log
django_celery_beat_clockedschedule
django_celery_beat_crontabschedule
django_celery_beat_intervalschedule
django_celery_beat_periodictask
django_celery_beat_periodictasks
django_celery_beat_solarschedule
django_content_type
django_migrations
django_session
ep_epsetup
ep_eptransaction
iclock_biodata
iclock_biophoto
iclock_devicemoduleconfig
iclock_errorcommandlog
iclock_privatemessage
iclock_publicmessage
iclock_shortmessage
iclock_terminal
iclock_terminalcommand
iclock_terminalcommandlog
iclock_terminalemployee
iclock_terminallog
iclock_terminalparameter
iclock_terminaluploadlog
iclock_terminalworkcode
iclock_transaction
iclock_transactionproofcmd
meeting_meetingentity
meeting_meetingentity_attender
meeting_meetingmanuallog
meeting_meetingpayloadbase
meeting_meetingroom
meeting_meetingroomdevice
meeting_meetingtransaction
mobile_announcement
mobile_appactionlog
mobile_applist
mobile_appnotification
mobile_gpsfordepartment
mobile_gpsfordepartment_location
mobile_gpsforemployee
mobile_gpsforemployee_location
mobile_gpslocation
mobile_mobileapirequestlog
payroll_deductionformula
payroll_empexpenseexemption
payroll_emploan
payroll_emppayrollprofile
payroll_exceptionformula
payroll_extradeduction
payroll_extraincrease
payroll_increasementformula
payroll_leaveformula
payroll_overtimeformula
payroll_payrollpayload
payroll_payrollpayloadexpenseexemption
payroll_payrollpayloadpaycode
payroll_reimbursement
payroll_salaryadvance
payroll_salarystructure
payroll_salarystructure_deductionformula
payroll_salarystructure_exceptionformula
payroll_salarystructure_increasementformula
payroll_salarystructure_leaveformula
payroll_salarystructure_overtimeformula
payroll_socialsecuritydeduction
payroll_specialpayment
payroll_taxdeduction
personnel_area
personnel_assignareaemployee
personnel_certification
personnel_company
personnel_department
personnel_employee
personnel_employeecalendar
personnel_employeecertification
personnel_employeecustomattribute
personnel_employeeextrainfo
personnel_employeeprofile
personnel_employee_area
personnel_employee_area_privilege
personnel_employee_flow_role
personnel_employment
personnel_position
personnel_resign
rest_framework_tracking_apirequestlog
staff_stafftoken
sync_area
sync_department
sync_employee
sync_job
visitor_reason
visitor_reservation
visitor_visitor
visitor_visitorbiodata
visitor_visitorbiophoto
visitor_visitorcertification
visitor_visitorconfig
visitor_visitorlog
visitor_visitortransaction
visitor_visitor_acc_groups
visitor_visitor_area
workflow_nodeinstance
workflow_workflowengine
workflow_workflowengine_employee
workflow_workflowinstance
workflow_workflownode
workflow_workflownode_approver
workflow_workflownode_notifier
workflow_workflowrole
.
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
accounts_adminbiodata
accounts_passwordresetkey
accounts_usernotification
acc_acccombination
acc_accgroups
acc_accholiday
acc_accprivilege
acc_accterminal
acc_acctimezone
attparam
att_attcalclog
att_attcode
att_attemployee
att_attgroup
att_attpolicy
att_attreportsetting
att_attrule
att_attschedule
att_attshift
att_breaktime
att_calculatelastdate
att_calculatetask
att_changeschedule
att_departmentpolicy
att_departmentschedule
att_deptattrule
att_grouppolicy
att_groupschedule
att_holiday
att_leave
att_leavegroup
att_leavegroupdetail
att_leaveyearbalance
att_manuallog
att_overtime
att_overtimepolicy
att_paycode
att_payloadattcode
att_payloadbase
att_payloadbreak
att_payloadeffectpunch
att_payloadexception
att_payloadmulpunchset
att_payloadovertime
att_payloadparing
att_payloadpaycode
att_payloadpunch
att_payloadtimecard
att_payloadworkcodeparing
att_reportparam
att_reporttemplate
att_shiftdetail
att_temporaryschedule
att_tempschedule
att_timeinterval
att_timeinterval_break_time
att_training
att_webpunch
authtoken_token
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_auth_area
auth_user_auth_dept
auth_user_groups
auth_user_profile
auth_user_user_permissions
base_adminlog
base_attparamdepts
base_autoattexporttask
base_autoexporttask
base_autoimporttask
base_bookmark
base_dbbackuplog
base_emailtemplate
base_eventalertsetting
base_linenotifyforemployee
base_linenotifysetting
base_messengersentlog
base_reportoutputsetting
base_securitypolicy
base_sendemail
base_sftpsetting
base_sysparam
base_sysparamdept
base_systemlog
base_systemsetting
base_zoomsetting
django_admin_log
django_celery_beat_clockedschedule
django_celery_beat_crontabschedule
django_celery_beat_intervalschedule
django_celery_beat_periodictask
django_celery_beat_periodictasks
django_celery_beat_solarschedule
django_content_type
django_migrations
django_session
ep_epsetup
ep_eptransaction
iclock_biodata
iclock_biophoto
iclock_devicemoduleconfig
iclock_errorcommandlog
iclock_privatemessage
iclock_publicmessage
iclock_shortmessage
iclock_terminal
iclock_terminalcommand
iclock_terminalcommandlog
iclock_terminalemployee
iclock_terminallog
iclock_terminalparameter
iclock_terminaluploadlog
iclock_terminalworkcode
iclock_transaction
iclock_transactionproofcmd
meeting_meetingentity
meeting_meetingentity_attender
meeting_meetingmanuallog
meeting_meetingpayloadbase
meeting_meetingroom
meeting_meetingroomdevice
meeting_meetingtransaction
mobile_announcement
mobile_appactionlog
mobile_applist
mobile_appnotification
mobile_gpsfordepartment
mobile_gpsfordepartment_location
mobile_gpsforemployee
mobile_gpsforemployee_location
mobile_gpslocation
mobile_mobileapirequestlog
payroll_deductionformula
payroll_empexpenseexemption
payroll_emploan
payroll_emppayrollprofile
payroll_exceptionformula
payroll_extradeduction
payroll_extraincrease
payroll_increasementformula
payroll_leaveformula
payroll_overtimeformula
payroll_payrollpayload
payroll_payrollpayloadexpenseexemption
payroll_payrollpayloadpaycode
payroll_reimbursement
payroll_salaryadvance
payroll_salarystructure
payroll_salarystructure_deductionformula
payroll_salarystructure_exceptionformula
payroll_salarystructure_increasementformula
payroll_salarystructure_leaveformula
payroll_salarystructure_overtimeformula
payroll_socialsecuritydeduction
payroll_specialpayment
payroll_taxdeduction
personnel_area
personnel_assignareaemployee
personnel_certification
personnel_company
personnel_department
personnel_employee
personnel_employeecalendar
personnel_employeecertification
personnel_employeecustomattribute
personnel_employeeextrainfo
personnel_employeeprofile
personnel_employee_area
personnel_employee_area_privilege
personnel_employee_flow_role
personnel_employment
personnel_position
personnel_resign
rest_framework_tracking_apirequestlog
staff_stafftoken
sync_area
sync_department
sync_employee
sync_job
visitor_reason
visitor_reservation
visitor_visitor
visitor_visitorbiodata
visitor_visitorbiophoto
visitor_visitorcertification
visitor_visitorconfig
visitor_visitorlog
visitor_visitortransaction
visitor_visitor_acc_groups
visitor_visitor_area
workflow_nodeinstance
workflow_workflowengine
workflow_workflowengine_employee
workflow_workflowinstance
workflow_workflownode
workflow_workflownode_approver
workflow_workflownode_notifier
workflow_workflowrole
.
select column
select table
accounts_adminbiodata
accounts_passwordresetkey
accounts_usernotification
acc_acccombination
acc_accgroups
acc_accholiday
acc_accprivilege
acc_accterminal
acc_acctimezone
attparam
att_attcalclog
att_attcode
att_attemployee
att_attgroup
att_attpolicy
att_attreportsetting
att_attrule
att_attschedule
att_attshift
att_breaktime
att_calculatelastdate
att_calculatetask
att_changeschedule
att_departmentpolicy
att_departmentschedule
att_deptattrule
att_grouppolicy
att_groupschedule
att_holiday
att_leave
att_leavegroup
att_leavegroupdetail
att_leaveyearbalance
att_manuallog
att_overtime
att_overtimepolicy
att_paycode
att_payloadattcode
att_payloadbase
att_payloadbreak
att_payloadeffectpunch
att_payloadexception
att_payloadmulpunchset
att_payloadovertime
att_payloadparing
att_payloadpaycode
att_payloadpunch
att_payloadtimecard
att_payloadworkcodeparing
att_reportparam
att_reporttemplate
att_shiftdetail
att_temporaryschedule
att_tempschedule
att_timeinterval
att_timeinterval_break_time
att_training
att_webpunch
authtoken_token
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_auth_area
auth_user_auth_dept
auth_user_groups
auth_user_profile
auth_user_user_permissions
base_adminlog
base_attparamdepts
base_autoattexporttask
base_autoexporttask
base_autoimporttask
base_bookmark
base_dbbackuplog
base_emailtemplate
base_eventalertsetting
base_linenotifyforemployee
base_linenotifysetting
base_messengersentlog
base_reportoutputsetting
base_securitypolicy
base_sendemail
base_sftpsetting
base_sysparam
base_sysparamdept
base_systemlog
base_systemsetting
base_zoomsetting
django_admin_log
django_celery_beat_clockedschedule
django_celery_beat_crontabschedule
django_celery_beat_intervalschedule
django_celery_beat_periodictask
django_celery_beat_periodictasks
django_celery_beat_solarschedule
django_content_type
django_migrations
django_session
ep_epsetup
ep_eptransaction
iclock_biodata
iclock_biophoto
iclock_devicemoduleconfig
iclock_errorcommandlog
iclock_privatemessage
iclock_publicmessage
iclock_shortmessage
iclock_terminal
iclock_terminalcommand
iclock_terminalcommandlog
iclock_terminalemployee
iclock_terminallog
iclock_terminalparameter
iclock_terminaluploadlog
iclock_terminalworkcode
iclock_transaction
iclock_transactionproofcmd
meeting_meetingentity
meeting_meetingentity_attender
meeting_meetingmanuallog
meeting_meetingpayloadbase
meeting_meetingroom
meeting_meetingroomdevice
meeting_meetingtransaction
mobile_announcement
mobile_appactionlog
mobile_applist
mobile_appnotification
mobile_gpsfordepartment
mobile_gpsfordepartment_location
mobile_gpsforemployee
mobile_gpsforemployee_location
mobile_gpslocation
mobile_mobileapirequestlog
payroll_deductionformula
payroll_empexpenseexemption
payroll_emploan
payroll_emppayrollprofile
payroll_exceptionformula
payroll_extradeduction
payroll_extraincrease
payroll_increasementformula
payroll_leaveformula
payroll_overtimeformula
payroll_payrollpayload
payroll_payrollpayloadexpenseexemption
payroll_payrollpayloadpaycode
payroll_reimbursement
payroll_salaryadvance
payroll_salarystructure
payroll_salarystructure_deductionformula
payroll_salarystructure_exceptionformula
payroll_salarystructure_increasementformula
payroll_salarystructure_leaveformula
payroll_salarystructure_overtimeformula
payroll_socialsecuritydeduction
payroll_specialpayment
payroll_taxdeduction
personnel_area
personnel_assignareaemployee
personnel_certification
personnel_company
personnel_department
personnel_employee
personnel_employeecalendar
personnel_employeecertification
personnel_employeecustomattribute
personnel_employeeextrainfo
personnel_employeeprofile
personnel_employee_area
personnel_employee_area_privilege
personnel_employee_flow_role
personnel_employment
personnel_position
personnel_resign
rest_framework_tracking_apirequestlog
staff_stafftoken
sync_area
sync_department
sync_employee
sync_job
visitor_reason
visitor_reservation
visitor_visitor
visitor_visitorbiodata
visitor_visitorbiophoto
visitor_visitorcertification
visitor_visitorconfig
visitor_visitorlog
visitor_visitortransaction
visitor_visitor_acc_groups
visitor_visitor_area
workflow_nodeinstance
workflow_workflowengine
workflow_workflowengine_employee
workflow_workflowinstance
workflow_workflownode
workflow_workflownode_approver
workflow_workflownode_notifier
workflow_workflowrole
.
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
accounts_adminbiodata
accounts_passwordresetkey
accounts_usernotification
acc_acccombination
acc_accgroups
acc_accholiday
acc_accprivilege
acc_accterminal
acc_acctimezone
attparam
att_attcalclog
att_attcode
att_attemployee
att_attgroup
att_attpolicy
att_attreportsetting
att_attrule
att_attschedule
att_attshift
att_breaktime
att_calculatelastdate
att_calculatetask
att_changeschedule
att_departmentpolicy
att_departmentschedule
att_deptattrule
att_grouppolicy
att_groupschedule
att_holiday
att_leave
att_leavegroup
att_leavegroupdetail
att_leaveyearbalance
att_manuallog
att_overtime
att_overtimepolicy
att_paycode
att_payloadattcode
att_payloadbase
att_payloadbreak
att_payloadeffectpunch
att_payloadexception
att_payloadmulpunchset
att_payloadovertime
att_payloadparing
att_payloadpaycode
att_payloadpunch
att_payloadtimecard
att_payloadworkcodeparing
att_reportparam
att_reporttemplate
att_shiftdetail
att_temporaryschedule
att_tempschedule
att_timeinterval
att_timeinterval_break_time
att_training
att_webpunch
authtoken_token
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_auth_area
auth_user_auth_dept
auth_user_groups
auth_user_profile
auth_user_user_permissions
base_adminlog
base_attparamdepts
base_autoattexporttask
base_autoexporttask
base_autoimporttask
base_bookmark
base_dbbackuplog
base_emailtemplate
base_eventalertsetting
base_linenotifyforemployee
base_linenotifysetting
base_messengersentlog
base_reportoutputsetting
base_securitypolicy
base_sendemail
base_sftpsetting
base_sysparam
base_sysparamdept
base_systemlog
base_systemsetting
base_zoomsetting
django_admin_log
django_celery_beat_clockedschedule
django_celery_beat_crontabschedule
django_celery_beat_intervalschedule
django_celery_beat_periodictask
django_celery_beat_periodictasks
django_celery_beat_solarschedule
django_content_type
django_migrations
django_session
ep_epsetup
ep_eptransaction
iclock_biodata
iclock_biophoto
iclock_devicemoduleconfig
iclock_errorcommandlog
iclock_privatemessage
iclock_publicmessage
iclock_shortmessage
iclock_terminal
iclock_terminalcommand
iclock_terminalcommandlog
iclock_terminalemployee
iclock_terminallog
iclock_terminalparameter
iclock_terminaluploadlog
iclock_terminalworkcode
iclock_transaction
iclock_transactionproofcmd
meeting_meetingentity
meeting_meetingentity_attender
meeting_meetingmanuallog
meeting_meetingpayloadbase
meeting_meetingroom
meeting_meetingroomdevice
meeting_meetingtransaction
mobile_announcement
mobile_appactionlog
mobile_applist
mobile_appnotification
mobile_gpsfordepartment
mobile_gpsfordepartment_location
mobile_gpsforemployee
mobile_gpsforemployee_location
mobile_gpslocation
mobile_mobileapirequestlog
payroll_deductionformula
payroll_empexpenseexemption
payroll_emploan
payroll_emppayrollprofile
payroll_exceptionformula
payroll_extradeduction
payroll_extraincrease
payroll_increasementformula
payroll_leaveformula
payroll_overtimeformula
payroll_payrollpayload
payroll_payrollpayloadexpenseexemption
payroll_payrollpayloadpaycode
payroll_reimbursement
payroll_salaryadvance
payroll_salarystructure
payroll_salarystructure_deductionformula
payroll_salarystructure_exceptionformula
payroll_salarystructure_increasementformula
payroll_salarystructure_leaveformula
payroll_salarystructure_overtimeformula
payroll_socialsecuritydeduction
payroll_specialpayment
payroll_taxdeduction
personnel_area
personnel_assignareaemployee
personnel_certification
personnel_company
personnel_department
personnel_employee
personnel_employeecalendar
personnel_employeecertification
personnel_employeecustomattribute
personnel_employeeextrainfo
personnel_employeeprofile
personnel_employee_area
personnel_employee_area_privilege
personnel_employee_flow_role
personnel_employment
personnel_position
personnel_resign
rest_framework_tracking_apirequestlog
staff_stafftoken
sync_area
sync_department
sync_employee
sync_job
visitor_reason
visitor_reservation
visitor_visitor
visitor_visitorbiodata
visitor_visitorbiophoto
visitor_visitorcertification
visitor_visitorconfig
visitor_visitorlog
visitor_visitortransaction
visitor_visitor_acc_groups
visitor_visitor_area
workflow_nodeinstance
workflow_workflowengine
workflow_workflowengine_employee
workflow_workflowinstance
workflow_workflownode
workflow_workflownode_approver
workflow_workflownode_notifier
workflow_workflowrole
.
select column