将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
未命名 *
v 显示/隐藏表格列表 全屏查看 从其他数据库中添加表 新页面 打开页面 保存页面 保存页面为 删除页 新建数据表 创建关系 选择要显示的字段 重新载入 帮助 折角连接 / 直接连接 对齐网格 v 全部收缩/展开 反向收缩/展开 显示/隐藏关系线 导出架构 > 移动菜单 > 固定文字
数据表数量: 0
v peopleteam_HESK hesk_attachments
* att_id : mediumint(8) unsigned
* ticket_id : varchar(13)
* saved_name : varchar(255)
* real_name : varchar(255)
* size : int(10) unsigned
* type : enum('0','1')
v peopleteam_HESK hesk_auth_tokens
* id : int(11) unsigned
* selector : char(12)
* token : char(64)
* user_id : smallint(5) unsigned
* created : timestamp
* expires : timestamp
v peopleteam_HESK hesk_banned_emails
* id : smallint(5) unsigned
* email : varchar(255)
* banned_by : smallint(5) unsigned
* dt : timestamp
v peopleteam_HESK hesk_banned_ips
* id : smallint(5) unsigned
* ip_from : int(10) unsigned
* ip_to : int(10) unsigned
* ip_display : varchar(100)
* banned_by : smallint(5) unsigned
* dt : timestamp
v peopleteam_HESK hesk_categories
* id : smallint(5) unsigned
* name : varchar(255)
* cat_order : smallint(5) unsigned
* autoassign : enum('0','1')
* autoassign_config : varchar(1000)
* type : enum('0','1')
* priority : enum('0','1','2','3')
* default_due_date_amount : int(11)
* default_due_date_unit : varchar(10)
v peopleteam_HESK hesk_custom_fields
* id : tinyint(3) unsigned
* use : enum('0','1','2')
* place : enum('0','1')
* type : varchar(20)
* req : enum('0','1','2')
* category : text
* name : text
* value : text
* order : smallint(5) unsigned
v peopleteam_HESK hesk_custom_statuses
* id : tinyint(3) unsigned
* name : text
* color : varchar(6)
* can_customers_change : enum('0','1')
* order : smallint(5) unsigned
v peopleteam_HESK hesk_kb_articles
* id : smallint(5) unsigned
* catid : smallint(5) unsigned
* dt : timestamp
* author : smallint(5) unsigned
* subject : varchar(255)
* content : mediumtext
* keywords : mediumtext
* rating : float
* votes : mediumint(8) unsigned
* views : mediumint(8) unsigned
* type : enum('0','1','2')
* html : enum('0','1')
* sticky : enum('0','1')
* art_order : smallint(5) unsigned
* history : mediumtext
* attachments : mediumtext
v peopleteam_HESK hesk_kb_attachments
* att_id : mediumint(8) unsigned
* saved_name : varchar(255)
* real_name : varchar(255)
* size : int(10) unsigned
v peopleteam_HESK hesk_kb_categories
* id : smallint(5) unsigned
* name : varchar(255)
* parent : smallint(5) unsigned
* articles : smallint(5) unsigned
* articles_private : smallint(5) unsigned
* articles_draft : smallint(5) unsigned
* cat_order : smallint(5) unsigned
* type : enum('0','1')
v peopleteam_HESK hesk_logins
* id : int(10) unsigned
* ip : varchar(45)
* number : tinyint(3) unsigned
* last_attempt : timestamp
v peopleteam_HESK hesk_log_overdue
* id : int(10) unsigned
* dt : timestamp
* ticket : mediumint(8) unsigned
* category : smallint(5) unsigned
* priority : enum('0','1','2','3')
* status : tinyint(3) unsigned
* owner : smallint(5) unsigned
* due_date : timestamp
* comments : varchar(255)
v peopleteam_HESK hesk_mail
* id : int(10) unsigned
* from : smallint(5) unsigned
* to : smallint(5) unsigned
* subject : varchar(255)
* message : mediumtext
* dt : timestamp
* read : enum('0','1')
* deletedby : smallint(5) unsigned
v peopleteam_HESK hesk_mfa_backup_codes
* id : int(10) unsigned
* dt : timestamp
* user_id : smallint(5) unsigned
* code : varchar(255)
v peopleteam_HESK hesk_mfa_verification_tokens
* id : int(10) unsigned
* user_id : smallint(5) unsigned
* verification_token : varchar(255)
* expires_at : timestamp
v peopleteam_HESK hesk_notes
* id : mediumint(8) unsigned
* ticket : mediumint(8) unsigned
* who : smallint(5) unsigned
* dt : timestamp
* message : mediumtext
* attachments : mediumtext
v peopleteam_HESK hesk_oauth_providers
* id : int(11) unsigned
* name : varchar(255)
* authorization_url : text
* token_url : text
* client_id : text
* client_secret : text
* scope : text
* no_val_ssl : tinyint(4)
* verified : smallint(6)
v peopleteam_HESK hesk_oauth_tokens
* id : int(11) unsigned
* provider_id : int(11)
* token_value : text
* token_type : varchar(32)
* created : timestamp
* expires : timestamp
v peopleteam_HESK hesk_online
* id : int(10) unsigned
* user_id : smallint(5) unsigned
* dt : timestamp
* tmp : int(11) unsigned
v peopleteam_HESK hesk_pipe_loops
* id : int(10) unsigned
* email : varchar(255)
* hits : smallint(1) unsigned
* message_hash : char(32)
* dt : timestamp
v peopleteam_HESK hesk_replies
* id : mediumint(8) unsigned
* replyto : mediumint(8) unsigned
* name : varchar(255)
* message : mediumtext
* message_html : mediumtext
* dt : timestamp
* attachments : mediumtext
* staffid : smallint(5) unsigned
* rating : enum('1','5')
* read : enum('0','1')
v peopleteam_HESK hesk_reply_drafts
* id : int(10) unsigned
* owner : smallint(5) unsigned
* ticket : mediumint(8) unsigned
* message : mediumtext
* message_html : mediumtext
* dt : timestamp
v peopleteam_HESK hesk_reset_password
* id : mediumint(8) unsigned
* user : smallint(5) unsigned
* hash : char(40)
* ip : varchar(45)
* dt : timestamp
v peopleteam_HESK hesk_service_messages
* id : smallint(5) unsigned
* dt : timestamp
* author : smallint(5) unsigned
* title : varchar(255)
* message : mediumtext
* language : varchar(50)
* style : enum('0','1','2','3','4')
* type : enum('0','1')
* order : smallint(5) unsigned
v peopleteam_HESK hesk_std_replies
* id : smallint(5) unsigned
* title : varchar(100)
* message : mediumtext
* message_html : mediumtext
* reply_order : smallint(5) unsigned
v peopleteam_HESK hesk_temp_attachments
* att_id : mediumint(8) unsigned
* unique_id : varchar(255)
* saved_name : varchar(255)
* real_name : varchar(255)
* size : int(10) unsigned
* expires_at : timestamp
v peopleteam_HESK hesk_temp_attachments_limits
* ip : varchar(45)
* upload_count : int(10) unsigned
* last_upload_at : timestamp
v peopleteam_HESK hesk_tickets
* id : mediumint(8) unsigned
* trackid : varchar(13)
* name : varchar(255)
* email : varchar(1000)
* category : smallint(5) unsigned
* priority : enum('0','1','2','3')
* subject : varchar(255)
* message : mediumtext
* message_html : mediumtext
* dt : timestamp
* lastchange : timestamp
* firstreply : timestamp
* closedat : timestamp
* articles : varchar(255)
* ip : varchar(45)
* language : varchar(50)
* status : tinyint(3) unsigned
* openedby : mediumint(8)
* firstreplyby : smallint(5) unsigned
* closedby : mediumint(8)
* replies : smallint(5) unsigned
* staffreplies : smallint(5) unsigned
* owner : smallint(5) unsigned
* assignedby : mediumint(8)
* time_worked : time
* lastreplier : enum('0','1')
* replierid : smallint(5) unsigned
* archive : enum('0','1')
* locked : enum('0','1')
* attachments : mediumtext
* merged : mediumtext
* history : mediumtext
* custom1 : mediumtext
* custom2 : mediumtext
* custom3 : mediumtext
* custom4 : mediumtext
* custom5 : mediumtext
* custom6 : mediumtext
* custom7 : mediumtext
* custom8 : mediumtext
* custom9 : mediumtext
* custom10 : mediumtext
* custom11 : mediumtext
* custom12 : mediumtext
* custom13 : mediumtext
* custom14 : mediumtext
* custom15 : mediumtext
* custom16 : mediumtext
* custom17 : mediumtext
* custom18 : mediumtext
* custom19 : mediumtext
* custom20 : mediumtext
* custom21 : mediumtext
* custom22 : mediumtext
* custom23 : mediumtext
* custom24 : mediumtext
* custom25 : mediumtext
* custom26 : mediumtext
* custom27 : mediumtext
* custom28 : mediumtext
* custom29 : mediumtext
* custom30 : mediumtext
* custom31 : mediumtext
* custom32 : mediumtext
* custom33 : mediumtext
* custom34 : mediumtext
* custom35 : mediumtext
* custom36 : mediumtext
* custom37 : mediumtext
* custom38 : mediumtext
* custom39 : mediumtext
* custom40 : mediumtext
* custom41 : mediumtext
* custom42 : mediumtext
* custom43 : mediumtext
* custom44 : mediumtext
* custom45 : mediumtext
* custom46 : mediumtext
* custom47 : mediumtext
* custom48 : mediumtext
* custom49 : mediumtext
* custom50 : mediumtext
* due_date : timestamp
* overdue_email_sent : tinyint(1)
* satisfaction_email_sent : tinyint(1)
* satisfaction_email_dt : timestamp
v peopleteam_HESK hesk_ticket_templates
* id : smallint(5) unsigned
* title : varchar(100)
* message : mediumtext
* message_html : mediumtext
* tpl_order : smallint(5) unsigned
v peopleteam_HESK hesk_users
* id : smallint(5) unsigned
* user : varchar(255)
* pass : varchar(255)
* isadmin : enum('0','1')
* name : varchar(255)
* email : varchar(255)
* signature : varchar(1000)
* language : varchar(50)
* categories : varchar(500)
* afterreply : enum('0','1','2')
* autostart : enum('0','1')
* autoreload : smallint(5) unsigned
* notify_customer_new : enum('0','1')
* notify_customer_reply : enum('0','1')
* show_suggested : enum('0','1')
* notify_new_unassigned : enum('0','1')
* notify_new_my : enum('0','1')
* notify_reply_unassigned : enum('0','1')
* notify_reply_my : enum('0','1')
* notify_assigned : enum('0','1')
* notify_pm : enum('0','1')
* notify_note : enum('0','1')
* notify_overdue_unassigned : enum('0','1')
* notify_overdue_my : enum('0','1')
* default_list : varchar(255)
* autoassign : enum('0','1')
* heskprivileges : varchar(1000)
* ratingneg : mediumint(8) unsigned
* ratingpos : mediumint(8) unsigned
* rating : float
* replies : mediumint(8) unsigned
* mfa_enrollment : smallint(5) unsigned
* mfa_secret : varchar(255)
创建关系
FOREIGN KEY
on delete
on update
删除关系