* id name code parent_account account_type_id active

* id name slug group

* id description date staffid

* announcementid name message showtousers showtostaff showname dateadded userid

* id article_name expense_category price tax rel_type rel_id channel meeting_date contact_id description file

* id userid company vat phonenumber country city zip state address website datecreated active leadid billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country longitude latitude default_language default_currency show_primary_contact stripe_id registration_confirmed addedfrom internal_notes id_odoo tax_type tax_pct bank_account bank_name swift_bic balance exchange_rate payment_terms payment_days billing_ftao billing_phone billing_street_addon shipping_ftao shipping_phone shipping_street_addon shipping_department shipping_designation classification

* id billid amount paymentmode paymentmethod date daterecorded note transactionid status company_address_id

* id sent datesend supplierid deleted_supplier_name number prefix number_format reference datecreated date duedate currency subtotal total_tax total adjustment addedfrom hash status suppliernote adminnote last_overdue_reminder last_due_reminder cancel_overdue_reminders allowed_payment_modes token discount_percent discount_total discount_type recurring recurring_type custom_recurring cycles total_cycles is_recurring_from last_recurring_date terms sale_agent billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_bill show_quantity_as project_id subscription_id purchase_order_id language company_address_id bill_description payment_term

* userid company vat phonenumber country city zip state address website datecreated active leadid billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country longitude latitude default_language default_currency show_primary_contact stripe_id registration_confirmed addedfrom internal_notes id_odoo tax_type tax_pct bank_account bank_name swift_bic balance exchange_rate payment_terms payment_days billing_ftao billing_phone billing_street_addon shipping_ftao shipping_phone shipping_street_addon shipping_department shipping_designation classification last_vat

* id name address city state zip country phone vat is_default

* id action date ip contact_id lead_id description opt_in_purpose_description purpose_id staff_name

* id name description date_created last_updated

* id userid is_primary firstname lastname email phonenumber phonenumber2 title datecreated password new_pass_key new_pass_key_requested email_verified_at email_verification_key email_verification_sent_at last_ip last_login last_password_change active profile_image direction invoice_emails estimate_emails credit_note_emails contract_emails task_emails project_emails ticket_emails internal_notes greeting

* id permission_id userid

* id content description subject client datestart dateend contract_type addedfrom dateadded isexpirynotified contract_value trash not_visible_to_client hash signed signature acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip

* id name

* id content contract_id staffid dateadded

* id contractid old_start_date new_start_date old_end_date new_end_date old_value new_value date_renewed renewed_by renewed_by_staff_id is_on_old_expiry_notified

* country_id iso2 short_name long_name iso3 numcode un_member calling_code cctld

* id clientid deleted_customer_name number prefix number_format datecreated date adminnote terms clientnote currency subtotal total_tax total adjustment addedfrom status project_id discount_percent discount_total discount_type billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_credit_note show_quantity_as reference_no public_client_id language company_address_id

* id credit_note_id staff_id refunded_on payment_mode note amount created_at

* id invoice_id credit_id staff_id date date_applied amount

* id symbol name decimal_separator thousand_separator placement isdefault

* id name

* id name

* id customerid description additional_data date staffid full_name custom_activity

* staff_id customer_id date_assigned

* id groupid customer_id

* id groupid customer_id

* id fieldto name slug required type options display_inline field_order active show_on_pdf show_on_ticket_form only_admin show_on_table show_on_client_portal disalow_client_to_edit bs_column

* id relid fieldid fieldto value

* departmentid name imap_username email email_from_header host password encryption delete_after_import calendar_id hidefromclient

* id hash name surname title company description country zip city state address assigned dateadded from_form_id status source lastcontact dateassigned last_status_change addedfrom email website leadorder date_converted lost junk last_lead_status is_imported_from_email_integration email_integration_uid default_language rel_type rel_id contact_id channel_id

* id diary_id staff_id

* dismissedannouncementid announcementid staff userid

* listid name creator datecreated

* emailtemplateid type slug language name subject message fromname fromemail plaintext active order

* id name supports_import supports_export

* id connector_id entity_type

* id type connector_id entity_id entity_type synched attempts log created_at updated_at synched_at

* id type connector_id entity_types active schedule_type schedule_value mapping last_run_at created_at updated_at

* id sent datesend clientid contactid work_type deleted_customer_name project_id number prefix number_format hash datecreated date expirydate date3 date4 date5 currency subtotal total_tax total adjustment addedfrom status clientnote adminnote discount_percent discount_total discount_type invoiceid invoiced_date terms reference_no sale_agent billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_estimate show_quantity_as pipeline_order is_expiry_notified acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip signature contract_operation_txt summary_txt summary_title work_type_item origen origen_type administrator phone phone2 email irdam1 irdam2 client_details_txt contactid2 contactid3 contactid4 contactid5 contactid6 contactid7 contactid8 contactid9 contactid10 parentid e_company prevstudies_id version estimate_type estimate_pdf_prefs housing_surfaces housing_coef_geo housing_coef_typology housing_coef_quality housing_coef_use garage_surfaces garage_coef_geo garage_coef_typology garage_coef_quality garage_coef_use sp_surfaces sp_coef_geo sp_coef_typology sp_coef_quality sp_coef_use porches_surfaces porches_coef_geo porches_coef_typology porches_coef_quality porches_coef_use next_discount topographic_study geotechnical_study indicative work_license_fee icio aesa bail_replacement_urban_elements works_plaque public_manhole_connection street_cuts occupation_of_public_roads first_occupation_license ford_application_fee mail_code project_subtotal specialty lead_date language priority prov_price proposal_note project_type study_area power country_id province term_id awarded_status_date total_invoiced_pct company_address_id date_year

* id estimate_id diary_id

* id estimate_id staff_id

* eventid title description userid start end public color isstartnotified reminder_before reminder_before_type

* id category currency amount tax tax2 reference_no note expense_name supplierid clientid project_id task_id billable invoiceid paymentmode date recurring_type repeat_every recurring cycles total_cycles custom_recurring last_recurring_date create_invoice_billable send_invoice_to_customer recurring_from dateadded addedfrom id_article id_prevstudies add_base total_tax total_irpf is_irpf is_provider_expense is_confirmed is_paid

* id name description account account_type accounting_account_id

* id rel_id rel_type file_name filetype visible_to_customer attachment_key external external_link thumbnail_link staffid contact_id task_comment_id dateadded

* questionid rel_id rel_type question required question_order

* boxid boxtype questionid

* questionboxdescriptionid description boxid questionid

* resultid boxid boxdescriptionid rel_id rel_type questionid answer resultsetid

* id clientid contact_id lead_id request_type status request_date request_from description

* id subject description start_date end_date goal_type contract_type achievement notify_when_fail notify_when_achieve notified staff_id

* id sku description group_id brand_model serial_number location status supplier manufacturer observations entry_date calibration_verification calibration_type calibration_date next_calibration_date certificate quantity updated_at updated_by

* id name parent_id

* id invoiceid amount paymentmode paymentmethod date daterecorded note transactionid expenseid invoice_date status company_address_id

* id sent datesend clientid deleted_customer_name number prefix number_format datecreated date duedate currency subtotal total_tax total adjustment adjustment_percent adjustment_type addedfrom hash status clientnote adminnote last_overdue_reminder cancel_overdue_reminders allowed_payment_modes token discount_percent discount_total discount_type recurring recurring_type custom_recurring cycles total_cycles is_recurring_from last_recurring_date terms sale_agent billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_invoice show_quantity_as project_id subscription_id invoice_type rel_id certificate_pct certificate_text rel_type contact_id sub_cost_from_project invoice_description expense_id_from_project is_verified estimateid estimate_pct public_client_id payment_term invoice_general_tax_pct language company_address_id

* id rel_id rel_type is_adjust description long_description item_order cod rate_formula estimate_text group_id json_fields qty rate pct_rate unit performance_day performance_hour operator_cost_hour profit_meters material_cost_meters item_id item_type item_invoiced_pct category accounting_account_id

* id description long_description rate tax tax2 unit group_id cod sku

* id name

* id itemid rel_id rel_type taxrate taxname

* articleanswerid articleid answer ip date

* articleid articlegroup subject description slug active datecreated article_order staff_article

* groupid name group_slug description active color group_order

* id hash name surname title company description country zip city state address assigned dateadded from_form_id status source lastcontact dateassigned last_status_change addedfrom email website leadorder phonenumber date_converted lost junk last_lead_status is_imported_from_email_integration email_integration_uid is_public default_language client_id api_id email_template email_send_period date_last_notification

* id active email imap_server password check_every responsible lead_source lead_status encryption folder last_run notify_lead_imported notify_lead_contact_more_times notify_type notify_ids mark_public only_loop_on_unseen_emails delete_after_import create_task_if_customer

* id name

* id name statusorder color isdefault api_status

* id leadid description additional_data date staffid full_name custom_activity

* id subject body dateadded leadid emailid

* emailid listid email dateadded

* customfieldid listid fieldname fieldslug

* customfieldvalueid listid customfieldid emailid value

* id engine email cc bcc message alt_message status date headers attachments

* id creator datecreated content pinned datepinned

* id content userid postid dateadded is_contact

* version

* id name description description_visible_to_customer due_date project_id color milestone_order datecreated prevstudies_id

* id module_name installed_version active

* id postid commentid userid dateliked

* postid creator datecreated visibility content pinned datepinned

* id content userid postid dateadded

* id postid userid dateliked

* id inbox_id action by_staff_id at before_json after_json note

* id tipo_movimiento categoria subcategoria active sort_order

* id payload_type idempotency_key n8n_workflow_id n8n_execution_id source_email raw_payload extracted_fields sharepoint_drive_id sharepoint_item_id sharepoint_web_url attachment_filename attachment_size attachment_mime pdf_file_id status ai_confidence error_text received_at approved_by_staff_id approved_at native_record_id native_record_type edit_history created_at updated_at

* id rel_id rel_type description date_contacted addedfrom dateadded

* id isread isread_inline date description fromuserid fromclientid from_fullname touserid fromcompany link additional_data

* id name value autoload

* id paymentid replyid file_name filetype dateadded

* id name description account_code account_type accounting_account_id show_on_pdf invoices_only expenses_only selected_by_default active

* id name description show_on_pdf invoices_only expenses_only selected_by_default active

* id name_english name_spanish days active

* permissionid name shortname active

* id project_id staff_id pin_order

* id project_id staff_id pin_order

* id name description status clientid billing_type start_date deadline project_created date_finished progress progress_from_tasks project_sub_cost project_cost project_rate_per_hour estimated_hours addedfrom work_type est_number rel_id cod_prevstudy cod_project visa_date record_licence date_licence record_coac collab_name collab_cif collab_dir collab_phone collab_email contractor_name contractor_cif contractor_dir contractor_phone contractor_email eng_name eng_cif eng_dir eng_phone eng_email calc_name calc_cif calc_dir calc_phone calc_email dir cadastr_ref town_hall_pass project_tipology prom1_name prom1_cif prom1_dir prom1_phone prom1_email prom2_name prom2_cif prom2_dir prom2_phone prom2_email rep_name rep_cif rep_dir rep_phone rep_email plot_area built_living_place_ref built_parking_ref built_totals_ref built_living_place_amp built_parking_amp built_totals_amp built_living_place_const built_parking_const built_others_ref built_others_amp built_others_const built_others_total built_totals_const built_living_place_total built_parking_total built_totals_total pool_surface util_surface num_households num_parking pem checkboxes capture_date briefing_date forecast_date presentation_date mail_notification_status enable_capture_reminders capture_reminder_date4 enable_presentation_reminders presentation_reminder_date_4 capture_reminders_email presentation_reminders_email

* id discussion_id discussion_type parent created modified content staff_id contact_id fullname file_name file_mime_type viewed_by_users liked_by_users

* id project_id subject description show_to_customer datecreated last_activity staff_id contact_id

* id project_id staff_id contact_id fullname visible_to_customer description_key additional_data dateadded

* id file_name subject description filetype dateadded last_activity project_id visible_to_customer staffid contact_id external external_link thumbnail_link folder

* id project_id staff_id

* id project_id content staff_id

* id project_id name value

* id name color element_order filter_default

* id discussion_id discussion_type parent created modified content staff_id contact_id fullname file_name file_mime_type viewed_by_users liked_by_users

* id project_id subject description show_to_customer datecreated last_activity staff_id contact_id

* id name description status clientid billing_type start_date deadline project_created date_finished progress progress_from_tasks project_sub_cost project_cost project_rate_per_hour estimated_hours addedfrom work_type est_number rel_id project_cod visa_date record_licence date_licence record_coac collab_name collab_cif collab_dir collab_phone collab_email contractor_name contractor_cif contractor_dir contractor_phone contractor_email eng_name eng_cif eng_dir eng_phone eng_email calc_name calc_cif calc_dir calc_phone calc_email dir cadastr_ref town_hall_pass project_tipology prom1_name prom1_cif prom1_dir prom1_phone prom1_email prom2_name prom2_cif prom2_dir prom2_phone prom2_email rep_name rep_cif rep_dir rep_phone rep_email plot_area built_living_place_ref built_parking_ref built_totals_ref built_living_place_amp built_parking_amp built_totals_amp built_living_place_const built_parking_const built_others_ref built_others_amp built_others_const built_others_total built_totals_const built_living_place_total built_parking_total built_totals_total pool_surface util_surface num_households num_parking pem horizontal_expenses profit_objective project_checkbox project_inputbox other_comment other_comment2 other_comment3 licence_date profile_licence num_locals other1_name other2_name other1_cif other2_cif other1_dir other2_dir other1_phone other2_phone other1_email other2_email prevstudy_id horizontal_expenses_real profit_real project_sub_cost_real project_cost_real

* id project_id staff_id contact_id fullname visible_to_customer description_key additional_data dateadded

* id project_id staff_id

* id file_name subject description filetype dateadded last_activity project_id visible_to_customer staffid contact_id external external_link thumbnail_link folder

* id project_id staff_id

* id project_id content staff_id

* id project_id staff_id

* id project_id name value

* id name color element_order filter_default

* id project_id staff_id

* id name datecreated

* id subject content addedfrom datecreated total subtotal total_tax adjustment discount_percent discount_total discount_type show_quantity_as currency open_till date rel_id rel_type assigned hash proposal_to country zip state city address email phone allow_comments status estimate_id invoice_id date_converted pipeline_order is_expiry_notified acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip signature specialty lead_date language priority prov_price proposal_note

* id content proposalid staffid dateadded

* id proposal_id diary_id

* id description_spanish description_english long_description rate tax tax2 unit group_id accounting_account_id sku type equipment model serial_n currect_location item_condition provider maker admission_date calibration_verification internal_external calibration_date next_calibration_date certificate last_edit_date edited_by currency

* id name

* id sent datesend supplierid deleted_supplier_name project_id number prefix number_format hash datecreated date expirydate currency subtotal total_tax total adjustment addedfrom status suppliernote adminnote discount_percent discount_total discount_type billid billed_date terms reference_no sale_agent billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_purchase_order show_quantity_as pipeline_order is_expiry_notified acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip signature short_link term_id language company_address_id reviewed_by approved_by

* id rel_id rel_type item_id

* id description date isnotified rel_id staff rel_type notify_by_email creator

* roleid name

* rolepermissionid roleid can_view can_view_own can_edit can_create can_delete can_approve permissionid

* id rel_type rel_id description additional_data staffid full_name date

* id description_spanish description_english long_description rate tax tax2 unit group_id accounting_account_id sku type sale_code rate_currency_1

* id name group_sku

* serviceid name

* id ip_address timestamp data

* file_id contact_id

* id type rel_type value

* staffid email firstname lastname facebook linkedin phonenumber skype password datecreated profile_image last_ip last_login last_activity last_password_change new_pass_key new_pass_key_requested admin role active default_language direction media_path_slug is_not_staff hourly_rate two_factor_auth_enabled two_factor_auth_code two_factor_auth_code_requested email_signature position hourly_rate_person

* id rel_type rel_id description additional_data staffid full_name date

* staffdepartmentid staffid departmentid

* staffpermid permissionid can_view can_view_own can_edit can_create can_delete can_approve staffid

* id sent datesend clientid contactid work_type deleted_customer_name project_id number prefix number_format hash datecreated date expirydate date3 date4 date5 currency subtotal total_tax total adjustment addedfrom status clientnote adminnote discount_percent discount_total discount_type invoiceid invoiced_date terms reference_no sale_agent billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_estimate show_quantity_as pipeline_order is_expiry_notified acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip signature contract_operation_txt summary_txt summary_title work_type_item origen origen_type administrator phone phone2 email irdam1 irdam2 client_details_txt contactid2 contactid3 contactid4 contactid5 contactid6 contactid7 contactid8 contactid9 contactid10 parentid e_company

* id name description description_in_item clientid date currency tax_id stripe_plan_id stripe_subscription_id next_billing_cycle ends_at status quantity project_id hash created created_from date_subscribed

* userid company vat firstname lastname email phonenumber mobilephone website quality active billing_ftao billing_street billing_street_addon billing_city billing_state billing_zip billing_country billing_phone shipping_ftao shipping_street shipping_street_addon shipping_city shipping_state shipping_zip shipping_country shipping_phone longitude latitude default_language default_currency tax_type payment_terms addedfrom datecreated

* id name

* id hash datecreated addedfrom quality name company firstname lastname email website phone mobilephone department vatnumber vattype paymentmethod currency paymentterms billingaddress city province country postalcode shippingphone shippingaddress shippingcity shippingprovince shippingcountry shippingpostalcode invoice_phone

* id name

* id groupid supplier_id

* resultsetid surveyid ip useragent date

* surveyid subject slug description viewdescription datecreated redirect_url send onlyforloggedin fromname iprestrict active hash

* id surveyid email emailid listid log_id

* id surveyid total date iscronfinished send_to_mail_lists

* rel_id rel_type tag_id tag_order

* id name

* id name category typology description priority dateadded startdate duedate datefinished addedfrom is_added_from_contact status recurring_type repeat_every recurring is_recurring_from cycles total_cycles custom_recurring last_recurring_date rel_id rel_type is_public billable billed invoice_id hourly_rate milestone kanban_order milestone_order visible_to_client deadline_notified hours_estimated total_wages cod unit_type unit_total internal_notes certificate_values item_id estimated_time_pct alert_sent billing_percentage related_link

* id task_id start_time end_time staff_id hourly_rate note start_lat start_lon end_lat end_lon

* id description

* id staffid taskid assigned_from is_assigned_from_contact

* id taskid description finished dateadded addedfrom finished_from list_order

* id content taskid staffid contact_id file_id dateadded

* id staffid taskid

* id name color element_order filter_default

* id name taxrate math_action

* id name content_english content_spanish active

* ticketid adminreplying userid contactid email name department priority status service ticketkey subject message admin date project_id lastreply clientread adminread assigned

* id date email_to name subject message email status

* id name message

* priorityid name

* ticketstatusid name isdefault statuscolor statusorder

* id ticketid replyid file_name filetype dateadded

* id ticketid userid contactid name email date message attachment admin

* todoid description staffid dateadded finished datefinished item_order status_id

* id name

* id uid rel_id rel_type date email opened date_opened subject

* key_id user_id user_agent last_ip last_login staff

* umeta_id staff_id client_id contact_id meta_key meta_value

* id customer_id server_address port username password description creator creator_name visibility share_in_projects last_updated last_updated_from date_created

* id rel_id rel_type date view_ip

* id form_key lead_source lead_status notify_lead_imported notify_type notify_ids responsible name form_data recaptcha submit_btn_name success_submit_msg language allow_duplicate mark_public track_duplicate_field track_duplicate_field_and create_task_on_duplicate dateadded

* id name color element_order filter_default

select table tblaccounting_accounts tblaccounting_account_types tblactivity_log tblannouncements tblarticles tblassigned_clients tblbillpaymentrecords tblbills tblclients tblcompany_addresses tblconsents tblconsent_purposes tblcontacts tblcontact_permissions tblcontracts tblcontracts_types tblcontract_comments tblcontract_renewals tblcountries tblcreditnotes tblcreditnote_refunds tblcredits tblcurrencies tblcustomers_groupings tblcustomers_groups tblcustomer_activity_log tblcustomer_admins tblcustomer_groupings tblcustomer_groups tblcustomfields tblcustomfieldsvalues tbldepartments tbldiary tbldiary_members tbldismissed_announcements tblemaillists tblemailtemplates tblesconnect_connectors tblesconnect_connector_entities tblesconnect_sync_queue tblesconnect_sync_settings tblestimates tblestimate_meetings tblestimate_members tblevents tblexpenses tblexpenses_categories tblfiles tblform_questions tblform_question_box tblform_question_box_description tblform_results tblgdpr_requests tblgoals tblinventory_items tblinventory_items_groups tblinvoicepaymentrecords tblinvoices tblitemable tblitems tblitems_groups tblitem_tax tblknowedge_base_article_feedback tblknowledge_base tblknowledge_base_groups tblleads tblleads_email_integration tblleads_sources tblleads_status tbllead_activity_log tbllead_integration_emails tbllistemails tblmaillistscustomfields tblmaillistscustomfieldvalues tblmail_queue tblmention_posts tblmention_post_comments tblmigrations tblmilestones tblmodules tblnewsfeed_comment_likes tblnewsfeed_posts tblnewsfeed_post_comments tblnewsfeed_post_likes tblngn_audit tblngn_classification tblngn_inbox tblnotes tblnotifications tbloptions tblpayment_attachments tblpayment_modes tblpayment_modes_old tblpayment_terms tblpermissions tblpinned_prevstudies tblpinned_projects tblprevstudies tblprevstudiesdiscussioncomments tblprevstudiesdiscussions tblprevstudies_activity tblprevstudies_files tblprevstudies_members tblprevstudies_notes tblprevstudies_settings tblprevstudies_status tblprojectdiscussioncomments tblprojectdiscussions tblprojects tblproject_activity tblproject_clients tblproject_files tblproject_members tblproject_notes tblproject_responsible_members tblproject_settings tblproject_status tblproject_support_members tblproject_types tblproposals tblproposal_comments tblproposal_meetings tblpurchase_items tblpurchase_items_groups tblpurchase_orders tblrelated_items tblreminders tblroles tblrole_permissions tblsales_activity tblsale_items tblsale_items_groups tblservices tblsessions tblshared_customer_files tblspam_filters tblstaff tblstaff_activity tblstaff_departments tblstaff_permissions tblstudies tblsubscriptions tblsuppliers tblsuppliers_groups tblsuppliers_old tblsuppliers_qualities tblsupplier_groups tblsurveyresultsets tblsurveys tblsurveysemailsendcron tblsurveysendlog tbltaggables tbltags tbltasks tbltaskstimers tbltasks_checklist_templates tbltask_assigned tbltask_checklist_items tbltask_comments tbltask_followers tbltask_status tbltaxes tblterms_and_conditions tbltickets tbltickets_pipe_log tbltickets_predefined_replies tbltickets_priorities tbltickets_status tblticket_attachments tblticket_replies tbltodos tbltodo_status tbltracked_mails tbluser_auto_login tbluser_meta tblvault tblviews_tracking tblweb_to_lead tblwork_type . 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 tblaccounting_accounts tblaccounting_account_types tblactivity_log tblannouncements tblarticles tblassigned_clients tblbillpaymentrecords tblbills tblclients tblcompany_addresses tblconsents tblconsent_purposes tblcontacts tblcontact_permissions tblcontracts tblcontracts_types tblcontract_comments tblcontract_renewals tblcountries tblcreditnotes tblcreditnote_refunds tblcredits tblcurrencies tblcustomers_groupings tblcustomers_groups tblcustomer_activity_log tblcustomer_admins tblcustomer_groupings tblcustomer_groups tblcustomfields tblcustomfieldsvalues tbldepartments tbldiary tbldiary_members tbldismissed_announcements tblemaillists tblemailtemplates tblesconnect_connectors tblesconnect_connector_entities tblesconnect_sync_queue tblesconnect_sync_settings tblestimates tblestimate_meetings tblestimate_members tblevents tblexpenses tblexpenses_categories tblfiles tblform_questions tblform_question_box tblform_question_box_description tblform_results tblgdpr_requests tblgoals tblinventory_items tblinventory_items_groups tblinvoicepaymentrecords tblinvoices tblitemable tblitems tblitems_groups tblitem_tax tblknowedge_base_article_feedback tblknowledge_base tblknowledge_base_groups tblleads tblleads_email_integration tblleads_sources tblleads_status tbllead_activity_log tbllead_integration_emails tbllistemails tblmaillistscustomfields tblmaillistscustomfieldvalues tblmail_queue tblmention_posts tblmention_post_comments tblmigrations tblmilestones tblmodules tblnewsfeed_comment_likes tblnewsfeed_posts tblnewsfeed_post_comments tblnewsfeed_post_likes tblngn_audit tblngn_classification tblngn_inbox tblnotes tblnotifications tbloptions tblpayment_attachments tblpayment_modes tblpayment_modes_old tblpayment_terms tblpermissions tblpinned_prevstudies tblpinned_projects tblprevstudies tblprevstudiesdiscussioncomments tblprevstudiesdiscussions tblprevstudies_activity tblprevstudies_files tblprevstudies_members tblprevstudies_notes tblprevstudies_settings tblprevstudies_status tblprojectdiscussioncomments tblprojectdiscussions tblprojects tblproject_activity tblproject_clients tblproject_files tblproject_members tblproject_notes tblproject_responsible_members tblproject_settings tblproject_status tblproject_support_members tblproject_types tblproposals tblproposal_comments tblproposal_meetings tblpurchase_items tblpurchase_items_groups tblpurchase_orders tblrelated_items tblreminders tblroles tblrole_permissions tblsales_activity tblsale_items tblsale_items_groups tblservices tblsessions tblshared_customer_files tblspam_filters tblstaff tblstaff_activity tblstaff_departments tblstaff_permissions tblstudies tblsubscriptions tblsuppliers tblsuppliers_groups tblsuppliers_old tblsuppliers_qualities tblsupplier_groups tblsurveyresultsets tblsurveys tblsurveysemailsendcron tblsurveysendlog tbltaggables tbltags tbltasks tbltaskstimers tbltasks_checklist_templates tbltask_assigned tbltask_checklist_items tbltask_comments tbltask_followers tbltask_status tbltaxes tblterms_and_conditions tbltickets tbltickets_pipe_log tbltickets_predefined_replies tbltickets_priorities tbltickets_status tblticket_attachments tblticket_replies tbltodos tbltodo_status tbltracked_mails tbluser_auto_login tbluser_meta tblvault tblviews_tracking tblweb_to_lead tblwork_type .	select column