yourlove-pc.tail4b36f8.ts.net / 127.0.0.1 / ycycashop_db

There are no favorite tables.

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`).
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.

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 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 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 display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

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 :

Untitled *

v		ycycashop_db accountinfo
id : int(11)
a_name : varchar(50)
a_id : varchar(50)
a_password : varchar(255)
a_power : varchar(50)
a_mail : varchar(50)
a_mobile : varchar(50)
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		ycycashop_db accounts
account_id : int(11)
company_id : int(11)
account_code : varchar(50)
account_name : varchar(255)
category_id : int(11)
account_type : varchar(50)
balance_type : varchar(50)
parent_account_id : int(11)
description : text
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		ycycashop_db account_categories
category_id : int(11)
company_id : int(11)
category_code : varchar(50)
category_name : varchar(255)
category_type : varchar(50)
description : text
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		ycycashop_db bank_accounts
id : int(11)
bank_code : varchar(20)
bank_name : varchar(100)
branch_name : varchar(100)
account_number : varchar(50)
account_name : varchar(100)
is_enabled : tinyint(1)
created_at : datetime
updated_at : datetime

v		ycycashop_db budget_items
item_id : int(11)
budget_id : int(11)
account_id : int(11)
budget_amount : decimal(15,2)
actual_amount : decimal(15,2)
variance : decimal(15,2)
execution_rate : decimal(5,2)
notes : text
created_at : datetime
updated_at : datetime

v		ycycashop_db budget_plans
budget_id : int(11)
company_id : int(11)
budget_year : int(11)
budget_name : varchar(255)
status : enum('draft','approved','executing','closed')
approved_by : int(11)
approved_at : datetime
description : text
created_by : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db cases
id : int(11)
case_no : varchar(50)
referral_organization_id : int(11)
referral_worker_name : varchar(100)
referral_worker_phone : varchar(20)
applicant_name : varchar(100)
applicant_id_number : varchar(20)
applicant_birthday : date
applicant_phone : varchar(20)
applicant_address : text
case_category : varchar(50)
case_description : text
case_status : varchar(50)
assigned_worker_id : int(11)
assigned_worker_name : varchar(100)
total_subsidy_amount : decimal(15,2)
application_date : date
visit_scheduled_date : date
visit_date : date
close_date : date
close_reason : text
notes : text
created_at : datetime
updated_at : datetime

v		ycycashop_db case_closings
id : int(11)
case_id : int(11)
close_date : date
close_reason : text
close_summary : text
total_subsidy_amount : decimal(15,2)
worker_id : int(11)
worker_name : varchar(100)
created_at : datetime
updated_at : datetime

v		ycycashop_db case_documents
id : int(11)
case_id : int(11)
document_type : varchar(50)
document_name : varchar(255)
file_path : varchar(500)
file_size : int(11)
uploaded_by : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db case_family_members
id : int(11)
case_id : int(11)
name : varchar(100)
relation : varchar(50)
age : int(11)
job_status : varchar(200)
created_at : datetime
updated_at : datetime

v		ycycashop_db case_follows
id : int(11)
case_id : int(11)
follow_date : date
follow_type : varchar(50)
follow_content : text
next_follow_date : date
worker_id : int(11)
worker_name : varchar(100)
created_at : datetime
updated_at : datetime

v		ycycashop_db case_visits
id : int(11)
case_id : int(11)
visit_type : varchar(50)
visit_date : date
visit_location : varchar(200)
visitor_id : int(11)
visitor_name : varchar(100)
pre_assessment : text
post_family_status : text
post_economic_status : text
post_subsidy_recommendation : text
post_recommended_amount : decimal(15,2)
post_notes : text
created_at : datetime
updated_at : datetime

v		ycycashop_db communication_statuses
id : int(11)
name : varchar(100)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db contacts
id : int(11)
name : varchar(100)
email : varchar(150)
phone : varchar(30)
address : varchar(255)
subject : varchar(255)
message : text
status : enum('pending','replied','archived')
ip_address : varchar(45)
user_agent : varchar(500)
created_at : datetime
updated_at : datetime

v		ycycashop_db contact_logs
id : int(11)
contact_date : date
contact_time : time
contact_person : varchar(100)
contact_method_id : int(11)
communication_status_id : int(11)
content : text
notes : text
created_by : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db contact_methods
id : int(11)
name : varchar(100)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db contact_replies
id : int(11)
contact_id : int(11)
replier_id : int(11)
replier_name : varchar(100)
reply_content : text
is_draft : tinyint(1)
sent_at : datetime
created_at : datetime
updated_at : datetime

v		ycycashop_db data_change_logs
id : int(11)
module : varchar(50)
action : varchar(50)
target_type : varchar(50)
target_id : int(11)
target_identifier : varchar(100)
changed_fields : text
old_values : text
new_values : text
change_reason : text
changed_by : int(11)
changed_at : datetime

v		ycycashop_db donations
id : int(11)
DonationsNum : varchar(30)
is_named : tinyint(4)
is_receipt_needed : tinyint(4)
receipt_format : varchar(20)
donation_date : datetime
mem_id : int(11)
donor_name : varchar(100)
donor_id_card : varchar(30)
mobile : varchar(30)
tel : varchar(30)
gender : tinyint(4)
address : varchar(255)
email : varchar(150)
company_name : varchar(100)
company_tax_id : varchar(20)
is_public_credit : tinyint(4)
amount : decimal(12,2)
receipt_no : varchar(50)
receipt_title : varchar(100)
receipt_tax_id : varchar(20)
is_receipt_void : tinyint(4)
usage_purpose : varchar(100)
category : varchar(50)
project_name : varchar(150)
payment_period : varchar(20)
payment_source : varchar(50)
payid : int(11)
status : int(11)
project_type : varchar(50)
receipt_type : varchar(50)
beneficiary_ref : varchar(100)
note : text
receipt_log : text
print_mark : varchar(50)
pay_array : varchar(255)
created_at : datetime
updated_at : datetime
deleted_at : datetime
project_id : int(11)
payment_method_id : int(11)

v		ycycashop_db donor_recipient_matching
id : int(11)
donation_id : int(11)
donor_name : varchar(255)
donor_id : int(11)
recipient_type : varchar(50)
recipient_id : int(11)
recipient_name : varchar(255)
case_no : varchar(50)
matched_amount : decimal(15,2)
project_id : int(11)
matching_date : date
matching_method : varchar(50)
notes : text
created_by : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db email_settings
id : int(11)
setting_type : enum('receipt','general')
smtp_host : varchar(255)
smtp_port : varchar(10)
smtp_encryption : enum('tls','ssl','none')
from_email : varchar(255)
from_name : varchar(255)
username : varchar(255)
password : varchar(255)
created_at : datetime
updated_at : datetime

v		ycycashop_db faqs
id : int(11)
category_id : int(11)
question : varchar(500)
answer : text
sort_order : int(11)
is_enabled : tinyint(1)
view_count : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db faq_categories
id : int(11)
name : varchar(255)
description : text
sort_order : int(11)
is_enabled : tinyint(1)
created_at : datetime
updated_at : datetime

v		ycycashop_db faq_settings
id : int(11)
setting_key : varchar(50)
setting_value : text
created_at : datetime
updated_at : datetime

v		ycycashop_db footer
id : int(11)
name : varchar(255)
layout_data : longtext
main_columns : int(11)
rows_config : longtext
html_content : longtext
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		ycycashop_db header
id : int(11)
name : varchar(255)
layout_data : longtext
rows_config : longtext
html_content : longtext
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		ycycashop_db header_components
id : int(11)
row_name : varchar(20)
column_name : varchar(20)
component_type : varchar(50)
component_data : longtext
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db header_settings
id : int(11)
row_name : varchar(20)
is_visible : tinyint(1)
created_at : datetime
updated_at : datetime

v		ycycashop_db homepage
id : int(11)
name : varchar(255)
components_data : longtext
seo_title : varchar(60)
seo_description : varchar(160)
seo_keywords : varchar(255)
html_content : longtext
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		ycycashop_db journal_details
detail_id : int(11)
entry_id : int(11)
account_id : int(11)
debit_amount : decimal(15,2)
credit_amount : decimal(15,2)
description : text
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db journal_entries
entry_id : int(11)
entry_no : varchar(50)
entry_date : date
entry_type : varchar(50)
description : text
donation_id : int(11)
is_auto_generated : tinyint(1)
status : varchar(50)
posted_by : int(11)
posted_at : datetime
created_by : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db marquee
id : int(11)
is_enabled : tinyint(1)
content_format : text
display_location : varchar(50)
created_at : datetime
updated_at : datetime

v		ycycashop_db media_library
id : int(11)
name : varchar(255)
description : text
file_path : varchar(500)
file_type : enum('image','video','file')
file_size : bigint(20)
mime_type : varchar(100)
upload_date : datetime
created_at : datetime
updated_at : datetime

v		ycycashop_db member
mem_id : int(11)
mem_type : tinyint(4)
mem_name : varchar(100)
id_card : varchar(30)
mobile : varchar(30)
tel : varchar(30)
gender : tinyint(4)
address : varchar(255)
email : varchar(150)
company_name : varchar(100)
company_tax_id : varchar(20)
receipt_title : varchar(100)
receipt_tax_id : varchar(20)
created_at : datetime
updated_at : datetime
deleted_at : datetime
password : varchar(255)

v		ycycashop_db menu
id : int(11)
name : varchar(255)
location : enum('header','footer_block1','footer_block2','mobile_sidebar','unspecified')
description : text
created_at : datetime
updated_at : datetime

v		ycycashop_db menu_items
id : int(11)
menu_id : int(11)
parent_id : int(11)
item_type : enum('page','custom','title')
display_text : varchar(255)
link_url : varchar(500)
page_id : int(11)
open_in_new_tab : tinyint(1)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db news
id : int(11)
title : varchar(255)
content : longtext
category_id : int(11)
featured_image : varchar(500)
status : enum('draft','published','archived')
is_pinned : tinyint(1)
publish_date : datetime
view_count : int(11)
author_id : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db news_categories
id : int(11)
name : varchar(255)
description : text
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db pages
id : int(11)
title : varchar(255)
content : longtext
builder_content : longtext
html_content : longtext
featured_image : varchar(500)
slug : varchar(255)
status : enum('draft','published','scheduled','private','archived')
publish_date : datetime
parent_id : int(11)
template : varchar(50)
author_id : int(11)
view_count : int(11)
seo_title : varchar(60)
seo_description : varchar(160)
seo_keywords : varchar(255)
sort_order : int(11)
created_at : datetime
updated_at : datetime
in_structure : tinyint(1)

v		ycycashop_db page_builder
id : int(11)
news_id : int(11)
title : varchar(255)
content : longtext
html_content : longtext
created_at : datetime
updated_at : datetime

v		ycycashop_db page_structure
id : int(11)
page_id : int(11)
parent_structure_id : int(11)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db payment
payid : int(11)
pay_name : varchar(50)
line_onoff : tinyint(4)
pay_type : varchar(50)
store_id : varchar(50)
api_key : varchar(200)
Secret_key : varchar(200)
hash_key : varchar(200)
hash_iv : varchar(200)
created_at : datetime
updated_at : datetime
deleted_at : datetime
project_id : int(11)
amount : decimal(15,2)
payment_method_id : int(11)
donor_name : varchar(255)
donor_email : varchar(255)
donor_phone : varchar(50)
donor_address : text
need_receipt : tinyint(1)
receipt_status : enum('pending','issued','sent')
receipt_number : varchar(100)
payment_status : enum('pending','completed','failed','refunded')
transaction_id : varchar(255)
payment_date : datetime
notes : text

v		ycycashop_db payment_methods
id : int(11)
name : varchar(100)
code : varchar(50)
payment_type : enum('offline','online')
is_enabled : tinyint(1)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db project
id : int(11)
pj_name : varchar(100)
pj_use : varchar(50)
pj_class : varchar(50)
created_at : datetime
updated_at : datetime
deleted_at : datetime
summary : text
description : longtext
builder_content : longtext
goal_amount : decimal(15,2)
current_amount : decimal(15,2)
min_amount : decimal(10,2)
max_amount : decimal(10,2)
start_date : date
end_date : date
status : enum('draft','ongoing','completed','archived')
project_type : enum('regular','urgent')
category_id : int(11)
manager_id : int(11)
featured_image : varchar(500)
images : longtext
seo_title : varchar(255)
seo_description : varchar(500)
seo_keywords : varchar(255)
slug : varchar(255)
publish_date : datetime

v		ycycashop_db projects
id : int(11)
project_name : varchar(255)
project_code : varchar(50)
short_description : text
description : text
content : longtext
category : varchar(50)
target_amount : decimal(15,2)
current_amount : decimal(15,2)
start_date : date
end_date : date
is_long_term : tinyint(1)
status : varchar(50)
manager_name : varchar(100)
is_featured : tinyint(1)
meta_title : varchar(255)
meta_description : text
imageURL : varchar(1000)
created_by : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db project_amount_options
id : int(11)
project_id : int(11)
amount : decimal(10,2)
created_at : datetime

v		ycycashop_db project_categories
id : int(11)
name : varchar(255)
description : text
sort_order : int(11)
created_at : datetime
updated_at : datetime
image : varchar(500)

v		ycycashop_db project_payment_methods
id : int(11)
project_id : int(11)
payment_method_id : int(11)
created_at : datetime

v		ycycashop_db project_recipients
id : int(11)
project_id : int(11)
recipient_type : varchar(50)
recipient_id : int(11)
recipient_name : varchar(255)
allocated_amount : decimal(15,2)
notes : text
created_at : datetime
updated_at : datetime

v		ycycashop_db receipts
id : int(11)
receipt_no : varchar(100)
entry_id : int(11)
donation_id : int(11)
payment_method_id : int(11)
status : enum('issued','sent','void')
issued_date : date
sent_date : datetime
void_date : datetime
void_reason : text
reissue_count : int(11)
parent_receipt_id : int(11)
delivery_method : enum('mail','email','pickup')
delivery_status : enum('pending','sent','returned')
delivery_address : varchar(500)
delivery_email : varchar(255)
delivery_date : date
return_reason : text
archive_status : enum('pending','archived')
archive_box_no : varchar(100)
archive_date : date
created_at : datetime
updated_at : datetime

v		ycycashop_db receipt_number_settings
id : int(11)
prefix : varchar(20)
date_format : enum('YYYYMMDD','YYMMDD','YYYYMM','none')
sequence_digits : int(11)
current_sequence : int(11)
reset_daily : tinyint(1)
last_reset_date : date
created_at : datetime
updated_at : datetime

v		ycycashop_db referral_organizations
id : int(11)
organization_name : varchar(255)
organization_type : varchar(50)
tax_id : varchar(8)
contact_name : varchar(100)
contact_title : varchar(100)
contact_phone : varchar(50)
contact_mobile : varchar(50)
contact_email : varchar(255)
contact_address : varchar(500)
status : enum('pending','approved','rejected','suspended')
approved_by : int(11)
approved_at : datetime
rejection_reason : text
consent_agreed : tinyint(1)
terms_agreed : tinyint(1)
consent_agreed_at : datetime
terms_agreed_at : datetime
created_at : datetime
updated_at : datetime

v		ycycashop_db slideshow
id : int(11)
title : varchar(255)
description : text
image_path : varchar(500)
link : varchar(500)
open_in_new_tab : tinyint(1)
is_enabled : tinyint(1)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		ycycashop_db tax_filings
id : int(11)
filing_year : int(11)
filing_date : datetime
operator_id : int(11)
operator_name : varchar(255)
receipt_count : int(11)
total_amount : decimal(15,2)
export_file_path : varchar(500)
receipt_file_path : varchar(500)
receipt_file_name : varchar(255)
notes : text
created_at : datetime
updated_at : datetime

v		ycycashop_db transparency_reports
id : int(11)
title : varchar(255)
report_date : date
file_path : varchar(500)
file_name : varchar(255)
file_size : bigint(20)
file_type : varchar(100)
created_by : int(11)
created_at : datetime
updated_at : datetime

Create relationship
FOREIGN KEY
on delete
on update