近期访问
`prison_db_8080`.`relatives`
`prison_db_8080`.`vip_visit_grants`
`prison_db_8080`.`visit_discipline_suspensions`
`prison_db_8080`.`vip_visit_audit`
`performance_schema`.`file_summary_by_instance`
`performance_schema`.`setup_actors`
`prison_db_8080`.`visit_rounds`
`prison_db_8080`.`visit_settings`
`prison_db_8080`.`activity_audit`
`prison_db_8080`.`inmates`
表收藏夹
表收藏夹为空。
新建
bantiwa999_db
bill_db
information_schema
mybill
mybill
mybill_v2
mycloud_db
mysql
performance_schema
phpmyadmin
prison_db_8080
test
tiktok_ai_affiliate
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
导航面板
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
导航树
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
服务器
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
数据库
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
表
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
显示隐藏的导航树节点。
新建视图
该处必须启用 Javascript!
服务器: 127.0.0.1
数据库: prison_db_8080
结构
SQL
搜索
查询
(当前的)
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量 :
用时 :
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
正在加载
ENUM/SET 编辑器
新建视图
多表查询
通过示例查询
切换到
可视化查询生成器
搜索已经保存的书签:
新建书签
字段:
`activity_audit`.*
`activity_audit`.`id`
`activity_audit`.`occurred_at`
`activity_audit`.`user_id`
`activity_audit`.`username`
`activity_audit`.`action_type`
`activity_audit`.`entity_type`
`activity_audit`.`entity_id`
`activity_audit`.`summary`
`activity_audit`.`details_json`
`booking_visitor_history`.*
`booking_visitor_history`.`visitor_record_id`
`booking_visitor_history`.`booking_id`
`booking_visitor_history`.`id_card`
`booking_visitor_history`.`visitor_name`
`booking_visitor_history`.`inmate_name`
`booking_visitor_history`.`booking_date`
`booking_visitor_history`.`booking_round`
`booking_visitor_history`.`recorded_at`
`booking_visitors`.*
`booking_visitors`.`id`
`booking_visitors`.`booking_id`
`booking_visitors`.`visitor_name`
`booking_visitors`.`id_card`
`booking_visitors`.`created_at`
`bookings`.*
`bookings`.`id`
`bookings`.`inmate_name`
`bookings`.`relative_name`
`bookings`.`booking_date`
`bookings`.`booking_round`
`bookings`.`booking_round_id`
`bookings`.`booking_note`
`bookings`.`created_at`
`inmate_deletion_archive`.*
`inmate_deletion_archive`.`id`
`inmate_deletion_archive`.`inmate_id`
`inmate_deletion_archive`.`inmate_code`
`inmate_deletion_archive`.`inmate_name`
`inmate_deletion_archive`.`record_json`
`inmate_deletion_archive`.`deleted_by`
`inmate_deletion_archive`.`deleted_at`
`inmate_relative_history`.*
`inmate_relative_history`.`id`
`inmate_relative_history`.`inmate_id`
`inmate_relative_history`.`inmate_name`
`inmate_relative_history`.`event_day`
`inmate_relative_history`.`recorded_at`
`inmate_relative_history`.`actor_id`
`inmate_relative_history`.`before_json`
`inmate_relative_history`.`after_json`
`inmate_relative_relationships`.*
`inmate_relative_relationships`.`id`
`inmate_relative_relationships`.`inmate_code`
`inmate_relative_relationships`.`inmate_name`
`inmate_relative_relationships`.`slot_no`
`inmate_relative_relationships`.`relative_name`
`inmate_relative_relationships`.`relationship`
`inmate_relative_relationships`.`created_at`
`inmate_relative_relationships`.`updated_at`
`inmate_review_relatives`.*
`inmate_review_relatives`.`id`
`inmate_review_relatives`.`roster_key`
`inmate_review_relatives`.`relative_no`
`inmate_review_relatives`.`relative_name`
`inmate_review_relatives`.`relationship`
`inmate_review_relatives`.`created_at`
`inmate_review_roster`.*
`inmate_review_roster`.`id`
`inmate_review_roster`.`roster_key`
`inmate_review_roster`.`source_sheet`
`inmate_review_roster`.`source_row`
`inmate_review_roster`.`source_seq`
`inmate_review_roster`.`inmate_prefix`
`inmate_review_roster`.`inmate_name`
`inmate_review_roster`.`sex`
`inmate_review_roster`.`review_status`
`inmate_review_roster`.`reviewed_at`
`inmate_review_roster`.`created_at`
`inmates`.*
`inmates`.`id`
`inmates`.`inmate_fullname`
`inmates`.`inmate_gender`
`inmates`.`inmate_code`
`inmates`.`deposit_account_no`
`inmates`.`inmate_id_card`
`inmates`.`inmate_race`
`inmates`.`inmate_nationality`
`inmates`.`inmate_age`
`inmates`.`inmate_address`
`inmates`.`relative_name_1`
`inmates`.`relative_name_2`
`inmates`.`relative_name_3`
`inmates`.`relative_name_4`
`inmates`.`relative_name_5`
`inmates`.`relative_name_6`
`inmates`.`relative_name_7`
`inmates`.`relative_name_8`
`inmates`.`relative_name_9`
`inmates`.`relative_name_10`
`inmates`.`photo_path`
`inmates`.`created_at`
`inmates`.`rel_updated_1`
`inmates`.`rel_updated_2`
`inmates`.`rel_updated_3`
`inmates`.`rel_updated_4`
`inmates`.`rel_updated_5`
`inmates`.`rel_updated_6`
`inmates`.`rel_updated_7`
`inmates`.`rel_updated_8`
`inmates`.`rel_updated_9`
`inmates`.`rel_updated_10`
`inmates`.`relative_updated_1`
`inmates`.`relative_updated_2`
`inmates`.`relative_updated_3`
`inmates`.`relative_updated_4`
`inmates`.`relative_updated_5`
`inmates`.`relative_updated_6`
`inmates`.`relative_updated_7`
`inmates`.`relative_updated_8`
`inmates`.`relative_updated_9`
`inmates`.`relative_updated_10`
`inmates`.`relative_name_11`
`inmates`.`relative_updated_11`
`inmates`.`relative_name_12`
`inmates`.`relative_updated_12`
`inmates`.`relative_name_13`
`inmates`.`relative_updated_13`
`inmates`.`relative_name_14`
`inmates`.`relative_updated_14`
`inmates`.`relative_name_15`
`inmates`.`relative_updated_15`
`inmates`.`relative_name_16`
`inmates`.`relative_updated_16`
`relatives`.*
`relatives`.`id`
`relatives`.`id_card`
`relatives`.`fullname`
`relatives`.`race`
`relatives`.`nationality`
`relatives`.`age`
`relatives`.`address`
`relatives`.`phone`
`relatives`.`inmate_name`
`relatives`.`photo`
`relatives`.`created_at`
`relatives`.`updated_at`
`relatives`.`inmate_code`
`relatives`.`relationship`
`user_permissions`.*
`user_permissions`.`id`
`user_permissions`.`user_id`
`user_permissions`.`permission_key`
`user_permissions`.`is_allowed`
`user_permissions`.`updated_at`
`users`.*
`users`.`id`
`users`.`id_card`
`users`.`username`
`users`.`password`
`users`.`firstname`
`users`.`lastname`
`users`.`phone`
`users`.`role`
`users`.`created_at`
`vip_visit_audit`.*
`vip_visit_audit`.`id`
`vip_visit_audit`.`user_id`
`vip_visit_audit`.`username`
`vip_visit_audit`.`action`
`vip_visit_audit`.`details`
`vip_visit_audit`.`created_at`
`vip_visit_grants`.*
`vip_visit_grants`.`id`
`vip_visit_grants`.`inmate_id`
`vip_visit_grants`.`inmate_code`
`vip_visit_grants`.`inmate_name`
`vip_visit_grants`.`visit_date`
`vip_visit_grants`.`note`
`vip_visit_grants`.`granted_by`
`vip_visit_grants`.`granted_username`
`vip_visit_grants`.`granted_at`
`vip_visit_grants`.`revoked_at`
`vip_visit_grants`.`revoked_by`
`visit_discipline_suspensions`.*
`visit_discipline_suspensions`.`id`
`visit_discipline_suspensions`.`inmate_name`
`visit_discipline_suspensions`.`inmate_code`
`visit_discipline_suspensions`.`offense`
`visit_discipline_suspensions`.`start_date`
`visit_discipline_suspensions`.`end_date`
`visit_discipline_suspensions`.`order_no`
`visit_discipline_suspensions`.`note`
`visit_discipline_suspensions`.`created_at`
`visit_discipline_suspensions`.`updated_at`
`visit_rounds`.*
`visit_rounds`.`id`
`visit_rounds`.`period`
`visit_rounds`.`round_no`
`visit_rounds`.`start_time`
`visit_rounds`.`end_time`
`visit_rounds`.`gender`
`visit_rounds`.`capacity`
`visit_rounds`.`is_active`
`visit_rounds`.`sort_order`
`visit_settings`.*
`visit_settings`.`setting_key`
`visit_settings`.`setting_value`
`visit_settings`.`updated_at`
`visitors`.*
`visitors`.`id`
`visitors`.`fullname`
`visitors`.`race`
`visitors`.`nationality`
`visitors`.`age`
`visitors`.`address`
`visitors`.`phone`
`visitors`.`inmate_name`
`visitors`.`photo`
`visitors`.`created_at`
`activity_audit`.*
`activity_audit`.`id`
`activity_audit`.`occurred_at`
`activity_audit`.`user_id`
`activity_audit`.`username`
`activity_audit`.`action_type`
`activity_audit`.`entity_type`
`activity_audit`.`entity_id`
`activity_audit`.`summary`
`activity_audit`.`details_json`
`booking_visitor_history`.*
`booking_visitor_history`.`visitor_record_id`
`booking_visitor_history`.`booking_id`
`booking_visitor_history`.`id_card`
`booking_visitor_history`.`visitor_name`
`booking_visitor_history`.`inmate_name`
`booking_visitor_history`.`booking_date`
`booking_visitor_history`.`booking_round`
`booking_visitor_history`.`recorded_at`
`booking_visitors`.*
`booking_visitors`.`id`
`booking_visitors`.`booking_id`
`booking_visitors`.`visitor_name`
`booking_visitors`.`id_card`
`booking_visitors`.`created_at`
`bookings`.*
`bookings`.`id`
`bookings`.`inmate_name`
`bookings`.`relative_name`
`bookings`.`booking_date`
`bookings`.`booking_round`
`bookings`.`booking_round_id`
`bookings`.`booking_note`
`bookings`.`created_at`
`inmate_deletion_archive`.*
`inmate_deletion_archive`.`id`
`inmate_deletion_archive`.`inmate_id`
`inmate_deletion_archive`.`inmate_code`
`inmate_deletion_archive`.`inmate_name`
`inmate_deletion_archive`.`record_json`
`inmate_deletion_archive`.`deleted_by`
`inmate_deletion_archive`.`deleted_at`
`inmate_relative_history`.*
`inmate_relative_history`.`id`
`inmate_relative_history`.`inmate_id`
`inmate_relative_history`.`inmate_name`
`inmate_relative_history`.`event_day`
`inmate_relative_history`.`recorded_at`
`inmate_relative_history`.`actor_id`
`inmate_relative_history`.`before_json`
`inmate_relative_history`.`after_json`
`inmate_relative_relationships`.*
`inmate_relative_relationships`.`id`
`inmate_relative_relationships`.`inmate_code`
`inmate_relative_relationships`.`inmate_name`
`inmate_relative_relationships`.`slot_no`
`inmate_relative_relationships`.`relative_name`
`inmate_relative_relationships`.`relationship`
`inmate_relative_relationships`.`created_at`
`inmate_relative_relationships`.`updated_at`
`inmate_review_relatives`.*
`inmate_review_relatives`.`id`
`inmate_review_relatives`.`roster_key`
`inmate_review_relatives`.`relative_no`
`inmate_review_relatives`.`relative_name`
`inmate_review_relatives`.`relationship`
`inmate_review_relatives`.`created_at`
`inmate_review_roster`.*
`inmate_review_roster`.`id`
`inmate_review_roster`.`roster_key`
`inmate_review_roster`.`source_sheet`
`inmate_review_roster`.`source_row`
`inmate_review_roster`.`source_seq`
`inmate_review_roster`.`inmate_prefix`
`inmate_review_roster`.`inmate_name`
`inmate_review_roster`.`sex`
`inmate_review_roster`.`review_status`
`inmate_review_roster`.`reviewed_at`
`inmate_review_roster`.`created_at`
`inmates`.*
`inmates`.`id`
`inmates`.`inmate_fullname`
`inmates`.`inmate_gender`
`inmates`.`inmate_code`
`inmates`.`deposit_account_no`
`inmates`.`inmate_id_card`
`inmates`.`inmate_race`
`inmates`.`inmate_nationality`
`inmates`.`inmate_age`
`inmates`.`inmate_address`
`inmates`.`relative_name_1`
`inmates`.`relative_name_2`
`inmates`.`relative_name_3`
`inmates`.`relative_name_4`
`inmates`.`relative_name_5`
`inmates`.`relative_name_6`
`inmates`.`relative_name_7`
`inmates`.`relative_name_8`
`inmates`.`relative_name_9`
`inmates`.`relative_name_10`
`inmates`.`photo_path`
`inmates`.`created_at`
`inmates`.`rel_updated_1`
`inmates`.`rel_updated_2`
`inmates`.`rel_updated_3`
`inmates`.`rel_updated_4`
`inmates`.`rel_updated_5`
`inmates`.`rel_updated_6`
`inmates`.`rel_updated_7`
`inmates`.`rel_updated_8`
`inmates`.`rel_updated_9`
`inmates`.`rel_updated_10`
`inmates`.`relative_updated_1`
`inmates`.`relative_updated_2`
`inmates`.`relative_updated_3`
`inmates`.`relative_updated_4`
`inmates`.`relative_updated_5`
`inmates`.`relative_updated_6`
`inmates`.`relative_updated_7`
`inmates`.`relative_updated_8`
`inmates`.`relative_updated_9`
`inmates`.`relative_updated_10`
`inmates`.`relative_name_11`
`inmates`.`relative_updated_11`
`inmates`.`relative_name_12`
`inmates`.`relative_updated_12`
`inmates`.`relative_name_13`
`inmates`.`relative_updated_13`
`inmates`.`relative_name_14`
`inmates`.`relative_updated_14`
`inmates`.`relative_name_15`
`inmates`.`relative_updated_15`
`inmates`.`relative_name_16`
`inmates`.`relative_updated_16`
`relatives`.*
`relatives`.`id`
`relatives`.`id_card`
`relatives`.`fullname`
`relatives`.`race`
`relatives`.`nationality`
`relatives`.`age`
`relatives`.`address`
`relatives`.`phone`
`relatives`.`inmate_name`
`relatives`.`photo`
`relatives`.`created_at`
`relatives`.`updated_at`
`relatives`.`inmate_code`
`relatives`.`relationship`
`user_permissions`.*
`user_permissions`.`id`
`user_permissions`.`user_id`
`user_permissions`.`permission_key`
`user_permissions`.`is_allowed`
`user_permissions`.`updated_at`
`users`.*
`users`.`id`
`users`.`id_card`
`users`.`username`
`users`.`password`
`users`.`firstname`
`users`.`lastname`
`users`.`phone`
`users`.`role`
`users`.`created_at`
`vip_visit_audit`.*
`vip_visit_audit`.`id`
`vip_visit_audit`.`user_id`
`vip_visit_audit`.`username`
`vip_visit_audit`.`action`
`vip_visit_audit`.`details`
`vip_visit_audit`.`created_at`
`vip_visit_grants`.*
`vip_visit_grants`.`id`
`vip_visit_grants`.`inmate_id`
`vip_visit_grants`.`inmate_code`
`vip_visit_grants`.`inmate_name`
`vip_visit_grants`.`visit_date`
`vip_visit_grants`.`note`
`vip_visit_grants`.`granted_by`
`vip_visit_grants`.`granted_username`
`vip_visit_grants`.`granted_at`
`vip_visit_grants`.`revoked_at`
`vip_visit_grants`.`revoked_by`
`visit_discipline_suspensions`.*
`visit_discipline_suspensions`.`id`
`visit_discipline_suspensions`.`inmate_name`
`visit_discipline_suspensions`.`inmate_code`
`visit_discipline_suspensions`.`offense`
`visit_discipline_suspensions`.`start_date`
`visit_discipline_suspensions`.`end_date`
`visit_discipline_suspensions`.`order_no`
`visit_discipline_suspensions`.`note`
`visit_discipline_suspensions`.`created_at`
`visit_discipline_suspensions`.`updated_at`
`visit_rounds`.*
`visit_rounds`.`id`
`visit_rounds`.`period`
`visit_rounds`.`round_no`
`visit_rounds`.`start_time`
`visit_rounds`.`end_time`
`visit_rounds`.`gender`
`visit_rounds`.`capacity`
`visit_rounds`.`is_active`
`visit_rounds`.`sort_order`
`visit_settings`.*
`visit_settings`.`setting_key`
`visit_settings`.`setting_value`
`visit_settings`.`updated_at`
`visitors`.*
`visitors`.`id`
`visitors`.`fullname`
`visitors`.`race`
`visitors`.`nationality`
`visitors`.`age`
`visitors`.`address`
`visitors`.`phone`
`visitors`.`inmate_name`
`visitors`.`photo`
`visitors`.`created_at`
`activity_audit`.*
`activity_audit`.`id`
`activity_audit`.`occurred_at`
`activity_audit`.`user_id`
`activity_audit`.`username`
`activity_audit`.`action_type`
`activity_audit`.`entity_type`
`activity_audit`.`entity_id`
`activity_audit`.`summary`
`activity_audit`.`details_json`
`booking_visitor_history`.*
`booking_visitor_history`.`visitor_record_id`
`booking_visitor_history`.`booking_id`
`booking_visitor_history`.`id_card`
`booking_visitor_history`.`visitor_name`
`booking_visitor_history`.`inmate_name`
`booking_visitor_history`.`booking_date`
`booking_visitor_history`.`booking_round`
`booking_visitor_history`.`recorded_at`
`booking_visitors`.*
`booking_visitors`.`id`
`booking_visitors`.`booking_id`
`booking_visitors`.`visitor_name`
`booking_visitors`.`id_card`
`booking_visitors`.`created_at`
`bookings`.*
`bookings`.`id`
`bookings`.`inmate_name`
`bookings`.`relative_name`
`bookings`.`booking_date`
`bookings`.`booking_round`
`bookings`.`booking_round_id`
`bookings`.`booking_note`
`bookings`.`created_at`
`inmate_deletion_archive`.*
`inmate_deletion_archive`.`id`
`inmate_deletion_archive`.`inmate_id`
`inmate_deletion_archive`.`inmate_code`
`inmate_deletion_archive`.`inmate_name`
`inmate_deletion_archive`.`record_json`
`inmate_deletion_archive`.`deleted_by`
`inmate_deletion_archive`.`deleted_at`
`inmate_relative_history`.*
`inmate_relative_history`.`id`
`inmate_relative_history`.`inmate_id`
`inmate_relative_history`.`inmate_name`
`inmate_relative_history`.`event_day`
`inmate_relative_history`.`recorded_at`
`inmate_relative_history`.`actor_id`
`inmate_relative_history`.`before_json`
`inmate_relative_history`.`after_json`
`inmate_relative_relationships`.*
`inmate_relative_relationships`.`id`
`inmate_relative_relationships`.`inmate_code`
`inmate_relative_relationships`.`inmate_name`
`inmate_relative_relationships`.`slot_no`
`inmate_relative_relationships`.`relative_name`
`inmate_relative_relationships`.`relationship`
`inmate_relative_relationships`.`created_at`
`inmate_relative_relationships`.`updated_at`
`inmate_review_relatives`.*
`inmate_review_relatives`.`id`
`inmate_review_relatives`.`roster_key`
`inmate_review_relatives`.`relative_no`
`inmate_review_relatives`.`relative_name`
`inmate_review_relatives`.`relationship`
`inmate_review_relatives`.`created_at`
`inmate_review_roster`.*
`inmate_review_roster`.`id`
`inmate_review_roster`.`roster_key`
`inmate_review_roster`.`source_sheet`
`inmate_review_roster`.`source_row`
`inmate_review_roster`.`source_seq`
`inmate_review_roster`.`inmate_prefix`
`inmate_review_roster`.`inmate_name`
`inmate_review_roster`.`sex`
`inmate_review_roster`.`review_status`
`inmate_review_roster`.`reviewed_at`
`inmate_review_roster`.`created_at`
`inmates`.*
`inmates`.`id`
`inmates`.`inmate_fullname`
`inmates`.`inmate_gender`
`inmates`.`inmate_code`
`inmates`.`deposit_account_no`
`inmates`.`inmate_id_card`
`inmates`.`inmate_race`
`inmates`.`inmate_nationality`
`inmates`.`inmate_age`
`inmates`.`inmate_address`
`inmates`.`relative_name_1`
`inmates`.`relative_name_2`
`inmates`.`relative_name_3`
`inmates`.`relative_name_4`
`inmates`.`relative_name_5`
`inmates`.`relative_name_6`
`inmates`.`relative_name_7`
`inmates`.`relative_name_8`
`inmates`.`relative_name_9`
`inmates`.`relative_name_10`
`inmates`.`photo_path`
`inmates`.`created_at`
`inmates`.`rel_updated_1`
`inmates`.`rel_updated_2`
`inmates`.`rel_updated_3`
`inmates`.`rel_updated_4`
`inmates`.`rel_updated_5`
`inmates`.`rel_updated_6`
`inmates`.`rel_updated_7`
`inmates`.`rel_updated_8`
`inmates`.`rel_updated_9`
`inmates`.`rel_updated_10`
`inmates`.`relative_updated_1`
`inmates`.`relative_updated_2`
`inmates`.`relative_updated_3`
`inmates`.`relative_updated_4`
`inmates`.`relative_updated_5`
`inmates`.`relative_updated_6`
`inmates`.`relative_updated_7`
`inmates`.`relative_updated_8`
`inmates`.`relative_updated_9`
`inmates`.`relative_updated_10`
`inmates`.`relative_name_11`
`inmates`.`relative_updated_11`
`inmates`.`relative_name_12`
`inmates`.`relative_updated_12`
`inmates`.`relative_name_13`
`inmates`.`relative_updated_13`
`inmates`.`relative_name_14`
`inmates`.`relative_updated_14`
`inmates`.`relative_name_15`
`inmates`.`relative_updated_15`
`inmates`.`relative_name_16`
`inmates`.`relative_updated_16`
`relatives`.*
`relatives`.`id`
`relatives`.`id_card`
`relatives`.`fullname`
`relatives`.`race`
`relatives`.`nationality`
`relatives`.`age`
`relatives`.`address`
`relatives`.`phone`
`relatives`.`inmate_name`
`relatives`.`photo`
`relatives`.`created_at`
`relatives`.`updated_at`
`relatives`.`inmate_code`
`relatives`.`relationship`
`user_permissions`.*
`user_permissions`.`id`
`user_permissions`.`user_id`
`user_permissions`.`permission_key`
`user_permissions`.`is_allowed`
`user_permissions`.`updated_at`
`users`.*
`users`.`id`
`users`.`id_card`
`users`.`username`
`users`.`password`
`users`.`firstname`
`users`.`lastname`
`users`.`phone`
`users`.`role`
`users`.`created_at`
`vip_visit_audit`.*
`vip_visit_audit`.`id`
`vip_visit_audit`.`user_id`
`vip_visit_audit`.`username`
`vip_visit_audit`.`action`
`vip_visit_audit`.`details`
`vip_visit_audit`.`created_at`
`vip_visit_grants`.*
`vip_visit_grants`.`id`
`vip_visit_grants`.`inmate_id`
`vip_visit_grants`.`inmate_code`
`vip_visit_grants`.`inmate_name`
`vip_visit_grants`.`visit_date`
`vip_visit_grants`.`note`
`vip_visit_grants`.`granted_by`
`vip_visit_grants`.`granted_username`
`vip_visit_grants`.`granted_at`
`vip_visit_grants`.`revoked_at`
`vip_visit_grants`.`revoked_by`
`visit_discipline_suspensions`.*
`visit_discipline_suspensions`.`id`
`visit_discipline_suspensions`.`inmate_name`
`visit_discipline_suspensions`.`inmate_code`
`visit_discipline_suspensions`.`offense`
`visit_discipline_suspensions`.`start_date`
`visit_discipline_suspensions`.`end_date`
`visit_discipline_suspensions`.`order_no`
`visit_discipline_suspensions`.`note`
`visit_discipline_suspensions`.`created_at`
`visit_discipline_suspensions`.`updated_at`
`visit_rounds`.*
`visit_rounds`.`id`
`visit_rounds`.`period`
`visit_rounds`.`round_no`
`visit_rounds`.`start_time`
`visit_rounds`.`end_time`
`visit_rounds`.`gender`
`visit_rounds`.`capacity`
`visit_rounds`.`is_active`
`visit_rounds`.`sort_order`
`visit_settings`.*
`visit_settings`.`setting_key`
`visit_settings`.`setting_value`
`visit_settings`.`updated_at`
`visitors`.*
`visitors`.`id`
`visitors`.`fullname`
`visitors`.`race`
`visitors`.`nationality`
`visitors`.`age`
`visitors`.`address`
`visitors`.`phone`
`visitors`.`inmate_name`
`visitors`.`photo`
`visitors`.`created_at`
别名:
显示:
排序:
递增
递减
递增
递减
递增
递减
排序规则:
1
2
3
1
2
3
1
2
3
条件:
插入:
且:
删除:
或:
修改:
或:
且:
插入
删除
或:
且:
插入
删除
插入
删除
添加/删除标准行:
-3
-2
-1
0
1
2
3
添加/删除字段:
-3
-2
-1
0
1
2
3
使用表
activity_audit
booking_visitor_history
booking_visitors
bookings
inmate_deletion_archive
inmate_relative_history
inmate_relative_relationships
inmate_review_relatives
inmate_review_roster
inmates
relatives
user_permissions
users
vip_visit_audit
vip_visit_grants
visit_discipline_suspensions
visit_rounds
visit_settings
visitors
在数据库
prison_db_8080
执行 SQL 语句: