win-krggb4nf1fa.tailfded65.ts.net / 127.0.0.1 / osticket_db

There are no favorite tables.

Customize 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`).
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.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize 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 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 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 display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

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 :

Untitled *

v		osticket_db ost_api_key
id : int(10) unsigned
isactive : tinyint(1)
ipaddr : varchar(64)
apikey : varchar(255)
can_create_tickets : tinyint(1) unsigned
can_exec_cron : tinyint(1) unsigned
notes : text
updated : datetime
created : datetime

v		osticket_db ost_attachment
id : int(10) unsigned
object_id : int(11) unsigned
type : char(1)
file_id : int(11) unsigned
name : varchar(255)
inline : tinyint(1) unsigned
lang : varchar(16)

v		osticket_db ost_canned_response
canned_id : int(10) unsigned
dept_id : int(10) unsigned
isenabled : tinyint(1) unsigned
title : varchar(255)
response : text
lang : varchar(16)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_config
id : int(11) unsigned
namespace : varchar(64)
key : varchar(64)
value : text
updated : timestamp

v		osticket_db ost_content
id : int(10) unsigned
isactive : tinyint(1) unsigned
type : varchar(32)
name : varchar(255)
body : text
notes : text
created : datetime
updated : datetime

v		osticket_db ost_department
id : int(11) unsigned
pid : int(11) unsigned
tpl_id : int(10) unsigned
sla_id : int(10) unsigned
schedule_id : int(10) unsigned
email_id : int(10) unsigned
autoresp_email_id : int(10) unsigned
manager_id : int(10) unsigned
flags : int(10) unsigned
name : varchar(128)
signature : text
ispublic : tinyint(1) unsigned
group_membership : tinyint(1)
ticket_auto_response : tinyint(1)
message_auto_response : tinyint(1)
path : varchar(128)
updated : datetime
created : datetime

v		osticket_db ost_draft
id : int(11) unsigned
staff_id : int(11) unsigned
namespace : varchar(32)
body : text
extra : text
created : timestamp
updated : timestamp

v		osticket_db ost_email
email_id : int(11) unsigned
noautoresp : tinyint(1) unsigned
priority_id : int(11) unsigned
dept_id : int(11) unsigned
topic_id : int(11) unsigned
email : varchar(255)
name : varchar(255)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_email_account
id : int(11) unsigned
email_id : int(11) unsigned
type : enum('mailbox','smtp')
auth_bk : varchar(128)
auth_id : varchar(16)
active : tinyint(1) unsigned
host : varchar(128)
port : int(11)
folder : varchar(255)
protocol : enum('IMAP','POP','SMTP','OTHER')
encryption : enum('NONE','AUTO','SSL')
fetchfreq : tinyint(3) unsigned
fetchmax : tinyint(4) unsigned
postfetch : enum('archive','delete','nothing')
archivefolder : varchar(255)
allow_spoofing : tinyint(1) unsigned
num_errors : int(11) unsigned
last_error_msg : tinytext
last_error : datetime
last_activity : datetime
created : datetime
updated : datetime

v		osticket_db ost_email_template
id : int(11) unsigned
tpl_id : int(11) unsigned
code_name : varchar(32)
subject : varchar(255)
body : text
notes : text
created : datetime
updated : datetime

v		osticket_db ost_email_template_group
tpl_id : int(11)
isactive : tinyint(1) unsigned
name : varchar(32)
lang : varchar(16)
notes : text
created : datetime
updated : timestamp

v		osticket_db ost_event
id : int(10) unsigned
name : varchar(60)
description : varchar(60)

v		osticket_db ost_faq
faq_id : int(10) unsigned
category_id : int(10) unsigned
ispublished : tinyint(1) unsigned
question : varchar(255)
answer : text
keywords : tinytext
notes : text
created : datetime
updated : datetime

v		osticket_db ost_faq_category
category_id : int(10) unsigned
category_pid : int(10) unsigned
ispublic : tinyint(1) unsigned
name : varchar(125)
description : text
notes : tinytext
created : datetime
updated : datetime

v		osticket_db ost_faq_topic
faq_id : int(10) unsigned
topic_id : int(10) unsigned

v		osticket_db ost_file
id : int(11)
ft : char(1)
bk : char(1)
type : varchar(255)
size : bigint(20) unsigned
key : varchar(86)
signature : varchar(86)
name : varchar(255)
attrs : varchar(255)
created : datetime

v		osticket_db ost_file_chunk
file_id : int(11)
chunk_id : int(11)
filedata : longblob

v		osticket_db ost_filter
id : int(11) unsigned
execorder : int(10) unsigned
isactive : tinyint(1) unsigned
flags : int(10) unsigned
status : int(11) unsigned
match_all_rules : tinyint(1) unsigned
stop_onmatch : tinyint(1) unsigned
target : enum('Any','Web','Email','API')
email_id : int(10) unsigned
name : varchar(32)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_filter_action
id : int(11) unsigned
filter_id : int(10) unsigned
sort : int(10) unsigned
type : varchar(24)
configuration : text
updated : datetime

v		osticket_db ost_filter_rule
id : int(11) unsigned
filter_id : int(10) unsigned
what : varchar(32)
how : enum('equal','not_equal','contains','dn_contain','starts','ends','match','not_match')
val : varchar(255)
isactive : tinyint(1) unsigned
notes : tinytext
created : datetime
updated : datetime

v		osticket_db ost_form
id : int(11) unsigned
pid : int(10) unsigned
type : varchar(8)
flags : int(10) unsigned
title : varchar(255)
instructions : varchar(512)
name : varchar(64)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_form_entry
id : int(11) unsigned
form_id : int(11) unsigned
object_id : int(11) unsigned
object_type : char(1)
sort : int(11) unsigned
extra : text
created : datetime
updated : datetime

v		osticket_db ost_form_entry_values
entry_id : int(11) unsigned
field_id : int(11) unsigned
value : text
value_id : int(11)

v		osticket_db ost_form_field
id : int(11) unsigned
form_id : int(11) unsigned
flags : int(10) unsigned
type : varchar(255)
label : varchar(255)
name : varchar(64)
configuration : text
sort : int(11) unsigned
hint : varchar(512)
created : datetime
updated : datetime

v		osticket_db ost_group
id : int(10) unsigned
role_id : int(11) unsigned
flags : int(11) unsigned
name : varchar(120)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_help_topic
topic_id : int(11) unsigned
topic_pid : int(10) unsigned
ispublic : tinyint(1) unsigned
noautoresp : tinyint(3) unsigned
flags : int(10) unsigned
status_id : int(10) unsigned
priority_id : int(10) unsigned
dept_id : int(10) unsigned
staff_id : int(10) unsigned
team_id : int(10) unsigned
sla_id : int(10) unsigned
page_id : int(10) unsigned
sequence_id : int(10) unsigned
sort : int(10) unsigned
topic : varchar(128)
number_format : varchar(32)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_help_topic_form
id : int(11) unsigned
topic_id : int(11) unsigned
form_id : int(10) unsigned
sort : int(10) unsigned
extra : text

v		osticket_db ost_list
id : int(11) unsigned
name : varchar(255)
name_plural : varchar(255)
sort_mode : enum('Alpha','-Alpha','SortCol')
masks : int(11) unsigned
type : varchar(16)
configuration : text
notes : text
created : datetime
updated : datetime

v		osticket_db ost_list_items
id : int(11) unsigned
list_id : int(11)
status : int(11) unsigned
value : varchar(255)
extra : varchar(255)
sort : int(11)
properties : text

v		osticket_db ost_lock
lock_id : int(11) unsigned
staff_id : int(10) unsigned
expire : datetime
code : varchar(20)
created : datetime

v		osticket_db ost_note
id : int(11) unsigned
pid : int(11) unsigned
staff_id : int(11) unsigned
ext_id : varchar(10)
body : text
status : int(11) unsigned
sort : int(11) unsigned
created : timestamp
updated : timestamp

v		osticket_db ost_organization
id : int(11) unsigned
name : varchar(128)
manager : varchar(16)
status : int(11) unsigned
domain : varchar(256)
extra : text
created : timestamp
updated : timestamp

v		osticket_db ost_organization__cdata
org_id : int(11) unsigned
name : mediumtext
address : mediumtext
phone : mediumtext
website : mediumtext
notes : mediumtext

v		osticket_db ost_plugin
id : int(11) unsigned
name : varchar(255)
install_path : varchar(60)
isphar : tinyint(1)
isactive : tinyint(1)
version : varchar(64)
notes : text
installed : datetime

v		osticket_db ost_plugin_instance
id : int(11) unsigned
plugin_id : int(11) unsigned
flags : int(10)
name : varchar(255)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_queue
id : int(11) unsigned
parent_id : int(11) unsigned
columns_id : int(11) unsigned
sort_id : int(11) unsigned
flags : int(11) unsigned
staff_id : int(11) unsigned
sort : int(11) unsigned
title : varchar(60)
config : text
filter : varchar(64)
root : varchar(32)
path : varchar(80)
created : datetime
updated : datetime

v		osticket_db ost_queue_column
id : int(11) unsigned
flags : int(10) unsigned
name : varchar(64)
primary : varchar(64)
secondary : varchar(64)
filter : varchar(32)
truncate : varchar(16)
annotations : text
conditions : text
extra : text

v		osticket_db ost_queue_columns
queue_id : int(11) unsigned
column_id : int(11) unsigned
staff_id : int(11) unsigned
bits : int(10) unsigned
sort : int(10) unsigned
heading : varchar(64)
width : int(10) unsigned

v		osticket_db ost_queue_config
queue_id : int(11) unsigned
staff_id : int(11) unsigned
setting : text
updated : datetime

v		osticket_db ost_queue_export
id : int(11) unsigned
queue_id : int(11) unsigned
path : varchar(64)
heading : varchar(64)
sort : int(10) unsigned

v		osticket_db ost_queue_sort
id : int(11) unsigned
root : varchar(32)
name : varchar(64)
columns : text
updated : datetime

v		osticket_db ost_queue_sorts
queue_id : int(11) unsigned
sort_id : int(11) unsigned
bits : int(11) unsigned
sort : int(10) unsigned

v		osticket_db ost_role
id : int(11) unsigned
flags : int(10) unsigned
name : varchar(64)
permissions : text
notes : text
created : datetime
updated : datetime

v		osticket_db ost_schedule
id : int(11) unsigned
flags : int(11) unsigned
name : varchar(255)
timezone : varchar(64)
description : varchar(255)
created : datetime
updated : datetime

v		osticket_db ost_schedule_entry
id : int(11) unsigned
schedule_id : int(11) unsigned
flags : int(11) unsigned
sort : tinyint(3) unsigned
name : varchar(255)
repeats : varchar(16)
starts_on : date
starts_at : time
ends_on : date
ends_at : time
stops_on : datetime
day : tinyint(4)
week : tinyint(4)
month : tinyint(4)
created : datetime
updated : datetime

v		osticket_db ost_sequence
id : int(11) unsigned
name : varchar(64)
flags : int(10) unsigned
next : bigint(20) unsigned
increment : int(11)
padding : char(1)
updated : datetime

v		osticket_db ost_session
session_id : varchar(255)
session_data : blob
session_expire : datetime
session_updated : datetime
user_id : varchar(16)
user_ip : varchar(64)
user_agent : varchar(255)

v		osticket_db ost_sla
id : int(11) unsigned
schedule_id : int(10) unsigned
flags : int(10) unsigned
grace_period : int(10) unsigned
name : varchar(64)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_staff
staff_id : int(11) unsigned
dept_id : int(10) unsigned
role_id : int(10) unsigned
username : varchar(32)
firstname : varchar(32)
lastname : varchar(32)
passwd : varchar(128)
backend : varchar(32)
email : varchar(255)
phone : varchar(24)
phone_ext : varchar(6)
mobile : varchar(24)
signature : text
lang : varchar(16)
timezone : varchar(64)
locale : varchar(16)
notes : text
isactive : tinyint(1)
isadmin : tinyint(1)
isvisible : tinyint(1) unsigned
onvacation : tinyint(1) unsigned
assigned_only : tinyint(1) unsigned
show_assigned_tickets : tinyint(1) unsigned
change_passwd : tinyint(1) unsigned
max_page_size : int(11) unsigned
auto_refresh_rate : int(10) unsigned
default_signature_type : enum('none','mine','dept')
default_paper_size : enum('Letter','Legal','Ledger','A4','A3')
extra : text
permissions : text
created : datetime
lastlogin : datetime
passwdreset : datetime
updated : datetime

v		osticket_db ost_staff_dept_access
staff_id : int(10) unsigned
dept_id : int(10) unsigned
role_id : int(10) unsigned
flags : int(10) unsigned

v		osticket_db ost_syslog
log_id : int(11) unsigned
log_type : enum('Debug','Warning','Error')
title : varchar(255)
log : text
logger : varchar(64)
ip_address : varchar(64)
created : datetime
updated : datetime

v		osticket_db ost_task
id : int(11) unsigned
object_id : int(11)
object_type : char(1)
number : varchar(20)
dept_id : int(10) unsigned
staff_id : int(10) unsigned
team_id : int(10) unsigned
lock_id : int(11) unsigned
flags : int(10) unsigned
duedate : datetime
closed : datetime
created : datetime
updated : datetime

v		osticket_db ost_task__cdata
task_id : int(11) unsigned
title : mediumtext

v		osticket_db ost_team
team_id : int(10) unsigned
lead_id : int(10) unsigned
flags : int(10) unsigned
name : varchar(125)
notes : text
created : datetime
updated : datetime

v		osticket_db ost_team_member
team_id : int(10) unsigned
staff_id : int(10) unsigned
flags : int(10) unsigned

v		osticket_db ost_thread
id : int(11) unsigned
object_id : int(11) unsigned
object_type : char(1)
extra : text
lastresponse : datetime
lastmessage : datetime
created : datetime

v		osticket_db ost_thread_collaborator
id : int(11) unsigned
flags : int(10) unsigned
thread_id : int(11) unsigned
user_id : int(11) unsigned
role : char(1)
created : datetime
updated : datetime

v		osticket_db ost_thread_entry
id : int(11) unsigned
pid : int(11) unsigned
thread_id : int(11) unsigned
staff_id : int(11) unsigned
user_id : int(11) unsigned
type : char(1)
flags : int(11) unsigned
poster : varchar(128)
editor : int(10) unsigned
editor_type : char(1)
source : varchar(32)
title : varchar(255)
body : text
format : varchar(16)
ip_address : varchar(64)
extra : text
recipients : text
created : datetime
updated : datetime

v		osticket_db ost_thread_entry_email
id : int(11) unsigned
thread_entry_id : int(11) unsigned
email_id : int(11) unsigned
mid : varchar(255)
headers : text

v		osticket_db ost_thread_entry_merge
id : int(11) unsigned
thread_entry_id : int(11) unsigned
data : text

v		osticket_db ost_thread_event
id : int(10) unsigned
thread_id : int(11) unsigned
thread_type : char(1)
event_id : int(11) unsigned
staff_id : int(11) unsigned
team_id : int(11) unsigned
dept_id : int(11) unsigned
topic_id : int(11) unsigned
data : varchar(1024)
username : varchar(128)
uid : int(11) unsigned
uid_type : char(1)
annulled : tinyint(1) unsigned
timestamp : datetime

v		osticket_db ost_thread_referral
id : int(10) unsigned
thread_id : int(11) unsigned
object_id : int(11) unsigned
object_type : char(1)
created : datetime

v		osticket_db ost_ticket
ticket_id : int(11) unsigned
ticket_pid : int(11) unsigned
number : varchar(20)
user_id : int(11) unsigned
user_email_id : int(11) unsigned
status_id : int(10) unsigned
dept_id : int(10) unsigned
sla_id : int(10) unsigned
topic_id : int(10) unsigned
staff_id : int(10) unsigned
team_id : int(10) unsigned
email_id : int(11) unsigned
lock_id : int(11) unsigned
flags : int(10) unsigned
sort : int(11) unsigned
ip_address : varchar(64)
source : enum('Web','Email','Phone','API','Other')
source_extra : varchar(40)
isoverdue : tinyint(1) unsigned
isanswered : tinyint(1) unsigned
duedate : datetime
est_duedate : datetime
reopened : datetime
closed : datetime
lastupdate : datetime
created : datetime
updated : datetime

v		osticket_db ost_ticket_priority
priority_id : tinyint(4)
priority : varchar(60)
priority_desc : varchar(30)
priority_color : varchar(7)
priority_urgency : tinyint(1) unsigned
ispublic : tinyint(1)

v		osticket_db ost_ticket_status
id : int(11)
name : varchar(60)
state : varchar(16)
mode : int(11) unsigned
flags : int(11) unsigned
sort : int(11) unsigned
properties : text
created : datetime
updated : datetime

v		osticket_db ost_ticket__cdata
ticket_id : int(11) unsigned
subject : mediumtext
priority : mediumtext

v		osticket_db ost_translation
id : int(11) unsigned
object_hash : char(16)
type : enum('phrase','article','override')
flags : int(10) unsigned
revision : int(11) unsigned
agent_id : int(10) unsigned
lang : varchar(16)
text : mediumtext
source_text : text
updated : timestamp

v		osticket_db ost_user
id : int(10) unsigned
org_id : int(10) unsigned
default_email_id : int(10)
status : int(11) unsigned
name : varchar(128)
created : datetime
updated : datetime

v		osticket_db ost_user_account
id : int(11) unsigned
user_id : int(10) unsigned
status : int(11) unsigned
timezone : varchar(64)
lang : varchar(16)
username : varchar(64)
passwd : varchar(128)
backend : varchar(32)
extra : text
registered : timestamp

v		osticket_db ost_user_email
id : int(10) unsigned
user_id : int(10) unsigned
flags : int(10) unsigned
address : varchar(255)

v		osticket_db ost_user__cdata
user_id : int(11) unsigned
email : mediumtext
name : mediumtext
phone : mediumtext
notes : mediumtext

v		osticket_db ost__search
object_type : varchar(8)
object_id : int(11) unsigned
title : text
content : text

Create relationship
FOREIGN KEY
on delete
on update