localhost:8080 / 127.0.0.1 / opencats

There are no favorite tables.

New
db
empower_dev
information_schema
marketing_ops
- marketing_ops
- marketing_ops_testing
mysql
opencats
performance_schema
phpmyadmin
tamarisk
- tamarisk
- tamarisk_legal_advisors
test

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		opencats access_level
access_level_id : int(11)
short_description : varchar(32)
long_description : text

v		opencats activity
activity_id : int(11)
data_item_id : int(11)
data_item_type : int(11)
joborder_id : int(11)
site_id : int(11)
entered_by : int(11)
date_created : datetime
type : int(11)
notes : text
date_modified : datetime

v		opencats activity_type
activity_type_id : int(11)
short_description : varchar(32)

v		opencats attachment
attachment_id : int(11)
data_item_id : int(11)
data_item_type : int(11)
site_id : int(11)
title : varchar(128)
original_filename : varchar(255)
stored_filename : varchar(255)
content_type : varchar(255)
resume : int(1)
text : text
date_created : datetime
date_modified : datetime
profile_image : int(1)
directory_name : varchar(64)
md5_sum : varchar(40)
file_size_kb : int(11)
md5_sum_text : varchar(40)

v		opencats calendar_event
calendar_event_id : int(11)
type : int(11)
date : datetime
title : text
all_day : int(1)
data_item_id : int(11)
data_item_type : int(11)
entered_by : int(11)
date_created : datetime
date_modified : datetime
site_id : int(11)
joborder_id : int(11)
description : text
duration : int(11)
reminder_enabled : int(1)
reminder_email : text
reminder_time : int(11)
public : int(1)

v		opencats calendar_event_type
calendar_event_type_id : int(11)
short_description : varchar(32)
icon_image : varchar(128)

v		opencats candidate
candidate_id : int(11)
site_id : int(11)
last_name : varchar(64)
first_name : varchar(64)
middle_name : varchar(32)
phone_home : varchar(40)
phone_cell : varchar(40)
phone_work : varchar(40)
address : text
city : varchar(64)
state : varchar(64)
zip : varchar(16)
source : varchar(128)
date_available : datetime
can_relocate : int(1)
notes : text
key_skills : text
current_employer : varchar(128)
entered_by : int(11)
owner : int(11)
date_created : datetime
date_modified : datetime
email1 : varchar(128)
email2 : varchar(128)
web_site : varchar(128)
import_id : int(11)
is_hot : int(1)
eeo_ethnic_type_id : int(11)
eeo_veteran_type_id : int(11)
eeo_disability_status : varchar(5)
eeo_gender : varchar(5)
desired_pay : varchar(64)
current_pay : varchar(64)
is_active : int(1)
is_admin_hidden : int(1)
best_time_to_call : varchar(255)

v		opencats candidate_duplicates
old_candidate_id : int(11)
new_candidate_id : int(11)
site_id : int(11)

v		opencats candidate_joborder
candidate_joborder_id : int(11)
candidate_id : int(11)
joborder_id : int(11)
site_id : int(11)
status : int(11)
date_submitted : datetime
date_created : datetime
date_modified : datetime
rating_value : int(5)
added_by : int(11)

v		opencats candidate_joborder_status
candidate_joborder_status_id : int(11)
short_description : varchar(32)
can_be_scheduled : int(1)
triggers_email : int(1)
is_enabled : int(1)

v		opencats candidate_joborder_status_history
candidate_joborder_status_history_id : int(11)
candidate_id : int(11)
joborder_id : int(11)
date : datetime
status_from : int(11)
status_to : int(11)
site_id : int(11)

v		opencats candidate_jobordrer_status_type
candidate_status_type_id : int(11)
short_description : varchar(32)
can_be_scheduled : int(1)

v		opencats candidate_source
source_id : int(11)
name : varchar(255)
site_id : int(11)
date_created : datetime

v		opencats candidate_tag
id : int(10) unsigned
site_id : int(10) unsigned
candidate_id : int(10) unsigned
tag_id : int(10) unsigned

v		opencats career_portal_questionnaire
career_portal_questionnaire_id : int(11)
title : varchar(255)
site_id : int(11)
description : varchar(255)
is_active : tinyint(1)

v		opencats career_portal_questionnaire_answer
career_portal_questionnaire_answer_id : int(11)
career_portal_questionnaire_question_id : int(11)
career_portal_questionnaire_id : int(11)
text : varchar(255)
action_source : varchar(128)
action_notes : text
action_is_hot : tinyint(1)
action_is_active : tinyint(1)
action_can_relocate : tinyint(1)
action_key_skills : varchar(255)
position : int(4)
site_id : int(11)

v		opencats career_portal_questionnaire_history
career_portal_questionnaire_history_id : int(11)
site_id : int(11)
candidate_id : int(11)
question : varchar(255)
answer : varchar(255)
questionnaire_title : varchar(255)
questionnaire_description : varchar(255)
date : datetime

v		opencats career_portal_questionnaire_question
career_portal_questionnaire_question_id : int(11)
career_portal_questionnaire_id : int(11)
text : varchar(255)
minimum_length : int(11)
maximum_length : int(11)
required : tinyint(1)
position : int(4)
site_id : int(11)
type : int(11)

v		opencats career_portal_template
career_portal_template_id : int(11)
career_portal_name : varchar(255)
setting : varchar(128)
value : text

v		opencats career_portal_template_site
career_portal_template_id : int(11)
career_portal_name : varchar(255)
site_id : int(11)
setting : varchar(128)
value : text

v		opencats company
company_id : int(11)
site_id : int(11)
billing_contact : int(11)
name : varchar(64)
address : text
city : varchar(64)
state : varchar(64)
zip : varchar(16)
phone1 : varchar(40)
phone2 : varchar(40)
url : varchar(128)
key_technologies : text
notes : text
entered_by : int(11)
owner : int(11)
date_created : datetime
date_modified : datetime
is_hot : int(1)
fax_number : varchar(40)
import_id : int(11)
default_company : int(1)

v		opencats company_department
company_department_id : int(11)
name : varchar(128)
company_id : int(11)
site_id : int(11)
date_created : datetime
created_by : int(11)

v		opencats contact
contact_id : int(11)
company_id : int(11)
site_id : int(11)
last_name : varchar(64)
first_name : varchar(64)
title : varchar(128)
email1 : varchar(128)
email2 : varchar(128)
phone_work : varchar(40)
phone_cell : varchar(40)
phone_other : varchar(40)
address : text
city : varchar(64)
state : varchar(64)
zip : varchar(16)
is_hot : int(1)
notes : text
entered_by : int(11)
owner : int(11)
date_created : datetime
date_modified : datetime
left_company : int(1)
import_id : int(11)
company_department_id : int(11)
reports_to : int(11)

v		opencats data_item_type
data_item_type_id : int(11)
short_description : varchar(32)

v		opencats eeo_ethnic_type
eeo_ethnic_type_id : int(11)
type : varchar(128)

v		opencats eeo_veteran_type
eeo_veteran_type_id : int(11)
type : varchar(128)

v		opencats email_history
email_history_id : int(11)
from_address : varchar(128)
recipients : text
text : text
user_id : int(11)
site_id : int(11)
date : datetime

v		opencats email_template
email_template_id : int(11)
text : text
allow_substitution : int(1)
site_id : int(11)
tag : varchar(255)
title : varchar(255)
possible_variables : text
disabled : int(1)

v		opencats extension_statistics
extension_statistics_id : int(11)
extension : varchar(128)
action : varchar(128)
user : varchar(128)
date : date

v		opencats extra_field
extra_field_id : int(11)
data_item_id : int(11)
field_name : varchar(255)
value : text
import_id : int(11)
site_id : int(11)
data_item_type : int(11)

v		opencats extra_field_settings
extra_field_settings_id : int(11)
field_name : varchar(255)
import_id : int(11)
site_id : int(11)
date_created : datetime
data_item_type : int(11)
extra_field_type : int(11)
extra_field_options : text
position : int(4)

v		opencats feedback
feedback_id : int(11)
user_id : int(11)
site_id : int(11)
date_created : datetime
subject : varchar(255)
reply_to_address : varchar(255)
reply_to_name : varchar(255)
feedback : text
archived : int(1)

v		opencats history
history_id : int(11)
data_item_type : int(11)
data_item_id : int(11)
the_field : varchar(64)
previous_value : text
new_value : text
description : varchar(192)
set_date : datetime
entered_by : int(11)
site_id : int(11)

v		opencats http_log
log_id : int(11)
site_id : int(11)
remote_addr : char(16)
http_user_agent : varchar(255)
script_filename : varchar(255)
request_method : varchar(16)
query_string : varchar(255)
request_uri : varchar(255)
script_name : varchar(255)
log_type : int(11)
date : datetime

v		opencats http_log_types
log_type_id : int(11)
name : varchar(16)
description : varchar(255)
default_log_type : tinyint(1) unsigned zerofill

v		opencats import
import_id : int(11)
module_name : varchar(255)
reverted : int(1)
site_id : int(11)
import_errors : text
added_lines : int(11)
date_created : datetime

v		opencats installtest
id : int(11)

v		opencats joborder
joborder_id : int(11)
recruiter : int(11)
contact_id : int(11)
company_id : int(11)
entered_by : int(11)
owner : int(11)
site_id : int(11)
client_job_id : varchar(32)
title : varchar(64)
description : text
notes : text
type : varchar(64)
duration : varchar(64)
rate_max : varchar(255)
salary : varchar(64)
status : varchar(64)
is_hot : int(1)
openings : int(11)
city : varchar(64)
state : varchar(64)
start_date : datetime
date_created : datetime
date_modified : datetime
public : int(1)
company_department_id : int(11)
is_admin_hidden : int(1)
openings_available : int(11)
questionnaire_id : int(11)
import_id : int(11)

v		opencats module_schema
module_schema_id : int(11)
name : varchar(64)
version : int(11)

v		opencats mru
mru_id : int(11)
user_id : int(11)
site_id : int(11)
data_item_type : int(11)
data_item_text : varchar(64)
url : varchar(255)
date_created : datetime

v		opencats queue
queue_id : int(11)
site_id : int(11)
task : varchar(125)
args : text
priority : tinyint(2)
date_created : datetime
date_timeout : datetime
date_completed : datetime
locked : tinyint(1) unsigned
error : tinyint(1) unsigned
response : varchar(255)

v		opencats saved_list
saved_list_id : int(11)
description : varchar(64)
data_item_type : int(11)
site_id : int(11)
is_dynamic : int(1)
datagrid_instance : varchar(64)
parameters : text
created_by : int(11)
number_entries : int(11)
date_created : datetime
date_modified : datetime

v		opencats saved_list_entry
saved_list_entry_id : int(11)
saved_list_id : int(11)
data_item_type : int(11)
data_item_id : int(11)
site_id : int(11)
date_created : datetime

v		opencats saved_search
search_id : int(11)
data_item_text : text
url : text
is_custom : int(1)
data_item_type : int(11)
user_id : int(11)
site_id : int(11)
date_created : datetime

v		opencats settings
settings_id : int(11)
setting : varchar(255)
value : varchar(255)
site_id : int(11)
settings_type : int(11)

v		opencats site
site_id : int(11)
name : varchar(255)
is_demo : int(1)
user_licenses : int(11)
entered_by : int(11)
date_created : datetime
unix_name : varchar(128)
company_id : int(11)
is_free : int(1)
account_active : int(1)
account_deleted : int(1)
reason_disabled : text
time_zone : int(5)
time_format_24 : int(1)
date_format_ddmmyy : int(1)
is_hr_mode : int(1)
file_size_kb : int(11)
page_views : bigint(20)
page_view_days : int(11)
last_viewed_day : date
first_time_setup : tinyint(4)
localization_configured : int(1)
agreed_to_license : int(1)
limit_warning : tinyint(1)

v		opencats sph_counter
counter_id : int(11)
max_doc_id : int(11)

v		opencats system
system_id : int(20)
uid : int(20)
available_version : int(11)
date_version_checked : datetime
available_version_description : text
disable_version_check : int(1)

v		opencats tag
tag_id : int(10) unsigned
tag_parent_id : int(10) unsigned
title : varchar(255)
description : varchar(500)
site_id : int(11) unsigned
date_created : timestamp

v		opencats user
user_id : int(11)
site_id : int(11)
user_name : varchar(64)
email : varchar(128)
password : varchar(128)
access_level : int(11)
can_change_password : int(1)
is_test_user : int(1)
last_name : varchar(40)
first_name : varchar(40)
is_demo : int(1)
categories : varchar(192)
session_cookie : varchar(256)
pipeline_entries_per_page : int(8)
column_preferences : longtext
force_logout : int(1)
title : varchar(64)
phone_work : varchar(64)
phone_cell : varchar(64)
phone_other : varchar(64)
address : text
notes : text
company : varchar(255)
city : varchar(64)
state : varchar(64)
zip_code : varchar(16)
country : varchar(128)
can_see_eeo_info : int(1)

v		opencats user_login
user_login_id : int(11)
user_id : int(11)
site_id : int(11)
ip : varchar(128)
user_agent : varchar(255)
date : datetime
successful : int(1)
host : varchar(255)
date_refreshed : datetime

v		opencats word_verification
word_verification_ID : int(11)
word : varchar(28)

v		opencats xml_feeds
xml_feed_id : int(11)
name : varchar(50)
description : varchar(255)
website : varchar(255)
post_url : varchar(255)
success_string : varchar(255)
xml_template_name : varchar(255)

v		opencats xml_feed_submits
feed_id : int(11)
feed_site : varchar(75)
feed_url : varchar(255)
date_last_post : date

v		opencats zipcodes
zipcode : mediumint(9)
city : tinytext
state : varchar(2)
areacode : smallint(6)

Create relationship
FOREIGN KEY
on delete
on update