Recent
`mysql`.`procs_priv`
`osticket_db`.`ost_file`
`osticket_db`.`ost_thread`
`osticket_db`.`ost_list`
`performance_schema`.`events_statements_history_long`
`osticket_db`.`ost_ticket_priority`
`osticket_db`.`ost_queue`
`performance_schema`.`host_cache`
`osticket_db`.`ost_schedule`
`osticket_db`.`ost_thread_entry_merge`
Favorites
There are no favorite tables.
New
information_schema
mysql
osticket_db
performance_schema
phpmyadmin
test
wordpress_db
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
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.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
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
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: osticket_db
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
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`ost__search`.*
`ost__search`.`object_type`
`ost__search`.`object_id`
`ost__search`.`title`
`ost__search`.`content`
`ost_api_key`.*
`ost_api_key`.`id`
`ost_api_key`.`isactive`
`ost_api_key`.`ipaddr`
`ost_api_key`.`apikey`
`ost_api_key`.`can_create_tickets`
`ost_api_key`.`can_exec_cron`
`ost_api_key`.`notes`
`ost_api_key`.`updated`
`ost_api_key`.`created`
`ost_attachment`.*
`ost_attachment`.`id`
`ost_attachment`.`object_id`
`ost_attachment`.`type`
`ost_attachment`.`file_id`
`ost_attachment`.`name`
`ost_attachment`.`inline`
`ost_attachment`.`lang`
`ost_canned_response`.*
`ost_canned_response`.`canned_id`
`ost_canned_response`.`dept_id`
`ost_canned_response`.`isenabled`
`ost_canned_response`.`title`
`ost_canned_response`.`response`
`ost_canned_response`.`lang`
`ost_canned_response`.`notes`
`ost_canned_response`.`created`
`ost_canned_response`.`updated`
`ost_config`.*
`ost_config`.`id`
`ost_config`.`namespace`
`ost_config`.`key`
`ost_config`.`value`
`ost_config`.`updated`
`ost_content`.*
`ost_content`.`id`
`ost_content`.`isactive`
`ost_content`.`type`
`ost_content`.`name`
`ost_content`.`body`
`ost_content`.`notes`
`ost_content`.`created`
`ost_content`.`updated`
`ost_department`.*
`ost_department`.`id`
`ost_department`.`pid`
`ost_department`.`tpl_id`
`ost_department`.`sla_id`
`ost_department`.`schedule_id`
`ost_department`.`email_id`
`ost_department`.`autoresp_email_id`
`ost_department`.`manager_id`
`ost_department`.`flags`
`ost_department`.`name`
`ost_department`.`signature`
`ost_department`.`ispublic`
`ost_department`.`group_membership`
`ost_department`.`ticket_auto_response`
`ost_department`.`message_auto_response`
`ost_department`.`path`
`ost_department`.`updated`
`ost_department`.`created`
`ost_draft`.*
`ost_draft`.`id`
`ost_draft`.`staff_id`
`ost_draft`.`namespace`
`ost_draft`.`body`
`ost_draft`.`extra`
`ost_draft`.`created`
`ost_draft`.`updated`
`ost_email`.*
`ost_email`.`email_id`
`ost_email`.`noautoresp`
`ost_email`.`priority_id`
`ost_email`.`dept_id`
`ost_email`.`topic_id`
`ost_email`.`email`
`ost_email`.`name`
`ost_email`.`notes`
`ost_email`.`created`
`ost_email`.`updated`
`ost_email_account`.*
`ost_email_account`.`id`
`ost_email_account`.`email_id`
`ost_email_account`.`type`
`ost_email_account`.`auth_bk`
`ost_email_account`.`auth_id`
`ost_email_account`.`active`
`ost_email_account`.`host`
`ost_email_account`.`port`
`ost_email_account`.`folder`
`ost_email_account`.`protocol`
`ost_email_account`.`encryption`
`ost_email_account`.`fetchfreq`
`ost_email_account`.`fetchmax`
`ost_email_account`.`postfetch`
`ost_email_account`.`archivefolder`
`ost_email_account`.`allow_spoofing`
`ost_email_account`.`num_errors`
`ost_email_account`.`last_error_msg`
`ost_email_account`.`last_error`
`ost_email_account`.`last_activity`
`ost_email_account`.`created`
`ost_email_account`.`updated`
`ost_email_template`.*
`ost_email_template`.`id`
`ost_email_template`.`tpl_id`
`ost_email_template`.`code_name`
`ost_email_template`.`subject`
`ost_email_template`.`body`
`ost_email_template`.`notes`
`ost_email_template`.`created`
`ost_email_template`.`updated`
`ost_email_template_group`.*
`ost_email_template_group`.`tpl_id`
`ost_email_template_group`.`isactive`
`ost_email_template_group`.`name`
`ost_email_template_group`.`lang`
`ost_email_template_group`.`notes`
`ost_email_template_group`.`created`
`ost_email_template_group`.`updated`
`ost_event`.*
`ost_event`.`id`
`ost_event`.`name`
`ost_event`.`description`
`ost_faq`.*
`ost_faq`.`faq_id`
`ost_faq`.`category_id`
`ost_faq`.`ispublished`
`ost_faq`.`question`
`ost_faq`.`answer`
`ost_faq`.`keywords`
`ost_faq`.`notes`
`ost_faq`.`created`
`ost_faq`.`updated`
`ost_faq_category`.*
`ost_faq_category`.`category_id`
`ost_faq_category`.`category_pid`
`ost_faq_category`.`ispublic`
`ost_faq_category`.`name`
`ost_faq_category`.`description`
`ost_faq_category`.`notes`
`ost_faq_category`.`created`
`ost_faq_category`.`updated`
`ost_faq_topic`.*
`ost_faq_topic`.`faq_id`
`ost_faq_topic`.`topic_id`
`ost_file`.*
`ost_file`.`id`
`ost_file`.`ft`
`ost_file`.`bk`
`ost_file`.`type`
`ost_file`.`size`
`ost_file`.`key`
`ost_file`.`signature`
`ost_file`.`name`
`ost_file`.`attrs`
`ost_file`.`created`
`ost_file_chunk`.*
`ost_file_chunk`.`file_id`
`ost_file_chunk`.`chunk_id`
`ost_file_chunk`.`filedata`
`ost_filter`.*
`ost_filter`.`id`
`ost_filter`.`execorder`
`ost_filter`.`isactive`
`ost_filter`.`flags`
`ost_filter`.`status`
`ost_filter`.`match_all_rules`
`ost_filter`.`stop_onmatch`
`ost_filter`.`target`
`ost_filter`.`email_id`
`ost_filter`.`name`
`ost_filter`.`notes`
`ost_filter`.`created`
`ost_filter`.`updated`
`ost_filter_action`.*
`ost_filter_action`.`id`
`ost_filter_action`.`filter_id`
`ost_filter_action`.`sort`
`ost_filter_action`.`type`
`ost_filter_action`.`configuration`
`ost_filter_action`.`updated`
`ost_filter_rule`.*
`ost_filter_rule`.`id`
`ost_filter_rule`.`filter_id`
`ost_filter_rule`.`what`
`ost_filter_rule`.`how`
`ost_filter_rule`.`val`
`ost_filter_rule`.`isactive`
`ost_filter_rule`.`notes`
`ost_filter_rule`.`created`
`ost_filter_rule`.`updated`
`ost_form`.*
`ost_form`.`id`
`ost_form`.`pid`
`ost_form`.`type`
`ost_form`.`flags`
`ost_form`.`title`
`ost_form`.`instructions`
`ost_form`.`name`
`ost_form`.`notes`
`ost_form`.`created`
`ost_form`.`updated`
`ost_form_entry`.*
`ost_form_entry`.`id`
`ost_form_entry`.`form_id`
`ost_form_entry`.`object_id`
`ost_form_entry`.`object_type`
`ost_form_entry`.`sort`
`ost_form_entry`.`extra`
`ost_form_entry`.`created`
`ost_form_entry`.`updated`
`ost_form_entry_values`.*
`ost_form_entry_values`.`entry_id`
`ost_form_entry_values`.`field_id`
`ost_form_entry_values`.`value`
`ost_form_entry_values`.`value_id`
`ost_form_field`.*
`ost_form_field`.`id`
`ost_form_field`.`form_id`
`ost_form_field`.`flags`
`ost_form_field`.`type`
`ost_form_field`.`label`
`ost_form_field`.`name`
`ost_form_field`.`configuration`
`ost_form_field`.`sort`
`ost_form_field`.`hint`
`ost_form_field`.`created`
`ost_form_field`.`updated`
`ost_group`.*
`ost_group`.`id`
`ost_group`.`role_id`
`ost_group`.`flags`
`ost_group`.`name`
`ost_group`.`notes`
`ost_group`.`created`
`ost_group`.`updated`
`ost_help_topic`.*
`ost_help_topic`.`topic_id`
`ost_help_topic`.`topic_pid`
`ost_help_topic`.`ispublic`
`ost_help_topic`.`noautoresp`
`ost_help_topic`.`flags`
`ost_help_topic`.`status_id`
`ost_help_topic`.`priority_id`
`ost_help_topic`.`dept_id`
`ost_help_topic`.`staff_id`
`ost_help_topic`.`team_id`
`ost_help_topic`.`sla_id`
`ost_help_topic`.`page_id`
`ost_help_topic`.`sequence_id`
`ost_help_topic`.`sort`
`ost_help_topic`.`topic`
`ost_help_topic`.`number_format`
`ost_help_topic`.`notes`
`ost_help_topic`.`created`
`ost_help_topic`.`updated`
`ost_help_topic_form`.*
`ost_help_topic_form`.`id`
`ost_help_topic_form`.`topic_id`
`ost_help_topic_form`.`form_id`
`ost_help_topic_form`.`sort`
`ost_help_topic_form`.`extra`
`ost_list`.*
`ost_list`.`id`
`ost_list`.`name`
`ost_list`.`name_plural`
`ost_list`.`sort_mode`
`ost_list`.`masks`
`ost_list`.`type`
`ost_list`.`configuration`
`ost_list`.`notes`
`ost_list`.`created`
`ost_list`.`updated`
`ost_list_items`.*
`ost_list_items`.`id`
`ost_list_items`.`list_id`
`ost_list_items`.`status`
`ost_list_items`.`value`
`ost_list_items`.`extra`
`ost_list_items`.`sort`
`ost_list_items`.`properties`
`ost_lock`.*
`ost_lock`.`lock_id`
`ost_lock`.`staff_id`
`ost_lock`.`expire`
`ost_lock`.`code`
`ost_lock`.`created`
`ost_note`.*
`ost_note`.`id`
`ost_note`.`pid`
`ost_note`.`staff_id`
`ost_note`.`ext_id`
`ost_note`.`body`
`ost_note`.`status`
`ost_note`.`sort`
`ost_note`.`created`
`ost_note`.`updated`
`ost_organization`.*
`ost_organization`.`id`
`ost_organization`.`name`
`ost_organization`.`manager`
`ost_organization`.`status`
`ost_organization`.`domain`
`ost_organization`.`extra`
`ost_organization`.`created`
`ost_organization`.`updated`
`ost_organization__cdata`.*
`ost_organization__cdata`.`org_id`
`ost_organization__cdata`.`name`
`ost_organization__cdata`.`address`
`ost_organization__cdata`.`phone`
`ost_organization__cdata`.`website`
`ost_organization__cdata`.`notes`
`ost_plugin`.*
`ost_plugin`.`id`
`ost_plugin`.`name`
`ost_plugin`.`install_path`
`ost_plugin`.`isphar`
`ost_plugin`.`isactive`
`ost_plugin`.`version`
`ost_plugin`.`notes`
`ost_plugin`.`installed`
`ost_plugin_instance`.*
`ost_plugin_instance`.`id`
`ost_plugin_instance`.`plugin_id`
`ost_plugin_instance`.`flags`
`ost_plugin_instance`.`name`
`ost_plugin_instance`.`notes`
`ost_plugin_instance`.`created`
`ost_plugin_instance`.`updated`
`ost_queue`.*
`ost_queue`.`id`
`ost_queue`.`parent_id`
`ost_queue`.`columns_id`
`ost_queue`.`sort_id`
`ost_queue`.`flags`
`ost_queue`.`staff_id`
`ost_queue`.`sort`
`ost_queue`.`title`
`ost_queue`.`config`
`ost_queue`.`filter`
`ost_queue`.`root`
`ost_queue`.`path`
`ost_queue`.`created`
`ost_queue`.`updated`
`ost_queue_column`.*
`ost_queue_column`.`id`
`ost_queue_column`.`flags`
`ost_queue_column`.`name`
`ost_queue_column`.`primary`
`ost_queue_column`.`secondary`
`ost_queue_column`.`filter`
`ost_queue_column`.`truncate`
`ost_queue_column`.`annotations`
`ost_queue_column`.`conditions`
`ost_queue_column`.`extra`
`ost_queue_columns`.*
`ost_queue_columns`.`queue_id`
`ost_queue_columns`.`column_id`
`ost_queue_columns`.`staff_id`
`ost_queue_columns`.`bits`
`ost_queue_columns`.`sort`
`ost_queue_columns`.`heading`
`ost_queue_columns`.`width`
`ost_queue_config`.*
`ost_queue_config`.`queue_id`
`ost_queue_config`.`staff_id`
`ost_queue_config`.`setting`
`ost_queue_config`.`updated`
`ost_queue_export`.*
`ost_queue_export`.`id`
`ost_queue_export`.`queue_id`
`ost_queue_export`.`path`
`ost_queue_export`.`heading`
`ost_queue_export`.`sort`
`ost_queue_sort`.*
`ost_queue_sort`.`id`
`ost_queue_sort`.`root`
`ost_queue_sort`.`name`
`ost_queue_sort`.`columns`
`ost_queue_sort`.`updated`
`ost_queue_sorts`.*
`ost_queue_sorts`.`queue_id`
`ost_queue_sorts`.`sort_id`
`ost_queue_sorts`.`bits`
`ost_queue_sorts`.`sort`
`ost_role`.*
`ost_role`.`id`
`ost_role`.`flags`
`ost_role`.`name`
`ost_role`.`permissions`
`ost_role`.`notes`
`ost_role`.`created`
`ost_role`.`updated`
`ost_schedule`.*
`ost_schedule`.`id`
`ost_schedule`.`flags`
`ost_schedule`.`name`
`ost_schedule`.`timezone`
`ost_schedule`.`description`
`ost_schedule`.`created`
`ost_schedule`.`updated`
`ost_schedule_entry`.*
`ost_schedule_entry`.`id`
`ost_schedule_entry`.`schedule_id`
`ost_schedule_entry`.`flags`
`ost_schedule_entry`.`sort`
`ost_schedule_entry`.`name`
`ost_schedule_entry`.`repeats`
`ost_schedule_entry`.`starts_on`
`ost_schedule_entry`.`starts_at`
`ost_schedule_entry`.`ends_on`
`ost_schedule_entry`.`ends_at`
`ost_schedule_entry`.`stops_on`
`ost_schedule_entry`.`day`
`ost_schedule_entry`.`week`
`ost_schedule_entry`.`month`
`ost_schedule_entry`.`created`
`ost_schedule_entry`.`updated`
`ost_sequence`.*
`ost_sequence`.`id`
`ost_sequence`.`name`
`ost_sequence`.`flags`
`ost_sequence`.`next`
`ost_sequence`.`increment`
`ost_sequence`.`padding`
`ost_sequence`.`updated`
`ost_session`.*
`ost_session`.`session_id`
`ost_session`.`session_data`
`ost_session`.`session_expire`
`ost_session`.`session_updated`
`ost_session`.`user_id`
`ost_session`.`user_ip`
`ost_session`.`user_agent`
`ost_sla`.*
`ost_sla`.`id`
`ost_sla`.`schedule_id`
`ost_sla`.`flags`
`ost_sla`.`grace_period`
`ost_sla`.`name`
`ost_sla`.`notes`
`ost_sla`.`created`
`ost_sla`.`updated`
`ost_staff`.*
`ost_staff`.`staff_id`
`ost_staff`.`dept_id`
`ost_staff`.`role_id`
`ost_staff`.`username`
`ost_staff`.`firstname`
`ost_staff`.`lastname`
`ost_staff`.`passwd`
`ost_staff`.`backend`
`ost_staff`.`email`
`ost_staff`.`phone`
`ost_staff`.`phone_ext`
`ost_staff`.`mobile`
`ost_staff`.`signature`
`ost_staff`.`lang`
`ost_staff`.`timezone`
`ost_staff`.`locale`
`ost_staff`.`notes`
`ost_staff`.`isactive`
`ost_staff`.`isadmin`
`ost_staff`.`isvisible`
`ost_staff`.`onvacation`
`ost_staff`.`assigned_only`
`ost_staff`.`show_assigned_tickets`
`ost_staff`.`change_passwd`
`ost_staff`.`max_page_size`
`ost_staff`.`auto_refresh_rate`
`ost_staff`.`default_signature_type`
`ost_staff`.`default_paper_size`
`ost_staff`.`extra`
`ost_staff`.`permissions`
`ost_staff`.`created`
`ost_staff`.`lastlogin`
`ost_staff`.`passwdreset`
`ost_staff`.`updated`
`ost_staff_dept_access`.*
`ost_staff_dept_access`.`staff_id`
`ost_staff_dept_access`.`dept_id`
`ost_staff_dept_access`.`role_id`
`ost_staff_dept_access`.`flags`
`ost_syslog`.*
`ost_syslog`.`log_id`
`ost_syslog`.`log_type`
`ost_syslog`.`title`
`ost_syslog`.`log`
`ost_syslog`.`logger`
`ost_syslog`.`ip_address`
`ost_syslog`.`created`
`ost_syslog`.`updated`
`ost_task`.*
`ost_task`.`id`
`ost_task`.`object_id`
`ost_task`.`object_type`
`ost_task`.`number`
`ost_task`.`dept_id`
`ost_task`.`staff_id`
`ost_task`.`team_id`
`ost_task`.`lock_id`
`ost_task`.`flags`
`ost_task`.`duedate`
`ost_task`.`closed`
`ost_task`.`created`
`ost_task`.`updated`
`ost_task__cdata`.*
`ost_task__cdata`.`task_id`
`ost_task__cdata`.`title`
`ost_team`.*
`ost_team`.`team_id`
`ost_team`.`lead_id`
`ost_team`.`flags`
`ost_team`.`name`
`ost_team`.`notes`
`ost_team`.`created`
`ost_team`.`updated`
`ost_team_member`.*
`ost_team_member`.`team_id`
`ost_team_member`.`staff_id`
`ost_team_member`.`flags`
`ost_thread`.*
`ost_thread`.`id`
`ost_thread`.`object_id`
`ost_thread`.`object_type`
`ost_thread`.`extra`
`ost_thread`.`lastresponse`
`ost_thread`.`lastmessage`
`ost_thread`.`created`
`ost_thread_collaborator`.*
`ost_thread_collaborator`.`id`
`ost_thread_collaborator`.`flags`
`ost_thread_collaborator`.`thread_id`
`ost_thread_collaborator`.`user_id`
`ost_thread_collaborator`.`role`
`ost_thread_collaborator`.`created`
`ost_thread_collaborator`.`updated`
`ost_thread_entry`.*
`ost_thread_entry`.`id`
`ost_thread_entry`.`pid`
`ost_thread_entry`.`thread_id`
`ost_thread_entry`.`staff_id`
`ost_thread_entry`.`user_id`
`ost_thread_entry`.`type`
`ost_thread_entry`.`flags`
`ost_thread_entry`.`poster`
`ost_thread_entry`.`editor`
`ost_thread_entry`.`editor_type`
`ost_thread_entry`.`source`
`ost_thread_entry`.`title`
`ost_thread_entry`.`body`
`ost_thread_entry`.`format`
`ost_thread_entry`.`ip_address`
`ost_thread_entry`.`extra`
`ost_thread_entry`.`recipients`
`ost_thread_entry`.`created`
`ost_thread_entry`.`updated`
`ost_thread_entry_email`.*
`ost_thread_entry_email`.`id`
`ost_thread_entry_email`.`thread_entry_id`
`ost_thread_entry_email`.`email_id`
`ost_thread_entry_email`.`mid`
`ost_thread_entry_email`.`headers`
`ost_thread_entry_merge`.*
`ost_thread_entry_merge`.`id`
`ost_thread_entry_merge`.`thread_entry_id`
`ost_thread_entry_merge`.`data`
`ost_thread_event`.*
`ost_thread_event`.`id`
`ost_thread_event`.`thread_id`
`ost_thread_event`.`thread_type`
`ost_thread_event`.`event_id`
`ost_thread_event`.`staff_id`
`ost_thread_event`.`team_id`
`ost_thread_event`.`dept_id`
`ost_thread_event`.`topic_id`
`ost_thread_event`.`data`
`ost_thread_event`.`username`
`ost_thread_event`.`uid`
`ost_thread_event`.`uid_type`
`ost_thread_event`.`annulled`
`ost_thread_event`.`timestamp`
`ost_thread_referral`.*
`ost_thread_referral`.`id`
`ost_thread_referral`.`thread_id`
`ost_thread_referral`.`object_id`
`ost_thread_referral`.`object_type`
`ost_thread_referral`.`created`
`ost_ticket`.*
`ost_ticket`.`ticket_id`
`ost_ticket`.`ticket_pid`
`ost_ticket`.`number`
`ost_ticket`.`user_id`
`ost_ticket`.`user_email_id`
`ost_ticket`.`status_id`
`ost_ticket`.`dept_id`
`ost_ticket`.`sla_id`
`ost_ticket`.`topic_id`
`ost_ticket`.`staff_id`
`ost_ticket`.`team_id`
`ost_ticket`.`email_id`
`ost_ticket`.`lock_id`
`ost_ticket`.`flags`
`ost_ticket`.`sort`
`ost_ticket`.`ip_address`
`ost_ticket`.`source`
`ost_ticket`.`source_extra`
`ost_ticket`.`isoverdue`
`ost_ticket`.`isanswered`
`ost_ticket`.`duedate`
`ost_ticket`.`est_duedate`
`ost_ticket`.`reopened`
`ost_ticket`.`closed`
`ost_ticket`.`lastupdate`
`ost_ticket`.`created`
`ost_ticket`.`updated`
`ost_ticket__cdata`.*
`ost_ticket__cdata`.`ticket_id`
`ost_ticket__cdata`.`subject`
`ost_ticket__cdata`.`priority`
`ost_ticket_priority`.*
`ost_ticket_priority`.`priority_id`
`ost_ticket_priority`.`priority`
`ost_ticket_priority`.`priority_desc`
`ost_ticket_priority`.`priority_color`
`ost_ticket_priority`.`priority_urgency`
`ost_ticket_priority`.`ispublic`
`ost_ticket_status`.*
`ost_ticket_status`.`id`
`ost_ticket_status`.`name`
`ost_ticket_status`.`state`
`ost_ticket_status`.`mode`
`ost_ticket_status`.`flags`
`ost_ticket_status`.`sort`
`ost_ticket_status`.`properties`
`ost_ticket_status`.`created`
`ost_ticket_status`.`updated`
`ost_translation`.*
`ost_translation`.`id`
`ost_translation`.`object_hash`
`ost_translation`.`type`
`ost_translation`.`flags`
`ost_translation`.`revision`
`ost_translation`.`agent_id`
`ost_translation`.`lang`
`ost_translation`.`text`
`ost_translation`.`source_text`
`ost_translation`.`updated`
`ost_user`.*
`ost_user`.`id`
`ost_user`.`org_id`
`ost_user`.`default_email_id`
`ost_user`.`status`
`ost_user`.`name`
`ost_user`.`created`
`ost_user`.`updated`
`ost_user__cdata`.*
`ost_user__cdata`.`user_id`
`ost_user__cdata`.`email`
`ost_user__cdata`.`name`
`ost_user__cdata`.`phone`
`ost_user__cdata`.`notes`
`ost_user_account`.*
`ost_user_account`.`id`
`ost_user_account`.`user_id`
`ost_user_account`.`status`
`ost_user_account`.`timezone`
`ost_user_account`.`lang`
`ost_user_account`.`username`
`ost_user_account`.`passwd`
`ost_user_account`.`backend`
`ost_user_account`.`extra`
`ost_user_account`.`registered`
`ost_user_email`.*
`ost_user_email`.`id`
`ost_user_email`.`user_id`
`ost_user_email`.`flags`
`ost_user_email`.`address`
`ost__search`.*
`ost__search`.`object_type`
`ost__search`.`object_id`
`ost__search`.`title`
`ost__search`.`content`
`ost_api_key`.*
`ost_api_key`.`id`
`ost_api_key`.`isactive`
`ost_api_key`.`ipaddr`
`ost_api_key`.`apikey`
`ost_api_key`.`can_create_tickets`
`ost_api_key`.`can_exec_cron`
`ost_api_key`.`notes`
`ost_api_key`.`updated`
`ost_api_key`.`created`
`ost_attachment`.*
`ost_attachment`.`id`
`ost_attachment`.`object_id`
`ost_attachment`.`type`
`ost_attachment`.`file_id`
`ost_attachment`.`name`
`ost_attachment`.`inline`
`ost_attachment`.`lang`
`ost_canned_response`.*
`ost_canned_response`.`canned_id`
`ost_canned_response`.`dept_id`
`ost_canned_response`.`isenabled`
`ost_canned_response`.`title`
`ost_canned_response`.`response`
`ost_canned_response`.`lang`
`ost_canned_response`.`notes`
`ost_canned_response`.`created`
`ost_canned_response`.`updated`
`ost_config`.*
`ost_config`.`id`
`ost_config`.`namespace`
`ost_config`.`key`
`ost_config`.`value`
`ost_config`.`updated`
`ost_content`.*
`ost_content`.`id`
`ost_content`.`isactive`
`ost_content`.`type`
`ost_content`.`name`
`ost_content`.`body`
`ost_content`.`notes`
`ost_content`.`created`
`ost_content`.`updated`
`ost_department`.*
`ost_department`.`id`
`ost_department`.`pid`
`ost_department`.`tpl_id`
`ost_department`.`sla_id`
`ost_department`.`schedule_id`
`ost_department`.`email_id`
`ost_department`.`autoresp_email_id`
`ost_department`.`manager_id`
`ost_department`.`flags`
`ost_department`.`name`
`ost_department`.`signature`
`ost_department`.`ispublic`
`ost_department`.`group_membership`
`ost_department`.`ticket_auto_response`
`ost_department`.`message_auto_response`
`ost_department`.`path`
`ost_department`.`updated`
`ost_department`.`created`
`ost_draft`.*
`ost_draft`.`id`
`ost_draft`.`staff_id`
`ost_draft`.`namespace`
`ost_draft`.`body`
`ost_draft`.`extra`
`ost_draft`.`created`
`ost_draft`.`updated`
`ost_email`.*
`ost_email`.`email_id`
`ost_email`.`noautoresp`
`ost_email`.`priority_id`
`ost_email`.`dept_id`
`ost_email`.`topic_id`
`ost_email`.`email`
`ost_email`.`name`
`ost_email`.`notes`
`ost_email`.`created`
`ost_email`.`updated`
`ost_email_account`.*
`ost_email_account`.`id`
`ost_email_account`.`email_id`
`ost_email_account`.`type`
`ost_email_account`.`auth_bk`
`ost_email_account`.`auth_id`
`ost_email_account`.`active`
`ost_email_account`.`host`
`ost_email_account`.`port`
`ost_email_account`.`folder`
`ost_email_account`.`protocol`
`ost_email_account`.`encryption`
`ost_email_account`.`fetchfreq`
`ost_email_account`.`fetchmax`
`ost_email_account`.`postfetch`
`ost_email_account`.`archivefolder`
`ost_email_account`.`allow_spoofing`
`ost_email_account`.`num_errors`
`ost_email_account`.`last_error_msg`
`ost_email_account`.`last_error`
`ost_email_account`.`last_activity`
`ost_email_account`.`created`
`ost_email_account`.`updated`
`ost_email_template`.*
`ost_email_template`.`id`
`ost_email_template`.`tpl_id`
`ost_email_template`.`code_name`
`ost_email_template`.`subject`
`ost_email_template`.`body`
`ost_email_template`.`notes`
`ost_email_template`.`created`
`ost_email_template`.`updated`
`ost_email_template_group`.*
`ost_email_template_group`.`tpl_id`
`ost_email_template_group`.`isactive`
`ost_email_template_group`.`name`
`ost_email_template_group`.`lang`
`ost_email_template_group`.`notes`
`ost_email_template_group`.`created`
`ost_email_template_group`.`updated`
`ost_event`.*
`ost_event`.`id`
`ost_event`.`name`
`ost_event`.`description`
`ost_faq`.*
`ost_faq`.`faq_id`
`ost_faq`.`category_id`
`ost_faq`.`ispublished`
`ost_faq`.`question`
`ost_faq`.`answer`
`ost_faq`.`keywords`
`ost_faq`.`notes`
`ost_faq`.`created`
`ost_faq`.`updated`
`ost_faq_category`.*
`ost_faq_category`.`category_id`
`ost_faq_category`.`category_pid`
`ost_faq_category`.`ispublic`
`ost_faq_category`.`name`
`ost_faq_category`.`description`
`ost_faq_category`.`notes`
`ost_faq_category`.`created`
`ost_faq_category`.`updated`
`ost_faq_topic`.*
`ost_faq_topic`.`faq_id`
`ost_faq_topic`.`topic_id`
`ost_file`.*
`ost_file`.`id`
`ost_file`.`ft`
`ost_file`.`bk`
`ost_file`.`type`
`ost_file`.`size`
`ost_file`.`key`
`ost_file`.`signature`
`ost_file`.`name`
`ost_file`.`attrs`
`ost_file`.`created`
`ost_file_chunk`.*
`ost_file_chunk`.`file_id`
`ost_file_chunk`.`chunk_id`
`ost_file_chunk`.`filedata`
`ost_filter`.*
`ost_filter`.`id`
`ost_filter`.`execorder`
`ost_filter`.`isactive`
`ost_filter`.`flags`
`ost_filter`.`status`
`ost_filter`.`match_all_rules`
`ost_filter`.`stop_onmatch`
`ost_filter`.`target`
`ost_filter`.`email_id`
`ost_filter`.`name`
`ost_filter`.`notes`
`ost_filter`.`created`
`ost_filter`.`updated`
`ost_filter_action`.*
`ost_filter_action`.`id`
`ost_filter_action`.`filter_id`
`ost_filter_action`.`sort`
`ost_filter_action`.`type`
`ost_filter_action`.`configuration`
`ost_filter_action`.`updated`
`ost_filter_rule`.*
`ost_filter_rule`.`id`
`ost_filter_rule`.`filter_id`
`ost_filter_rule`.`what`
`ost_filter_rule`.`how`
`ost_filter_rule`.`val`
`ost_filter_rule`.`isactive`
`ost_filter_rule`.`notes`
`ost_filter_rule`.`created`
`ost_filter_rule`.`updated`
`ost_form`.*
`ost_form`.`id`
`ost_form`.`pid`
`ost_form`.`type`
`ost_form`.`flags`
`ost_form`.`title`
`ost_form`.`instructions`
`ost_form`.`name`
`ost_form`.`notes`
`ost_form`.`created`
`ost_form`.`updated`
`ost_form_entry`.*
`ost_form_entry`.`id`
`ost_form_entry`.`form_id`
`ost_form_entry`.`object_id`
`ost_form_entry`.`object_type`
`ost_form_entry`.`sort`
`ost_form_entry`.`extra`
`ost_form_entry`.`created`
`ost_form_entry`.`updated`
`ost_form_entry_values`.*
`ost_form_entry_values`.`entry_id`
`ost_form_entry_values`.`field_id`
`ost_form_entry_values`.`value`
`ost_form_entry_values`.`value_id`
`ost_form_field`.*
`ost_form_field`.`id`
`ost_form_field`.`form_id`
`ost_form_field`.`flags`
`ost_form_field`.`type`
`ost_form_field`.`label`
`ost_form_field`.`name`
`ost_form_field`.`configuration`
`ost_form_field`.`sort`
`ost_form_field`.`hint`
`ost_form_field`.`created`
`ost_form_field`.`updated`
`ost_group`.*
`ost_group`.`id`
`ost_group`.`role_id`
`ost_group`.`flags`
`ost_group`.`name`
`ost_group`.`notes`
`ost_group`.`created`
`ost_group`.`updated`
`ost_help_topic`.*
`ost_help_topic`.`topic_id`
`ost_help_topic`.`topic_pid`
`ost_help_topic`.`ispublic`
`ost_help_topic`.`noautoresp`
`ost_help_topic`.`flags`
`ost_help_topic`.`status_id`
`ost_help_topic`.`priority_id`
`ost_help_topic`.`dept_id`
`ost_help_topic`.`staff_id`
`ost_help_topic`.`team_id`
`ost_help_topic`.`sla_id`
`ost_help_topic`.`page_id`
`ost_help_topic`.`sequence_id`
`ost_help_topic`.`sort`
`ost_help_topic`.`topic`
`ost_help_topic`.`number_format`
`ost_help_topic`.`notes`
`ost_help_topic`.`created`
`ost_help_topic`.`updated`
`ost_help_topic_form`.*
`ost_help_topic_form`.`id`
`ost_help_topic_form`.`topic_id`
`ost_help_topic_form`.`form_id`
`ost_help_topic_form`.`sort`
`ost_help_topic_form`.`extra`
`ost_list`.*
`ost_list`.`id`
`ost_list`.`name`
`ost_list`.`name_plural`
`ost_list`.`sort_mode`
`ost_list`.`masks`
`ost_list`.`type`
`ost_list`.`configuration`
`ost_list`.`notes`
`ost_list`.`created`
`ost_list`.`updated`
`ost_list_items`.*
`ost_list_items`.`id`
`ost_list_items`.`list_id`
`ost_list_items`.`status`
`ost_list_items`.`value`
`ost_list_items`.`extra`
`ost_list_items`.`sort`
`ost_list_items`.`properties`
`ost_lock`.*
`ost_lock`.`lock_id`
`ost_lock`.`staff_id`
`ost_lock`.`expire`
`ost_lock`.`code`
`ost_lock`.`created`
`ost_note`.*
`ost_note`.`id`
`ost_note`.`pid`
`ost_note`.`staff_id`
`ost_note`.`ext_id`
`ost_note`.`body`
`ost_note`.`status`
`ost_note`.`sort`
`ost_note`.`created`
`ost_note`.`updated`
`ost_organization`.*
`ost_organization`.`id`
`ost_organization`.`name`
`ost_organization`.`manager`
`ost_organization`.`status`
`ost_organization`.`domain`
`ost_organization`.`extra`
`ost_organization`.`created`
`ost_organization`.`updated`
`ost_organization__cdata`.*
`ost_organization__cdata`.`org_id`
`ost_organization__cdata`.`name`
`ost_organization__cdata`.`address`
`ost_organization__cdata`.`phone`
`ost_organization__cdata`.`website`
`ost_organization__cdata`.`notes`
`ost_plugin`.*
`ost_plugin`.`id`
`ost_plugin`.`name`
`ost_plugin`.`install_path`
`ost_plugin`.`isphar`
`ost_plugin`.`isactive`
`ost_plugin`.`version`
`ost_plugin`.`notes`
`ost_plugin`.`installed`
`ost_plugin_instance`.*
`ost_plugin_instance`.`id`
`ost_plugin_instance`.`plugin_id`
`ost_plugin_instance`.`flags`
`ost_plugin_instance`.`name`
`ost_plugin_instance`.`notes`
`ost_plugin_instance`.`created`
`ost_plugin_instance`.`updated`
`ost_queue`.*
`ost_queue`.`id`
`ost_queue`.`parent_id`
`ost_queue`.`columns_id`
`ost_queue`.`sort_id`
`ost_queue`.`flags`
`ost_queue`.`staff_id`
`ost_queue`.`sort`
`ost_queue`.`title`
`ost_queue`.`config`
`ost_queue`.`filter`
`ost_queue`.`root`
`ost_queue`.`path`
`ost_queue`.`created`
`ost_queue`.`updated`
`ost_queue_column`.*
`ost_queue_column`.`id`
`ost_queue_column`.`flags`
`ost_queue_column`.`name`
`ost_queue_column`.`primary`
`ost_queue_column`.`secondary`
`ost_queue_column`.`filter`
`ost_queue_column`.`truncate`
`ost_queue_column`.`annotations`
`ost_queue_column`.`conditions`
`ost_queue_column`.`extra`
`ost_queue_columns`.*
`ost_queue_columns`.`queue_id`
`ost_queue_columns`.`column_id`
`ost_queue_columns`.`staff_id`
`ost_queue_columns`.`bits`
`ost_queue_columns`.`sort`
`ost_queue_columns`.`heading`
`ost_queue_columns`.`width`
`ost_queue_config`.*
`ost_queue_config`.`queue_id`
`ost_queue_config`.`staff_id`
`ost_queue_config`.`setting`
`ost_queue_config`.`updated`
`ost_queue_export`.*
`ost_queue_export`.`id`
`ost_queue_export`.`queue_id`
`ost_queue_export`.`path`
`ost_queue_export`.`heading`
`ost_queue_export`.`sort`
`ost_queue_sort`.*
`ost_queue_sort`.`id`
`ost_queue_sort`.`root`
`ost_queue_sort`.`name`
`ost_queue_sort`.`columns`
`ost_queue_sort`.`updated`
`ost_queue_sorts`.*
`ost_queue_sorts`.`queue_id`
`ost_queue_sorts`.`sort_id`
`ost_queue_sorts`.`bits`
`ost_queue_sorts`.`sort`
`ost_role`.*
`ost_role`.`id`
`ost_role`.`flags`
`ost_role`.`name`
`ost_role`.`permissions`
`ost_role`.`notes`
`ost_role`.`created`
`ost_role`.`updated`
`ost_schedule`.*
`ost_schedule`.`id`
`ost_schedule`.`flags`
`ost_schedule`.`name`
`ost_schedule`.`timezone`
`ost_schedule`.`description`
`ost_schedule`.`created`
`ost_schedule`.`updated`
`ost_schedule_entry`.*
`ost_schedule_entry`.`id`
`ost_schedule_entry`.`schedule_id`
`ost_schedule_entry`.`flags`
`ost_schedule_entry`.`sort`
`ost_schedule_entry`.`name`
`ost_schedule_entry`.`repeats`
`ost_schedule_entry`.`starts_on`
`ost_schedule_entry`.`starts_at`
`ost_schedule_entry`.`ends_on`
`ost_schedule_entry`.`ends_at`
`ost_schedule_entry`.`stops_on`
`ost_schedule_entry`.`day`
`ost_schedule_entry`.`week`
`ost_schedule_entry`.`month`
`ost_schedule_entry`.`created`
`ost_schedule_entry`.`updated`
`ost_sequence`.*
`ost_sequence`.`id`
`ost_sequence`.`name`
`ost_sequence`.`flags`
`ost_sequence`.`next`
`ost_sequence`.`increment`
`ost_sequence`.`padding`
`ost_sequence`.`updated`
`ost_session`.*
`ost_session`.`session_id`
`ost_session`.`session_data`
`ost_session`.`session_expire`
`ost_session`.`session_updated`
`ost_session`.`user_id`
`ost_session`.`user_ip`
`ost_session`.`user_agent`
`ost_sla`.*
`ost_sla`.`id`
`ost_sla`.`schedule_id`
`ost_sla`.`flags`
`ost_sla`.`grace_period`
`ost_sla`.`name`
`ost_sla`.`notes`
`ost_sla`.`created`
`ost_sla`.`updated`
`ost_staff`.*
`ost_staff`.`staff_id`
`ost_staff`.`dept_id`
`ost_staff`.`role_id`
`ost_staff`.`username`
`ost_staff`.`firstname`
`ost_staff`.`lastname`
`ost_staff`.`passwd`
`ost_staff`.`backend`
`ost_staff`.`email`
`ost_staff`.`phone`
`ost_staff`.`phone_ext`
`ost_staff`.`mobile`
`ost_staff`.`signature`
`ost_staff`.`lang`
`ost_staff`.`timezone`
`ost_staff`.`locale`
`ost_staff`.`notes`
`ost_staff`.`isactive`
`ost_staff`.`isadmin`
`ost_staff`.`isvisible`
`ost_staff`.`onvacation`
`ost_staff`.`assigned_only`
`ost_staff`.`show_assigned_tickets`
`ost_staff`.`change_passwd`
`ost_staff`.`max_page_size`
`ost_staff`.`auto_refresh_rate`
`ost_staff`.`default_signature_type`
`ost_staff`.`default_paper_size`
`ost_staff`.`extra`
`ost_staff`.`permissions`
`ost_staff`.`created`
`ost_staff`.`lastlogin`
`ost_staff`.`passwdreset`
`ost_staff`.`updated`
`ost_staff_dept_access`.*
`ost_staff_dept_access`.`staff_id`
`ost_staff_dept_access`.`dept_id`
`ost_staff_dept_access`.`role_id`
`ost_staff_dept_access`.`flags`
`ost_syslog`.*
`ost_syslog`.`log_id`
`ost_syslog`.`log_type`
`ost_syslog`.`title`
`ost_syslog`.`log`
`ost_syslog`.`logger`
`ost_syslog`.`ip_address`
`ost_syslog`.`created`
`ost_syslog`.`updated`
`ost_task`.*
`ost_task`.`id`
`ost_task`.`object_id`
`ost_task`.`object_type`
`ost_task`.`number`
`ost_task`.`dept_id`
`ost_task`.`staff_id`
`ost_task`.`team_id`
`ost_task`.`lock_id`
`ost_task`.`flags`
`ost_task`.`duedate`
`ost_task`.`closed`
`ost_task`.`created`
`ost_task`.`updated`
`ost_task__cdata`.*
`ost_task__cdata`.`task_id`
`ost_task__cdata`.`title`
`ost_team`.*
`ost_team`.`team_id`
`ost_team`.`lead_id`
`ost_team`.`flags`
`ost_team`.`name`
`ost_team`.`notes`
`ost_team`.`created`
`ost_team`.`updated`
`ost_team_member`.*
`ost_team_member`.`team_id`
`ost_team_member`.`staff_id`
`ost_team_member`.`flags`
`ost_thread`.*
`ost_thread`.`id`
`ost_thread`.`object_id`
`ost_thread`.`object_type`
`ost_thread`.`extra`
`ost_thread`.`lastresponse`
`ost_thread`.`lastmessage`
`ost_thread`.`created`
`ost_thread_collaborator`.*
`ost_thread_collaborator`.`id`
`ost_thread_collaborator`.`flags`
`ost_thread_collaborator`.`thread_id`
`ost_thread_collaborator`.`user_id`
`ost_thread_collaborator`.`role`
`ost_thread_collaborator`.`created`
`ost_thread_collaborator`.`updated`
`ost_thread_entry`.*
`ost_thread_entry`.`id`
`ost_thread_entry`.`pid`
`ost_thread_entry`.`thread_id`
`ost_thread_entry`.`staff_id`
`ost_thread_entry`.`user_id`
`ost_thread_entry`.`type`
`ost_thread_entry`.`flags`
`ost_thread_entry`.`poster`
`ost_thread_entry`.`editor`
`ost_thread_entry`.`editor_type`
`ost_thread_entry`.`source`
`ost_thread_entry`.`title`
`ost_thread_entry`.`body`
`ost_thread_entry`.`format`
`ost_thread_entry`.`ip_address`
`ost_thread_entry`.`extra`
`ost_thread_entry`.`recipients`
`ost_thread_entry`.`created`
`ost_thread_entry`.`updated`
`ost_thread_entry_email`.*
`ost_thread_entry_email`.`id`
`ost_thread_entry_email`.`thread_entry_id`
`ost_thread_entry_email`.`email_id`
`ost_thread_entry_email`.`mid`
`ost_thread_entry_email`.`headers`
`ost_thread_entry_merge`.*
`ost_thread_entry_merge`.`id`
`ost_thread_entry_merge`.`thread_entry_id`
`ost_thread_entry_merge`.`data`
`ost_thread_event`.*
`ost_thread_event`.`id`
`ost_thread_event`.`thread_id`
`ost_thread_event`.`thread_type`
`ost_thread_event`.`event_id`
`ost_thread_event`.`staff_id`
`ost_thread_event`.`team_id`
`ost_thread_event`.`dept_id`
`ost_thread_event`.`topic_id`
`ost_thread_event`.`data`
`ost_thread_event`.`username`
`ost_thread_event`.`uid`
`ost_thread_event`.`uid_type`
`ost_thread_event`.`annulled`
`ost_thread_event`.`timestamp`
`ost_thread_referral`.*
`ost_thread_referral`.`id`
`ost_thread_referral`.`thread_id`
`ost_thread_referral`.`object_id`
`ost_thread_referral`.`object_type`
`ost_thread_referral`.`created`
`ost_ticket`.*
`ost_ticket`.`ticket_id`
`ost_ticket`.`ticket_pid`
`ost_ticket`.`number`
`ost_ticket`.`user_id`
`ost_ticket`.`user_email_id`
`ost_ticket`.`status_id`
`ost_ticket`.`dept_id`
`ost_ticket`.`sla_id`
`ost_ticket`.`topic_id`
`ost_ticket`.`staff_id`
`ost_ticket`.`team_id`
`ost_ticket`.`email_id`
`ost_ticket`.`lock_id`
`ost_ticket`.`flags`
`ost_ticket`.`sort`
`ost_ticket`.`ip_address`
`ost_ticket`.`source`
`ost_ticket`.`source_extra`
`ost_ticket`.`isoverdue`
`ost_ticket`.`isanswered`
`ost_ticket`.`duedate`
`ost_ticket`.`est_duedate`
`ost_ticket`.`reopened`
`ost_ticket`.`closed`
`ost_ticket`.`lastupdate`
`ost_ticket`.`created`
`ost_ticket`.`updated`
`ost_ticket__cdata`.*
`ost_ticket__cdata`.`ticket_id`
`ost_ticket__cdata`.`subject`
`ost_ticket__cdata`.`priority`
`ost_ticket_priority`.*
`ost_ticket_priority`.`priority_id`
`ost_ticket_priority`.`priority`
`ost_ticket_priority`.`priority_desc`
`ost_ticket_priority`.`priority_color`
`ost_ticket_priority`.`priority_urgency`
`ost_ticket_priority`.`ispublic`
`ost_ticket_status`.*
`ost_ticket_status`.`id`
`ost_ticket_status`.`name`
`ost_ticket_status`.`state`
`ost_ticket_status`.`mode`
`ost_ticket_status`.`flags`
`ost_ticket_status`.`sort`
`ost_ticket_status`.`properties`
`ost_ticket_status`.`created`
`ost_ticket_status`.`updated`
`ost_translation`.*
`ost_translation`.`id`
`ost_translation`.`object_hash`
`ost_translation`.`type`
`ost_translation`.`flags`
`ost_translation`.`revision`
`ost_translation`.`agent_id`
`ost_translation`.`lang`
`ost_translation`.`text`
`ost_translation`.`source_text`
`ost_translation`.`updated`
`ost_user`.*
`ost_user`.`id`
`ost_user`.`org_id`
`ost_user`.`default_email_id`
`ost_user`.`status`
`ost_user`.`name`
`ost_user`.`created`
`ost_user`.`updated`
`ost_user__cdata`.*
`ost_user__cdata`.`user_id`
`ost_user__cdata`.`email`
`ost_user__cdata`.`name`
`ost_user__cdata`.`phone`
`ost_user__cdata`.`notes`
`ost_user_account`.*
`ost_user_account`.`id`
`ost_user_account`.`user_id`
`ost_user_account`.`status`
`ost_user_account`.`timezone`
`ost_user_account`.`lang`
`ost_user_account`.`username`
`ost_user_account`.`passwd`
`ost_user_account`.`backend`
`ost_user_account`.`extra`
`ost_user_account`.`registered`
`ost_user_email`.*
`ost_user_email`.`id`
`ost_user_email`.`user_id`
`ost_user_email`.`flags`
`ost_user_email`.`address`
`ost__search`.*
`ost__search`.`object_type`
`ost__search`.`object_id`
`ost__search`.`title`
`ost__search`.`content`
`ost_api_key`.*
`ost_api_key`.`id`
`ost_api_key`.`isactive`
`ost_api_key`.`ipaddr`
`ost_api_key`.`apikey`
`ost_api_key`.`can_create_tickets`
`ost_api_key`.`can_exec_cron`
`ost_api_key`.`notes`
`ost_api_key`.`updated`
`ost_api_key`.`created`
`ost_attachment`.*
`ost_attachment`.`id`
`ost_attachment`.`object_id`
`ost_attachment`.`type`
`ost_attachment`.`file_id`
`ost_attachment`.`name`
`ost_attachment`.`inline`
`ost_attachment`.`lang`
`ost_canned_response`.*
`ost_canned_response`.`canned_id`
`ost_canned_response`.`dept_id`
`ost_canned_response`.`isenabled`
`ost_canned_response`.`title`
`ost_canned_response`.`response`
`ost_canned_response`.`lang`
`ost_canned_response`.`notes`
`ost_canned_response`.`created`
`ost_canned_response`.`updated`
`ost_config`.*
`ost_config`.`id`
`ost_config`.`namespace`
`ost_config`.`key`
`ost_config`.`value`
`ost_config`.`updated`
`ost_content`.*
`ost_content`.`id`
`ost_content`.`isactive`
`ost_content`.`type`
`ost_content`.`name`
`ost_content`.`body`
`ost_content`.`notes`
`ost_content`.`created`
`ost_content`.`updated`
`ost_department`.*
`ost_department`.`id`
`ost_department`.`pid`
`ost_department`.`tpl_id`
`ost_department`.`sla_id`
`ost_department`.`schedule_id`
`ost_department`.`email_id`
`ost_department`.`autoresp_email_id`
`ost_department`.`manager_id`
`ost_department`.`flags`
`ost_department`.`name`
`ost_department`.`signature`
`ost_department`.`ispublic`
`ost_department`.`group_membership`
`ost_department`.`ticket_auto_response`
`ost_department`.`message_auto_response`
`ost_department`.`path`
`ost_department`.`updated`
`ost_department`.`created`
`ost_draft`.*
`ost_draft`.`id`
`ost_draft`.`staff_id`
`ost_draft`.`namespace`
`ost_draft`.`body`
`ost_draft`.`extra`
`ost_draft`.`created`
`ost_draft`.`updated`
`ost_email`.*
`ost_email`.`email_id`
`ost_email`.`noautoresp`
`ost_email`.`priority_id`
`ost_email`.`dept_id`
`ost_email`.`topic_id`
`ost_email`.`email`
`ost_email`.`name`
`ost_email`.`notes`
`ost_email`.`created`
`ost_email`.`updated`
`ost_email_account`.*
`ost_email_account`.`id`
`ost_email_account`.`email_id`
`ost_email_account`.`type`
`ost_email_account`.`auth_bk`
`ost_email_account`.`auth_id`
`ost_email_account`.`active`
`ost_email_account`.`host`
`ost_email_account`.`port`
`ost_email_account`.`folder`
`ost_email_account`.`protocol`
`ost_email_account`.`encryption`
`ost_email_account`.`fetchfreq`
`ost_email_account`.`fetchmax`
`ost_email_account`.`postfetch`
`ost_email_account`.`archivefolder`
`ost_email_account`.`allow_spoofing`
`ost_email_account`.`num_errors`
`ost_email_account`.`last_error_msg`
`ost_email_account`.`last_error`
`ost_email_account`.`last_activity`
`ost_email_account`.`created`
`ost_email_account`.`updated`
`ost_email_template`.*
`ost_email_template`.`id`
`ost_email_template`.`tpl_id`
`ost_email_template`.`code_name`
`ost_email_template`.`subject`
`ost_email_template`.`body`
`ost_email_template`.`notes`
`ost_email_template`.`created`
`ost_email_template`.`updated`
`ost_email_template_group`.*
`ost_email_template_group`.`tpl_id`
`ost_email_template_group`.`isactive`
`ost_email_template_group`.`name`
`ost_email_template_group`.`lang`
`ost_email_template_group`.`notes`
`ost_email_template_group`.`created`
`ost_email_template_group`.`updated`
`ost_event`.*
`ost_event`.`id`
`ost_event`.`name`
`ost_event`.`description`
`ost_faq`.*
`ost_faq`.`faq_id`
`ost_faq`.`category_id`
`ost_faq`.`ispublished`
`ost_faq`.`question`
`ost_faq`.`answer`
`ost_faq`.`keywords`
`ost_faq`.`notes`
`ost_faq`.`created`
`ost_faq`.`updated`
`ost_faq_category`.*
`ost_faq_category`.`category_id`
`ost_faq_category`.`category_pid`
`ost_faq_category`.`ispublic`
`ost_faq_category`.`name`
`ost_faq_category`.`description`
`ost_faq_category`.`notes`
`ost_faq_category`.`created`
`ost_faq_category`.`updated`
`ost_faq_topic`.*
`ost_faq_topic`.`faq_id`
`ost_faq_topic`.`topic_id`
`ost_file`.*
`ost_file`.`id`
`ost_file`.`ft`
`ost_file`.`bk`
`ost_file`.`type`
`ost_file`.`size`
`ost_file`.`key`
`ost_file`.`signature`
`ost_file`.`name`
`ost_file`.`attrs`
`ost_file`.`created`
`ost_file_chunk`.*
`ost_file_chunk`.`file_id`
`ost_file_chunk`.`chunk_id`
`ost_file_chunk`.`filedata`
`ost_filter`.*
`ost_filter`.`id`
`ost_filter`.`execorder`
`ost_filter`.`isactive`
`ost_filter`.`flags`
`ost_filter`.`status`
`ost_filter`.`match_all_rules`
`ost_filter`.`stop_onmatch`
`ost_filter`.`target`
`ost_filter`.`email_id`
`ost_filter`.`name`
`ost_filter`.`notes`
`ost_filter`.`created`
`ost_filter`.`updated`
`ost_filter_action`.*
`ost_filter_action`.`id`
`ost_filter_action`.`filter_id`
`ost_filter_action`.`sort`
`ost_filter_action`.`type`
`ost_filter_action`.`configuration`
`ost_filter_action`.`updated`
`ost_filter_rule`.*
`ost_filter_rule`.`id`
`ost_filter_rule`.`filter_id`
`ost_filter_rule`.`what`
`ost_filter_rule`.`how`
`ost_filter_rule`.`val`
`ost_filter_rule`.`isactive`
`ost_filter_rule`.`notes`
`ost_filter_rule`.`created`
`ost_filter_rule`.`updated`
`ost_form`.*
`ost_form`.`id`
`ost_form`.`pid`
`ost_form`.`type`
`ost_form`.`flags`
`ost_form`.`title`
`ost_form`.`instructions`
`ost_form`.`name`
`ost_form`.`notes`
`ost_form`.`created`
`ost_form`.`updated`
`ost_form_entry`.*
`ost_form_entry`.`id`
`ost_form_entry`.`form_id`
`ost_form_entry`.`object_id`
`ost_form_entry`.`object_type`
`ost_form_entry`.`sort`
`ost_form_entry`.`extra`
`ost_form_entry`.`created`
`ost_form_entry`.`updated`
`ost_form_entry_values`.*
`ost_form_entry_values`.`entry_id`
`ost_form_entry_values`.`field_id`
`ost_form_entry_values`.`value`
`ost_form_entry_values`.`value_id`
`ost_form_field`.*
`ost_form_field`.`id`
`ost_form_field`.`form_id`
`ost_form_field`.`flags`
`ost_form_field`.`type`
`ost_form_field`.`label`
`ost_form_field`.`name`
`ost_form_field`.`configuration`
`ost_form_field`.`sort`
`ost_form_field`.`hint`
`ost_form_field`.`created`
`ost_form_field`.`updated`
`ost_group`.*
`ost_group`.`id`
`ost_group`.`role_id`
`ost_group`.`flags`
`ost_group`.`name`
`ost_group`.`notes`
`ost_group`.`created`
`ost_group`.`updated`
`ost_help_topic`.*
`ost_help_topic`.`topic_id`
`ost_help_topic`.`topic_pid`
`ost_help_topic`.`ispublic`
`ost_help_topic`.`noautoresp`
`ost_help_topic`.`flags`
`ost_help_topic`.`status_id`
`ost_help_topic`.`priority_id`
`ost_help_topic`.`dept_id`
`ost_help_topic`.`staff_id`
`ost_help_topic`.`team_id`
`ost_help_topic`.`sla_id`
`ost_help_topic`.`page_id`
`ost_help_topic`.`sequence_id`
`ost_help_topic`.`sort`
`ost_help_topic`.`topic`
`ost_help_topic`.`number_format`
`ost_help_topic`.`notes`
`ost_help_topic`.`created`
`ost_help_topic`.`updated`
`ost_help_topic_form`.*
`ost_help_topic_form`.`id`
`ost_help_topic_form`.`topic_id`
`ost_help_topic_form`.`form_id`
`ost_help_topic_form`.`sort`
`ost_help_topic_form`.`extra`
`ost_list`.*
`ost_list`.`id`
`ost_list`.`name`
`ost_list`.`name_plural`
`ost_list`.`sort_mode`
`ost_list`.`masks`
`ost_list`.`type`
`ost_list`.`configuration`
`ost_list`.`notes`
`ost_list`.`created`
`ost_list`.`updated`
`ost_list_items`.*
`ost_list_items`.`id`
`ost_list_items`.`list_id`
`ost_list_items`.`status`
`ost_list_items`.`value`
`ost_list_items`.`extra`
`ost_list_items`.`sort`
`ost_list_items`.`properties`
`ost_lock`.*
`ost_lock`.`lock_id`
`ost_lock`.`staff_id`
`ost_lock`.`expire`
`ost_lock`.`code`
`ost_lock`.`created`
`ost_note`.*
`ost_note`.`id`
`ost_note`.`pid`
`ost_note`.`staff_id`
`ost_note`.`ext_id`
`ost_note`.`body`
`ost_note`.`status`
`ost_note`.`sort`
`ost_note`.`created`
`ost_note`.`updated`
`ost_organization`.*
`ost_organization`.`id`
`ost_organization`.`name`
`ost_organization`.`manager`
`ost_organization`.`status`
`ost_organization`.`domain`
`ost_organization`.`extra`
`ost_organization`.`created`
`ost_organization`.`updated`
`ost_organization__cdata`.*
`ost_organization__cdata`.`org_id`
`ost_organization__cdata`.`name`
`ost_organization__cdata`.`address`
`ost_organization__cdata`.`phone`
`ost_organization__cdata`.`website`
`ost_organization__cdata`.`notes`
`ost_plugin`.*
`ost_plugin`.`id`
`ost_plugin`.`name`
`ost_plugin`.`install_path`
`ost_plugin`.`isphar`
`ost_plugin`.`isactive`
`ost_plugin`.`version`
`ost_plugin`.`notes`
`ost_plugin`.`installed`
`ost_plugin_instance`.*
`ost_plugin_instance`.`id`
`ost_plugin_instance`.`plugin_id`
`ost_plugin_instance`.`flags`
`ost_plugin_instance`.`name`
`ost_plugin_instance`.`notes`
`ost_plugin_instance`.`created`
`ost_plugin_instance`.`updated`
`ost_queue`.*
`ost_queue`.`id`
`ost_queue`.`parent_id`
`ost_queue`.`columns_id`
`ost_queue`.`sort_id`
`ost_queue`.`flags`
`ost_queue`.`staff_id`
`ost_queue`.`sort`
`ost_queue`.`title`
`ost_queue`.`config`
`ost_queue`.`filter`
`ost_queue`.`root`
`ost_queue`.`path`
`ost_queue`.`created`
`ost_queue`.`updated`
`ost_queue_column`.*
`ost_queue_column`.`id`
`ost_queue_column`.`flags`
`ost_queue_column`.`name`
`ost_queue_column`.`primary`
`ost_queue_column`.`secondary`
`ost_queue_column`.`filter`
`ost_queue_column`.`truncate`
`ost_queue_column`.`annotations`
`ost_queue_column`.`conditions`
`ost_queue_column`.`extra`
`ost_queue_columns`.*
`ost_queue_columns`.`queue_id`
`ost_queue_columns`.`column_id`
`ost_queue_columns`.`staff_id`
`ost_queue_columns`.`bits`
`ost_queue_columns`.`sort`
`ost_queue_columns`.`heading`
`ost_queue_columns`.`width`
`ost_queue_config`.*
`ost_queue_config`.`queue_id`
`ost_queue_config`.`staff_id`
`ost_queue_config`.`setting`
`ost_queue_config`.`updated`
`ost_queue_export`.*
`ost_queue_export`.`id`
`ost_queue_export`.`queue_id`
`ost_queue_export`.`path`
`ost_queue_export`.`heading`
`ost_queue_export`.`sort`
`ost_queue_sort`.*
`ost_queue_sort`.`id`
`ost_queue_sort`.`root`
`ost_queue_sort`.`name`
`ost_queue_sort`.`columns`
`ost_queue_sort`.`updated`
`ost_queue_sorts`.*
`ost_queue_sorts`.`queue_id`
`ost_queue_sorts`.`sort_id`
`ost_queue_sorts`.`bits`
`ost_queue_sorts`.`sort`
`ost_role`.*
`ost_role`.`id`
`ost_role`.`flags`
`ost_role`.`name`
`ost_role`.`permissions`
`ost_role`.`notes`
`ost_role`.`created`
`ost_role`.`updated`
`ost_schedule`.*
`ost_schedule`.`id`
`ost_schedule`.`flags`
`ost_schedule`.`name`
`ost_schedule`.`timezone`
`ost_schedule`.`description`
`ost_schedule`.`created`
`ost_schedule`.`updated`
`ost_schedule_entry`.*
`ost_schedule_entry`.`id`
`ost_schedule_entry`.`schedule_id`
`ost_schedule_entry`.`flags`
`ost_schedule_entry`.`sort`
`ost_schedule_entry`.`name`
`ost_schedule_entry`.`repeats`
`ost_schedule_entry`.`starts_on`
`ost_schedule_entry`.`starts_at`
`ost_schedule_entry`.`ends_on`
`ost_schedule_entry`.`ends_at`
`ost_schedule_entry`.`stops_on`
`ost_schedule_entry`.`day`
`ost_schedule_entry`.`week`
`ost_schedule_entry`.`month`
`ost_schedule_entry`.`created`
`ost_schedule_entry`.`updated`
`ost_sequence`.*
`ost_sequence`.`id`
`ost_sequence`.`name`
`ost_sequence`.`flags`
`ost_sequence`.`next`
`ost_sequence`.`increment`
`ost_sequence`.`padding`
`ost_sequence`.`updated`
`ost_session`.*
`ost_session`.`session_id`
`ost_session`.`session_data`
`ost_session`.`session_expire`
`ost_session`.`session_updated`
`ost_session`.`user_id`
`ost_session`.`user_ip`
`ost_session`.`user_agent`
`ost_sla`.*
`ost_sla`.`id`
`ost_sla`.`schedule_id`
`ost_sla`.`flags`
`ost_sla`.`grace_period`
`ost_sla`.`name`
`ost_sla`.`notes`
`ost_sla`.`created`
`ost_sla`.`updated`
`ost_staff`.*
`ost_staff`.`staff_id`
`ost_staff`.`dept_id`
`ost_staff`.`role_id`
`ost_staff`.`username`
`ost_staff`.`firstname`
`ost_staff`.`lastname`
`ost_staff`.`passwd`
`ost_staff`.`backend`
`ost_staff`.`email`
`ost_staff`.`phone`
`ost_staff`.`phone_ext`
`ost_staff`.`mobile`
`ost_staff`.`signature`
`ost_staff`.`lang`
`ost_staff`.`timezone`
`ost_staff`.`locale`
`ost_staff`.`notes`
`ost_staff`.`isactive`
`ost_staff`.`isadmin`
`ost_staff`.`isvisible`
`ost_staff`.`onvacation`
`ost_staff`.`assigned_only`
`ost_staff`.`show_assigned_tickets`
`ost_staff`.`change_passwd`
`ost_staff`.`max_page_size`
`ost_staff`.`auto_refresh_rate`
`ost_staff`.`default_signature_type`
`ost_staff`.`default_paper_size`
`ost_staff`.`extra`
`ost_staff`.`permissions`
`ost_staff`.`created`
`ost_staff`.`lastlogin`
`ost_staff`.`passwdreset`
`ost_staff`.`updated`
`ost_staff_dept_access`.*
`ost_staff_dept_access`.`staff_id`
`ost_staff_dept_access`.`dept_id`
`ost_staff_dept_access`.`role_id`
`ost_staff_dept_access`.`flags`
`ost_syslog`.*
`ost_syslog`.`log_id`
`ost_syslog`.`log_type`
`ost_syslog`.`title`
`ost_syslog`.`log`
`ost_syslog`.`logger`
`ost_syslog`.`ip_address`
`ost_syslog`.`created`
`ost_syslog`.`updated`
`ost_task`.*
`ost_task`.`id`
`ost_task`.`object_id`
`ost_task`.`object_type`
`ost_task`.`number`
`ost_task`.`dept_id`
`ost_task`.`staff_id`
`ost_task`.`team_id`
`ost_task`.`lock_id`
`ost_task`.`flags`
`ost_task`.`duedate`
`ost_task`.`closed`
`ost_task`.`created`
`ost_task`.`updated`
`ost_task__cdata`.*
`ost_task__cdata`.`task_id`
`ost_task__cdata`.`title`
`ost_team`.*
`ost_team`.`team_id`
`ost_team`.`lead_id`
`ost_team`.`flags`
`ost_team`.`name`
`ost_team`.`notes`
`ost_team`.`created`
`ost_team`.`updated`
`ost_team_member`.*
`ost_team_member`.`team_id`
`ost_team_member`.`staff_id`
`ost_team_member`.`flags`
`ost_thread`.*
`ost_thread`.`id`
`ost_thread`.`object_id`
`ost_thread`.`object_type`
`ost_thread`.`extra`
`ost_thread`.`lastresponse`
`ost_thread`.`lastmessage`
`ost_thread`.`created`
`ost_thread_collaborator`.*
`ost_thread_collaborator`.`id`
`ost_thread_collaborator`.`flags`
`ost_thread_collaborator`.`thread_id`
`ost_thread_collaborator`.`user_id`
`ost_thread_collaborator`.`role`
`ost_thread_collaborator`.`created`
`ost_thread_collaborator`.`updated`
`ost_thread_entry`.*
`ost_thread_entry`.`id`
`ost_thread_entry`.`pid`
`ost_thread_entry`.`thread_id`
`ost_thread_entry`.`staff_id`
`ost_thread_entry`.`user_id`
`ost_thread_entry`.`type`
`ost_thread_entry`.`flags`
`ost_thread_entry`.`poster`
`ost_thread_entry`.`editor`
`ost_thread_entry`.`editor_type`
`ost_thread_entry`.`source`
`ost_thread_entry`.`title`
`ost_thread_entry`.`body`
`ost_thread_entry`.`format`
`ost_thread_entry`.`ip_address`
`ost_thread_entry`.`extra`
`ost_thread_entry`.`recipients`
`ost_thread_entry`.`created`
`ost_thread_entry`.`updated`
`ost_thread_entry_email`.*
`ost_thread_entry_email`.`id`
`ost_thread_entry_email`.`thread_entry_id`
`ost_thread_entry_email`.`email_id`
`ost_thread_entry_email`.`mid`
`ost_thread_entry_email`.`headers`
`ost_thread_entry_merge`.*
`ost_thread_entry_merge`.`id`
`ost_thread_entry_merge`.`thread_entry_id`
`ost_thread_entry_merge`.`data`
`ost_thread_event`.*
`ost_thread_event`.`id`
`ost_thread_event`.`thread_id`
`ost_thread_event`.`thread_type`
`ost_thread_event`.`event_id`
`ost_thread_event`.`staff_id`
`ost_thread_event`.`team_id`
`ost_thread_event`.`dept_id`
`ost_thread_event`.`topic_id`
`ost_thread_event`.`data`
`ost_thread_event`.`username`
`ost_thread_event`.`uid`
`ost_thread_event`.`uid_type`
`ost_thread_event`.`annulled`
`ost_thread_event`.`timestamp`
`ost_thread_referral`.*
`ost_thread_referral`.`id`
`ost_thread_referral`.`thread_id`
`ost_thread_referral`.`object_id`
`ost_thread_referral`.`object_type`
`ost_thread_referral`.`created`
`ost_ticket`.*
`ost_ticket`.`ticket_id`
`ost_ticket`.`ticket_pid`
`ost_ticket`.`number`
`ost_ticket`.`user_id`
`ost_ticket`.`user_email_id`
`ost_ticket`.`status_id`
`ost_ticket`.`dept_id`
`ost_ticket`.`sla_id`
`ost_ticket`.`topic_id`
`ost_ticket`.`staff_id`
`ost_ticket`.`team_id`
`ost_ticket`.`email_id`
`ost_ticket`.`lock_id`
`ost_ticket`.`flags`
`ost_ticket`.`sort`
`ost_ticket`.`ip_address`
`ost_ticket`.`source`
`ost_ticket`.`source_extra`
`ost_ticket`.`isoverdue`
`ost_ticket`.`isanswered`
`ost_ticket`.`duedate`
`ost_ticket`.`est_duedate`
`ost_ticket`.`reopened`
`ost_ticket`.`closed`
`ost_ticket`.`lastupdate`
`ost_ticket`.`created`
`ost_ticket`.`updated`
`ost_ticket__cdata`.*
`ost_ticket__cdata`.`ticket_id`
`ost_ticket__cdata`.`subject`
`ost_ticket__cdata`.`priority`
`ost_ticket_priority`.*
`ost_ticket_priority`.`priority_id`
`ost_ticket_priority`.`priority`
`ost_ticket_priority`.`priority_desc`
`ost_ticket_priority`.`priority_color`
`ost_ticket_priority`.`priority_urgency`
`ost_ticket_priority`.`ispublic`
`ost_ticket_status`.*
`ost_ticket_status`.`id`
`ost_ticket_status`.`name`
`ost_ticket_status`.`state`
`ost_ticket_status`.`mode`
`ost_ticket_status`.`flags`
`ost_ticket_status`.`sort`
`ost_ticket_status`.`properties`
`ost_ticket_status`.`created`
`ost_ticket_status`.`updated`
`ost_translation`.*
`ost_translation`.`id`
`ost_translation`.`object_hash`
`ost_translation`.`type`
`ost_translation`.`flags`
`ost_translation`.`revision`
`ost_translation`.`agent_id`
`ost_translation`.`lang`
`ost_translation`.`text`
`ost_translation`.`source_text`
`ost_translation`.`updated`
`ost_user`.*
`ost_user`.`id`
`ost_user`.`org_id`
`ost_user`.`default_email_id`
`ost_user`.`status`
`ost_user`.`name`
`ost_user`.`created`
`ost_user`.`updated`
`ost_user__cdata`.*
`ost_user__cdata`.`user_id`
`ost_user__cdata`.`email`
`ost_user__cdata`.`name`
`ost_user__cdata`.`phone`
`ost_user__cdata`.`notes`
`ost_user_account`.*
`ost_user_account`.`id`
`ost_user_account`.`user_id`
`ost_user_account`.`status`
`ost_user_account`.`timezone`
`ost_user_account`.`lang`
`ost_user_account`.`username`
`ost_user_account`.`passwd`
`ost_user_account`.`backend`
`ost_user_account`.`extra`
`ost_user_account`.`registered`
`ost_user_email`.*
`ost_user_email`.`id`
`ost_user_email`.`user_id`
`ost_user_email`.`flags`
`ost_user_email`.`address`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
ost__search
ost_api_key
ost_attachment
ost_canned_response
ost_config
ost_content
ost_department
ost_draft
ost_email
ost_email_account
ost_email_template
ost_email_template_group
ost_event
ost_faq
ost_faq_category
ost_faq_topic
ost_file
ost_file_chunk
ost_filter
ost_filter_action
ost_filter_rule
ost_form
ost_form_entry
ost_form_entry_values
ost_form_field
ost_group
ost_help_topic
ost_help_topic_form
ost_list
ost_list_items
ost_lock
ost_note
ost_organization
ost_organization__cdata
ost_plugin
ost_plugin_instance
ost_queue
ost_queue_column
ost_queue_columns
ost_queue_config
ost_queue_export
ost_queue_sort
ost_queue_sorts
ost_role
ost_schedule
ost_schedule_entry
ost_sequence
ost_session
ost_sla
ost_staff
ost_staff_dept_access
ost_syslog
ost_task
ost_task__cdata
ost_team
ost_team_member
ost_thread
ost_thread_collaborator
ost_thread_entry
ost_thread_entry_email
ost_thread_entry_merge
ost_thread_event
ost_thread_referral
ost_ticket
ost_ticket__cdata
ost_ticket_priority
ost_ticket_status
ost_translation
ost_user
ost_user__cdata
ost_user_account
ost_user_email
SQL query on database
osticket_db
: