Recent
`information_schema`.`TRIGGERS`
`information_schema`.`OPTIMIZER_TRACE`
`information_schema`.`COLLATIONS`
`information_schema`.`SESSION_STATUS`
`information_schema`.`INNODB_BUFFER_PAGE_LRU`
`information_schema`.`INNODB_FT_INDEX_CACHE`
`information_schema`.`TABLESPACES`
`information_schema`.`SPATIAL_REF_SYS`
`performance_schema`.`session_account_connect_attrs`
`phpmyadmin`.`pma__userconfig`
Favorites
There are no favorite tables.
New
information_schema
mysql
performance_schema
phpmyadmin
test
ycycashop_db
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: ycycashop_db
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:
`account_categories`.*
`account_categories`.`category_id`
`account_categories`.`company_id`
`account_categories`.`category_code`
`account_categories`.`category_name`
`account_categories`.`category_type`
`account_categories`.`description`
`account_categories`.`is_active`
`account_categories`.`created_at`
`account_categories`.`updated_at`
`accountinfo`.*
`accountinfo`.`id`
`accountinfo`.`a_name`
`accountinfo`.`a_id`
`accountinfo`.`a_password`
`accountinfo`.`a_power`
`accountinfo`.`a_mail`
`accountinfo`.`a_mobile`
`accountinfo`.`created_at`
`accountinfo`.`updated_at`
`accountinfo`.`deleted_at`
`accounts`.*
`accounts`.`account_id`
`accounts`.`company_id`
`accounts`.`account_code`
`accounts`.`account_name`
`accounts`.`category_id`
`accounts`.`account_type`
`accounts`.`balance_type`
`accounts`.`parent_account_id`
`accounts`.`description`
`accounts`.`is_active`
`accounts`.`created_at`
`accounts`.`updated_at`
`bank_accounts`.*
`bank_accounts`.`id`
`bank_accounts`.`bank_code`
`bank_accounts`.`bank_name`
`bank_accounts`.`branch_name`
`bank_accounts`.`account_number`
`bank_accounts`.`account_name`
`bank_accounts`.`is_enabled`
`bank_accounts`.`created_at`
`bank_accounts`.`updated_at`
`budget_items`.*
`budget_items`.`item_id`
`budget_items`.`budget_id`
`budget_items`.`account_id`
`budget_items`.`budget_amount`
`budget_items`.`actual_amount`
`budget_items`.`variance`
`budget_items`.`execution_rate`
`budget_items`.`notes`
`budget_items`.`created_at`
`budget_items`.`updated_at`
`budget_plans`.*
`budget_plans`.`budget_id`
`budget_plans`.`company_id`
`budget_plans`.`budget_year`
`budget_plans`.`budget_name`
`budget_plans`.`status`
`budget_plans`.`approved_by`
`budget_plans`.`approved_at`
`budget_plans`.`description`
`budget_plans`.`created_by`
`budget_plans`.`created_at`
`budget_plans`.`updated_at`
`case_closings`.*
`case_closings`.`id`
`case_closings`.`case_id`
`case_closings`.`close_date`
`case_closings`.`close_reason`
`case_closings`.`close_summary`
`case_closings`.`total_subsidy_amount`
`case_closings`.`worker_id`
`case_closings`.`worker_name`
`case_closings`.`created_at`
`case_closings`.`updated_at`
`case_documents`.*
`case_documents`.`id`
`case_documents`.`case_id`
`case_documents`.`document_type`
`case_documents`.`document_name`
`case_documents`.`file_path`
`case_documents`.`file_size`
`case_documents`.`uploaded_by`
`case_documents`.`created_at`
`case_documents`.`updated_at`
`case_family_members`.*
`case_family_members`.`id`
`case_family_members`.`case_id`
`case_family_members`.`name`
`case_family_members`.`relation`
`case_family_members`.`age`
`case_family_members`.`job_status`
`case_family_members`.`created_at`
`case_family_members`.`updated_at`
`case_follows`.*
`case_follows`.`id`
`case_follows`.`case_id`
`case_follows`.`follow_date`
`case_follows`.`follow_type`
`case_follows`.`follow_content`
`case_follows`.`next_follow_date`
`case_follows`.`worker_id`
`case_follows`.`worker_name`
`case_follows`.`created_at`
`case_follows`.`updated_at`
`case_visits`.*
`case_visits`.`id`
`case_visits`.`case_id`
`case_visits`.`visit_type`
`case_visits`.`visit_date`
`case_visits`.`visit_location`
`case_visits`.`visitor_id`
`case_visits`.`visitor_name`
`case_visits`.`pre_assessment`
`case_visits`.`post_family_status`
`case_visits`.`post_economic_status`
`case_visits`.`post_subsidy_recommendation`
`case_visits`.`post_recommended_amount`
`case_visits`.`post_notes`
`case_visits`.`created_at`
`case_visits`.`updated_at`
`cases`.*
`cases`.`id`
`cases`.`case_no`
`cases`.`referral_organization_id`
`cases`.`referral_worker_name`
`cases`.`referral_worker_phone`
`cases`.`applicant_name`
`cases`.`applicant_id_number`
`cases`.`applicant_birthday`
`cases`.`applicant_phone`
`cases`.`applicant_address`
`cases`.`case_category`
`cases`.`case_description`
`cases`.`case_status`
`cases`.`assigned_worker_id`
`cases`.`assigned_worker_name`
`cases`.`total_subsidy_amount`
`cases`.`application_date`
`cases`.`visit_scheduled_date`
`cases`.`visit_date`
`cases`.`close_date`
`cases`.`close_reason`
`cases`.`notes`
`cases`.`created_at`
`cases`.`updated_at`
`communication_statuses`.*
`communication_statuses`.`id`
`communication_statuses`.`name`
`communication_statuses`.`sort_order`
`communication_statuses`.`created_at`
`communication_statuses`.`updated_at`
`contact_logs`.*
`contact_logs`.`id`
`contact_logs`.`contact_date`
`contact_logs`.`contact_time`
`contact_logs`.`contact_person`
`contact_logs`.`contact_method_id`
`contact_logs`.`communication_status_id`
`contact_logs`.`content`
`contact_logs`.`notes`
`contact_logs`.`created_by`
`contact_logs`.`created_at`
`contact_logs`.`updated_at`
`contact_methods`.*
`contact_methods`.`id`
`contact_methods`.`name`
`contact_methods`.`sort_order`
`contact_methods`.`created_at`
`contact_methods`.`updated_at`
`contact_replies`.*
`contact_replies`.`id`
`contact_replies`.`contact_id`
`contact_replies`.`replier_id`
`contact_replies`.`replier_name`
`contact_replies`.`reply_content`
`contact_replies`.`is_draft`
`contact_replies`.`sent_at`
`contact_replies`.`created_at`
`contact_replies`.`updated_at`
`contacts`.*
`contacts`.`id`
`contacts`.`name`
`contacts`.`email`
`contacts`.`phone`
`contacts`.`address`
`contacts`.`subject`
`contacts`.`message`
`contacts`.`status`
`contacts`.`ip_address`
`contacts`.`user_agent`
`contacts`.`created_at`
`contacts`.`updated_at`
`data_change_logs`.*
`data_change_logs`.`id`
`data_change_logs`.`module`
`data_change_logs`.`action`
`data_change_logs`.`target_type`
`data_change_logs`.`target_id`
`data_change_logs`.`target_identifier`
`data_change_logs`.`changed_fields`
`data_change_logs`.`old_values`
`data_change_logs`.`new_values`
`data_change_logs`.`change_reason`
`data_change_logs`.`changed_by`
`data_change_logs`.`changed_at`
`donations`.*
`donations`.`id`
`donations`.`DonationsNum`
`donations`.`is_named`
`donations`.`is_receipt_needed`
`donations`.`receipt_format`
`donations`.`donation_date`
`donations`.`mem_id`
`donations`.`donor_name`
`donations`.`donor_id_card`
`donations`.`mobile`
`donations`.`tel`
`donations`.`gender`
`donations`.`address`
`donations`.`email`
`donations`.`company_name`
`donations`.`company_tax_id`
`donations`.`is_public_credit`
`donations`.`amount`
`donations`.`receipt_no`
`donations`.`receipt_title`
`donations`.`receipt_tax_id`
`donations`.`is_receipt_void`
`donations`.`usage_purpose`
`donations`.`category`
`donations`.`project_name`
`donations`.`payment_period`
`donations`.`payment_source`
`donations`.`payid`
`donations`.`status`
`donations`.`project_type`
`donations`.`receipt_type`
`donations`.`beneficiary_ref`
`donations`.`note`
`donations`.`receipt_log`
`donations`.`print_mark`
`donations`.`pay_array`
`donations`.`created_at`
`donations`.`updated_at`
`donations`.`deleted_at`
`donations`.`project_id`
`donations`.`payment_method_id`
`donor_recipient_matching`.*
`donor_recipient_matching`.`id`
`donor_recipient_matching`.`donation_id`
`donor_recipient_matching`.`donor_name`
`donor_recipient_matching`.`donor_id`
`donor_recipient_matching`.`recipient_type`
`donor_recipient_matching`.`recipient_id`
`donor_recipient_matching`.`recipient_name`
`donor_recipient_matching`.`case_no`
`donor_recipient_matching`.`matched_amount`
`donor_recipient_matching`.`project_id`
`donor_recipient_matching`.`matching_date`
`donor_recipient_matching`.`matching_method`
`donor_recipient_matching`.`notes`
`donor_recipient_matching`.`created_by`
`donor_recipient_matching`.`created_at`
`donor_recipient_matching`.`updated_at`
`email_settings`.*
`email_settings`.`id`
`email_settings`.`setting_type`
`email_settings`.`smtp_host`
`email_settings`.`smtp_port`
`email_settings`.`smtp_encryption`
`email_settings`.`from_email`
`email_settings`.`from_name`
`email_settings`.`username`
`email_settings`.`password`
`email_settings`.`created_at`
`email_settings`.`updated_at`
`faq_categories`.*
`faq_categories`.`id`
`faq_categories`.`name`
`faq_categories`.`description`
`faq_categories`.`sort_order`
`faq_categories`.`is_enabled`
`faq_categories`.`created_at`
`faq_categories`.`updated_at`
`faq_settings`.*
`faq_settings`.`id`
`faq_settings`.`setting_key`
`faq_settings`.`setting_value`
`faq_settings`.`created_at`
`faq_settings`.`updated_at`
`faqs`.*
`faqs`.`id`
`faqs`.`category_id`
`faqs`.`question`
`faqs`.`answer`
`faqs`.`sort_order`
`faqs`.`is_enabled`
`faqs`.`view_count`
`faqs`.`created_at`
`faqs`.`updated_at`
`footer`.*
`footer`.`id`
`footer`.`name`
`footer`.`layout_data`
`footer`.`main_columns`
`footer`.`rows_config`
`footer`.`html_content`
`footer`.`is_active`
`footer`.`created_at`
`footer`.`updated_at`
`header`.*
`header`.`id`
`header`.`name`
`header`.`layout_data`
`header`.`rows_config`
`header`.`html_content`
`header`.`is_active`
`header`.`created_at`
`header`.`updated_at`
`header_components`.*
`header_components`.`id`
`header_components`.`row_name`
`header_components`.`column_name`
`header_components`.`component_type`
`header_components`.`component_data`
`header_components`.`sort_order`
`header_components`.`created_at`
`header_components`.`updated_at`
`header_settings`.*
`header_settings`.`id`
`header_settings`.`row_name`
`header_settings`.`is_visible`
`header_settings`.`created_at`
`header_settings`.`updated_at`
`homepage`.*
`homepage`.`id`
`homepage`.`name`
`homepage`.`components_data`
`homepage`.`seo_title`
`homepage`.`seo_description`
`homepage`.`seo_keywords`
`homepage`.`html_content`
`homepage`.`is_active`
`homepage`.`created_at`
`homepage`.`updated_at`
`journal_details`.*
`journal_details`.`detail_id`
`journal_details`.`entry_id`
`journal_details`.`account_id`
`journal_details`.`debit_amount`
`journal_details`.`credit_amount`
`journal_details`.`description`
`journal_details`.`sort_order`
`journal_details`.`created_at`
`journal_details`.`updated_at`
`journal_entries`.*
`journal_entries`.`entry_id`
`journal_entries`.`entry_no`
`journal_entries`.`entry_date`
`journal_entries`.`entry_type`
`journal_entries`.`description`
`journal_entries`.`donation_id`
`journal_entries`.`is_auto_generated`
`journal_entries`.`status`
`journal_entries`.`posted_by`
`journal_entries`.`posted_at`
`journal_entries`.`created_by`
`journal_entries`.`created_at`
`journal_entries`.`updated_at`
`marquee`.*
`marquee`.`id`
`marquee`.`is_enabled`
`marquee`.`content_format`
`marquee`.`display_location`
`marquee`.`created_at`
`marquee`.`updated_at`
`media_library`.*
`media_library`.`id`
`media_library`.`name`
`media_library`.`description`
`media_library`.`file_path`
`media_library`.`file_type`
`media_library`.`file_size`
`media_library`.`mime_type`
`media_library`.`upload_date`
`media_library`.`created_at`
`media_library`.`updated_at`
`member`.*
`member`.`mem_id`
`member`.`mem_type`
`member`.`mem_name`
`member`.`id_card`
`member`.`mobile`
`member`.`tel`
`member`.`gender`
`member`.`address`
`member`.`email`
`member`.`company_name`
`member`.`company_tax_id`
`member`.`receipt_title`
`member`.`receipt_tax_id`
`member`.`created_at`
`member`.`updated_at`
`member`.`deleted_at`
`member`.`password`
`menu`.*
`menu`.`id`
`menu`.`name`
`menu`.`location`
`menu`.`description`
`menu`.`created_at`
`menu`.`updated_at`
`menu_items`.*
`menu_items`.`id`
`menu_items`.`menu_id`
`menu_items`.`parent_id`
`menu_items`.`item_type`
`menu_items`.`display_text`
`menu_items`.`link_url`
`menu_items`.`page_id`
`menu_items`.`open_in_new_tab`
`menu_items`.`sort_order`
`menu_items`.`created_at`
`menu_items`.`updated_at`
`news`.*
`news`.`id`
`news`.`title`
`news`.`content`
`news`.`category_id`
`news`.`featured_image`
`news`.`status`
`news`.`is_pinned`
`news`.`publish_date`
`news`.`view_count`
`news`.`author_id`
`news`.`created_at`
`news`.`updated_at`
`news_categories`.*
`news_categories`.`id`
`news_categories`.`name`
`news_categories`.`description`
`news_categories`.`sort_order`
`news_categories`.`created_at`
`news_categories`.`updated_at`
`page_builder`.*
`page_builder`.`id`
`page_builder`.`news_id`
`page_builder`.`title`
`page_builder`.`content`
`page_builder`.`html_content`
`page_builder`.`created_at`
`page_builder`.`updated_at`
`page_structure`.*
`page_structure`.`id`
`page_structure`.`page_id`
`page_structure`.`parent_structure_id`
`page_structure`.`sort_order`
`page_structure`.`created_at`
`page_structure`.`updated_at`
`pages`.*
`pages`.`id`
`pages`.`title`
`pages`.`content`
`pages`.`builder_content`
`pages`.`html_content`
`pages`.`featured_image`
`pages`.`slug`
`pages`.`status`
`pages`.`publish_date`
`pages`.`parent_id`
`pages`.`template`
`pages`.`author_id`
`pages`.`view_count`
`pages`.`seo_title`
`pages`.`seo_description`
`pages`.`seo_keywords`
`pages`.`sort_order`
`pages`.`created_at`
`pages`.`updated_at`
`pages`.`in_structure`
`payment`.*
`payment`.`payid`
`payment`.`pay_name`
`payment`.`line_onoff`
`payment`.`pay_type`
`payment`.`store_id`
`payment`.`api_key`
`payment`.`Secret_key`
`payment`.`hash_key`
`payment`.`hash_iv`
`payment`.`created_at`
`payment`.`updated_at`
`payment`.`deleted_at`
`payment`.`project_id`
`payment`.`amount`
`payment`.`payment_method_id`
`payment`.`donor_name`
`payment`.`donor_email`
`payment`.`donor_phone`
`payment`.`donor_address`
`payment`.`need_receipt`
`payment`.`receipt_status`
`payment`.`receipt_number`
`payment`.`payment_status`
`payment`.`transaction_id`
`payment`.`payment_date`
`payment`.`notes`
`payment_methods`.*
`payment_methods`.`id`
`payment_methods`.`name`
`payment_methods`.`code`
`payment_methods`.`payment_type`
`payment_methods`.`is_enabled`
`payment_methods`.`sort_order`
`payment_methods`.`created_at`
`payment_methods`.`updated_at`
`project`.*
`project`.`id`
`project`.`pj_name`
`project`.`pj_use`
`project`.`pj_class`
`project`.`created_at`
`project`.`updated_at`
`project`.`deleted_at`
`project`.`summary`
`project`.`description`
`project`.`builder_content`
`project`.`goal_amount`
`project`.`current_amount`
`project`.`min_amount`
`project`.`max_amount`
`project`.`start_date`
`project`.`end_date`
`project`.`status`
`project`.`project_type`
`project`.`category_id`
`project`.`manager_id`
`project`.`featured_image`
`project`.`images`
`project`.`seo_title`
`project`.`seo_description`
`project`.`seo_keywords`
`project`.`slug`
`project`.`publish_date`
`project_amount_options`.*
`project_amount_options`.`id`
`project_amount_options`.`project_id`
`project_amount_options`.`amount`
`project_amount_options`.`created_at`
`project_categories`.*
`project_categories`.`id`
`project_categories`.`name`
`project_categories`.`description`
`project_categories`.`sort_order`
`project_categories`.`created_at`
`project_categories`.`updated_at`
`project_categories`.`image`
`project_payment_methods`.*
`project_payment_methods`.`id`
`project_payment_methods`.`project_id`
`project_payment_methods`.`payment_method_id`
`project_payment_methods`.`created_at`
`project_recipients`.*
`project_recipients`.`id`
`project_recipients`.`project_id`
`project_recipients`.`recipient_type`
`project_recipients`.`recipient_id`
`project_recipients`.`recipient_name`
`project_recipients`.`allocated_amount`
`project_recipients`.`notes`
`project_recipients`.`created_at`
`project_recipients`.`updated_at`
`projects`.*
`projects`.`id`
`projects`.`project_name`
`projects`.`project_code`
`projects`.`short_description`
`projects`.`description`
`projects`.`content`
`projects`.`category`
`projects`.`target_amount`
`projects`.`current_amount`
`projects`.`start_date`
`projects`.`end_date`
`projects`.`is_long_term`
`projects`.`status`
`projects`.`manager_name`
`projects`.`is_featured`
`projects`.`meta_title`
`projects`.`meta_description`
`projects`.`imageURL`
`projects`.`created_by`
`projects`.`created_at`
`projects`.`updated_at`
`receipt_number_settings`.*
`receipt_number_settings`.`id`
`receipt_number_settings`.`prefix`
`receipt_number_settings`.`date_format`
`receipt_number_settings`.`sequence_digits`
`receipt_number_settings`.`current_sequence`
`receipt_number_settings`.`reset_daily`
`receipt_number_settings`.`last_reset_date`
`receipt_number_settings`.`created_at`
`receipt_number_settings`.`updated_at`
`receipts`.*
`receipts`.`id`
`receipts`.`receipt_no`
`receipts`.`entry_id`
`receipts`.`donation_id`
`receipts`.`payment_method_id`
`receipts`.`status`
`receipts`.`issued_date`
`receipts`.`sent_date`
`receipts`.`void_date`
`receipts`.`void_reason`
`receipts`.`reissue_count`
`receipts`.`parent_receipt_id`
`receipts`.`delivery_method`
`receipts`.`delivery_status`
`receipts`.`delivery_address`
`receipts`.`delivery_email`
`receipts`.`delivery_date`
`receipts`.`return_reason`
`receipts`.`archive_status`
`receipts`.`archive_box_no`
`receipts`.`archive_date`
`receipts`.`created_at`
`receipts`.`updated_at`
`referral_organizations`.*
`referral_organizations`.`id`
`referral_organizations`.`organization_name`
`referral_organizations`.`organization_type`
`referral_organizations`.`tax_id`
`referral_organizations`.`contact_name`
`referral_organizations`.`contact_title`
`referral_organizations`.`contact_phone`
`referral_organizations`.`contact_mobile`
`referral_organizations`.`contact_email`
`referral_organizations`.`contact_address`
`referral_organizations`.`status`
`referral_organizations`.`approved_by`
`referral_organizations`.`approved_at`
`referral_organizations`.`rejection_reason`
`referral_organizations`.`consent_agreed`
`referral_organizations`.`terms_agreed`
`referral_organizations`.`consent_agreed_at`
`referral_organizations`.`terms_agreed_at`
`referral_organizations`.`created_at`
`referral_organizations`.`updated_at`
`slideshow`.*
`slideshow`.`id`
`slideshow`.`title`
`slideshow`.`description`
`slideshow`.`image_path`
`slideshow`.`link`
`slideshow`.`open_in_new_tab`
`slideshow`.`is_enabled`
`slideshow`.`sort_order`
`slideshow`.`created_at`
`slideshow`.`updated_at`
`tax_filings`.*
`tax_filings`.`id`
`tax_filings`.`filing_year`
`tax_filings`.`filing_date`
`tax_filings`.`operator_id`
`tax_filings`.`operator_name`
`tax_filings`.`receipt_count`
`tax_filings`.`total_amount`
`tax_filings`.`export_file_path`
`tax_filings`.`receipt_file_path`
`tax_filings`.`receipt_file_name`
`tax_filings`.`notes`
`tax_filings`.`created_at`
`tax_filings`.`updated_at`
`transparency_reports`.*
`transparency_reports`.`id`
`transparency_reports`.`title`
`transparency_reports`.`report_date`
`transparency_reports`.`file_path`
`transparency_reports`.`file_name`
`transparency_reports`.`file_size`
`transparency_reports`.`file_type`
`transparency_reports`.`created_by`
`transparency_reports`.`created_at`
`transparency_reports`.`updated_at`
`account_categories`.*
`account_categories`.`category_id`
`account_categories`.`company_id`
`account_categories`.`category_code`
`account_categories`.`category_name`
`account_categories`.`category_type`
`account_categories`.`description`
`account_categories`.`is_active`
`account_categories`.`created_at`
`account_categories`.`updated_at`
`accountinfo`.*
`accountinfo`.`id`
`accountinfo`.`a_name`
`accountinfo`.`a_id`
`accountinfo`.`a_password`
`accountinfo`.`a_power`
`accountinfo`.`a_mail`
`accountinfo`.`a_mobile`
`accountinfo`.`created_at`
`accountinfo`.`updated_at`
`accountinfo`.`deleted_at`
`accounts`.*
`accounts`.`account_id`
`accounts`.`company_id`
`accounts`.`account_code`
`accounts`.`account_name`
`accounts`.`category_id`
`accounts`.`account_type`
`accounts`.`balance_type`
`accounts`.`parent_account_id`
`accounts`.`description`
`accounts`.`is_active`
`accounts`.`created_at`
`accounts`.`updated_at`
`bank_accounts`.*
`bank_accounts`.`id`
`bank_accounts`.`bank_code`
`bank_accounts`.`bank_name`
`bank_accounts`.`branch_name`
`bank_accounts`.`account_number`
`bank_accounts`.`account_name`
`bank_accounts`.`is_enabled`
`bank_accounts`.`created_at`
`bank_accounts`.`updated_at`
`budget_items`.*
`budget_items`.`item_id`
`budget_items`.`budget_id`
`budget_items`.`account_id`
`budget_items`.`budget_amount`
`budget_items`.`actual_amount`
`budget_items`.`variance`
`budget_items`.`execution_rate`
`budget_items`.`notes`
`budget_items`.`created_at`
`budget_items`.`updated_at`
`budget_plans`.*
`budget_plans`.`budget_id`
`budget_plans`.`company_id`
`budget_plans`.`budget_year`
`budget_plans`.`budget_name`
`budget_plans`.`status`
`budget_plans`.`approved_by`
`budget_plans`.`approved_at`
`budget_plans`.`description`
`budget_plans`.`created_by`
`budget_plans`.`created_at`
`budget_plans`.`updated_at`
`case_closings`.*
`case_closings`.`id`
`case_closings`.`case_id`
`case_closings`.`close_date`
`case_closings`.`close_reason`
`case_closings`.`close_summary`
`case_closings`.`total_subsidy_amount`
`case_closings`.`worker_id`
`case_closings`.`worker_name`
`case_closings`.`created_at`
`case_closings`.`updated_at`
`case_documents`.*
`case_documents`.`id`
`case_documents`.`case_id`
`case_documents`.`document_type`
`case_documents`.`document_name`
`case_documents`.`file_path`
`case_documents`.`file_size`
`case_documents`.`uploaded_by`
`case_documents`.`created_at`
`case_documents`.`updated_at`
`case_family_members`.*
`case_family_members`.`id`
`case_family_members`.`case_id`
`case_family_members`.`name`
`case_family_members`.`relation`
`case_family_members`.`age`
`case_family_members`.`job_status`
`case_family_members`.`created_at`
`case_family_members`.`updated_at`
`case_follows`.*
`case_follows`.`id`
`case_follows`.`case_id`
`case_follows`.`follow_date`
`case_follows`.`follow_type`
`case_follows`.`follow_content`
`case_follows`.`next_follow_date`
`case_follows`.`worker_id`
`case_follows`.`worker_name`
`case_follows`.`created_at`
`case_follows`.`updated_at`
`case_visits`.*
`case_visits`.`id`
`case_visits`.`case_id`
`case_visits`.`visit_type`
`case_visits`.`visit_date`
`case_visits`.`visit_location`
`case_visits`.`visitor_id`
`case_visits`.`visitor_name`
`case_visits`.`pre_assessment`
`case_visits`.`post_family_status`
`case_visits`.`post_economic_status`
`case_visits`.`post_subsidy_recommendation`
`case_visits`.`post_recommended_amount`
`case_visits`.`post_notes`
`case_visits`.`created_at`
`case_visits`.`updated_at`
`cases`.*
`cases`.`id`
`cases`.`case_no`
`cases`.`referral_organization_id`
`cases`.`referral_worker_name`
`cases`.`referral_worker_phone`
`cases`.`applicant_name`
`cases`.`applicant_id_number`
`cases`.`applicant_birthday`
`cases`.`applicant_phone`
`cases`.`applicant_address`
`cases`.`case_category`
`cases`.`case_description`
`cases`.`case_status`
`cases`.`assigned_worker_id`
`cases`.`assigned_worker_name`
`cases`.`total_subsidy_amount`
`cases`.`application_date`
`cases`.`visit_scheduled_date`
`cases`.`visit_date`
`cases`.`close_date`
`cases`.`close_reason`
`cases`.`notes`
`cases`.`created_at`
`cases`.`updated_at`
`communication_statuses`.*
`communication_statuses`.`id`
`communication_statuses`.`name`
`communication_statuses`.`sort_order`
`communication_statuses`.`created_at`
`communication_statuses`.`updated_at`
`contact_logs`.*
`contact_logs`.`id`
`contact_logs`.`contact_date`
`contact_logs`.`contact_time`
`contact_logs`.`contact_person`
`contact_logs`.`contact_method_id`
`contact_logs`.`communication_status_id`
`contact_logs`.`content`
`contact_logs`.`notes`
`contact_logs`.`created_by`
`contact_logs`.`created_at`
`contact_logs`.`updated_at`
`contact_methods`.*
`contact_methods`.`id`
`contact_methods`.`name`
`contact_methods`.`sort_order`
`contact_methods`.`created_at`
`contact_methods`.`updated_at`
`contact_replies`.*
`contact_replies`.`id`
`contact_replies`.`contact_id`
`contact_replies`.`replier_id`
`contact_replies`.`replier_name`
`contact_replies`.`reply_content`
`contact_replies`.`is_draft`
`contact_replies`.`sent_at`
`contact_replies`.`created_at`
`contact_replies`.`updated_at`
`contacts`.*
`contacts`.`id`
`contacts`.`name`
`contacts`.`email`
`contacts`.`phone`
`contacts`.`address`
`contacts`.`subject`
`contacts`.`message`
`contacts`.`status`
`contacts`.`ip_address`
`contacts`.`user_agent`
`contacts`.`created_at`
`contacts`.`updated_at`
`data_change_logs`.*
`data_change_logs`.`id`
`data_change_logs`.`module`
`data_change_logs`.`action`
`data_change_logs`.`target_type`
`data_change_logs`.`target_id`
`data_change_logs`.`target_identifier`
`data_change_logs`.`changed_fields`
`data_change_logs`.`old_values`
`data_change_logs`.`new_values`
`data_change_logs`.`change_reason`
`data_change_logs`.`changed_by`
`data_change_logs`.`changed_at`
`donations`.*
`donations`.`id`
`donations`.`DonationsNum`
`donations`.`is_named`
`donations`.`is_receipt_needed`
`donations`.`receipt_format`
`donations`.`donation_date`
`donations`.`mem_id`
`donations`.`donor_name`
`donations`.`donor_id_card`
`donations`.`mobile`
`donations`.`tel`
`donations`.`gender`
`donations`.`address`
`donations`.`email`
`donations`.`company_name`
`donations`.`company_tax_id`
`donations`.`is_public_credit`
`donations`.`amount`
`donations`.`receipt_no`
`donations`.`receipt_title`
`donations`.`receipt_tax_id`
`donations`.`is_receipt_void`
`donations`.`usage_purpose`
`donations`.`category`
`donations`.`project_name`
`donations`.`payment_period`
`donations`.`payment_source`
`donations`.`payid`
`donations`.`status`
`donations`.`project_type`
`donations`.`receipt_type`
`donations`.`beneficiary_ref`
`donations`.`note`
`donations`.`receipt_log`
`donations`.`print_mark`
`donations`.`pay_array`
`donations`.`created_at`
`donations`.`updated_at`
`donations`.`deleted_at`
`donations`.`project_id`
`donations`.`payment_method_id`
`donor_recipient_matching`.*
`donor_recipient_matching`.`id`
`donor_recipient_matching`.`donation_id`
`donor_recipient_matching`.`donor_name`
`donor_recipient_matching`.`donor_id`
`donor_recipient_matching`.`recipient_type`
`donor_recipient_matching`.`recipient_id`
`donor_recipient_matching`.`recipient_name`
`donor_recipient_matching`.`case_no`
`donor_recipient_matching`.`matched_amount`
`donor_recipient_matching`.`project_id`
`donor_recipient_matching`.`matching_date`
`donor_recipient_matching`.`matching_method`
`donor_recipient_matching`.`notes`
`donor_recipient_matching`.`created_by`
`donor_recipient_matching`.`created_at`
`donor_recipient_matching`.`updated_at`
`email_settings`.*
`email_settings`.`id`
`email_settings`.`setting_type`
`email_settings`.`smtp_host`
`email_settings`.`smtp_port`
`email_settings`.`smtp_encryption`
`email_settings`.`from_email`
`email_settings`.`from_name`
`email_settings`.`username`
`email_settings`.`password`
`email_settings`.`created_at`
`email_settings`.`updated_at`
`faq_categories`.*
`faq_categories`.`id`
`faq_categories`.`name`
`faq_categories`.`description`
`faq_categories`.`sort_order`
`faq_categories`.`is_enabled`
`faq_categories`.`created_at`
`faq_categories`.`updated_at`
`faq_settings`.*
`faq_settings`.`id`
`faq_settings`.`setting_key`
`faq_settings`.`setting_value`
`faq_settings`.`created_at`
`faq_settings`.`updated_at`
`faqs`.*
`faqs`.`id`
`faqs`.`category_id`
`faqs`.`question`
`faqs`.`answer`
`faqs`.`sort_order`
`faqs`.`is_enabled`
`faqs`.`view_count`
`faqs`.`created_at`
`faqs`.`updated_at`
`footer`.*
`footer`.`id`
`footer`.`name`
`footer`.`layout_data`
`footer`.`main_columns`
`footer`.`rows_config`
`footer`.`html_content`
`footer`.`is_active`
`footer`.`created_at`
`footer`.`updated_at`
`header`.*
`header`.`id`
`header`.`name`
`header`.`layout_data`
`header`.`rows_config`
`header`.`html_content`
`header`.`is_active`
`header`.`created_at`
`header`.`updated_at`
`header_components`.*
`header_components`.`id`
`header_components`.`row_name`
`header_components`.`column_name`
`header_components`.`component_type`
`header_components`.`component_data`
`header_components`.`sort_order`
`header_components`.`created_at`
`header_components`.`updated_at`
`header_settings`.*
`header_settings`.`id`
`header_settings`.`row_name`
`header_settings`.`is_visible`
`header_settings`.`created_at`
`header_settings`.`updated_at`
`homepage`.*
`homepage`.`id`
`homepage`.`name`
`homepage`.`components_data`
`homepage`.`seo_title`
`homepage`.`seo_description`
`homepage`.`seo_keywords`
`homepage`.`html_content`
`homepage`.`is_active`
`homepage`.`created_at`
`homepage`.`updated_at`
`journal_details`.*
`journal_details`.`detail_id`
`journal_details`.`entry_id`
`journal_details`.`account_id`
`journal_details`.`debit_amount`
`journal_details`.`credit_amount`
`journal_details`.`description`
`journal_details`.`sort_order`
`journal_details`.`created_at`
`journal_details`.`updated_at`
`journal_entries`.*
`journal_entries`.`entry_id`
`journal_entries`.`entry_no`
`journal_entries`.`entry_date`
`journal_entries`.`entry_type`
`journal_entries`.`description`
`journal_entries`.`donation_id`
`journal_entries`.`is_auto_generated`
`journal_entries`.`status`
`journal_entries`.`posted_by`
`journal_entries`.`posted_at`
`journal_entries`.`created_by`
`journal_entries`.`created_at`
`journal_entries`.`updated_at`
`marquee`.*
`marquee`.`id`
`marquee`.`is_enabled`
`marquee`.`content_format`
`marquee`.`display_location`
`marquee`.`created_at`
`marquee`.`updated_at`
`media_library`.*
`media_library`.`id`
`media_library`.`name`
`media_library`.`description`
`media_library`.`file_path`
`media_library`.`file_type`
`media_library`.`file_size`
`media_library`.`mime_type`
`media_library`.`upload_date`
`media_library`.`created_at`
`media_library`.`updated_at`
`member`.*
`member`.`mem_id`
`member`.`mem_type`
`member`.`mem_name`
`member`.`id_card`
`member`.`mobile`
`member`.`tel`
`member`.`gender`
`member`.`address`
`member`.`email`
`member`.`company_name`
`member`.`company_tax_id`
`member`.`receipt_title`
`member`.`receipt_tax_id`
`member`.`created_at`
`member`.`updated_at`
`member`.`deleted_at`
`member`.`password`
`menu`.*
`menu`.`id`
`menu`.`name`
`menu`.`location`
`menu`.`description`
`menu`.`created_at`
`menu`.`updated_at`
`menu_items`.*
`menu_items`.`id`
`menu_items`.`menu_id`
`menu_items`.`parent_id`
`menu_items`.`item_type`
`menu_items`.`display_text`
`menu_items`.`link_url`
`menu_items`.`page_id`
`menu_items`.`open_in_new_tab`
`menu_items`.`sort_order`
`menu_items`.`created_at`
`menu_items`.`updated_at`
`news`.*
`news`.`id`
`news`.`title`
`news`.`content`
`news`.`category_id`
`news`.`featured_image`
`news`.`status`
`news`.`is_pinned`
`news`.`publish_date`
`news`.`view_count`
`news`.`author_id`
`news`.`created_at`
`news`.`updated_at`
`news_categories`.*
`news_categories`.`id`
`news_categories`.`name`
`news_categories`.`description`
`news_categories`.`sort_order`
`news_categories`.`created_at`
`news_categories`.`updated_at`
`page_builder`.*
`page_builder`.`id`
`page_builder`.`news_id`
`page_builder`.`title`
`page_builder`.`content`
`page_builder`.`html_content`
`page_builder`.`created_at`
`page_builder`.`updated_at`
`page_structure`.*
`page_structure`.`id`
`page_structure`.`page_id`
`page_structure`.`parent_structure_id`
`page_structure`.`sort_order`
`page_structure`.`created_at`
`page_structure`.`updated_at`
`pages`.*
`pages`.`id`
`pages`.`title`
`pages`.`content`
`pages`.`builder_content`
`pages`.`html_content`
`pages`.`featured_image`
`pages`.`slug`
`pages`.`status`
`pages`.`publish_date`
`pages`.`parent_id`
`pages`.`template`
`pages`.`author_id`
`pages`.`view_count`
`pages`.`seo_title`
`pages`.`seo_description`
`pages`.`seo_keywords`
`pages`.`sort_order`
`pages`.`created_at`
`pages`.`updated_at`
`pages`.`in_structure`
`payment`.*
`payment`.`payid`
`payment`.`pay_name`
`payment`.`line_onoff`
`payment`.`pay_type`
`payment`.`store_id`
`payment`.`api_key`
`payment`.`Secret_key`
`payment`.`hash_key`
`payment`.`hash_iv`
`payment`.`created_at`
`payment`.`updated_at`
`payment`.`deleted_at`
`payment`.`project_id`
`payment`.`amount`
`payment`.`payment_method_id`
`payment`.`donor_name`
`payment`.`donor_email`
`payment`.`donor_phone`
`payment`.`donor_address`
`payment`.`need_receipt`
`payment`.`receipt_status`
`payment`.`receipt_number`
`payment`.`payment_status`
`payment`.`transaction_id`
`payment`.`payment_date`
`payment`.`notes`
`payment_methods`.*
`payment_methods`.`id`
`payment_methods`.`name`
`payment_methods`.`code`
`payment_methods`.`payment_type`
`payment_methods`.`is_enabled`
`payment_methods`.`sort_order`
`payment_methods`.`created_at`
`payment_methods`.`updated_at`
`project`.*
`project`.`id`
`project`.`pj_name`
`project`.`pj_use`
`project`.`pj_class`
`project`.`created_at`
`project`.`updated_at`
`project`.`deleted_at`
`project`.`summary`
`project`.`description`
`project`.`builder_content`
`project`.`goal_amount`
`project`.`current_amount`
`project`.`min_amount`
`project`.`max_amount`
`project`.`start_date`
`project`.`end_date`
`project`.`status`
`project`.`project_type`
`project`.`category_id`
`project`.`manager_id`
`project`.`featured_image`
`project`.`images`
`project`.`seo_title`
`project`.`seo_description`
`project`.`seo_keywords`
`project`.`slug`
`project`.`publish_date`
`project_amount_options`.*
`project_amount_options`.`id`
`project_amount_options`.`project_id`
`project_amount_options`.`amount`
`project_amount_options`.`created_at`
`project_categories`.*
`project_categories`.`id`
`project_categories`.`name`
`project_categories`.`description`
`project_categories`.`sort_order`
`project_categories`.`created_at`
`project_categories`.`updated_at`
`project_categories`.`image`
`project_payment_methods`.*
`project_payment_methods`.`id`
`project_payment_methods`.`project_id`
`project_payment_methods`.`payment_method_id`
`project_payment_methods`.`created_at`
`project_recipients`.*
`project_recipients`.`id`
`project_recipients`.`project_id`
`project_recipients`.`recipient_type`
`project_recipients`.`recipient_id`
`project_recipients`.`recipient_name`
`project_recipients`.`allocated_amount`
`project_recipients`.`notes`
`project_recipients`.`created_at`
`project_recipients`.`updated_at`
`projects`.*
`projects`.`id`
`projects`.`project_name`
`projects`.`project_code`
`projects`.`short_description`
`projects`.`description`
`projects`.`content`
`projects`.`category`
`projects`.`target_amount`
`projects`.`current_amount`
`projects`.`start_date`
`projects`.`end_date`
`projects`.`is_long_term`
`projects`.`status`
`projects`.`manager_name`
`projects`.`is_featured`
`projects`.`meta_title`
`projects`.`meta_description`
`projects`.`imageURL`
`projects`.`created_by`
`projects`.`created_at`
`projects`.`updated_at`
`receipt_number_settings`.*
`receipt_number_settings`.`id`
`receipt_number_settings`.`prefix`
`receipt_number_settings`.`date_format`
`receipt_number_settings`.`sequence_digits`
`receipt_number_settings`.`current_sequence`
`receipt_number_settings`.`reset_daily`
`receipt_number_settings`.`last_reset_date`
`receipt_number_settings`.`created_at`
`receipt_number_settings`.`updated_at`
`receipts`.*
`receipts`.`id`
`receipts`.`receipt_no`
`receipts`.`entry_id`
`receipts`.`donation_id`
`receipts`.`payment_method_id`
`receipts`.`status`
`receipts`.`issued_date`
`receipts`.`sent_date`
`receipts`.`void_date`
`receipts`.`void_reason`
`receipts`.`reissue_count`
`receipts`.`parent_receipt_id`
`receipts`.`delivery_method`
`receipts`.`delivery_status`
`receipts`.`delivery_address`
`receipts`.`delivery_email`
`receipts`.`delivery_date`
`receipts`.`return_reason`
`receipts`.`archive_status`
`receipts`.`archive_box_no`
`receipts`.`archive_date`
`receipts`.`created_at`
`receipts`.`updated_at`
`referral_organizations`.*
`referral_organizations`.`id`
`referral_organizations`.`organization_name`
`referral_organizations`.`organization_type`
`referral_organizations`.`tax_id`
`referral_organizations`.`contact_name`
`referral_organizations`.`contact_title`
`referral_organizations`.`contact_phone`
`referral_organizations`.`contact_mobile`
`referral_organizations`.`contact_email`
`referral_organizations`.`contact_address`
`referral_organizations`.`status`
`referral_organizations`.`approved_by`
`referral_organizations`.`approved_at`
`referral_organizations`.`rejection_reason`
`referral_organizations`.`consent_agreed`
`referral_organizations`.`terms_agreed`
`referral_organizations`.`consent_agreed_at`
`referral_organizations`.`terms_agreed_at`
`referral_organizations`.`created_at`
`referral_organizations`.`updated_at`
`slideshow`.*
`slideshow`.`id`
`slideshow`.`title`
`slideshow`.`description`
`slideshow`.`image_path`
`slideshow`.`link`
`slideshow`.`open_in_new_tab`
`slideshow`.`is_enabled`
`slideshow`.`sort_order`
`slideshow`.`created_at`
`slideshow`.`updated_at`
`tax_filings`.*
`tax_filings`.`id`
`tax_filings`.`filing_year`
`tax_filings`.`filing_date`
`tax_filings`.`operator_id`
`tax_filings`.`operator_name`
`tax_filings`.`receipt_count`
`tax_filings`.`total_amount`
`tax_filings`.`export_file_path`
`tax_filings`.`receipt_file_path`
`tax_filings`.`receipt_file_name`
`tax_filings`.`notes`
`tax_filings`.`created_at`
`tax_filings`.`updated_at`
`transparency_reports`.*
`transparency_reports`.`id`
`transparency_reports`.`title`
`transparency_reports`.`report_date`
`transparency_reports`.`file_path`
`transparency_reports`.`file_name`
`transparency_reports`.`file_size`
`transparency_reports`.`file_type`
`transparency_reports`.`created_by`
`transparency_reports`.`created_at`
`transparency_reports`.`updated_at`
`account_categories`.*
`account_categories`.`category_id`
`account_categories`.`company_id`
`account_categories`.`category_code`
`account_categories`.`category_name`
`account_categories`.`category_type`
`account_categories`.`description`
`account_categories`.`is_active`
`account_categories`.`created_at`
`account_categories`.`updated_at`
`accountinfo`.*
`accountinfo`.`id`
`accountinfo`.`a_name`
`accountinfo`.`a_id`
`accountinfo`.`a_password`
`accountinfo`.`a_power`
`accountinfo`.`a_mail`
`accountinfo`.`a_mobile`
`accountinfo`.`created_at`
`accountinfo`.`updated_at`
`accountinfo`.`deleted_at`
`accounts`.*
`accounts`.`account_id`
`accounts`.`company_id`
`accounts`.`account_code`
`accounts`.`account_name`
`accounts`.`category_id`
`accounts`.`account_type`
`accounts`.`balance_type`
`accounts`.`parent_account_id`
`accounts`.`description`
`accounts`.`is_active`
`accounts`.`created_at`
`accounts`.`updated_at`
`bank_accounts`.*
`bank_accounts`.`id`
`bank_accounts`.`bank_code`
`bank_accounts`.`bank_name`
`bank_accounts`.`branch_name`
`bank_accounts`.`account_number`
`bank_accounts`.`account_name`
`bank_accounts`.`is_enabled`
`bank_accounts`.`created_at`
`bank_accounts`.`updated_at`
`budget_items`.*
`budget_items`.`item_id`
`budget_items`.`budget_id`
`budget_items`.`account_id`
`budget_items`.`budget_amount`
`budget_items`.`actual_amount`
`budget_items`.`variance`
`budget_items`.`execution_rate`
`budget_items`.`notes`
`budget_items`.`created_at`
`budget_items`.`updated_at`
`budget_plans`.*
`budget_plans`.`budget_id`
`budget_plans`.`company_id`
`budget_plans`.`budget_year`
`budget_plans`.`budget_name`
`budget_plans`.`status`
`budget_plans`.`approved_by`
`budget_plans`.`approved_at`
`budget_plans`.`description`
`budget_plans`.`created_by`
`budget_plans`.`created_at`
`budget_plans`.`updated_at`
`case_closings`.*
`case_closings`.`id`
`case_closings`.`case_id`
`case_closings`.`close_date`
`case_closings`.`close_reason`
`case_closings`.`close_summary`
`case_closings`.`total_subsidy_amount`
`case_closings`.`worker_id`
`case_closings`.`worker_name`
`case_closings`.`created_at`
`case_closings`.`updated_at`
`case_documents`.*
`case_documents`.`id`
`case_documents`.`case_id`
`case_documents`.`document_type`
`case_documents`.`document_name`
`case_documents`.`file_path`
`case_documents`.`file_size`
`case_documents`.`uploaded_by`
`case_documents`.`created_at`
`case_documents`.`updated_at`
`case_family_members`.*
`case_family_members`.`id`
`case_family_members`.`case_id`
`case_family_members`.`name`
`case_family_members`.`relation`
`case_family_members`.`age`
`case_family_members`.`job_status`
`case_family_members`.`created_at`
`case_family_members`.`updated_at`
`case_follows`.*
`case_follows`.`id`
`case_follows`.`case_id`
`case_follows`.`follow_date`
`case_follows`.`follow_type`
`case_follows`.`follow_content`
`case_follows`.`next_follow_date`
`case_follows`.`worker_id`
`case_follows`.`worker_name`
`case_follows`.`created_at`
`case_follows`.`updated_at`
`case_visits`.*
`case_visits`.`id`
`case_visits`.`case_id`
`case_visits`.`visit_type`
`case_visits`.`visit_date`
`case_visits`.`visit_location`
`case_visits`.`visitor_id`
`case_visits`.`visitor_name`
`case_visits`.`pre_assessment`
`case_visits`.`post_family_status`
`case_visits`.`post_economic_status`
`case_visits`.`post_subsidy_recommendation`
`case_visits`.`post_recommended_amount`
`case_visits`.`post_notes`
`case_visits`.`created_at`
`case_visits`.`updated_at`
`cases`.*
`cases`.`id`
`cases`.`case_no`
`cases`.`referral_organization_id`
`cases`.`referral_worker_name`
`cases`.`referral_worker_phone`
`cases`.`applicant_name`
`cases`.`applicant_id_number`
`cases`.`applicant_birthday`
`cases`.`applicant_phone`
`cases`.`applicant_address`
`cases`.`case_category`
`cases`.`case_description`
`cases`.`case_status`
`cases`.`assigned_worker_id`
`cases`.`assigned_worker_name`
`cases`.`total_subsidy_amount`
`cases`.`application_date`
`cases`.`visit_scheduled_date`
`cases`.`visit_date`
`cases`.`close_date`
`cases`.`close_reason`
`cases`.`notes`
`cases`.`created_at`
`cases`.`updated_at`
`communication_statuses`.*
`communication_statuses`.`id`
`communication_statuses`.`name`
`communication_statuses`.`sort_order`
`communication_statuses`.`created_at`
`communication_statuses`.`updated_at`
`contact_logs`.*
`contact_logs`.`id`
`contact_logs`.`contact_date`
`contact_logs`.`contact_time`
`contact_logs`.`contact_person`
`contact_logs`.`contact_method_id`
`contact_logs`.`communication_status_id`
`contact_logs`.`content`
`contact_logs`.`notes`
`contact_logs`.`created_by`
`contact_logs`.`created_at`
`contact_logs`.`updated_at`
`contact_methods`.*
`contact_methods`.`id`
`contact_methods`.`name`
`contact_methods`.`sort_order`
`contact_methods`.`created_at`
`contact_methods`.`updated_at`
`contact_replies`.*
`contact_replies`.`id`
`contact_replies`.`contact_id`
`contact_replies`.`replier_id`
`contact_replies`.`replier_name`
`contact_replies`.`reply_content`
`contact_replies`.`is_draft`
`contact_replies`.`sent_at`
`contact_replies`.`created_at`
`contact_replies`.`updated_at`
`contacts`.*
`contacts`.`id`
`contacts`.`name`
`contacts`.`email`
`contacts`.`phone`
`contacts`.`address`
`contacts`.`subject`
`contacts`.`message`
`contacts`.`status`
`contacts`.`ip_address`
`contacts`.`user_agent`
`contacts`.`created_at`
`contacts`.`updated_at`
`data_change_logs`.*
`data_change_logs`.`id`
`data_change_logs`.`module`
`data_change_logs`.`action`
`data_change_logs`.`target_type`
`data_change_logs`.`target_id`
`data_change_logs`.`target_identifier`
`data_change_logs`.`changed_fields`
`data_change_logs`.`old_values`
`data_change_logs`.`new_values`
`data_change_logs`.`change_reason`
`data_change_logs`.`changed_by`
`data_change_logs`.`changed_at`
`donations`.*
`donations`.`id`
`donations`.`DonationsNum`
`donations`.`is_named`
`donations`.`is_receipt_needed`
`donations`.`receipt_format`
`donations`.`donation_date`
`donations`.`mem_id`
`donations`.`donor_name`
`donations`.`donor_id_card`
`donations`.`mobile`
`donations`.`tel`
`donations`.`gender`
`donations`.`address`
`donations`.`email`
`donations`.`company_name`
`donations`.`company_tax_id`
`donations`.`is_public_credit`
`donations`.`amount`
`donations`.`receipt_no`
`donations`.`receipt_title`
`donations`.`receipt_tax_id`
`donations`.`is_receipt_void`
`donations`.`usage_purpose`
`donations`.`category`
`donations`.`project_name`
`donations`.`payment_period`
`donations`.`payment_source`
`donations`.`payid`
`donations`.`status`
`donations`.`project_type`
`donations`.`receipt_type`
`donations`.`beneficiary_ref`
`donations`.`note`
`donations`.`receipt_log`
`donations`.`print_mark`
`donations`.`pay_array`
`donations`.`created_at`
`donations`.`updated_at`
`donations`.`deleted_at`
`donations`.`project_id`
`donations`.`payment_method_id`
`donor_recipient_matching`.*
`donor_recipient_matching`.`id`
`donor_recipient_matching`.`donation_id`
`donor_recipient_matching`.`donor_name`
`donor_recipient_matching`.`donor_id`
`donor_recipient_matching`.`recipient_type`
`donor_recipient_matching`.`recipient_id`
`donor_recipient_matching`.`recipient_name`
`donor_recipient_matching`.`case_no`
`donor_recipient_matching`.`matched_amount`
`donor_recipient_matching`.`project_id`
`donor_recipient_matching`.`matching_date`
`donor_recipient_matching`.`matching_method`
`donor_recipient_matching`.`notes`
`donor_recipient_matching`.`created_by`
`donor_recipient_matching`.`created_at`
`donor_recipient_matching`.`updated_at`
`email_settings`.*
`email_settings`.`id`
`email_settings`.`setting_type`
`email_settings`.`smtp_host`
`email_settings`.`smtp_port`
`email_settings`.`smtp_encryption`
`email_settings`.`from_email`
`email_settings`.`from_name`
`email_settings`.`username`
`email_settings`.`password`
`email_settings`.`created_at`
`email_settings`.`updated_at`
`faq_categories`.*
`faq_categories`.`id`
`faq_categories`.`name`
`faq_categories`.`description`
`faq_categories`.`sort_order`
`faq_categories`.`is_enabled`
`faq_categories`.`created_at`
`faq_categories`.`updated_at`
`faq_settings`.*
`faq_settings`.`id`
`faq_settings`.`setting_key`
`faq_settings`.`setting_value`
`faq_settings`.`created_at`
`faq_settings`.`updated_at`
`faqs`.*
`faqs`.`id`
`faqs`.`category_id`
`faqs`.`question`
`faqs`.`answer`
`faqs`.`sort_order`
`faqs`.`is_enabled`
`faqs`.`view_count`
`faqs`.`created_at`
`faqs`.`updated_at`
`footer`.*
`footer`.`id`
`footer`.`name`
`footer`.`layout_data`
`footer`.`main_columns`
`footer`.`rows_config`
`footer`.`html_content`
`footer`.`is_active`
`footer`.`created_at`
`footer`.`updated_at`
`header`.*
`header`.`id`
`header`.`name`
`header`.`layout_data`
`header`.`rows_config`
`header`.`html_content`
`header`.`is_active`
`header`.`created_at`
`header`.`updated_at`
`header_components`.*
`header_components`.`id`
`header_components`.`row_name`
`header_components`.`column_name`
`header_components`.`component_type`
`header_components`.`component_data`
`header_components`.`sort_order`
`header_components`.`created_at`
`header_components`.`updated_at`
`header_settings`.*
`header_settings`.`id`
`header_settings`.`row_name`
`header_settings`.`is_visible`
`header_settings`.`created_at`
`header_settings`.`updated_at`
`homepage`.*
`homepage`.`id`
`homepage`.`name`
`homepage`.`components_data`
`homepage`.`seo_title`
`homepage`.`seo_description`
`homepage`.`seo_keywords`
`homepage`.`html_content`
`homepage`.`is_active`
`homepage`.`created_at`
`homepage`.`updated_at`
`journal_details`.*
`journal_details`.`detail_id`
`journal_details`.`entry_id`
`journal_details`.`account_id`
`journal_details`.`debit_amount`
`journal_details`.`credit_amount`
`journal_details`.`description`
`journal_details`.`sort_order`
`journal_details`.`created_at`
`journal_details`.`updated_at`
`journal_entries`.*
`journal_entries`.`entry_id`
`journal_entries`.`entry_no`
`journal_entries`.`entry_date`
`journal_entries`.`entry_type`
`journal_entries`.`description`
`journal_entries`.`donation_id`
`journal_entries`.`is_auto_generated`
`journal_entries`.`status`
`journal_entries`.`posted_by`
`journal_entries`.`posted_at`
`journal_entries`.`created_by`
`journal_entries`.`created_at`
`journal_entries`.`updated_at`
`marquee`.*
`marquee`.`id`
`marquee`.`is_enabled`
`marquee`.`content_format`
`marquee`.`display_location`
`marquee`.`created_at`
`marquee`.`updated_at`
`media_library`.*
`media_library`.`id`
`media_library`.`name`
`media_library`.`description`
`media_library`.`file_path`
`media_library`.`file_type`
`media_library`.`file_size`
`media_library`.`mime_type`
`media_library`.`upload_date`
`media_library`.`created_at`
`media_library`.`updated_at`
`member`.*
`member`.`mem_id`
`member`.`mem_type`
`member`.`mem_name`
`member`.`id_card`
`member`.`mobile`
`member`.`tel`
`member`.`gender`
`member`.`address`
`member`.`email`
`member`.`company_name`
`member`.`company_tax_id`
`member`.`receipt_title`
`member`.`receipt_tax_id`
`member`.`created_at`
`member`.`updated_at`
`member`.`deleted_at`
`member`.`password`
`menu`.*
`menu`.`id`
`menu`.`name`
`menu`.`location`
`menu`.`description`
`menu`.`created_at`
`menu`.`updated_at`
`menu_items`.*
`menu_items`.`id`
`menu_items`.`menu_id`
`menu_items`.`parent_id`
`menu_items`.`item_type`
`menu_items`.`display_text`
`menu_items`.`link_url`
`menu_items`.`page_id`
`menu_items`.`open_in_new_tab`
`menu_items`.`sort_order`
`menu_items`.`created_at`
`menu_items`.`updated_at`
`news`.*
`news`.`id`
`news`.`title`
`news`.`content`
`news`.`category_id`
`news`.`featured_image`
`news`.`status`
`news`.`is_pinned`
`news`.`publish_date`
`news`.`view_count`
`news`.`author_id`
`news`.`created_at`
`news`.`updated_at`
`news_categories`.*
`news_categories`.`id`
`news_categories`.`name`
`news_categories`.`description`
`news_categories`.`sort_order`
`news_categories`.`created_at`
`news_categories`.`updated_at`
`page_builder`.*
`page_builder`.`id`
`page_builder`.`news_id`
`page_builder`.`title`
`page_builder`.`content`
`page_builder`.`html_content`
`page_builder`.`created_at`
`page_builder`.`updated_at`
`page_structure`.*
`page_structure`.`id`
`page_structure`.`page_id`
`page_structure`.`parent_structure_id`
`page_structure`.`sort_order`
`page_structure`.`created_at`
`page_structure`.`updated_at`
`pages`.*
`pages`.`id`
`pages`.`title`
`pages`.`content`
`pages`.`builder_content`
`pages`.`html_content`
`pages`.`featured_image`
`pages`.`slug`
`pages`.`status`
`pages`.`publish_date`
`pages`.`parent_id`
`pages`.`template`
`pages`.`author_id`
`pages`.`view_count`
`pages`.`seo_title`
`pages`.`seo_description`
`pages`.`seo_keywords`
`pages`.`sort_order`
`pages`.`created_at`
`pages`.`updated_at`
`pages`.`in_structure`
`payment`.*
`payment`.`payid`
`payment`.`pay_name`
`payment`.`line_onoff`
`payment`.`pay_type`
`payment`.`store_id`
`payment`.`api_key`
`payment`.`Secret_key`
`payment`.`hash_key`
`payment`.`hash_iv`
`payment`.`created_at`
`payment`.`updated_at`
`payment`.`deleted_at`
`payment`.`project_id`
`payment`.`amount`
`payment`.`payment_method_id`
`payment`.`donor_name`
`payment`.`donor_email`
`payment`.`donor_phone`
`payment`.`donor_address`
`payment`.`need_receipt`
`payment`.`receipt_status`
`payment`.`receipt_number`
`payment`.`payment_status`
`payment`.`transaction_id`
`payment`.`payment_date`
`payment`.`notes`
`payment_methods`.*
`payment_methods`.`id`
`payment_methods`.`name`
`payment_methods`.`code`
`payment_methods`.`payment_type`
`payment_methods`.`is_enabled`
`payment_methods`.`sort_order`
`payment_methods`.`created_at`
`payment_methods`.`updated_at`
`project`.*
`project`.`id`
`project`.`pj_name`
`project`.`pj_use`
`project`.`pj_class`
`project`.`created_at`
`project`.`updated_at`
`project`.`deleted_at`
`project`.`summary`
`project`.`description`
`project`.`builder_content`
`project`.`goal_amount`
`project`.`current_amount`
`project`.`min_amount`
`project`.`max_amount`
`project`.`start_date`
`project`.`end_date`
`project`.`status`
`project`.`project_type`
`project`.`category_id`
`project`.`manager_id`
`project`.`featured_image`
`project`.`images`
`project`.`seo_title`
`project`.`seo_description`
`project`.`seo_keywords`
`project`.`slug`
`project`.`publish_date`
`project_amount_options`.*
`project_amount_options`.`id`
`project_amount_options`.`project_id`
`project_amount_options`.`amount`
`project_amount_options`.`created_at`
`project_categories`.*
`project_categories`.`id`
`project_categories`.`name`
`project_categories`.`description`
`project_categories`.`sort_order`
`project_categories`.`created_at`
`project_categories`.`updated_at`
`project_categories`.`image`
`project_payment_methods`.*
`project_payment_methods`.`id`
`project_payment_methods`.`project_id`
`project_payment_methods`.`payment_method_id`
`project_payment_methods`.`created_at`
`project_recipients`.*
`project_recipients`.`id`
`project_recipients`.`project_id`
`project_recipients`.`recipient_type`
`project_recipients`.`recipient_id`
`project_recipients`.`recipient_name`
`project_recipients`.`allocated_amount`
`project_recipients`.`notes`
`project_recipients`.`created_at`
`project_recipients`.`updated_at`
`projects`.*
`projects`.`id`
`projects`.`project_name`
`projects`.`project_code`
`projects`.`short_description`
`projects`.`description`
`projects`.`content`
`projects`.`category`
`projects`.`target_amount`
`projects`.`current_amount`
`projects`.`start_date`
`projects`.`end_date`
`projects`.`is_long_term`
`projects`.`status`
`projects`.`manager_name`
`projects`.`is_featured`
`projects`.`meta_title`
`projects`.`meta_description`
`projects`.`imageURL`
`projects`.`created_by`
`projects`.`created_at`
`projects`.`updated_at`
`receipt_number_settings`.*
`receipt_number_settings`.`id`
`receipt_number_settings`.`prefix`
`receipt_number_settings`.`date_format`
`receipt_number_settings`.`sequence_digits`
`receipt_number_settings`.`current_sequence`
`receipt_number_settings`.`reset_daily`
`receipt_number_settings`.`last_reset_date`
`receipt_number_settings`.`created_at`
`receipt_number_settings`.`updated_at`
`receipts`.*
`receipts`.`id`
`receipts`.`receipt_no`
`receipts`.`entry_id`
`receipts`.`donation_id`
`receipts`.`payment_method_id`
`receipts`.`status`
`receipts`.`issued_date`
`receipts`.`sent_date`
`receipts`.`void_date`
`receipts`.`void_reason`
`receipts`.`reissue_count`
`receipts`.`parent_receipt_id`
`receipts`.`delivery_method`
`receipts`.`delivery_status`
`receipts`.`delivery_address`
`receipts`.`delivery_email`
`receipts`.`delivery_date`
`receipts`.`return_reason`
`receipts`.`archive_status`
`receipts`.`archive_box_no`
`receipts`.`archive_date`
`receipts`.`created_at`
`receipts`.`updated_at`
`referral_organizations`.*
`referral_organizations`.`id`
`referral_organizations`.`organization_name`
`referral_organizations`.`organization_type`
`referral_organizations`.`tax_id`
`referral_organizations`.`contact_name`
`referral_organizations`.`contact_title`
`referral_organizations`.`contact_phone`
`referral_organizations`.`contact_mobile`
`referral_organizations`.`contact_email`
`referral_organizations`.`contact_address`
`referral_organizations`.`status`
`referral_organizations`.`approved_by`
`referral_organizations`.`approved_at`
`referral_organizations`.`rejection_reason`
`referral_organizations`.`consent_agreed`
`referral_organizations`.`terms_agreed`
`referral_organizations`.`consent_agreed_at`
`referral_organizations`.`terms_agreed_at`
`referral_organizations`.`created_at`
`referral_organizations`.`updated_at`
`slideshow`.*
`slideshow`.`id`
`slideshow`.`title`
`slideshow`.`description`
`slideshow`.`image_path`
`slideshow`.`link`
`slideshow`.`open_in_new_tab`
`slideshow`.`is_enabled`
`slideshow`.`sort_order`
`slideshow`.`created_at`
`slideshow`.`updated_at`
`tax_filings`.*
`tax_filings`.`id`
`tax_filings`.`filing_year`
`tax_filings`.`filing_date`
`tax_filings`.`operator_id`
`tax_filings`.`operator_name`
`tax_filings`.`receipt_count`
`tax_filings`.`total_amount`
`tax_filings`.`export_file_path`
`tax_filings`.`receipt_file_path`
`tax_filings`.`receipt_file_name`
`tax_filings`.`notes`
`tax_filings`.`created_at`
`tax_filings`.`updated_at`
`transparency_reports`.*
`transparency_reports`.`id`
`transparency_reports`.`title`
`transparency_reports`.`report_date`
`transparency_reports`.`file_path`
`transparency_reports`.`file_name`
`transparency_reports`.`file_size`
`transparency_reports`.`file_type`
`transparency_reports`.`created_by`
`transparency_reports`.`created_at`
`transparency_reports`.`updated_at`
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
account_categories
accountinfo
accounts
bank_accounts
budget_items
budget_plans
case_closings
case_documents
case_family_members
case_follows
case_visits
cases
communication_statuses
contact_logs
contact_methods
contact_replies
contacts
data_change_logs
donations
donor_recipient_matching
email_settings
faq_categories
faq_settings
faqs
footer
header
header_components
header_settings
homepage
journal_details
journal_entries
marquee
media_library
member
menu
menu_items
news
news_categories
page_builder
page_structure
pages
payment
payment_methods
project
project_amount_options
project_categories
project_payment_methods
project_recipients
projects
receipt_number_settings
receipts
referral_organizations
slideshow
tax_filings
transparency_reports
SQL query on database
ycycashop_db
: