Recent
`tamarisk_legal_advisors`.`wp_wffilemods`
`marketing_ops`.`payroll_details`
`marketing_ops`.`tbid`
`tamarisk_legal_advisors`.`wp_wftrafficrates`
`marketing_ops`.`leavedatebase`
`marketing_ops`.`customerlist`
`marketing_ops_testing`.`tbiddoc`
`tamarisk_legal_advisors`.`wp_wfcrawlers`
`marketing_ops_testing`.`customerlist`
`marketing_ops`.`setting`
Favorites
There are no favorite tables.
New
db
db_empower_migration
db_empower_qa
db_empowe_qa_v2
empower_dev
information_schema
marketing_ops
marketing_ops
marketing_ops_testing
mysql
opencats
performance_schema
phpmyadmin
tamarisk
tamarisk
tamarisk_legal_advisors
test
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: opencats
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:
`access_level`.*
`access_level`.`access_level_id`
`access_level`.`short_description`
`access_level`.`long_description`
`activity`.*
`activity`.`activity_id`
`activity`.`data_item_id`
`activity`.`data_item_type`
`activity`.`joborder_id`
`activity`.`site_id`
`activity`.`entered_by`
`activity`.`date_created`
`activity`.`type`
`activity`.`notes`
`activity`.`date_modified`
`activity_type`.*
`activity_type`.`activity_type_id`
`activity_type`.`short_description`
`attachment`.*
`attachment`.`attachment_id`
`attachment`.`data_item_id`
`attachment`.`data_item_type`
`attachment`.`site_id`
`attachment`.`title`
`attachment`.`original_filename`
`attachment`.`stored_filename`
`attachment`.`content_type`
`attachment`.`resume`
`attachment`.`text`
`attachment`.`date_created`
`attachment`.`date_modified`
`attachment`.`profile_image`
`attachment`.`directory_name`
`attachment`.`md5_sum`
`attachment`.`file_size_kb`
`attachment`.`md5_sum_text`
`calendar_event`.*
`calendar_event`.`calendar_event_id`
`calendar_event`.`type`
`calendar_event`.`date`
`calendar_event`.`title`
`calendar_event`.`all_day`
`calendar_event`.`data_item_id`
`calendar_event`.`data_item_type`
`calendar_event`.`entered_by`
`calendar_event`.`date_created`
`calendar_event`.`date_modified`
`calendar_event`.`site_id`
`calendar_event`.`joborder_id`
`calendar_event`.`description`
`calendar_event`.`duration`
`calendar_event`.`reminder_enabled`
`calendar_event`.`reminder_email`
`calendar_event`.`reminder_time`
`calendar_event`.`public`
`calendar_event_type`.*
`calendar_event_type`.`calendar_event_type_id`
`calendar_event_type`.`short_description`
`calendar_event_type`.`icon_image`
`candidate`.*
`candidate`.`candidate_id`
`candidate`.`site_id`
`candidate`.`last_name`
`candidate`.`first_name`
`candidate`.`middle_name`
`candidate`.`phone_home`
`candidate`.`phone_cell`
`candidate`.`phone_work`
`candidate`.`address`
`candidate`.`city`
`candidate`.`state`
`candidate`.`zip`
`candidate`.`source`
`candidate`.`date_available`
`candidate`.`can_relocate`
`candidate`.`notes`
`candidate`.`key_skills`
`candidate`.`current_employer`
`candidate`.`entered_by`
`candidate`.`owner`
`candidate`.`date_created`
`candidate`.`date_modified`
`candidate`.`email1`
`candidate`.`email2`
`candidate`.`web_site`
`candidate`.`import_id`
`candidate`.`is_hot`
`candidate`.`eeo_ethnic_type_id`
`candidate`.`eeo_veteran_type_id`
`candidate`.`eeo_disability_status`
`candidate`.`eeo_gender`
`candidate`.`desired_pay`
`candidate`.`current_pay`
`candidate`.`is_active`
`candidate`.`is_admin_hidden`
`candidate`.`best_time_to_call`
`candidate_duplicates`.*
`candidate_duplicates`.`old_candidate_id`
`candidate_duplicates`.`new_candidate_id`
`candidate_duplicates`.`site_id`
`candidate_joborder`.*
`candidate_joborder`.`candidate_joborder_id`
`candidate_joborder`.`candidate_id`
`candidate_joborder`.`joborder_id`
`candidate_joborder`.`site_id`
`candidate_joborder`.`status`
`candidate_joborder`.`date_submitted`
`candidate_joborder`.`date_created`
`candidate_joborder`.`date_modified`
`candidate_joborder`.`rating_value`
`candidate_joborder`.`added_by`
`candidate_joborder_status`.*
`candidate_joborder_status`.`candidate_joborder_status_id`
`candidate_joborder_status`.`short_description`
`candidate_joborder_status`.`can_be_scheduled`
`candidate_joborder_status`.`triggers_email`
`candidate_joborder_status`.`is_enabled`
`candidate_joborder_status_history`.*
`candidate_joborder_status_history`.`candidate_joborder_status_history_id`
`candidate_joborder_status_history`.`candidate_id`
`candidate_joborder_status_history`.`joborder_id`
`candidate_joborder_status_history`.`date`
`candidate_joborder_status_history`.`status_from`
`candidate_joborder_status_history`.`status_to`
`candidate_joborder_status_history`.`site_id`
`candidate_jobordrer_status_type`.*
`candidate_jobordrer_status_type`.`candidate_status_type_id`
`candidate_jobordrer_status_type`.`short_description`
`candidate_jobordrer_status_type`.`can_be_scheduled`
`candidate_source`.*
`candidate_source`.`source_id`
`candidate_source`.`name`
`candidate_source`.`site_id`
`candidate_source`.`date_created`
`candidate_tag`.*
`candidate_tag`.`id`
`candidate_tag`.`site_id`
`candidate_tag`.`candidate_id`
`candidate_tag`.`tag_id`
`career_portal_questionnaire`.*
`career_portal_questionnaire`.`career_portal_questionnaire_id`
`career_portal_questionnaire`.`title`
`career_portal_questionnaire`.`site_id`
`career_portal_questionnaire`.`description`
`career_portal_questionnaire`.`is_active`
`career_portal_questionnaire_answer`.*
`career_portal_questionnaire_answer`.`career_portal_questionnaire_answer_id`
`career_portal_questionnaire_answer`.`career_portal_questionnaire_question_id`
`career_portal_questionnaire_answer`.`career_portal_questionnaire_id`
`career_portal_questionnaire_answer`.`text`
`career_portal_questionnaire_answer`.`action_source`
`career_portal_questionnaire_answer`.`action_notes`
`career_portal_questionnaire_answer`.`action_is_hot`
`career_portal_questionnaire_answer`.`action_is_active`
`career_portal_questionnaire_answer`.`action_can_relocate`
`career_portal_questionnaire_answer`.`action_key_skills`
`career_portal_questionnaire_answer`.`position`
`career_portal_questionnaire_answer`.`site_id`
`career_portal_questionnaire_history`.*
`career_portal_questionnaire_history`.`career_portal_questionnaire_history_id`
`career_portal_questionnaire_history`.`site_id`
`career_portal_questionnaire_history`.`candidate_id`
`career_portal_questionnaire_history`.`question`
`career_portal_questionnaire_history`.`answer`
`career_portal_questionnaire_history`.`questionnaire_title`
`career_portal_questionnaire_history`.`questionnaire_description`
`career_portal_questionnaire_history`.`date`
`career_portal_questionnaire_question`.*
`career_portal_questionnaire_question`.`career_portal_questionnaire_question_id`
`career_portal_questionnaire_question`.`career_portal_questionnaire_id`
`career_portal_questionnaire_question`.`text`
`career_portal_questionnaire_question`.`minimum_length`
`career_portal_questionnaire_question`.`maximum_length`
`career_portal_questionnaire_question`.`required`
`career_portal_questionnaire_question`.`position`
`career_portal_questionnaire_question`.`site_id`
`career_portal_questionnaire_question`.`type`
`career_portal_template`.*
`career_portal_template`.`career_portal_template_id`
`career_portal_template`.`career_portal_name`
`career_portal_template`.`setting`
`career_portal_template`.`value`
`career_portal_template_site`.*
`career_portal_template_site`.`career_portal_template_id`
`career_portal_template_site`.`career_portal_name`
`career_portal_template_site`.`site_id`
`career_portal_template_site`.`setting`
`career_portal_template_site`.`value`
`company`.*
`company`.`company_id`
`company`.`site_id`
`company`.`billing_contact`
`company`.`name`
`company`.`address`
`company`.`city`
`company`.`state`
`company`.`zip`
`company`.`phone1`
`company`.`phone2`
`company`.`url`
`company`.`key_technologies`
`company`.`notes`
`company`.`entered_by`
`company`.`owner`
`company`.`date_created`
`company`.`date_modified`
`company`.`is_hot`
`company`.`fax_number`
`company`.`import_id`
`company`.`default_company`
`company_department`.*
`company_department`.`company_department_id`
`company_department`.`name`
`company_department`.`company_id`
`company_department`.`site_id`
`company_department`.`date_created`
`company_department`.`created_by`
`contact`.*
`contact`.`contact_id`
`contact`.`company_id`
`contact`.`site_id`
`contact`.`last_name`
`contact`.`first_name`
`contact`.`title`
`contact`.`email1`
`contact`.`email2`
`contact`.`phone_work`
`contact`.`phone_cell`
`contact`.`phone_other`
`contact`.`address`
`contact`.`city`
`contact`.`state`
`contact`.`zip`
`contact`.`is_hot`
`contact`.`notes`
`contact`.`entered_by`
`contact`.`owner`
`contact`.`date_created`
`contact`.`date_modified`
`contact`.`left_company`
`contact`.`import_id`
`contact`.`company_department_id`
`contact`.`reports_to`
`data_item_type`.*
`data_item_type`.`data_item_type_id`
`data_item_type`.`short_description`
`eeo_ethnic_type`.*
`eeo_ethnic_type`.`eeo_ethnic_type_id`
`eeo_ethnic_type`.`type`
`eeo_veteran_type`.*
`eeo_veteran_type`.`eeo_veteran_type_id`
`eeo_veteran_type`.`type`
`email_history`.*
`email_history`.`email_history_id`
`email_history`.`from_address`
`email_history`.`recipients`
`email_history`.`text`
`email_history`.`user_id`
`email_history`.`site_id`
`email_history`.`date`
`email_template`.*
`email_template`.`email_template_id`
`email_template`.`text`
`email_template`.`allow_substitution`
`email_template`.`site_id`
`email_template`.`tag`
`email_template`.`title`
`email_template`.`possible_variables`
`email_template`.`disabled`
`extension_statistics`.*
`extension_statistics`.`extension_statistics_id`
`extension_statistics`.`extension`
`extension_statistics`.`action`
`extension_statistics`.`user`
`extension_statistics`.`date`
`extra_field`.*
`extra_field`.`extra_field_id`
`extra_field`.`data_item_id`
`extra_field`.`field_name`
`extra_field`.`value`
`extra_field`.`import_id`
`extra_field`.`site_id`
`extra_field`.`data_item_type`
`extra_field_settings`.*
`extra_field_settings`.`extra_field_settings_id`
`extra_field_settings`.`field_name`
`extra_field_settings`.`import_id`
`extra_field_settings`.`site_id`
`extra_field_settings`.`date_created`
`extra_field_settings`.`data_item_type`
`extra_field_settings`.`extra_field_type`
`extra_field_settings`.`extra_field_options`
`extra_field_settings`.`position`
`feedback`.*
`feedback`.`feedback_id`
`feedback`.`user_id`
`feedback`.`site_id`
`feedback`.`date_created`
`feedback`.`subject`
`feedback`.`reply_to_address`
`feedback`.`reply_to_name`
`feedback`.`feedback`
`feedback`.`archived`
`history`.*
`history`.`history_id`
`history`.`data_item_type`
`history`.`data_item_id`
`history`.`the_field`
`history`.`previous_value`
`history`.`new_value`
`history`.`description`
`history`.`set_date`
`history`.`entered_by`
`history`.`site_id`
`http_log`.*
`http_log`.`log_id`
`http_log`.`site_id`
`http_log`.`remote_addr`
`http_log`.`http_user_agent`
`http_log`.`script_filename`
`http_log`.`request_method`
`http_log`.`query_string`
`http_log`.`request_uri`
`http_log`.`script_name`
`http_log`.`log_type`
`http_log`.`date`
`http_log_types`.*
`http_log_types`.`log_type_id`
`http_log_types`.`name`
`http_log_types`.`description`
`http_log_types`.`default_log_type`
`import`.*
`import`.`import_id`
`import`.`module_name`
`import`.`reverted`
`import`.`site_id`
`import`.`import_errors`
`import`.`added_lines`
`import`.`date_created`
`installtest`.*
`installtest`.`id`
`joborder`.*
`joborder`.`joborder_id`
`joborder`.`recruiter`
`joborder`.`contact_id`
`joborder`.`company_id`
`joborder`.`entered_by`
`joborder`.`owner`
`joborder`.`site_id`
`joborder`.`client_job_id`
`joborder`.`title`
`joborder`.`description`
`joborder`.`notes`
`joborder`.`type`
`joborder`.`duration`
`joborder`.`rate_max`
`joborder`.`salary`
`joborder`.`status`
`joborder`.`is_hot`
`joborder`.`openings`
`joborder`.`city`
`joborder`.`state`
`joborder`.`start_date`
`joborder`.`date_created`
`joborder`.`date_modified`
`joborder`.`public`
`joborder`.`company_department_id`
`joborder`.`is_admin_hidden`
`joborder`.`openings_available`
`joborder`.`questionnaire_id`
`joborder`.`import_id`
`module_schema`.*
`module_schema`.`module_schema_id`
`module_schema`.`name`
`module_schema`.`version`
`mru`.*
`mru`.`mru_id`
`mru`.`user_id`
`mru`.`site_id`
`mru`.`data_item_type`
`mru`.`data_item_text`
`mru`.`url`
`mru`.`date_created`
`queue`.*
`queue`.`queue_id`
`queue`.`site_id`
`queue`.`task`
`queue`.`args`
`queue`.`priority`
`queue`.`date_created`
`queue`.`date_timeout`
`queue`.`date_completed`
`queue`.`locked`
`queue`.`error`
`queue`.`response`
`saved_list`.*
`saved_list`.`saved_list_id`
`saved_list`.`description`
`saved_list`.`data_item_type`
`saved_list`.`site_id`
`saved_list`.`is_dynamic`
`saved_list`.`datagrid_instance`
`saved_list`.`parameters`
`saved_list`.`created_by`
`saved_list`.`number_entries`
`saved_list`.`date_created`
`saved_list`.`date_modified`
`saved_list_entry`.*
`saved_list_entry`.`saved_list_entry_id`
`saved_list_entry`.`saved_list_id`
`saved_list_entry`.`data_item_type`
`saved_list_entry`.`data_item_id`
`saved_list_entry`.`site_id`
`saved_list_entry`.`date_created`
`saved_search`.*
`saved_search`.`search_id`
`saved_search`.`data_item_text`
`saved_search`.`url`
`saved_search`.`is_custom`
`saved_search`.`data_item_type`
`saved_search`.`user_id`
`saved_search`.`site_id`
`saved_search`.`date_created`
`settings`.*
`settings`.`settings_id`
`settings`.`setting`
`settings`.`value`
`settings`.`site_id`
`settings`.`settings_type`
`site`.*
`site`.`site_id`
`site`.`name`
`site`.`is_demo`
`site`.`user_licenses`
`site`.`entered_by`
`site`.`date_created`
`site`.`unix_name`
`site`.`company_id`
`site`.`is_free`
`site`.`account_active`
`site`.`account_deleted`
`site`.`reason_disabled`
`site`.`time_zone`
`site`.`time_format_24`
`site`.`date_format_ddmmyy`
`site`.`is_hr_mode`
`site`.`file_size_kb`
`site`.`page_views`
`site`.`page_view_days`
`site`.`last_viewed_day`
`site`.`first_time_setup`
`site`.`localization_configured`
`site`.`agreed_to_license`
`site`.`limit_warning`
`sph_counter`.*
`sph_counter`.`counter_id`
`sph_counter`.`max_doc_id`
`system`.*
`system`.`system_id`
`system`.`uid`
`system`.`available_version`
`system`.`date_version_checked`
`system`.`available_version_description`
`system`.`disable_version_check`
`tag`.*
`tag`.`tag_id`
`tag`.`tag_parent_id`
`tag`.`title`
`tag`.`description`
`tag`.`site_id`
`tag`.`date_created`
`user`.*
`user`.`user_id`
`user`.`site_id`
`user`.`user_name`
`user`.`email`
`user`.`password`
`user`.`access_level`
`user`.`can_change_password`
`user`.`is_test_user`
`user`.`last_name`
`user`.`first_name`
`user`.`is_demo`
`user`.`categories`
`user`.`session_cookie`
`user`.`pipeline_entries_per_page`
`user`.`column_preferences`
`user`.`force_logout`
`user`.`title`
`user`.`phone_work`
`user`.`phone_cell`
`user`.`phone_other`
`user`.`address`
`user`.`notes`
`user`.`company`
`user`.`city`
`user`.`state`
`user`.`zip_code`
`user`.`country`
`user`.`can_see_eeo_info`
`user_login`.*
`user_login`.`user_login_id`
`user_login`.`user_id`
`user_login`.`site_id`
`user_login`.`ip`
`user_login`.`user_agent`
`user_login`.`date`
`user_login`.`successful`
`user_login`.`host`
`user_login`.`date_refreshed`
`word_verification`.*
`word_verification`.`word_verification_ID`
`word_verification`.`word`
`xml_feed_submits`.*
`xml_feed_submits`.`feed_id`
`xml_feed_submits`.`feed_site`
`xml_feed_submits`.`feed_url`
`xml_feed_submits`.`date_last_post`
`xml_feeds`.*
`xml_feeds`.`xml_feed_id`
`xml_feeds`.`name`
`xml_feeds`.`description`
`xml_feeds`.`website`
`xml_feeds`.`post_url`
`xml_feeds`.`success_string`
`xml_feeds`.`xml_template_name`
`zipcodes`.*
`zipcodes`.`zipcode`
`zipcodes`.`city`
`zipcodes`.`state`
`zipcodes`.`areacode`
`access_level`.*
`access_level`.`access_level_id`
`access_level`.`short_description`
`access_level`.`long_description`
`activity`.*
`activity`.`activity_id`
`activity`.`data_item_id`
`activity`.`data_item_type`
`activity`.`joborder_id`
`activity`.`site_id`
`activity`.`entered_by`
`activity`.`date_created`
`activity`.`type`
`activity`.`notes`
`activity`.`date_modified`
`activity_type`.*
`activity_type`.`activity_type_id`
`activity_type`.`short_description`
`attachment`.*
`attachment`.`attachment_id`
`attachment`.`data_item_id`
`attachment`.`data_item_type`
`attachment`.`site_id`
`attachment`.`title`
`attachment`.`original_filename`
`attachment`.`stored_filename`
`attachment`.`content_type`
`attachment`.`resume`
`attachment`.`text`
`attachment`.`date_created`
`attachment`.`date_modified`
`attachment`.`profile_image`
`attachment`.`directory_name`
`attachment`.`md5_sum`
`attachment`.`file_size_kb`
`attachment`.`md5_sum_text`
`calendar_event`.*
`calendar_event`.`calendar_event_id`
`calendar_event`.`type`
`calendar_event`.`date`
`calendar_event`.`title`
`calendar_event`.`all_day`
`calendar_event`.`data_item_id`
`calendar_event`.`data_item_type`
`calendar_event`.`entered_by`
`calendar_event`.`date_created`
`calendar_event`.`date_modified`
`calendar_event`.`site_id`
`calendar_event`.`joborder_id`
`calendar_event`.`description`
`calendar_event`.`duration`
`calendar_event`.`reminder_enabled`
`calendar_event`.`reminder_email`
`calendar_event`.`reminder_time`
`calendar_event`.`public`
`calendar_event_type`.*
`calendar_event_type`.`calendar_event_type_id`
`calendar_event_type`.`short_description`
`calendar_event_type`.`icon_image`
`candidate`.*
`candidate`.`candidate_id`
`candidate`.`site_id`
`candidate`.`last_name`
`candidate`.`first_name`
`candidate`.`middle_name`
`candidate`.`phone_home`
`candidate`.`phone_cell`
`candidate`.`phone_work`
`candidate`.`address`
`candidate`.`city`
`candidate`.`state`
`candidate`.`zip`
`candidate`.`source`
`candidate`.`date_available`
`candidate`.`can_relocate`
`candidate`.`notes`
`candidate`.`key_skills`
`candidate`.`current_employer`
`candidate`.`entered_by`
`candidate`.`owner`
`candidate`.`date_created`
`candidate`.`date_modified`
`candidate`.`email1`
`candidate`.`email2`
`candidate`.`web_site`
`candidate`.`import_id`
`candidate`.`is_hot`
`candidate`.`eeo_ethnic_type_id`
`candidate`.`eeo_veteran_type_id`
`candidate`.`eeo_disability_status`
`candidate`.`eeo_gender`
`candidate`.`desired_pay`
`candidate`.`current_pay`
`candidate`.`is_active`
`candidate`.`is_admin_hidden`
`candidate`.`best_time_to_call`
`candidate_duplicates`.*
`candidate_duplicates`.`old_candidate_id`
`candidate_duplicates`.`new_candidate_id`
`candidate_duplicates`.`site_id`
`candidate_joborder`.*
`candidate_joborder`.`candidate_joborder_id`
`candidate_joborder`.`candidate_id`
`candidate_joborder`.`joborder_id`
`candidate_joborder`.`site_id`
`candidate_joborder`.`status`
`candidate_joborder`.`date_submitted`
`candidate_joborder`.`date_created`
`candidate_joborder`.`date_modified`
`candidate_joborder`.`rating_value`
`candidate_joborder`.`added_by`
`candidate_joborder_status`.*
`candidate_joborder_status`.`candidate_joborder_status_id`
`candidate_joborder_status`.`short_description`
`candidate_joborder_status`.`can_be_scheduled`
`candidate_joborder_status`.`triggers_email`
`candidate_joborder_status`.`is_enabled`
`candidate_joborder_status_history`.*
`candidate_joborder_status_history`.`candidate_joborder_status_history_id`
`candidate_joborder_status_history`.`candidate_id`
`candidate_joborder_status_history`.`joborder_id`
`candidate_joborder_status_history`.`date`
`candidate_joborder_status_history`.`status_from`
`candidate_joborder_status_history`.`status_to`
`candidate_joborder_status_history`.`site_id`
`candidate_jobordrer_status_type`.*
`candidate_jobordrer_status_type`.`candidate_status_type_id`
`candidate_jobordrer_status_type`.`short_description`
`candidate_jobordrer_status_type`.`can_be_scheduled`
`candidate_source`.*
`candidate_source`.`source_id`
`candidate_source`.`name`
`candidate_source`.`site_id`
`candidate_source`.`date_created`
`candidate_tag`.*
`candidate_tag`.`id`
`candidate_tag`.`site_id`
`candidate_tag`.`candidate_id`
`candidate_tag`.`tag_id`
`career_portal_questionnaire`.*
`career_portal_questionnaire`.`career_portal_questionnaire_id`
`career_portal_questionnaire`.`title`
`career_portal_questionnaire`.`site_id`
`career_portal_questionnaire`.`description`
`career_portal_questionnaire`.`is_active`
`career_portal_questionnaire_answer`.*
`career_portal_questionnaire_answer`.`career_portal_questionnaire_answer_id`
`career_portal_questionnaire_answer`.`career_portal_questionnaire_question_id`
`career_portal_questionnaire_answer`.`career_portal_questionnaire_id`
`career_portal_questionnaire_answer`.`text`
`career_portal_questionnaire_answer`.`action_source`
`career_portal_questionnaire_answer`.`action_notes`
`career_portal_questionnaire_answer`.`action_is_hot`
`career_portal_questionnaire_answer`.`action_is_active`
`career_portal_questionnaire_answer`.`action_can_relocate`
`career_portal_questionnaire_answer`.`action_key_skills`
`career_portal_questionnaire_answer`.`position`
`career_portal_questionnaire_answer`.`site_id`
`career_portal_questionnaire_history`.*
`career_portal_questionnaire_history`.`career_portal_questionnaire_history_id`
`career_portal_questionnaire_history`.`site_id`
`career_portal_questionnaire_history`.`candidate_id`
`career_portal_questionnaire_history`.`question`
`career_portal_questionnaire_history`.`answer`
`career_portal_questionnaire_history`.`questionnaire_title`
`career_portal_questionnaire_history`.`questionnaire_description`
`career_portal_questionnaire_history`.`date`
`career_portal_questionnaire_question`.*
`career_portal_questionnaire_question`.`career_portal_questionnaire_question_id`
`career_portal_questionnaire_question`.`career_portal_questionnaire_id`
`career_portal_questionnaire_question`.`text`
`career_portal_questionnaire_question`.`minimum_length`
`career_portal_questionnaire_question`.`maximum_length`
`career_portal_questionnaire_question`.`required`
`career_portal_questionnaire_question`.`position`
`career_portal_questionnaire_question`.`site_id`
`career_portal_questionnaire_question`.`type`
`career_portal_template`.*
`career_portal_template`.`career_portal_template_id`
`career_portal_template`.`career_portal_name`
`career_portal_template`.`setting`
`career_portal_template`.`value`
`career_portal_template_site`.*
`career_portal_template_site`.`career_portal_template_id`
`career_portal_template_site`.`career_portal_name`
`career_portal_template_site`.`site_id`
`career_portal_template_site`.`setting`
`career_portal_template_site`.`value`
`company`.*
`company`.`company_id`
`company`.`site_id`
`company`.`billing_contact`
`company`.`name`
`company`.`address`
`company`.`city`
`company`.`state`
`company`.`zip`
`company`.`phone1`
`company`.`phone2`
`company`.`url`
`company`.`key_technologies`
`company`.`notes`
`company`.`entered_by`
`company`.`owner`
`company`.`date_created`
`company`.`date_modified`
`company`.`is_hot`
`company`.`fax_number`
`company`.`import_id`
`company`.`default_company`
`company_department`.*
`company_department`.`company_department_id`
`company_department`.`name`
`company_department`.`company_id`
`company_department`.`site_id`
`company_department`.`date_created`
`company_department`.`created_by`
`contact`.*
`contact`.`contact_id`
`contact`.`company_id`
`contact`.`site_id`
`contact`.`last_name`
`contact`.`first_name`
`contact`.`title`
`contact`.`email1`
`contact`.`email2`
`contact`.`phone_work`
`contact`.`phone_cell`
`contact`.`phone_other`
`contact`.`address`
`contact`.`city`
`contact`.`state`
`contact`.`zip`
`contact`.`is_hot`
`contact`.`notes`
`contact`.`entered_by`
`contact`.`owner`
`contact`.`date_created`
`contact`.`date_modified`
`contact`.`left_company`
`contact`.`import_id`
`contact`.`company_department_id`
`contact`.`reports_to`
`data_item_type`.*
`data_item_type`.`data_item_type_id`
`data_item_type`.`short_description`
`eeo_ethnic_type`.*
`eeo_ethnic_type`.`eeo_ethnic_type_id`
`eeo_ethnic_type`.`type`
`eeo_veteran_type`.*
`eeo_veteran_type`.`eeo_veteran_type_id`
`eeo_veteran_type`.`type`
`email_history`.*
`email_history`.`email_history_id`
`email_history`.`from_address`
`email_history`.`recipients`
`email_history`.`text`
`email_history`.`user_id`
`email_history`.`site_id`
`email_history`.`date`
`email_template`.*
`email_template`.`email_template_id`
`email_template`.`text`
`email_template`.`allow_substitution`
`email_template`.`site_id`
`email_template`.`tag`
`email_template`.`title`
`email_template`.`possible_variables`
`email_template`.`disabled`
`extension_statistics`.*
`extension_statistics`.`extension_statistics_id`
`extension_statistics`.`extension`
`extension_statistics`.`action`
`extension_statistics`.`user`
`extension_statistics`.`date`
`extra_field`.*
`extra_field`.`extra_field_id`
`extra_field`.`data_item_id`
`extra_field`.`field_name`
`extra_field`.`value`
`extra_field`.`import_id`
`extra_field`.`site_id`
`extra_field`.`data_item_type`
`extra_field_settings`.*
`extra_field_settings`.`extra_field_settings_id`
`extra_field_settings`.`field_name`
`extra_field_settings`.`import_id`
`extra_field_settings`.`site_id`
`extra_field_settings`.`date_created`
`extra_field_settings`.`data_item_type`
`extra_field_settings`.`extra_field_type`
`extra_field_settings`.`extra_field_options`
`extra_field_settings`.`position`
`feedback`.*
`feedback`.`feedback_id`
`feedback`.`user_id`
`feedback`.`site_id`
`feedback`.`date_created`
`feedback`.`subject`
`feedback`.`reply_to_address`
`feedback`.`reply_to_name`
`feedback`.`feedback`
`feedback`.`archived`
`history`.*
`history`.`history_id`
`history`.`data_item_type`
`history`.`data_item_id`
`history`.`the_field`
`history`.`previous_value`
`history`.`new_value`
`history`.`description`
`history`.`set_date`
`history`.`entered_by`
`history`.`site_id`
`http_log`.*
`http_log`.`log_id`
`http_log`.`site_id`
`http_log`.`remote_addr`
`http_log`.`http_user_agent`
`http_log`.`script_filename`
`http_log`.`request_method`
`http_log`.`query_string`
`http_log`.`request_uri`
`http_log`.`script_name`
`http_log`.`log_type`
`http_log`.`date`
`http_log_types`.*
`http_log_types`.`log_type_id`
`http_log_types`.`name`
`http_log_types`.`description`
`http_log_types`.`default_log_type`
`import`.*
`import`.`import_id`
`import`.`module_name`
`import`.`reverted`
`import`.`site_id`
`import`.`import_errors`
`import`.`added_lines`
`import`.`date_created`
`installtest`.*
`installtest`.`id`
`joborder`.*
`joborder`.`joborder_id`
`joborder`.`recruiter`
`joborder`.`contact_id`
`joborder`.`company_id`
`joborder`.`entered_by`
`joborder`.`owner`
`joborder`.`site_id`
`joborder`.`client_job_id`
`joborder`.`title`
`joborder`.`description`
`joborder`.`notes`
`joborder`.`type`
`joborder`.`duration`
`joborder`.`rate_max`
`joborder`.`salary`
`joborder`.`status`
`joborder`.`is_hot`
`joborder`.`openings`
`joborder`.`city`
`joborder`.`state`
`joborder`.`start_date`
`joborder`.`date_created`
`joborder`.`date_modified`
`joborder`.`public`
`joborder`.`company_department_id`
`joborder`.`is_admin_hidden`
`joborder`.`openings_available`
`joborder`.`questionnaire_id`
`joborder`.`import_id`
`module_schema`.*
`module_schema`.`module_schema_id`
`module_schema`.`name`
`module_schema`.`version`
`mru`.*
`mru`.`mru_id`
`mru`.`user_id`
`mru`.`site_id`
`mru`.`data_item_type`
`mru`.`data_item_text`
`mru`.`url`
`mru`.`date_created`
`queue`.*
`queue`.`queue_id`
`queue`.`site_id`
`queue`.`task`
`queue`.`args`
`queue`.`priority`
`queue`.`date_created`
`queue`.`date_timeout`
`queue`.`date_completed`
`queue`.`locked`
`queue`.`error`
`queue`.`response`
`saved_list`.*
`saved_list`.`saved_list_id`
`saved_list`.`description`
`saved_list`.`data_item_type`
`saved_list`.`site_id`
`saved_list`.`is_dynamic`
`saved_list`.`datagrid_instance`
`saved_list`.`parameters`
`saved_list`.`created_by`
`saved_list`.`number_entries`
`saved_list`.`date_created`
`saved_list`.`date_modified`
`saved_list_entry`.*
`saved_list_entry`.`saved_list_entry_id`
`saved_list_entry`.`saved_list_id`
`saved_list_entry`.`data_item_type`
`saved_list_entry`.`data_item_id`
`saved_list_entry`.`site_id`
`saved_list_entry`.`date_created`
`saved_search`.*
`saved_search`.`search_id`
`saved_search`.`data_item_text`
`saved_search`.`url`
`saved_search`.`is_custom`
`saved_search`.`data_item_type`
`saved_search`.`user_id`
`saved_search`.`site_id`
`saved_search`.`date_created`
`settings`.*
`settings`.`settings_id`
`settings`.`setting`
`settings`.`value`
`settings`.`site_id`
`settings`.`settings_type`
`site`.*
`site`.`site_id`
`site`.`name`
`site`.`is_demo`
`site`.`user_licenses`
`site`.`entered_by`
`site`.`date_created`
`site`.`unix_name`
`site`.`company_id`
`site`.`is_free`
`site`.`account_active`
`site`.`account_deleted`
`site`.`reason_disabled`
`site`.`time_zone`
`site`.`time_format_24`
`site`.`date_format_ddmmyy`
`site`.`is_hr_mode`
`site`.`file_size_kb`
`site`.`page_views`
`site`.`page_view_days`
`site`.`last_viewed_day`
`site`.`first_time_setup`
`site`.`localization_configured`
`site`.`agreed_to_license`
`site`.`limit_warning`
`sph_counter`.*
`sph_counter`.`counter_id`
`sph_counter`.`max_doc_id`
`system`.*
`system`.`system_id`
`system`.`uid`
`system`.`available_version`
`system`.`date_version_checked`
`system`.`available_version_description`
`system`.`disable_version_check`
`tag`.*
`tag`.`tag_id`
`tag`.`tag_parent_id`
`tag`.`title`
`tag`.`description`
`tag`.`site_id`
`tag`.`date_created`
`user`.*
`user`.`user_id`
`user`.`site_id`
`user`.`user_name`
`user`.`email`
`user`.`password`
`user`.`access_level`
`user`.`can_change_password`
`user`.`is_test_user`
`user`.`last_name`
`user`.`first_name`
`user`.`is_demo`
`user`.`categories`
`user`.`session_cookie`
`user`.`pipeline_entries_per_page`
`user`.`column_preferences`
`user`.`force_logout`
`user`.`title`
`user`.`phone_work`
`user`.`phone_cell`
`user`.`phone_other`
`user`.`address`
`user`.`notes`
`user`.`company`
`user`.`city`
`user`.`state`
`user`.`zip_code`
`user`.`country`
`user`.`can_see_eeo_info`
`user_login`.*
`user_login`.`user_login_id`
`user_login`.`user_id`
`user_login`.`site_id`
`user_login`.`ip`
`user_login`.`user_agent`
`user_login`.`date`
`user_login`.`successful`
`user_login`.`host`
`user_login`.`date_refreshed`
`word_verification`.*
`word_verification`.`word_verification_ID`
`word_verification`.`word`
`xml_feed_submits`.*
`xml_feed_submits`.`feed_id`
`xml_feed_submits`.`feed_site`
`xml_feed_submits`.`feed_url`
`xml_feed_submits`.`date_last_post`
`xml_feeds`.*
`xml_feeds`.`xml_feed_id`
`xml_feeds`.`name`
`xml_feeds`.`description`
`xml_feeds`.`website`
`xml_feeds`.`post_url`
`xml_feeds`.`success_string`
`xml_feeds`.`xml_template_name`
`zipcodes`.*
`zipcodes`.`zipcode`
`zipcodes`.`city`
`zipcodes`.`state`
`zipcodes`.`areacode`
`access_level`.*
`access_level`.`access_level_id`
`access_level`.`short_description`
`access_level`.`long_description`
`activity`.*
`activity`.`activity_id`
`activity`.`data_item_id`
`activity`.`data_item_type`
`activity`.`joborder_id`
`activity`.`site_id`
`activity`.`entered_by`
`activity`.`date_created`
`activity`.`type`
`activity`.`notes`
`activity`.`date_modified`
`activity_type`.*
`activity_type`.`activity_type_id`
`activity_type`.`short_description`
`attachment`.*
`attachment`.`attachment_id`
`attachment`.`data_item_id`
`attachment`.`data_item_type`
`attachment`.`site_id`
`attachment`.`title`
`attachment`.`original_filename`
`attachment`.`stored_filename`
`attachment`.`content_type`
`attachment`.`resume`
`attachment`.`text`
`attachment`.`date_created`
`attachment`.`date_modified`
`attachment`.`profile_image`
`attachment`.`directory_name`
`attachment`.`md5_sum`
`attachment`.`file_size_kb`
`attachment`.`md5_sum_text`
`calendar_event`.*
`calendar_event`.`calendar_event_id`
`calendar_event`.`type`
`calendar_event`.`date`
`calendar_event`.`title`
`calendar_event`.`all_day`
`calendar_event`.`data_item_id`
`calendar_event`.`data_item_type`
`calendar_event`.`entered_by`
`calendar_event`.`date_created`
`calendar_event`.`date_modified`
`calendar_event`.`site_id`
`calendar_event`.`joborder_id`
`calendar_event`.`description`
`calendar_event`.`duration`
`calendar_event`.`reminder_enabled`
`calendar_event`.`reminder_email`
`calendar_event`.`reminder_time`
`calendar_event`.`public`
`calendar_event_type`.*
`calendar_event_type`.`calendar_event_type_id`
`calendar_event_type`.`short_description`
`calendar_event_type`.`icon_image`
`candidate`.*
`candidate`.`candidate_id`
`candidate`.`site_id`
`candidate`.`last_name`
`candidate`.`first_name`
`candidate`.`middle_name`
`candidate`.`phone_home`
`candidate`.`phone_cell`
`candidate`.`phone_work`
`candidate`.`address`
`candidate`.`city`
`candidate`.`state`
`candidate`.`zip`
`candidate`.`source`
`candidate`.`date_available`
`candidate`.`can_relocate`
`candidate`.`notes`
`candidate`.`key_skills`
`candidate`.`current_employer`
`candidate`.`entered_by`
`candidate`.`owner`
`candidate`.`date_created`
`candidate`.`date_modified`
`candidate`.`email1`
`candidate`.`email2`
`candidate`.`web_site`
`candidate`.`import_id`
`candidate`.`is_hot`
`candidate`.`eeo_ethnic_type_id`
`candidate`.`eeo_veteran_type_id`
`candidate`.`eeo_disability_status`
`candidate`.`eeo_gender`
`candidate`.`desired_pay`
`candidate`.`current_pay`
`candidate`.`is_active`
`candidate`.`is_admin_hidden`
`candidate`.`best_time_to_call`
`candidate_duplicates`.*
`candidate_duplicates`.`old_candidate_id`
`candidate_duplicates`.`new_candidate_id`
`candidate_duplicates`.`site_id`
`candidate_joborder`.*
`candidate_joborder`.`candidate_joborder_id`
`candidate_joborder`.`candidate_id`
`candidate_joborder`.`joborder_id`
`candidate_joborder`.`site_id`
`candidate_joborder`.`status`
`candidate_joborder`.`date_submitted`
`candidate_joborder`.`date_created`
`candidate_joborder`.`date_modified`
`candidate_joborder`.`rating_value`
`candidate_joborder`.`added_by`
`candidate_joborder_status`.*
`candidate_joborder_status`.`candidate_joborder_status_id`
`candidate_joborder_status`.`short_description`
`candidate_joborder_status`.`can_be_scheduled`
`candidate_joborder_status`.`triggers_email`
`candidate_joborder_status`.`is_enabled`
`candidate_joborder_status_history`.*
`candidate_joborder_status_history`.`candidate_joborder_status_history_id`
`candidate_joborder_status_history`.`candidate_id`
`candidate_joborder_status_history`.`joborder_id`
`candidate_joborder_status_history`.`date`
`candidate_joborder_status_history`.`status_from`
`candidate_joborder_status_history`.`status_to`
`candidate_joborder_status_history`.`site_id`
`candidate_jobordrer_status_type`.*
`candidate_jobordrer_status_type`.`candidate_status_type_id`
`candidate_jobordrer_status_type`.`short_description`
`candidate_jobordrer_status_type`.`can_be_scheduled`
`candidate_source`.*
`candidate_source`.`source_id`
`candidate_source`.`name`
`candidate_source`.`site_id`
`candidate_source`.`date_created`
`candidate_tag`.*
`candidate_tag`.`id`
`candidate_tag`.`site_id`
`candidate_tag`.`candidate_id`
`candidate_tag`.`tag_id`
`career_portal_questionnaire`.*
`career_portal_questionnaire`.`career_portal_questionnaire_id`
`career_portal_questionnaire`.`title`
`career_portal_questionnaire`.`site_id`
`career_portal_questionnaire`.`description`
`career_portal_questionnaire`.`is_active`
`career_portal_questionnaire_answer`.*
`career_portal_questionnaire_answer`.`career_portal_questionnaire_answer_id`
`career_portal_questionnaire_answer`.`career_portal_questionnaire_question_id`
`career_portal_questionnaire_answer`.`career_portal_questionnaire_id`
`career_portal_questionnaire_answer`.`text`
`career_portal_questionnaire_answer`.`action_source`
`career_portal_questionnaire_answer`.`action_notes`
`career_portal_questionnaire_answer`.`action_is_hot`
`career_portal_questionnaire_answer`.`action_is_active`
`career_portal_questionnaire_answer`.`action_can_relocate`
`career_portal_questionnaire_answer`.`action_key_skills`
`career_portal_questionnaire_answer`.`position`
`career_portal_questionnaire_answer`.`site_id`
`career_portal_questionnaire_history`.*
`career_portal_questionnaire_history`.`career_portal_questionnaire_history_id`
`career_portal_questionnaire_history`.`site_id`
`career_portal_questionnaire_history`.`candidate_id`
`career_portal_questionnaire_history`.`question`
`career_portal_questionnaire_history`.`answer`
`career_portal_questionnaire_history`.`questionnaire_title`
`career_portal_questionnaire_history`.`questionnaire_description`
`career_portal_questionnaire_history`.`date`
`career_portal_questionnaire_question`.*
`career_portal_questionnaire_question`.`career_portal_questionnaire_question_id`
`career_portal_questionnaire_question`.`career_portal_questionnaire_id`
`career_portal_questionnaire_question`.`text`
`career_portal_questionnaire_question`.`minimum_length`
`career_portal_questionnaire_question`.`maximum_length`
`career_portal_questionnaire_question`.`required`
`career_portal_questionnaire_question`.`position`
`career_portal_questionnaire_question`.`site_id`
`career_portal_questionnaire_question`.`type`
`career_portal_template`.*
`career_portal_template`.`career_portal_template_id`
`career_portal_template`.`career_portal_name`
`career_portal_template`.`setting`
`career_portal_template`.`value`
`career_portal_template_site`.*
`career_portal_template_site`.`career_portal_template_id`
`career_portal_template_site`.`career_portal_name`
`career_portal_template_site`.`site_id`
`career_portal_template_site`.`setting`
`career_portal_template_site`.`value`
`company`.*
`company`.`company_id`
`company`.`site_id`
`company`.`billing_contact`
`company`.`name`
`company`.`address`
`company`.`city`
`company`.`state`
`company`.`zip`
`company`.`phone1`
`company`.`phone2`
`company`.`url`
`company`.`key_technologies`
`company`.`notes`
`company`.`entered_by`
`company`.`owner`
`company`.`date_created`
`company`.`date_modified`
`company`.`is_hot`
`company`.`fax_number`
`company`.`import_id`
`company`.`default_company`
`company_department`.*
`company_department`.`company_department_id`
`company_department`.`name`
`company_department`.`company_id`
`company_department`.`site_id`
`company_department`.`date_created`
`company_department`.`created_by`
`contact`.*
`contact`.`contact_id`
`contact`.`company_id`
`contact`.`site_id`
`contact`.`last_name`
`contact`.`first_name`
`contact`.`title`
`contact`.`email1`
`contact`.`email2`
`contact`.`phone_work`
`contact`.`phone_cell`
`contact`.`phone_other`
`contact`.`address`
`contact`.`city`
`contact`.`state`
`contact`.`zip`
`contact`.`is_hot`
`contact`.`notes`
`contact`.`entered_by`
`contact`.`owner`
`contact`.`date_created`
`contact`.`date_modified`
`contact`.`left_company`
`contact`.`import_id`
`contact`.`company_department_id`
`contact`.`reports_to`
`data_item_type`.*
`data_item_type`.`data_item_type_id`
`data_item_type`.`short_description`
`eeo_ethnic_type`.*
`eeo_ethnic_type`.`eeo_ethnic_type_id`
`eeo_ethnic_type`.`type`
`eeo_veteran_type`.*
`eeo_veteran_type`.`eeo_veteran_type_id`
`eeo_veteran_type`.`type`
`email_history`.*
`email_history`.`email_history_id`
`email_history`.`from_address`
`email_history`.`recipients`
`email_history`.`text`
`email_history`.`user_id`
`email_history`.`site_id`
`email_history`.`date`
`email_template`.*
`email_template`.`email_template_id`
`email_template`.`text`
`email_template`.`allow_substitution`
`email_template`.`site_id`
`email_template`.`tag`
`email_template`.`title`
`email_template`.`possible_variables`
`email_template`.`disabled`
`extension_statistics`.*
`extension_statistics`.`extension_statistics_id`
`extension_statistics`.`extension`
`extension_statistics`.`action`
`extension_statistics`.`user`
`extension_statistics`.`date`
`extra_field`.*
`extra_field`.`extra_field_id`
`extra_field`.`data_item_id`
`extra_field`.`field_name`
`extra_field`.`value`
`extra_field`.`import_id`
`extra_field`.`site_id`
`extra_field`.`data_item_type`
`extra_field_settings`.*
`extra_field_settings`.`extra_field_settings_id`
`extra_field_settings`.`field_name`
`extra_field_settings`.`import_id`
`extra_field_settings`.`site_id`
`extra_field_settings`.`date_created`
`extra_field_settings`.`data_item_type`
`extra_field_settings`.`extra_field_type`
`extra_field_settings`.`extra_field_options`
`extra_field_settings`.`position`
`feedback`.*
`feedback`.`feedback_id`
`feedback`.`user_id`
`feedback`.`site_id`
`feedback`.`date_created`
`feedback`.`subject`
`feedback`.`reply_to_address`
`feedback`.`reply_to_name`
`feedback`.`feedback`
`feedback`.`archived`
`history`.*
`history`.`history_id`
`history`.`data_item_type`
`history`.`data_item_id`
`history`.`the_field`
`history`.`previous_value`
`history`.`new_value`
`history`.`description`
`history`.`set_date`
`history`.`entered_by`
`history`.`site_id`
`http_log`.*
`http_log`.`log_id`
`http_log`.`site_id`
`http_log`.`remote_addr`
`http_log`.`http_user_agent`
`http_log`.`script_filename`
`http_log`.`request_method`
`http_log`.`query_string`
`http_log`.`request_uri`
`http_log`.`script_name`
`http_log`.`log_type`
`http_log`.`date`
`http_log_types`.*
`http_log_types`.`log_type_id`
`http_log_types`.`name`
`http_log_types`.`description`
`http_log_types`.`default_log_type`
`import`.*
`import`.`import_id`
`import`.`module_name`
`import`.`reverted`
`import`.`site_id`
`import`.`import_errors`
`import`.`added_lines`
`import`.`date_created`
`installtest`.*
`installtest`.`id`
`joborder`.*
`joborder`.`joborder_id`
`joborder`.`recruiter`
`joborder`.`contact_id`
`joborder`.`company_id`
`joborder`.`entered_by`
`joborder`.`owner`
`joborder`.`site_id`
`joborder`.`client_job_id`
`joborder`.`title`
`joborder`.`description`
`joborder`.`notes`
`joborder`.`type`
`joborder`.`duration`
`joborder`.`rate_max`
`joborder`.`salary`
`joborder`.`status`
`joborder`.`is_hot`
`joborder`.`openings`
`joborder`.`city`
`joborder`.`state`
`joborder`.`start_date`
`joborder`.`date_created`
`joborder`.`date_modified`
`joborder`.`public`
`joborder`.`company_department_id`
`joborder`.`is_admin_hidden`
`joborder`.`openings_available`
`joborder`.`questionnaire_id`
`joborder`.`import_id`
`module_schema`.*
`module_schema`.`module_schema_id`
`module_schema`.`name`
`module_schema`.`version`
`mru`.*
`mru`.`mru_id`
`mru`.`user_id`
`mru`.`site_id`
`mru`.`data_item_type`
`mru`.`data_item_text`
`mru`.`url`
`mru`.`date_created`
`queue`.*
`queue`.`queue_id`
`queue`.`site_id`
`queue`.`task`
`queue`.`args`
`queue`.`priority`
`queue`.`date_created`
`queue`.`date_timeout`
`queue`.`date_completed`
`queue`.`locked`
`queue`.`error`
`queue`.`response`
`saved_list`.*
`saved_list`.`saved_list_id`
`saved_list`.`description`
`saved_list`.`data_item_type`
`saved_list`.`site_id`
`saved_list`.`is_dynamic`
`saved_list`.`datagrid_instance`
`saved_list`.`parameters`
`saved_list`.`created_by`
`saved_list`.`number_entries`
`saved_list`.`date_created`
`saved_list`.`date_modified`
`saved_list_entry`.*
`saved_list_entry`.`saved_list_entry_id`
`saved_list_entry`.`saved_list_id`
`saved_list_entry`.`data_item_type`
`saved_list_entry`.`data_item_id`
`saved_list_entry`.`site_id`
`saved_list_entry`.`date_created`
`saved_search`.*
`saved_search`.`search_id`
`saved_search`.`data_item_text`
`saved_search`.`url`
`saved_search`.`is_custom`
`saved_search`.`data_item_type`
`saved_search`.`user_id`
`saved_search`.`site_id`
`saved_search`.`date_created`
`settings`.*
`settings`.`settings_id`
`settings`.`setting`
`settings`.`value`
`settings`.`site_id`
`settings`.`settings_type`
`site`.*
`site`.`site_id`
`site`.`name`
`site`.`is_demo`
`site`.`user_licenses`
`site`.`entered_by`
`site`.`date_created`
`site`.`unix_name`
`site`.`company_id`
`site`.`is_free`
`site`.`account_active`
`site`.`account_deleted`
`site`.`reason_disabled`
`site`.`time_zone`
`site`.`time_format_24`
`site`.`date_format_ddmmyy`
`site`.`is_hr_mode`
`site`.`file_size_kb`
`site`.`page_views`
`site`.`page_view_days`
`site`.`last_viewed_day`
`site`.`first_time_setup`
`site`.`localization_configured`
`site`.`agreed_to_license`
`site`.`limit_warning`
`sph_counter`.*
`sph_counter`.`counter_id`
`sph_counter`.`max_doc_id`
`system`.*
`system`.`system_id`
`system`.`uid`
`system`.`available_version`
`system`.`date_version_checked`
`system`.`available_version_description`
`system`.`disable_version_check`
`tag`.*
`tag`.`tag_id`
`tag`.`tag_parent_id`
`tag`.`title`
`tag`.`description`
`tag`.`site_id`
`tag`.`date_created`
`user`.*
`user`.`user_id`
`user`.`site_id`
`user`.`user_name`
`user`.`email`
`user`.`password`
`user`.`access_level`
`user`.`can_change_password`
`user`.`is_test_user`
`user`.`last_name`
`user`.`first_name`
`user`.`is_demo`
`user`.`categories`
`user`.`session_cookie`
`user`.`pipeline_entries_per_page`
`user`.`column_preferences`
`user`.`force_logout`
`user`.`title`
`user`.`phone_work`
`user`.`phone_cell`
`user`.`phone_other`
`user`.`address`
`user`.`notes`
`user`.`company`
`user`.`city`
`user`.`state`
`user`.`zip_code`
`user`.`country`
`user`.`can_see_eeo_info`
`user_login`.*
`user_login`.`user_login_id`
`user_login`.`user_id`
`user_login`.`site_id`
`user_login`.`ip`
`user_login`.`user_agent`
`user_login`.`date`
`user_login`.`successful`
`user_login`.`host`
`user_login`.`date_refreshed`
`word_verification`.*
`word_verification`.`word_verification_ID`
`word_verification`.`word`
`xml_feed_submits`.*
`xml_feed_submits`.`feed_id`
`xml_feed_submits`.`feed_site`
`xml_feed_submits`.`feed_url`
`xml_feed_submits`.`date_last_post`
`xml_feeds`.*
`xml_feeds`.`xml_feed_id`
`xml_feeds`.`name`
`xml_feeds`.`description`
`xml_feeds`.`website`
`xml_feeds`.`post_url`
`xml_feeds`.`success_string`
`xml_feeds`.`xml_template_name`
`zipcodes`.*
`zipcodes`.`zipcode`
`zipcodes`.`city`
`zipcodes`.`state`
`zipcodes`.`areacode`
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
access_level
activity
activity_type
attachment
calendar_event
calendar_event_type
candidate
candidate_duplicates
candidate_joborder
candidate_joborder_status
candidate_joborder_status_history
candidate_jobordrer_status_type
candidate_source
candidate_tag
career_portal_questionnaire
career_portal_questionnaire_answer
career_portal_questionnaire_history
career_portal_questionnaire_question
career_portal_template
career_portal_template_site
company
company_department
contact
data_item_type
eeo_ethnic_type
eeo_veteran_type
email_history
email_template
extension_statistics
extra_field
extra_field_settings
feedback
history
http_log
http_log_types
import
installtest
joborder
module_schema
mru
queue
saved_list
saved_list_entry
saved_search
settings
site
sph_counter
system
tag
user
user_login
word_verification
xml_feed_submits
xml_feeds
zipcodes
SQL query on database
opencats
: