* id a_name a_id a_password a_power a_mail a_mobile created_at updated_at deleted_at

* account_id company_id account_code account_name category_id account_type balance_type parent_account_id description is_active created_at updated_at

* category_id company_id category_code category_name category_type description is_active created_at updated_at

* id bank_code bank_name branch_name account_number account_name is_enabled created_at updated_at

* item_id budget_id account_id budget_amount actual_amount variance execution_rate notes created_at updated_at

* budget_id company_id budget_year budget_name status approved_by approved_at description created_by created_at updated_at

* id case_no referral_organization_id referral_worker_name referral_worker_phone applicant_name applicant_id_number applicant_birthday applicant_phone applicant_address case_category case_description case_status assigned_worker_id assigned_worker_name total_subsidy_amount application_date visit_scheduled_date visit_date close_date close_reason notes created_at updated_at

* id case_id close_date close_reason close_summary total_subsidy_amount worker_id worker_name created_at updated_at

* id case_id document_type document_name file_path file_size uploaded_by created_at updated_at

* id case_id name relation age job_status created_at updated_at

* id case_id follow_date follow_type follow_content next_follow_date worker_id worker_name created_at updated_at

* id case_id visit_type visit_date visit_location visitor_id visitor_name pre_assessment post_family_status post_economic_status post_subsidy_recommendation post_recommended_amount post_notes created_at updated_at

* id name sort_order created_at updated_at

* id name email phone address subject message status ip_address user_agent created_at updated_at

* id contact_date contact_time contact_person contact_method_id communication_status_id content notes created_by created_at updated_at

* id name sort_order created_at updated_at

* id contact_id replier_id replier_name reply_content is_draft sent_at created_at updated_at

* id module action target_type target_id target_identifier changed_fields old_values new_values change_reason changed_by changed_at

* id DonationsNum is_named is_receipt_needed receipt_format donation_date mem_id donor_name donor_id_card mobile tel gender address email company_name company_tax_id is_public_credit amount receipt_no receipt_title receipt_tax_id is_receipt_void usage_purpose category project_name payment_period payment_source payid status project_type receipt_type beneficiary_ref note receipt_log print_mark pay_array created_at updated_at deleted_at project_id payment_method_id

* id donation_id donor_name donor_id recipient_type recipient_id recipient_name case_no matched_amount project_id matching_date matching_method notes created_by created_at updated_at

* id setting_type smtp_host smtp_port smtp_encryption from_email from_name username password created_at updated_at

* id category_id question answer sort_order is_enabled view_count created_at updated_at

* id name description sort_order is_enabled created_at updated_at

* id setting_key setting_value created_at updated_at

* id name layout_data main_columns rows_config html_content is_active created_at updated_at

* id name layout_data rows_config html_content is_active created_at updated_at

* id row_name column_name component_type component_data sort_order created_at updated_at

* id row_name is_visible created_at updated_at

* id name components_data seo_title seo_description seo_keywords html_content is_active created_at updated_at

* detail_id entry_id account_id debit_amount credit_amount description sort_order created_at updated_at

* entry_id entry_no entry_date entry_type description donation_id is_auto_generated status posted_by posted_at created_by created_at updated_at

* id is_enabled content_format display_location created_at updated_at

* id name description file_path file_type file_size mime_type upload_date created_at updated_at

* mem_id mem_type mem_name id_card mobile tel gender address email company_name company_tax_id receipt_title receipt_tax_id created_at updated_at deleted_at password

* id name location description created_at updated_at

* id menu_id parent_id item_type display_text link_url page_id open_in_new_tab sort_order created_at updated_at

* id title content category_id featured_image status is_pinned publish_date view_count author_id created_at updated_at

* id name description sort_order created_at updated_at

* id title content builder_content html_content featured_image slug status publish_date parent_id template author_id view_count seo_title seo_description seo_keywords sort_order created_at updated_at in_structure

* id news_id title content html_content created_at updated_at

* id page_id parent_structure_id sort_order created_at updated_at

* payid pay_name line_onoff pay_type store_id api_key Secret_key hash_key hash_iv created_at updated_at deleted_at project_id amount payment_method_id donor_name donor_email donor_phone donor_address need_receipt receipt_status receipt_number payment_status transaction_id payment_date notes

* id name code payment_type is_enabled sort_order created_at updated_at

* id pj_name pj_use pj_class created_at updated_at deleted_at summary description builder_content goal_amount current_amount min_amount max_amount start_date end_date status project_type category_id manager_id featured_image images seo_title seo_description seo_keywords slug publish_date

* id project_name project_code short_description description content category target_amount current_amount start_date end_date is_long_term status manager_name is_featured meta_title meta_description imageURL created_by created_at updated_at

* id project_id amount created_at

* id name description sort_order created_at updated_at image

* id project_id payment_method_id created_at

* id project_id recipient_type recipient_id recipient_name allocated_amount notes created_at updated_at

* id receipt_no entry_id donation_id payment_method_id status issued_date sent_date void_date void_reason reissue_count parent_receipt_id delivery_method delivery_status delivery_address delivery_email delivery_date return_reason archive_status archive_box_no archive_date created_at updated_at

* id prefix date_format sequence_digits current_sequence reset_daily last_reset_date created_at updated_at

* id organization_name organization_type tax_id contact_name contact_title contact_phone contact_mobile contact_email contact_address status approved_by approved_at rejection_reason consent_agreed terms_agreed consent_agreed_at terms_agreed_at created_at updated_at

* id title description image_path link open_in_new_tab is_enabled sort_order created_at updated_at

* id filing_year filing_date operator_id operator_name receipt_count total_amount export_file_path receipt_file_path receipt_file_name notes created_at updated_at

* id title report_date file_path file_name file_size file_type created_by created_at updated_at

select table accountinfo accounts account_categories bank_accounts budget_items budget_plans cases case_closings case_documents case_family_members case_follows case_visits communication_statuses contacts contact_logs contact_methods contact_replies data_change_logs donations donor_recipient_matching email_settings faqs faq_categories faq_settings footer header header_components header_settings homepage journal_details journal_entries marquee media_library member menu menu_items news news_categories pages page_builder page_structure payment payment_methods project projects project_amount_options project_categories project_payment_methods project_recipients receipts receipt_number_settings referral_organizations slideshow tax_filings transparency_reports . 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 accountinfo accounts account_categories bank_accounts budget_items budget_plans cases case_closings case_documents case_family_members case_follows case_visits communication_statuses contacts contact_logs contact_methods contact_replies data_change_logs donations donor_recipient_matching email_settings faqs faq_categories faq_settings footer header header_components header_settings homepage journal_details journal_entries marquee media_library member menu menu_items news news_categories pages page_builder page_structure payment payment_methods project projects project_amount_options project_categories project_payment_methods project_recipients receipts receipt_number_settings referral_organizations slideshow tax_filings transparency_reports .	select column