近期访问
`ebms_db`.`daily_pocket_limit`
`performance_schema`.`setup_timers`
`information_schema`.`COLLATIONS`
`ebms_db`.`students`
`ebms_db`.`purchases`
`ebms_db`.`packages`
`ebms_db`.`provinces`
`mysql`.`general_log`
`ebms_db`.`requirements`
`information_schema`.`CHARACTER_SETS`
表收藏夹
表收藏夹为空。
新建
ebms_db
information_schema
mysql
performance_schema
phpmyadmin
test
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
导航面板
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
导航树
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
服务器
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
数据库
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
表
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
显示隐藏的导航树节点。
该处必须启用 Javascript!
服务器: 127.0.0.1
数据库: ebms_db
结构
SQL
搜索
查询
(当前的)
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
正在加载
ENUM/SET 编辑器
新建视图
多表查询
通过示例查询
切换到
可视化查询生成器
搜索已经保存的书签:
新建书签
字段:
`account_breakfast`.*
`account_breakfast`.`id`
`account_breakfast`.`account_id`
`account_dpu`.*
`account_dpu`.`id`
`account_dpu`.`account_id`
`account_pocket`.*
`account_pocket`.`id`
`account_pocket`.`account_id`
`accounts`.*
`accounts`.`id`
`accounts`.`name`
`accounts`.`category`
`accounts`.`nominal`
`accounts`.`created_at`
`accounts`.`status`
`calendar`.*
`calendar`.`id`
`calendar`.`hijri`
`calendar`.`masehi`
`cards`.*
`cards`.`id`
`cards`.`student_id`
`cards`.`status`
`cards`.`created_at`
`cities`.*
`cities`.`id`
`cities`.`province_id`
`cities`.`name`
`constitutions`.*
`constitutions`.`id`
`constitutions`.`name`
`constitutions`.`type`
`constitutions`.`category`
`constitutions`.`clause`
`constitutions`.`created_at`
`daily_pocket_limit`.*
`daily_pocket_limit`.`id`
`daily_pocket_limit`.`student_id`
`daily_pocket_limit`.`pocket`
`daily_pocket_limit`.`reserved`
`deposit_credit`.*
`deposit_credit`.`id`
`deposit_credit`.`student_id`
`deposit_credit`.`created_at`
`deposit_credit`.`amount`
`deposit_debit`.*
`deposit_debit`.`id`
`deposit_debit`.`student_id`
`deposit_debit`.`amount`
`deposit_debit`.`role_id`
`deposit_debit`.`created_at`
`deposit_debit`.`status`
`disbursements`.*
`disbursements`.`id`
`disbursements`.`student_id`
`disbursements`.`purchase_id`
`disbursements`.`account_id`
`disbursements`.`amount`
`disbursements`.`role_id`
`disbursements`.`created_at`
`disbursements`.`status`
`distribution_daily`.*
`distribution_daily`.`id`
`distribution_daily`.`student_id`
`distribution_daily`.`purchase_id`
`distribution_daily`.`account_id`
`distribution_daily`.`role_id`
`distribution_daily`.`nominal`
`distribution_daily`.`created_at`
`distributions`.*
`distributions`.`id`
`distributions`.`student_id`
`distributions`.`purchase_id`
`distributions`.`account_id`
`distributions`.`role_id`
`distributions`.`nominal`
`distributions`.`created_at`
`districts`.*
`districts`.`id`
`districts`.`city_id`
`districts`.`name`
`expenditures`.*
`expenditures`.`id`
`expenditures`.`purchase_id`
`expenditures`.`student_id`
`expenditures`.`account_id`
`expenditures`.`package_name`
`expenditures`.`nominal`
`expenditures`.`created_at`
`expenditures`.`caption`
`holidays`.*
`holidays`.`id`
`holidays`.`student_id`
`holidays`.`period`
`holidays`.`holiday`
`holidays`.`created_at`
`homerooms`.*
`homerooms`.`id`
`homerooms`.`teacher`
`homerooms`.`class`
`homerooms`.`rombel`
`homerooms`.`level`
`homerooms`.`period`
`incomes`.*
`incomes`.`id`
`incomes`.`student_id`
`incomes`.`purchase_id`
`incomes`.`account_id`
`incomes`.`package_name`
`incomes`.`nominal`
`incomes`.`created_at`
`incomes`.`caption`
`menus`.*
`menus`.`id`
`menus`.`name`
`menus`.`icon`
`menus`.`url`
`menus`.`status`
`package_deposit`.*
`package_deposit`.`id`
`package_deposit`.`package_id`
`package_deposit`.`created_at`
`package_deposit`.`amount`
`package_detail`.*
`package_detail`.`id`
`package_detail`.`package_id`
`package_detail`.`account_id`
`package_detail`.`nominal`
`package_limit`.*
`package_limit`.`id`
`package_limit`.`package_id`
`package_limit`.`account_id`
`package_limit`.`nominal`
`package_limit`.`qty`
`package_transaction`.*
`package_transaction`.`id`
`package_transaction`.`student_id`
`package_transaction`.`package_id`
`package_transaction`.`created_at`
`package_transaction`.`amount`
`package_transaction`.`type`
`package_transaction`.`status`
`packages`.*
`packages`.`id`
`packages`.`name`
`packages`.`amount`
`packages`.`created_at`
`packages`.`updated_at`
`payment_account`.*
`payment_account`.`id`
`payment_account`.`name`
`payment_account`.`type`
`payment_detail`.*
`payment_detail`.`id`
`payment_detail`.`payment_id`
`payment_detail`.`account_id`
`payment_detail`.`amount`
`payment_package_detail`.*
`payment_package_detail`.`id`
`payment_package_detail`.`account_id`
`payment_package_detail`.`amount`
`payment_package_detail`.`package`
`payment_package_detail`.`period`
`payment_rate_detail`.*
`payment_rate_detail`.`id`
`payment_rate_detail`.`account_id`
`payment_rate_detail`.`amount`
`payment_rate_detail`.`type`
`payment_rate_detail`.`period`
`payment_registration`.*
`payment_registration`.`id`
`payment_registration`.`student_id`
`payment_registration`.`bill`
`payment_registration`.`amount`
`payment_registration`.`created_at`
`payment_registration`.`period`
`payment_registration_detail`.*
`payment_registration_detail`.`id`
`payment_registration_detail`.`payment_registration_id`
`payment_registration_detail`.`account_id`
`payment_registration_detail`.`amount`
`payment_security`.*
`payment_security`.`id`
`payment_security`.`student_id`
`payment_security`.`step`
`payment_security`.`amount`
`payment_security`.`created_at`
`payment_security`.`period`
`payment_security`.`type`
`payment_security`.`status`
`payment_setting`.*
`payment_setting`.`id`
`payment_setting`.`period`
`payments`.*
`payments`.`id`
`payments`.`student_id`
`payments`.`bill`
`payments`.`amount`
`payments`.`status`
`payments`.`created_at`
`payments`.`period`
`period`.*
`period`.`id`
`period`.`name`
`permissions`.*
`permissions`.`id`
`permissions`.`order`
`permissions`.`reference`
`permissions`.`step`
`permissions`.`period`
`permissions`.`student_id`
`permissions`.`reason`
`permissions`.`created_at`
`permissions`.`expired_at`
`permissions`.`checked_at`
`permissions`.`printed_at`
`permissions`.`type`
`permissions`.`status`
`permissions`.`payment`
`permissions`.`note`
`presences`.*
`presences`.`id`
`presences`.`student_id`
`presences`.`level`
`presences`.`grade`
`presences`.`rombel`
`presences`.`presence`
`presences`.`month`
`presences`.`amount`
`presences`.`period`
`provinces`.*
`provinces`.`id`
`provinces`.`name`
`punishment_detail`.*
`punishment_detail`.`id`
`punishment_detail`.`punishment_id`
`punishment_detail`.`constitution_id`
`punishments`.*
`punishments`.`id`
`punishments`.`student_id`
`punishments`.`constitution_id`
`punishments`.`period`
`punishments`.`created_at`
`punishments`.`status`
`purchase_detail`.*
`purchase_detail`.`id`
`purchase_detail`.`account_id`
`purchase_detail`.`nominal`
`purchase_detail`.`purchase_id`
`purchase_temp`.*
`purchase_temp`.`id`
`purchase_temp`.`student_id`
`purchase_temp`.`account_id`
`purchase_temp`.`nominal`
`purchase_temp`.`user`
`purchases`.*
`purchases`.`id`
`purchases`.`student_id`
`purchases`.`package_id`
`purchases`.`package_name`
`purchases`.`amount`
`purchases`.`created_at`
`purchases`.`user_id`
`purchases`.`status`
`rates`.*
`rates`.`id`
`rates`.`type`
`rates`.`amount`
`rates`.`period`
`reasons`.*
`reasons`.`id`
`reasons`.`name`
`reasons`.`type`
`registrations`.*
`registrations`.`id`
`registrations`.`student_id`
`registrations`.`period`
`registrations`.`status_of_domicile`
`registrations`.`domicile`
`registrations`.`class`
`registrations`.`rombel`
`registrations`.`level`
`registrations`.`class_of_formal`
`registrations`.`rombel_of_formal`
`registrations`.`level_of_formal`
`requirement_detail`.*
`requirement_detail`.`id`
`requirement_detail`.`requirement_id`
`requirement_detail`.`security_account`
`requirement_detail`.`status`
`requirements`.*
`requirements`.`id`
`requirements`.`student_id`
`requirements`.`period`
`requirements`.`holiday`
`requirements`.`created_at`
`requirements`.`updated_at`
`requirements`.`status`
`reserved_pocket`.*
`reserved_pocket`.`id`
`reserved_pocket`.`student_id`
`reserved_pocket`.`amount`
`reserved_pocket_daily`.*
`reserved_pocket_daily`.`id`
`reserved_pocket_daily`.`student_id`
`reserved_pocket_daily`.`amount`
`reserved_pocket_daily`.`created_at`
`role_menu`.*
`role_menu`.`id`
`role_menu`.`menu_id`
`role_menu`.`role_id`
`role_menu`.`order`
`role_user`.*
`role_user`.`id`
`role_user`.`user_id`
`role_user`.`role_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`rooms`.*
`rooms`.`id`
`rooms`.`name`
`rooms`.`head`
`rooms`.`security`
`security_account`.*
`security_account`.`id`
`security_account`.`name`
`security_account`.`status`
`security_setting`.*
`security_setting`.`id`
`security_setting`.`holiday`
`security_setting`.`gohome`
`security_setting`.`comeback`
`security_setting`.`status`
`set_daily`.*
`set_daily`.`id`
`set_daily`.`created_at`
`set_daily`.`amount`
`set_daily`.`status`
`set_daily_log`.*
`set_daily_log`.`id`
`set_daily_log`.`created_at`
`set_transaction_daily`.*
`set_transaction_daily`.`id`
`set_transaction_daily`.`table_name`
`set_transaction_daily`.`category`
`set_transaction_daily`.`user_id`
`shifts`.*
`shifts`.`id`
`shifts`.`name`
`shifts`.`begin`
`shifts`.`finish`
`steps`.*
`steps`.`id`
`steps`.`step`
`steps`.`status`
`steps`.`start_at`
`store_setting`.*
`store_setting`.`id`
`store_setting`.`name`
`store_setting`.`price`
`store_setting`.`created_at`
`students`.*
`students`.`id`
`students`.`year_of_entry`
`students`.`date_of_entry`
`students`.`date_of_entry_hijriah`
`students`.`period`
`students`.`nik`
`students`.`kk`
`students`.`name`
`students`.`place_of_birth`
`students`.`date_of_birth`
`students`.`last_education`
`students`.`address`
`students`.`village`
`students`.`district`
`students`.`city`
`students`.`province`
`students`.`postal_code`
`students`.`father_nik`
`students`.`father`
`students`.`mother_nik`
`students`.`mother`
`students`.`phone`
`students`.`status_of_domicile`
`students`.`domicile`
`students`.`class`
`students`.`rombel`
`students`.`level`
`students`.`class_of_formal`
`students`.`level_of_formal`
`students`.`status`
`students`.`user_id`
`suspensions`.*
`suspensions`.`id`
`suspensions`.`student_id`
`suspensions`.`constitution_id`
`suspensions`.`punishment_id`
`suspensions`.`period`
`suspensions`.`term`
`suspensions`.`actived_at`
`suspensions`.`expired_at`
`suspensions`.`created_at`
`suspensions`.`status`
`term_setting`.*
`term_setting`.`id`
`term_setting`.`term`
`transactions`.*
`transactions`.`id`
`transactions`.`student_id`
`transactions`.`purchase_id`
`transactions`.`account_id`
`transactions`.`role_id`
`transactions`.`amount`
`transactions`.`created_at`
`transactions`.`status`
`user_menu`.*
`user_menu`.`id`
`user_menu`.`menu_id`
`user_menu`.`role`
`users`.*
`users`.`id`
`users`.`name`
`users`.`username`
`users`.`password`
`users`.`role`
`users`.`current_role`
`users`.`status`
`villages`.*
`villages`.`id`
`villages`.`district_id`
`villages`.`name`
`villages`.`postal_code`
`account_breakfast`.*
`account_breakfast`.`id`
`account_breakfast`.`account_id`
`account_dpu`.*
`account_dpu`.`id`
`account_dpu`.`account_id`
`account_pocket`.*
`account_pocket`.`id`
`account_pocket`.`account_id`
`accounts`.*
`accounts`.`id`
`accounts`.`name`
`accounts`.`category`
`accounts`.`nominal`
`accounts`.`created_at`
`accounts`.`status`
`calendar`.*
`calendar`.`id`
`calendar`.`hijri`
`calendar`.`masehi`
`cards`.*
`cards`.`id`
`cards`.`student_id`
`cards`.`status`
`cards`.`created_at`
`cities`.*
`cities`.`id`
`cities`.`province_id`
`cities`.`name`
`constitutions`.*
`constitutions`.`id`
`constitutions`.`name`
`constitutions`.`type`
`constitutions`.`category`
`constitutions`.`clause`
`constitutions`.`created_at`
`daily_pocket_limit`.*
`daily_pocket_limit`.`id`
`daily_pocket_limit`.`student_id`
`daily_pocket_limit`.`pocket`
`daily_pocket_limit`.`reserved`
`deposit_credit`.*
`deposit_credit`.`id`
`deposit_credit`.`student_id`
`deposit_credit`.`created_at`
`deposit_credit`.`amount`
`deposit_debit`.*
`deposit_debit`.`id`
`deposit_debit`.`student_id`
`deposit_debit`.`amount`
`deposit_debit`.`role_id`
`deposit_debit`.`created_at`
`deposit_debit`.`status`
`disbursements`.*
`disbursements`.`id`
`disbursements`.`student_id`
`disbursements`.`purchase_id`
`disbursements`.`account_id`
`disbursements`.`amount`
`disbursements`.`role_id`
`disbursements`.`created_at`
`disbursements`.`status`
`distribution_daily`.*
`distribution_daily`.`id`
`distribution_daily`.`student_id`
`distribution_daily`.`purchase_id`
`distribution_daily`.`account_id`
`distribution_daily`.`role_id`
`distribution_daily`.`nominal`
`distribution_daily`.`created_at`
`distributions`.*
`distributions`.`id`
`distributions`.`student_id`
`distributions`.`purchase_id`
`distributions`.`account_id`
`distributions`.`role_id`
`distributions`.`nominal`
`distributions`.`created_at`
`districts`.*
`districts`.`id`
`districts`.`city_id`
`districts`.`name`
`expenditures`.*
`expenditures`.`id`
`expenditures`.`purchase_id`
`expenditures`.`student_id`
`expenditures`.`account_id`
`expenditures`.`package_name`
`expenditures`.`nominal`
`expenditures`.`created_at`
`expenditures`.`caption`
`holidays`.*
`holidays`.`id`
`holidays`.`student_id`
`holidays`.`period`
`holidays`.`holiday`
`holidays`.`created_at`
`homerooms`.*
`homerooms`.`id`
`homerooms`.`teacher`
`homerooms`.`class`
`homerooms`.`rombel`
`homerooms`.`level`
`homerooms`.`period`
`incomes`.*
`incomes`.`id`
`incomes`.`student_id`
`incomes`.`purchase_id`
`incomes`.`account_id`
`incomes`.`package_name`
`incomes`.`nominal`
`incomes`.`created_at`
`incomes`.`caption`
`menus`.*
`menus`.`id`
`menus`.`name`
`menus`.`icon`
`menus`.`url`
`menus`.`status`
`package_deposit`.*
`package_deposit`.`id`
`package_deposit`.`package_id`
`package_deposit`.`created_at`
`package_deposit`.`amount`
`package_detail`.*
`package_detail`.`id`
`package_detail`.`package_id`
`package_detail`.`account_id`
`package_detail`.`nominal`
`package_limit`.*
`package_limit`.`id`
`package_limit`.`package_id`
`package_limit`.`account_id`
`package_limit`.`nominal`
`package_limit`.`qty`
`package_transaction`.*
`package_transaction`.`id`
`package_transaction`.`student_id`
`package_transaction`.`package_id`
`package_transaction`.`created_at`
`package_transaction`.`amount`
`package_transaction`.`type`
`package_transaction`.`status`
`packages`.*
`packages`.`id`
`packages`.`name`
`packages`.`amount`
`packages`.`created_at`
`packages`.`updated_at`
`payment_account`.*
`payment_account`.`id`
`payment_account`.`name`
`payment_account`.`type`
`payment_detail`.*
`payment_detail`.`id`
`payment_detail`.`payment_id`
`payment_detail`.`account_id`
`payment_detail`.`amount`
`payment_package_detail`.*
`payment_package_detail`.`id`
`payment_package_detail`.`account_id`
`payment_package_detail`.`amount`
`payment_package_detail`.`package`
`payment_package_detail`.`period`
`payment_rate_detail`.*
`payment_rate_detail`.`id`
`payment_rate_detail`.`account_id`
`payment_rate_detail`.`amount`
`payment_rate_detail`.`type`
`payment_rate_detail`.`period`
`payment_registration`.*
`payment_registration`.`id`
`payment_registration`.`student_id`
`payment_registration`.`bill`
`payment_registration`.`amount`
`payment_registration`.`created_at`
`payment_registration`.`period`
`payment_registration_detail`.*
`payment_registration_detail`.`id`
`payment_registration_detail`.`payment_registration_id`
`payment_registration_detail`.`account_id`
`payment_registration_detail`.`amount`
`payment_security`.*
`payment_security`.`id`
`payment_security`.`student_id`
`payment_security`.`step`
`payment_security`.`amount`
`payment_security`.`created_at`
`payment_security`.`period`
`payment_security`.`type`
`payment_security`.`status`
`payment_setting`.*
`payment_setting`.`id`
`payment_setting`.`period`
`payments`.*
`payments`.`id`
`payments`.`student_id`
`payments`.`bill`
`payments`.`amount`
`payments`.`status`
`payments`.`created_at`
`payments`.`period`
`period`.*
`period`.`id`
`period`.`name`
`permissions`.*
`permissions`.`id`
`permissions`.`order`
`permissions`.`reference`
`permissions`.`step`
`permissions`.`period`
`permissions`.`student_id`
`permissions`.`reason`
`permissions`.`created_at`
`permissions`.`expired_at`
`permissions`.`checked_at`
`permissions`.`printed_at`
`permissions`.`type`
`permissions`.`status`
`permissions`.`payment`
`permissions`.`note`
`presences`.*
`presences`.`id`
`presences`.`student_id`
`presences`.`level`
`presences`.`grade`
`presences`.`rombel`
`presences`.`presence`
`presences`.`month`
`presences`.`amount`
`presences`.`period`
`provinces`.*
`provinces`.`id`
`provinces`.`name`
`punishment_detail`.*
`punishment_detail`.`id`
`punishment_detail`.`punishment_id`
`punishment_detail`.`constitution_id`
`punishments`.*
`punishments`.`id`
`punishments`.`student_id`
`punishments`.`constitution_id`
`punishments`.`period`
`punishments`.`created_at`
`punishments`.`status`
`purchase_detail`.*
`purchase_detail`.`id`
`purchase_detail`.`account_id`
`purchase_detail`.`nominal`
`purchase_detail`.`purchase_id`
`purchase_temp`.*
`purchase_temp`.`id`
`purchase_temp`.`student_id`
`purchase_temp`.`account_id`
`purchase_temp`.`nominal`
`purchase_temp`.`user`
`purchases`.*
`purchases`.`id`
`purchases`.`student_id`
`purchases`.`package_id`
`purchases`.`package_name`
`purchases`.`amount`
`purchases`.`created_at`
`purchases`.`user_id`
`purchases`.`status`
`rates`.*
`rates`.`id`
`rates`.`type`
`rates`.`amount`
`rates`.`period`
`reasons`.*
`reasons`.`id`
`reasons`.`name`
`reasons`.`type`
`registrations`.*
`registrations`.`id`
`registrations`.`student_id`
`registrations`.`period`
`registrations`.`status_of_domicile`
`registrations`.`domicile`
`registrations`.`class`
`registrations`.`rombel`
`registrations`.`level`
`registrations`.`class_of_formal`
`registrations`.`rombel_of_formal`
`registrations`.`level_of_formal`
`requirement_detail`.*
`requirement_detail`.`id`
`requirement_detail`.`requirement_id`
`requirement_detail`.`security_account`
`requirement_detail`.`status`
`requirements`.*
`requirements`.`id`
`requirements`.`student_id`
`requirements`.`period`
`requirements`.`holiday`
`requirements`.`created_at`
`requirements`.`updated_at`
`requirements`.`status`
`reserved_pocket`.*
`reserved_pocket`.`id`
`reserved_pocket`.`student_id`
`reserved_pocket`.`amount`
`reserved_pocket_daily`.*
`reserved_pocket_daily`.`id`
`reserved_pocket_daily`.`student_id`
`reserved_pocket_daily`.`amount`
`reserved_pocket_daily`.`created_at`
`role_menu`.*
`role_menu`.`id`
`role_menu`.`menu_id`
`role_menu`.`role_id`
`role_menu`.`order`
`role_user`.*
`role_user`.`id`
`role_user`.`user_id`
`role_user`.`role_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`rooms`.*
`rooms`.`id`
`rooms`.`name`
`rooms`.`head`
`rooms`.`security`
`security_account`.*
`security_account`.`id`
`security_account`.`name`
`security_account`.`status`
`security_setting`.*
`security_setting`.`id`
`security_setting`.`holiday`
`security_setting`.`gohome`
`security_setting`.`comeback`
`security_setting`.`status`
`set_daily`.*
`set_daily`.`id`
`set_daily`.`created_at`
`set_daily`.`amount`
`set_daily`.`status`
`set_daily_log`.*
`set_daily_log`.`id`
`set_daily_log`.`created_at`
`set_transaction_daily`.*
`set_transaction_daily`.`id`
`set_transaction_daily`.`table_name`
`set_transaction_daily`.`category`
`set_transaction_daily`.`user_id`
`shifts`.*
`shifts`.`id`
`shifts`.`name`
`shifts`.`begin`
`shifts`.`finish`
`steps`.*
`steps`.`id`
`steps`.`step`
`steps`.`status`
`steps`.`start_at`
`store_setting`.*
`store_setting`.`id`
`store_setting`.`name`
`store_setting`.`price`
`store_setting`.`created_at`
`students`.*
`students`.`id`
`students`.`year_of_entry`
`students`.`date_of_entry`
`students`.`date_of_entry_hijriah`
`students`.`period`
`students`.`nik`
`students`.`kk`
`students`.`name`
`students`.`place_of_birth`
`students`.`date_of_birth`
`students`.`last_education`
`students`.`address`
`students`.`village`
`students`.`district`
`students`.`city`
`students`.`province`
`students`.`postal_code`
`students`.`father_nik`
`students`.`father`
`students`.`mother_nik`
`students`.`mother`
`students`.`phone`
`students`.`status_of_domicile`
`students`.`domicile`
`students`.`class`
`students`.`rombel`
`students`.`level`
`students`.`class_of_formal`
`students`.`level_of_formal`
`students`.`status`
`students`.`user_id`
`suspensions`.*
`suspensions`.`id`
`suspensions`.`student_id`
`suspensions`.`constitution_id`
`suspensions`.`punishment_id`
`suspensions`.`period`
`suspensions`.`term`
`suspensions`.`actived_at`
`suspensions`.`expired_at`
`suspensions`.`created_at`
`suspensions`.`status`
`term_setting`.*
`term_setting`.`id`
`term_setting`.`term`
`transactions`.*
`transactions`.`id`
`transactions`.`student_id`
`transactions`.`purchase_id`
`transactions`.`account_id`
`transactions`.`role_id`
`transactions`.`amount`
`transactions`.`created_at`
`transactions`.`status`
`user_menu`.*
`user_menu`.`id`
`user_menu`.`menu_id`
`user_menu`.`role`
`users`.*
`users`.`id`
`users`.`name`
`users`.`username`
`users`.`password`
`users`.`role`
`users`.`current_role`
`users`.`status`
`villages`.*
`villages`.`id`
`villages`.`district_id`
`villages`.`name`
`villages`.`postal_code`
`account_breakfast`.*
`account_breakfast`.`id`
`account_breakfast`.`account_id`
`account_dpu`.*
`account_dpu`.`id`
`account_dpu`.`account_id`
`account_pocket`.*
`account_pocket`.`id`
`account_pocket`.`account_id`
`accounts`.*
`accounts`.`id`
`accounts`.`name`
`accounts`.`category`
`accounts`.`nominal`
`accounts`.`created_at`
`accounts`.`status`
`calendar`.*
`calendar`.`id`
`calendar`.`hijri`
`calendar`.`masehi`
`cards`.*
`cards`.`id`
`cards`.`student_id`
`cards`.`status`
`cards`.`created_at`
`cities`.*
`cities`.`id`
`cities`.`province_id`
`cities`.`name`
`constitutions`.*
`constitutions`.`id`
`constitutions`.`name`
`constitutions`.`type`
`constitutions`.`category`
`constitutions`.`clause`
`constitutions`.`created_at`
`daily_pocket_limit`.*
`daily_pocket_limit`.`id`
`daily_pocket_limit`.`student_id`
`daily_pocket_limit`.`pocket`
`daily_pocket_limit`.`reserved`
`deposit_credit`.*
`deposit_credit`.`id`
`deposit_credit`.`student_id`
`deposit_credit`.`created_at`
`deposit_credit`.`amount`
`deposit_debit`.*
`deposit_debit`.`id`
`deposit_debit`.`student_id`
`deposit_debit`.`amount`
`deposit_debit`.`role_id`
`deposit_debit`.`created_at`
`deposit_debit`.`status`
`disbursements`.*
`disbursements`.`id`
`disbursements`.`student_id`
`disbursements`.`purchase_id`
`disbursements`.`account_id`
`disbursements`.`amount`
`disbursements`.`role_id`
`disbursements`.`created_at`
`disbursements`.`status`
`distribution_daily`.*
`distribution_daily`.`id`
`distribution_daily`.`student_id`
`distribution_daily`.`purchase_id`
`distribution_daily`.`account_id`
`distribution_daily`.`role_id`
`distribution_daily`.`nominal`
`distribution_daily`.`created_at`
`distributions`.*
`distributions`.`id`
`distributions`.`student_id`
`distributions`.`purchase_id`
`distributions`.`account_id`
`distributions`.`role_id`
`distributions`.`nominal`
`distributions`.`created_at`
`districts`.*
`districts`.`id`
`districts`.`city_id`
`districts`.`name`
`expenditures`.*
`expenditures`.`id`
`expenditures`.`purchase_id`
`expenditures`.`student_id`
`expenditures`.`account_id`
`expenditures`.`package_name`
`expenditures`.`nominal`
`expenditures`.`created_at`
`expenditures`.`caption`
`holidays`.*
`holidays`.`id`
`holidays`.`student_id`
`holidays`.`period`
`holidays`.`holiday`
`holidays`.`created_at`
`homerooms`.*
`homerooms`.`id`
`homerooms`.`teacher`
`homerooms`.`class`
`homerooms`.`rombel`
`homerooms`.`level`
`homerooms`.`period`
`incomes`.*
`incomes`.`id`
`incomes`.`student_id`
`incomes`.`purchase_id`
`incomes`.`account_id`
`incomes`.`package_name`
`incomes`.`nominal`
`incomes`.`created_at`
`incomes`.`caption`
`menus`.*
`menus`.`id`
`menus`.`name`
`menus`.`icon`
`menus`.`url`
`menus`.`status`
`package_deposit`.*
`package_deposit`.`id`
`package_deposit`.`package_id`
`package_deposit`.`created_at`
`package_deposit`.`amount`
`package_detail`.*
`package_detail`.`id`
`package_detail`.`package_id`
`package_detail`.`account_id`
`package_detail`.`nominal`
`package_limit`.*
`package_limit`.`id`
`package_limit`.`package_id`
`package_limit`.`account_id`
`package_limit`.`nominal`
`package_limit`.`qty`
`package_transaction`.*
`package_transaction`.`id`
`package_transaction`.`student_id`
`package_transaction`.`package_id`
`package_transaction`.`created_at`
`package_transaction`.`amount`
`package_transaction`.`type`
`package_transaction`.`status`
`packages`.*
`packages`.`id`
`packages`.`name`
`packages`.`amount`
`packages`.`created_at`
`packages`.`updated_at`
`payment_account`.*
`payment_account`.`id`
`payment_account`.`name`
`payment_account`.`type`
`payment_detail`.*
`payment_detail`.`id`
`payment_detail`.`payment_id`
`payment_detail`.`account_id`
`payment_detail`.`amount`
`payment_package_detail`.*
`payment_package_detail`.`id`
`payment_package_detail`.`account_id`
`payment_package_detail`.`amount`
`payment_package_detail`.`package`
`payment_package_detail`.`period`
`payment_rate_detail`.*
`payment_rate_detail`.`id`
`payment_rate_detail`.`account_id`
`payment_rate_detail`.`amount`
`payment_rate_detail`.`type`
`payment_rate_detail`.`period`
`payment_registration`.*
`payment_registration`.`id`
`payment_registration`.`student_id`
`payment_registration`.`bill`
`payment_registration`.`amount`
`payment_registration`.`created_at`
`payment_registration`.`period`
`payment_registration_detail`.*
`payment_registration_detail`.`id`
`payment_registration_detail`.`payment_registration_id`
`payment_registration_detail`.`account_id`
`payment_registration_detail`.`amount`
`payment_security`.*
`payment_security`.`id`
`payment_security`.`student_id`
`payment_security`.`step`
`payment_security`.`amount`
`payment_security`.`created_at`
`payment_security`.`period`
`payment_security`.`type`
`payment_security`.`status`
`payment_setting`.*
`payment_setting`.`id`
`payment_setting`.`period`
`payments`.*
`payments`.`id`
`payments`.`student_id`
`payments`.`bill`
`payments`.`amount`
`payments`.`status`
`payments`.`created_at`
`payments`.`period`
`period`.*
`period`.`id`
`period`.`name`
`permissions`.*
`permissions`.`id`
`permissions`.`order`
`permissions`.`reference`
`permissions`.`step`
`permissions`.`period`
`permissions`.`student_id`
`permissions`.`reason`
`permissions`.`created_at`
`permissions`.`expired_at`
`permissions`.`checked_at`
`permissions`.`printed_at`
`permissions`.`type`
`permissions`.`status`
`permissions`.`payment`
`permissions`.`note`
`presences`.*
`presences`.`id`
`presences`.`student_id`
`presences`.`level`
`presences`.`grade`
`presences`.`rombel`
`presences`.`presence`
`presences`.`month`
`presences`.`amount`
`presences`.`period`
`provinces`.*
`provinces`.`id`
`provinces`.`name`
`punishment_detail`.*
`punishment_detail`.`id`
`punishment_detail`.`punishment_id`
`punishment_detail`.`constitution_id`
`punishments`.*
`punishments`.`id`
`punishments`.`student_id`
`punishments`.`constitution_id`
`punishments`.`period`
`punishments`.`created_at`
`punishments`.`status`
`purchase_detail`.*
`purchase_detail`.`id`
`purchase_detail`.`account_id`
`purchase_detail`.`nominal`
`purchase_detail`.`purchase_id`
`purchase_temp`.*
`purchase_temp`.`id`
`purchase_temp`.`student_id`
`purchase_temp`.`account_id`
`purchase_temp`.`nominal`
`purchase_temp`.`user`
`purchases`.*
`purchases`.`id`
`purchases`.`student_id`
`purchases`.`package_id`
`purchases`.`package_name`
`purchases`.`amount`
`purchases`.`created_at`
`purchases`.`user_id`
`purchases`.`status`
`rates`.*
`rates`.`id`
`rates`.`type`
`rates`.`amount`
`rates`.`period`
`reasons`.*
`reasons`.`id`
`reasons`.`name`
`reasons`.`type`
`registrations`.*
`registrations`.`id`
`registrations`.`student_id`
`registrations`.`period`
`registrations`.`status_of_domicile`
`registrations`.`domicile`
`registrations`.`class`
`registrations`.`rombel`
`registrations`.`level`
`registrations`.`class_of_formal`
`registrations`.`rombel_of_formal`
`registrations`.`level_of_formal`
`requirement_detail`.*
`requirement_detail`.`id`
`requirement_detail`.`requirement_id`
`requirement_detail`.`security_account`
`requirement_detail`.`status`
`requirements`.*
`requirements`.`id`
`requirements`.`student_id`
`requirements`.`period`
`requirements`.`holiday`
`requirements`.`created_at`
`requirements`.`updated_at`
`requirements`.`status`
`reserved_pocket`.*
`reserved_pocket`.`id`
`reserved_pocket`.`student_id`
`reserved_pocket`.`amount`
`reserved_pocket_daily`.*
`reserved_pocket_daily`.`id`
`reserved_pocket_daily`.`student_id`
`reserved_pocket_daily`.`amount`
`reserved_pocket_daily`.`created_at`
`role_menu`.*
`role_menu`.`id`
`role_menu`.`menu_id`
`role_menu`.`role_id`
`role_menu`.`order`
`role_user`.*
`role_user`.`id`
`role_user`.`user_id`
`role_user`.`role_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`rooms`.*
`rooms`.`id`
`rooms`.`name`
`rooms`.`head`
`rooms`.`security`
`security_account`.*
`security_account`.`id`
`security_account`.`name`
`security_account`.`status`
`security_setting`.*
`security_setting`.`id`
`security_setting`.`holiday`
`security_setting`.`gohome`
`security_setting`.`comeback`
`security_setting`.`status`
`set_daily`.*
`set_daily`.`id`
`set_daily`.`created_at`
`set_daily`.`amount`
`set_daily`.`status`
`set_daily_log`.*
`set_daily_log`.`id`
`set_daily_log`.`created_at`
`set_transaction_daily`.*
`set_transaction_daily`.`id`
`set_transaction_daily`.`table_name`
`set_transaction_daily`.`category`
`set_transaction_daily`.`user_id`
`shifts`.*
`shifts`.`id`
`shifts`.`name`
`shifts`.`begin`
`shifts`.`finish`
`steps`.*
`steps`.`id`
`steps`.`step`
`steps`.`status`
`steps`.`start_at`
`store_setting`.*
`store_setting`.`id`
`store_setting`.`name`
`store_setting`.`price`
`store_setting`.`created_at`
`students`.*
`students`.`id`
`students`.`year_of_entry`
`students`.`date_of_entry`
`students`.`date_of_entry_hijriah`
`students`.`period`
`students`.`nik`
`students`.`kk`
`students`.`name`
`students`.`place_of_birth`
`students`.`date_of_birth`
`students`.`last_education`
`students`.`address`
`students`.`village`
`students`.`district`
`students`.`city`
`students`.`province`
`students`.`postal_code`
`students`.`father_nik`
`students`.`father`
`students`.`mother_nik`
`students`.`mother`
`students`.`phone`
`students`.`status_of_domicile`
`students`.`domicile`
`students`.`class`
`students`.`rombel`
`students`.`level`
`students`.`class_of_formal`
`students`.`level_of_formal`
`students`.`status`
`students`.`user_id`
`suspensions`.*
`suspensions`.`id`
`suspensions`.`student_id`
`suspensions`.`constitution_id`
`suspensions`.`punishment_id`
`suspensions`.`period`
`suspensions`.`term`
`suspensions`.`actived_at`
`suspensions`.`expired_at`
`suspensions`.`created_at`
`suspensions`.`status`
`term_setting`.*
`term_setting`.`id`
`term_setting`.`term`
`transactions`.*
`transactions`.`id`
`transactions`.`student_id`
`transactions`.`purchase_id`
`transactions`.`account_id`
`transactions`.`role_id`
`transactions`.`amount`
`transactions`.`created_at`
`transactions`.`status`
`user_menu`.*
`user_menu`.`id`
`user_menu`.`menu_id`
`user_menu`.`role`
`users`.*
`users`.`id`
`users`.`name`
`users`.`username`
`users`.`password`
`users`.`role`
`users`.`current_role`
`users`.`status`
`villages`.*
`villages`.`id`
`villages`.`district_id`
`villages`.`name`
`villages`.`postal_code`
别名:
显示:
排序:
递增
递减
递增
递减
递增
递减
排序规则:
1
2
3
1
2
3
1
2
3
条件:
插入:
且:
删除:
或:
修改:
或:
且:
插入
删除
或:
且:
插入
删除
插入
删除
添加/删除标准行:
-3
-2
-1
0
1
2
3
添加/删除字段:
-3
-2
-1
0
1
2
3
使用表
account_breakfast
account_dpu
account_pocket
accounts
calendar
cards
cities
constitutions
daily_pocket_limit
deposit_credit
deposit_debit
disbursements
distribution_daily
distributions
districts
expenditures
holidays
homerooms
incomes
menus
package_deposit
package_detail
package_limit
package_transaction
packages
payment_account
payment_detail
payment_package_detail
payment_rate_detail
payment_registration
payment_registration_detail
payment_security
payment_setting
payments
period
permissions
presences
provinces
punishment_detail
punishments
purchase_detail
purchase_temp
purchases
rates
reasons
registrations
requirement_detail
requirements
reserved_pocket
reserved_pocket_daily
role_menu
role_user
roles
rooms
security_account
security_setting
set_daily
set_daily_log
set_transaction_daily
shifts
steps
store_setting
students
suspensions
term_setting
transactions
user_menu
users
villages
在数据库
ebms_db
执行 SQL 语句: