* access_level_id short_description long_description

* activity_id data_item_id data_item_type joborder_id site_id entered_by date_created type notes date_modified

* activity_type_id short_description

* attachment_id data_item_id data_item_type site_id title original_filename stored_filename content_type resume text date_created date_modified profile_image directory_name md5_sum file_size_kb md5_sum_text

* calendar_event_id type date title all_day data_item_id data_item_type entered_by date_created date_modified site_id joborder_id description duration reminder_enabled reminder_email reminder_time public

* calendar_event_type_id short_description icon_image

* candidate_id site_id last_name first_name middle_name phone_home phone_cell phone_work address city state zip source date_available can_relocate notes key_skills current_employer entered_by owner date_created date_modified email1 email2 web_site import_id is_hot eeo_ethnic_type_id eeo_veteran_type_id eeo_disability_status eeo_gender desired_pay current_pay is_active is_admin_hidden best_time_to_call

* old_candidate_id new_candidate_id site_id

* candidate_joborder_id candidate_id joborder_id site_id status date_submitted date_created date_modified rating_value added_by

* candidate_joborder_status_id short_description can_be_scheduled triggers_email is_enabled

* candidate_joborder_status_history_id candidate_id joborder_id date status_from status_to site_id

* candidate_status_type_id short_description can_be_scheduled

* source_id name site_id date_created

* id site_id candidate_id tag_id

* career_portal_questionnaire_id title site_id description is_active

* career_portal_questionnaire_answer_id career_portal_questionnaire_question_id career_portal_questionnaire_id text action_source action_notes action_is_hot action_is_active action_can_relocate action_key_skills position site_id

* career_portal_questionnaire_history_id site_id candidate_id question answer questionnaire_title questionnaire_description date

* career_portal_questionnaire_question_id career_portal_questionnaire_id text minimum_length maximum_length required position site_id type

* career_portal_template_id career_portal_name setting value

* career_portal_template_id career_portal_name site_id setting value

* company_id site_id billing_contact name address city state zip phone1 phone2 url key_technologies notes entered_by owner date_created date_modified is_hot fax_number import_id default_company

* company_department_id name company_id site_id date_created created_by

* contact_id company_id site_id last_name first_name title email1 email2 phone_work phone_cell phone_other address city state zip is_hot notes entered_by owner date_created date_modified left_company import_id company_department_id reports_to

* data_item_type_id short_description

* eeo_ethnic_type_id type

* eeo_veteran_type_id type

* email_history_id from_address recipients text user_id site_id date

* email_template_id text allow_substitution site_id tag title possible_variables disabled

* extension_statistics_id extension action user date

* extra_field_id data_item_id field_name value import_id site_id data_item_type

* extra_field_settings_id field_name import_id site_id date_created data_item_type extra_field_type extra_field_options position

* feedback_id user_id site_id date_created subject reply_to_address reply_to_name feedback archived

* history_id data_item_type data_item_id the_field previous_value new_value description set_date entered_by site_id

* log_id site_id remote_addr http_user_agent script_filename request_method query_string request_uri script_name log_type date

* log_type_id name description default_log_type

* import_id module_name reverted site_id import_errors added_lines date_created

* id

* joborder_id recruiter contact_id company_id entered_by owner site_id client_job_id title description notes type duration rate_max salary status is_hot openings city state start_date date_created date_modified public company_department_id is_admin_hidden openings_available questionnaire_id import_id

* module_schema_id name version

* mru_id user_id site_id data_item_type data_item_text url date_created

* queue_id site_id task args priority date_created date_timeout date_completed locked error response

* saved_list_id description data_item_type site_id is_dynamic datagrid_instance parameters created_by number_entries date_created date_modified

* saved_list_entry_id saved_list_id data_item_type data_item_id site_id date_created

* search_id data_item_text url is_custom data_item_type user_id site_id date_created

* settings_id setting value site_id settings_type

* site_id name is_demo user_licenses entered_by date_created unix_name company_id is_free account_active account_deleted reason_disabled time_zone time_format_24 date_format_ddmmyy is_hr_mode file_size_kb page_views page_view_days last_viewed_day first_time_setup localization_configured agreed_to_license limit_warning

* counter_id max_doc_id

* system_id uid available_version date_version_checked available_version_description disable_version_check

* tag_id tag_parent_id title description site_id date_created

* user_id site_id user_name email password access_level can_change_password is_test_user last_name first_name is_demo categories session_cookie pipeline_entries_per_page column_preferences force_logout title phone_work phone_cell phone_other address notes company city state zip_code country can_see_eeo_info

* user_login_id user_id site_id ip user_agent date successful host date_refreshed

* word_verification_ID word

* xml_feed_id name description website post_url success_string xml_template_name

* feed_id feed_site feed_url date_last_post

* zipcode city state areacode

select table 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_feeds xml_feed_submits zipcodes . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table 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_feeds xml_feed_submits zipcodes .	select column