🔍 Database Analysis Tool

📊 Available Databases:

ai_agent_grid
ai_agent_stocks_0
ai_bots
clinnco
information_schema
mysql
performance_schema
phpmyadmin
sys
system0
timelystay

🧹 Clinnco Database (Cleaning)

Tables:

adverts
affiliate_rewards
cities
cleaning_photos
cleanings
debts
debts_easypay_orders
debts_services
easypay_orders
employee_announce
employee_chat
employees
ical_properties
messages
payments
properties
property_checklist_items
reservation_services
reservations
service_language
service_prices
services
subscriptions
suppliers_rating
typologies
user_addresses
users

📋 Table: adverts

Column	Type	Null	Key	Default	Extra
id	int	NO	PRI		auto_increment
info	varchar(255)	NO
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED
adt_usr_id	int	YES	MUL
adt_usr_type	enum('Everyone','Property Owner','Cleaning Company','Manager','Accountant')	YES
language	enum('pt','en')	NO		pt

Row count: 0

📋 Table: affiliate_rewards

Column	Type	Null	Key	Default	Extra
afr_id	int	NO	PRI		auto_increment
afr_affiliate_id	int	NO	MUL
afr_user_id	int	NO	UNI
afr_rewarded	tinyint(1)	NO		0
afr_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
afr_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: cities

Column	Type	Null	Key	Default	Extra
cit_id	int	NO	PRI		auto_increment
cit_name	varchar(255)	NO
cit_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
cit_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 5

Sample Data (first 3 rows):

cit_id	cit_name	cit_created_at	cit_updated_at
1	Lisbon	2025-07-20 04:11:41	2025-07-20 04:11:41
2	Porto	2025-07-20 04:11:41	2025-07-20 04:11:41
3	Faro	2025-07-20 04:11:41	2025-07-20 04:11:41

📋 Table: cleaning_photos

Column	Type	Null	Key	Default	Extra
photo_id	int	NO	PRI		auto_increment
cleaning_id	int	NO	MUL
reservation_id	int	NO	MUL
photo_path	varchar(255)	NO
created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Row count: 0

📋 Table: cleanings

Column	Type	Null	Key	Default	Extra
cln_id	int	NO	PRI		auto_increment
cln_employee_id	int	NO	MUL
cln_property_id	int	YES	MUL
cln_reservation_id	int	YES	MUL
cln_url_path	varchar(256)	NO	UNI
cln_status	enum('Awaiting Start','On Going','Finished')	NO		Awaiting Start
cln_observation	varchar(1024)	YES
cln_start	datetime	YES
cln_finish	datetime	YES
cln_going	tinyint(1)	NO		0
cln_return	tinyint(1)	NO		0
cln_active	tinyint(1)	NO		1
cln_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
cln_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 2

Sample Data (first 3 rows):

cln_id	cln_employee_id	cln_property_id	cln_reservation_id	cln_url_path	cln_status	cln_observation	cln_start	cln_finish	cln_going	cln_return	cln_active	cln_created_at	cln_updated_at
1	1	1	1	cleaning-001	Awaiting Start	Standard cleaning after guest check-out			0	0	1	2025-07-20 04:11:41	2025-07-20 04:11:41
2	2	2	2	cleaning-002	Awaiting Start	Deep cleaning for new guest arrival			0	0	1	2025-07-20 04:11:41	2025-07-20 04:11:41

📋 Table: debts

Column	Type	Null	Key	Default	Extra
dbt_id	int	NO	PRI		auto_increment
dbt_property_id	int	NO	MUL
dbt_supplier_id	int	NO	MUL
dbt_payment_id	int	YES	MUL
dbt_description	varchar(512)	NO
dbt_cleaning_date	datetime	NO
dbt_status	enum('Awaiting Payment','Confirmed','Canceled')	YES		Awaiting Payment
dbt_discount	float	NO		0
dbt_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
dbt_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: debts_easypay_orders

Column	Type	Null	Key	Default	Extra
deo_id	int	NO	PRI		auto_increment
deo_debt_id	int	NO	MUL
deo_eap_id	int	NO	MUL
deo_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
deo_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: debts_services

Column	Type	Null	Key	Default	Extra
dse_id	int	NO	PRI		auto_increment
dse_debt_id	int	NO	MUL
dse_service_id	int	NO	MUL
dse_extra_included	tinyint(1)	NO		0
dse_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
dse_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: easypay_orders

Column	Type	Null	Key	Default	Extra
eap_id	int	NO	PRI		auto_increment
eap_reservation_id	int	NO	MUL
eap_payment_id	varchar(255)	NO
eap_value	float	NO
eap_nif	varchar(255)	YES
eap_phone	varchar(255)	YES
eap_phone_indicative	varchar(255)	YES
eap_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
eap_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: employee_announce

Column	Type	Null	Key	Default	Extra
id	int	NO	PRI		auto_increment
emp_id	int	NO	MUL
message	text	YES
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Row count: 0

📋 Table: employee_chat

Column	Type	Null	Key	Default	Extra
chat_id	int	NO	PRI		auto_increment
emp_id	int	NO	MUL
message	text	NO
admin_response	text	YES
is_read	tinyint(1)	YES		0
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED
response_at	timestamp	YES

Row count: 0

📋 Table: employees

Column	Type	Null	Key	Default	Extra
emp_id	int	NO	PRI		auto_increment
emp_name	varchar(256)	NO
emp_code	varchar(256)	YES
emp_active	tinyint(1)	NO		1
emp_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
emp_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP
language	varchar(18)	NO
role	varchar(18)	NO		employee

Row count: 3

Sample Data (first 3 rows):

emp_id	emp_name	emp_code	emp_active	emp_created_at	emp_updated_at	language	role
1	Ana Costa	EMP001	1	2025-07-20 04:11:41	2025-07-20 04:11:41	pt	employee
2	Carlos Ferreira	EMP002	1	2025-07-20 04:11:41	2025-07-20 04:11:41	pt	employee
3	Sofia Martins	EMP003	1	2025-07-20 04:11:41	2025-07-20 04:11:41	pt	manager

📋 Table: ical_properties

Column	Type	Null	Key	Default	Extra
icp_id	int	NO	PRI		auto_increment
icp_property_id	int	NO	MUL
icp_supplier_id	int	NO	MUL
icp_url	varchar(255)	NO
icp_cleaning_time	time	NO		12:30:00
icp_laundry_single_bed	int	NO		0
icp_laundry_double_bed	int	NO		0
icp_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
icp_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: messages

Column	Type	Null	Key	Default	Extra
msg_id	int	NO	PRI		auto_increment
msg_res_id	int	NO	MUL
msg_usr_id	int	NO	MUL
msg_text	text	NO
msg_read	tinyint(1)	NO		0
msg_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Row count: 0

📋 Table: payments

Column	Type	Null	Key	Default	Extra
pay_id	int	NO	PRI		auto_increment
pay_reservation_id	int	NO	UNI
pay_method	varchar(255)	NO
pay_value	varchar(255)	NO
pay_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
pay_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: properties

Column	Type	Null	Key	Default	Extra
prp_id	int	NO	PRI		auto_increment
prp_user_id	int	NO	MUL
prp_typology_id	int	NO	MUL
prp_name	varchar(255)	NO
prp_address	varchar(255)	NO
prp_number	varchar(10)	YES
prp_address_details	varchar(255)	NO
prp_postcode	varchar(255)	NO
prp_city	varchar(255)	NO
prp_region	varchar(255)	NO
prp_country	varchar(255)	NO
prp_coords	point	NO
prp_place_id	varchar(255)	NO
prp_travel_time	int	NO		0
prp_active	tinyint(1)	NO		1
prp_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
prp_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 2

Sample Data (first 3 rows):

prp_id	prp_user_id	prp_typology_id	prp_name	prp_address	prp_number	prp_address_details	prp_postcode	prp_city	prp_region	prp_country	prp_coords	prp_place_id	prp_travel_time	prp_active	prp_created_at	prp_updated_at
1	1	1	Beach House Lisbon	Rua da Praia, 123	123	Beachfront	1000-001	Lisbon	Lisboa	Portugal	e�`TRG"�M�St\C@	ChIJNS2FahDQzQ0RkgxGUNjO1kE	30	1	2025-07-20 04:11:41	2025-07-20 04:11:41
2	1	2	City Apartment Porto	Avenida da Liberdade, 456	456	City Center	4000-001	Porto	Porto	Portugal	��+eB!��46�D@	ChIJf4jXIcFQzQ0RkgxGUNjO1kE	25	1	2025-07-20 04:11:41	2025-07-20 04:11:41

📋 Table: property_checklist_items

Column	Type	Null	Key	Default	Extra
pci_id	int	NO	PRI		auto_increment
pci_property_id	int	YES	MUL
pci_description_pt	varchar(512)	NO
pci_description_en	varchar(512)	NO
pci_image_path	varchar(256)	YES
pci_type	enum('Before Cleaning','Start of Cleaning','During Cleaning','After Cleaning')	YES		During Cleaning
pci_active	tinyint(1)	NO		1
pci_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
pci_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: reservation_services

Column	Type	Null	Key	Default	Extra
rse_id	int	NO	PRI		auto_increment
rse_reservation_id	int	NO	MUL
rse_service_id	int	NO	MUL
rse_extra_included	tinyint(1)	NO
rse_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
rse_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: reservations

Column	Type	Null	Key	Default	Extra
res_id	int	NO	PRI		auto_increment
res_property_id	int	NO	MUL
res_supplier_id	int	NO	MUL
res_description	varchar(1024)	NO
res_cleaning_date	datetime	NO
res_status	enum('Awaiting Payment','Confirmed','Finished','Canceled')	YES		Awaiting Payment
res_ical	tinyint(1)	NO		0
res_discount	float	NO		0
res_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
res_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP
pay_value	double	YES

Row count: 2

Sample Data (first 3 rows):

res_id	res_property_id	res_supplier_id	res_description	res_cleaning_date	res_status	res_ical	res_discount	res_created_at	res_updated_at	pay_value
1	1	1	Standard cleaning after guest check-out	2024-07-30 10:00:00	Confirmed	0	0	2025-07-20 04:11:41	2025-07-20 04:11:41	80
2	2	1	Deep cleaning for new guest arrival	2024-08-02 09:00:00	Awaiting Payment	0	0	2025-07-20 04:11:41	2025-07-20 04:11:41	120

📋 Table: service_language

Column	Type	Null	Key	Extra
id	int	NO	PRI	auto_increment
pt	text	NO
en	text	NO
ser_id	int	NO	MUL

Row count: 0

📋 Table: service_prices

Column	Type	Null	Key	Default	Extra
spr_id	int	NO	PRI		auto_increment
spr_service_id	int	NO	MUL
spr_city_id	int	NO	MUL
spr_typology_id	int	YES	MUL
spr_price	float	NO
spr_extra	float	NO		0
spr_active	tinyint(1)	NO		1
spr_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
spr_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: services

Column	Type	Null	Key	Default	Extra
ser_id	int	NO	PRI		auto_increment
ser_name	varchar(255)	NO
ser_active	tinyint(1)	NO		1

Row count: 5

Sample Data (first 3 rows):

ser_id	ser_name	ser_active
1	Standard Cleaning	1
2	Deep Cleaning	1
3	Exit Cleaning	1

📋 Table: subscriptions

Column	Type	Null	Key	Default	Extra
subs_id	int	NO	PRI		auto_increment
subs_usr_id	int	NO	MUL
subs_method	varchar(255)	YES
subs_type	enum('monthly','annually')	NO
subs_value	float	NO
subs_billing_id	text	YES
subs_status	enum('active','cancellation_pending','canceled')	YES		active
subs_renewal_count	int	NO		1
subs_cancellation_reason	text	YES
subs_next_billing	timestamp	YES
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Row count: 0

📋 Table: suppliers_rating

Column	Type	Null	Key	Default	Extra
sur_id	int	NO	PRI		auto_increment
sur_reservation_id	int	NO	UNI
sur_rating	enum('Very Bad','Bad','Medium','Good','Very Good')	NO
sur_comment	text	NO
sur_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
sur_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: typologies

Column	Type	Null	Key	Default	Extra
typ_id	int	NO	PRI		auto_increment
typ_typology	varchar(3)	NO

Row count: 4

Sample Data (first 3 rows):

typ_id	typ_typology
1	T1
2	T2
3	T3

📋 Table: user_addresses

Column	Type	Null	Key	Default	Extra
adr_id	int	NO	PRI		auto_increment
adr_user_id	int	NO	MUL
adr_street	varchar(255)	NO
adr_number	varchar(10)	YES
adr_details	varchar(255)	YES
adr_postcode	varchar(255)	NO
adr_city	varchar(255)	NO
adr_region	varchar(255)	NO
adr_country	varchar(255)	NO
adr_coords	point	NO
adr_place_id	varchar(255)	NO
adr_distance_range	float	YES		10
adr_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
adr_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: users

Column	Type	Null	Key	Default	Extra
usr_id	int	NO	PRI		auto_increment
usr_name	varchar(255)	NO
usr_email	varchar(255)	NO	UNI
usr_password	varchar(512)	NO
usr_phone	varchar(256)	YES
usr_nif	varchar(255)	YES
usr_type	enum('Property Owner','Cleaning Company','Administrator','Manager','Accountant')	NO		Property Owner
usr_credits	float	NO		10
usr_monthly_credits_pct	float	NO		3
usr_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
usr_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP
usr_immediately_pct	float	YES

Row count: 3

Sample Data (first 3 rows):

usr_id	usr_name	usr_email	usr_password	usr_phone	usr_nif	usr_type	usr_credits	usr_monthly_credits_pct	usr_created_at	usr_updated_at
1	Maria Silva	maria@example.com	hashed_password	+351 123 456 789	123456789	Property Owner	10	3	2025-07-20 04:11:41	2025-07-20 04:11:41
2	João Santos	joao@example.com	hashed_password	+351 987 654 321	987654321	Cleaning Company	10	3	2025-07-20 04:11:41	2025-07-20 04:11:41
3	Admin User	admin@example.com	hashed_password	+351 555 123 456	555123456	Administrator	10	3	2025-07-20 04:11:41	2025-07-20 04:11:41

🏠 Timelystay Database (Management)

Tables:

blogs
checkin_data
cities
countries
events
guest_conversations
guest_messages
guest_notifications
ical_reservations
messages
partner_reservations
payments
properties
property_images
regions
reservations
users
users_checkin
users_region

📋 Table: blogs

Column	Type	Null	Key	Default	Extra
blg_id	int	NO	PRI		auto_increment
blg_url_path	varchar(255)	NO	UNI
blg_title_en	varchar(255)	NO
blg_title_pt	varchar(255)	NO
blg_subtitle_en	varchar(255)	YES
blg_subtitle_pt	varchar(255)	YES
blg_content_en	longtext	NO
blg_content_pt	longtext	NO
blg_active	tinyint(1)	NO		1
blg_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
blg_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: checkin_data

Column	Type	Null	Key	Default	Extra
id	int	NO	PRI		auto_increment
full_name	varchar(255)	NO
nationality	varchar(100)	NO
place_of_birth	varchar(255)	NO
place_of_residence	varchar(255)	NO
country_of_residence	varchar(100)	NO
dob	date	NO
document_type	enum('passport','citizen_card','other')	NO
passport_number	varchar(100)	NO
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED
usr_id_checkin	int	YES	MUL

Row count: 0

📋 Table: cities

Column	Type	Null	Key	Extra
cit_id	int	NO	PRI	auto_increment
cit_country_id	int	NO	MUL
cit_name	varchar(255)	NO

Row count: 45

Sample Data (first 3 rows):

cit_id	cit_country_id	cit_name
1	1	Lisbon
2	1	Porto
3	1	Faro

📋 Table: countries

Column	Type	Null	Key	Default	Extra
cou_id	int	NO	PRI		auto_increment
cou_name	varchar(255)	NO

Row count: 36

Sample Data (first 3 rows):

cou_id	cou_name
1	Portugal
2	Spain
3	France

📋 Table: events

Column	Type	Null	Key	Default	Extra
eve_id	int	NO	PRI		auto_increment
eve_property_id	int	NO	MUL
eve_date	date	NO
eve_type	enum('ical','reservation','closed','special_price')	YES
eve_price	float	YES
eve_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
eve_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: guest_conversations

Column	Type	Null	Key	Default	Extra
conv_id	int	NO	PRI		auto_increment
guest_id	int	NO	MUL
session_id	varchar(255)	NO	MUL
status	enum('active','closed','escalated')	YES	MUL	active
started_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED
ended_at	timestamp	YES
escalation_reason	text	YES

Row count: 2

Sample Data (first 3 rows):

conv_id	guest_id	session_id	status	started_at	ended_at	escalation_reason
1	1	session_687c6c7cc4aaf	active	2025-07-20 04:11:40
2	2	session_687c6c7cc4ab9	active	2025-07-20 04:11:40

📋 Table: guest_messages

Column	Type	Null	Key	Default	Extra
msg_id	int	NO	PRI		auto_increment
guest_id	int	NO	MUL
message_type	enum('guest','ai','human')	NO		ai
message_text	text	NO
is_read	tinyint(1)	YES	MUL	0
created_at	timestamp	YES	MUL	CURRENT_TIMESTAMP	DEFAULT_GENERATED
updated_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 4

Sample Data (first 3 rows):

msg_id	guest_id	message_type	message_text	created_at	updated_at
1	1	ai	Welcome to your stay! I'm your AI assistant. How can I help you today?	2025-07-20 04:11:40	2025-07-20 04:11:40
2	1	guest	What is the WiFi password?	2025-07-20 04:11:40	2025-07-20 04:11:40
3	1	ai	The WiFi network is "BeachHouse_WiFi" and the password is "beach2024".	2025-07-20 04:11:40	2025-07-20 04:11:40

📋 Table: guest_notifications

Column	Type	Null	Key	Default	Extra
notif_id	int	NO	PRI		auto_increment
guest_id	int	NO	MUL
notification_type	enum('checkin_reminder','checkout_reminder','maintenance','emergency','general')	NO	MUL
title	varchar(255)	NO
message	text	NO
is_read	tinyint(1)	YES	MUL	0
is_sent	tinyint(1)	YES		0
scheduled_at	timestamp	YES	MUL
sent_at	timestamp	YES
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Row count: 2

Sample Data (first 3 rows):

notif_id	guest_id	notification_type	title	message	is_read	is_sent	scheduled_at	sent_at	created_at
1	1	checkin_reminder	Check-in Reminder	Your check-in is scheduled for tomorrow at 3:00 PM. Please have your access code ready.	0	0	2025-07-21 04:11:40		2025-07-20 04:11:40
2	2	checkout_reminder	Check-out Reminder	Your check-out is scheduled for tomorrow at 10:00 AM. Please ensure the property is tidy.	0	0	2025-07-21 04:11:40		2025-07-20 04:11:40

📋 Table: ical_reservations

Column	Type	Null	Key	Default	Extra
ica_id	int	NO	PRI		auto_increment
ica_property_id	int	NO	MUL
ica_origin	varchar(255)	NO
ica_checkin	datetime	NO
ica_checkout	datetime	NO
ica_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
ica_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: messages

Column	Type	Null	Key	Default	Extra
msg_id	int	NO	PRI		auto_increment
msg_pay_id	int	NO	MUL
msg_usr_id	int	NO	MUL
msg_text	text	NO
msg_read	tinyint(1)	NO		0
msg_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Row count: 0

📋 Table: partner_reservations

Column	Type	Null	Key	Default	Extra
ptr_id	int	NO	PRI		auto_increment
ptr_user_id	int	NO	MUL
ptr_ical_reservation_id	int	YES	MUL
ptr_payments_id	int	YES	MUL
ptr_price	float	NO
usr_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
usr_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

📋 Table: payments

Column	Type	Null	Key	Extra
id	int	NO	PRI	auto_increment
property_id	int	YES
email	varchar(255)	NO
service	varchar(255)	NO
amount	float	NO
checkin	date	NO
checkout	date	NO
created	datetime	YES
usr_id	int	YES

Row count: 0

📋 Table: properties

Column	Type	Null	Key	Default	Extra
prp_id	int	NO	PRI		auto_increment
prp_user_id	int	NO	MUL
prp_url_path	varchar(255)	NO	UNI
prp_title	varchar(255)	NO
prp_description	text	YES
prp_property_type	enum('house','apartment','bed_and_breakfast','camper_rv','guesthouse','hotel')	YES
prp_place_type	enum('entire_place','private_room','shared_room')	YES
prp_al_number	varchar(255)	YES
prp_city_id	int	YES	MUL
prp_address	varchar(255)	YES
prp_coords	point	YES
prp_min_days	int	NO		2
prp_max_days	int	NO		30
prp_check_in_time	time	NO		11:00:00
prp_check_out_time	time	NO		16:00:00
prp_building_code	varchar(32)	YES
prp_lockbox_code	varchar(32)	YES
prp_wifi_name	varchar(128)	YES
prp_wifi_pass	varchar(128)	YES
prp_contact_info	varchar(128)	YES
prp_check_in_obs	varchar(300)	YES
prp_check_out_obs	varchar(300)	YES
prp_observation	varchar(600)	YES
prp_guests	int	YES
prp_double_beds	int	YES
prp_single_beds	int	YES
prp_bedrooms	int	YES
prp_bathrooms	int	YES
prp_wifi	tinyint(1)	YES
prp_tv	tinyint(1)	YES
prp_air_conditioning	tinyint(1)	YES
prp_kitchen	tinyint(1)	YES
prp_kitchenette	tinyint(1)	YES
prp_dishwasher	tinyint(1)	YES
prp_washer	tinyint(1)	YES
prp_free_parking	tinyint(1)	YES
prp_paid_parking	tinyint(1)	YES
prp_workspace	tinyint(1)	YES
prp_pool	tinyint(1)	YES
prp_hot_tub	tinyint(1)	YES
prp_patio	tinyint(1)	YES
prp_beach	tinyint(1)	YES
prp_smoke_alarm	tinyint(1)	YES
prp_first_aid_kit	tinyint(1)	YES
prp_fire_extinguisher	tinyint(1)	YES
prp_carbon_alarm	tinyint(1)	YES
prp_price	float	YES
prp_free_cancel	tinyint(1)	YES
prp_special_offer	float	YES
prp_rating	float	YES
prp_reviews	int	YES
prp_ical_airbnb	varchar(255)	YES
prp_ical_booking	varchar(255)	YES
prp_publish	tinyint(1)	NO		0
prp_active	tinyint(1)	NO		1
prp_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
prp_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 2

Sample Data (first 3 rows):

prp_id	prp_user_id	prp_url_path	prp_title	prp_description	prp_property_type	prp_place_type	prp_al_number	prp_city_id	prp_address	prp_coords	prp_min_days	prp_max_days	prp_check_in_time	prp_check_out_time	prp_building_code	prp_lockbox_code	prp_wifi_name	prp_wifi_pass	prp_contact_info	prp_check_in_obs	prp_check_out_obs	prp_observation	prp_guests	prp_double_beds	prp_single_beds	prp_bedrooms	prp_bathrooms	prp_wifi	prp_tv	prp_air_conditioning	prp_kitchen	prp_kitchenette	prp_dishwasher	prp_washer	prp_free_parking	prp_paid_parking	prp_workspace	prp_pool	prp_hot_tub	prp_patio	prp_beach	prp_smoke_alarm	prp_first_aid_kit	prp_fire_extinguisher	prp_carbon_alarm	prp_price	prp_free_cancel	prp_special_offer	prp_rating	prp_reviews	prp_ical_airbnb	prp_ical_booking	prp_publish	prp_active	prp_created_at	prp_updated_at
1	3	beach-house-lisbon	Beautiful Beach House in Lisbon	Stunning beachfront property with amazing ocean views	house	entire_place		1	Rua da Praia, 123		2	30	15:00:00	11:00:00	1234	5678	BeachHouse_WiFi	beach2024	+351 123 456 789	Please use the lockbox code to access the keys. The lockbox is located next to the main entrance.	Please leave the keys in the lockbox and ensure all windows are closed.	This property features a private beach access and stunning sunset views.	6			3	2		1	1	1				1		1	0		1	1					150							1	1	2025-07-20 04:11:40	2025-07-20 04:11:40
2	3	city-apartment-porto	Modern City Apartment in Porto	Contemporary apartment in the heart of Porto with all amenities	apartment	entire_place		2	Avenida da Liberdade, 456		2	30	14:00:00	10:00:00	5678	9012	PortoApartment_WiFi	porto2024	+351 987 654 321	The apartment is on the 3rd floor. Use the elevator and the lockbox code for key access.	Please return the keys to the lockbox and ensure the apartment is tidy.	Located in the historic center, walking distance to all major attractions.	4			2	1		1	1	1				0		1	0		0	0					120							1	1	2025-07-20 04:11:40	2025-07-20 04:11:40

📋 Table: property_images

Column	Type	Null	Key	Default	Extra
pri_id	int	NO	PRI		auto_increment
pri_path	varchar(255)	NO
pri_property_id	int	NO	MUL
pri_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Row count: 0

📋 Table: regions

Column	Type	Null	Key	Default	Extra
reg_id	int	NO	PRI		auto_increment
reg_name	varchar(256)	NO
reg_type	varchar(50)	NO
reg_price_t1	float	YES
reg_price_t2	float	YES
reg_price_t3	float	YES
reg_price_t4	float	YES
reg_reg_id	int	YES	MUL
reg_active	tinyint(1)	YES		1

Row count: 0

📋 Table: reservations

Column	Type	Null	Key	Extra
res_id	int	NO	PRI	auto_increment
client_id	int	NO
guest_name	varchar(64)	NO
price	float	NO
checkin	varchar(16)	NO
checkout	varchar(16)	NO
obs	varchar(512)	NO

Row count: 0

📋 Table: users

Column	Type	Null	Key	Default	Extra
user_id	int	NO	PRI		auto_increment
user_name	varchar(64)	NO
user_email	varchar(64)	NO	UNI
user_password	varchar(128)	NO
user_type	enum('Guest','Property Owner','Partner','Administrator')	NO		Guest
user_payment_obs	date	YES
user_picture	varchar(128)	NO
user_ip	varchar(32)	NO
user_system	varchar(256)	NO
created	datetime	NO
supplier	text	NO
discount	int	NO		0
credits	float	NO		0

Row count: 4

Sample Data (first 3 rows):

user_id	user_name	user_email	user_password	user_type	user_ip	user_system	created	supplier
1	John Smith	john@example.com	hashed_password	Guest	127.0.0.1	Web	2025-07-20 04:11:40	direct
2	Sarah Johnson	sarah@example.com	hashed_password	Guest	127.0.0.1	Web	2025-07-20 04:11:40	direct
3	Maria Silva	maria@example.com	hashed_password	Property Owner	127.0.0.1	Web	2025-07-20 04:11:40	direct

📋 Table: users_checkin

Column	Type	Null	Key	Default	Extra
usr_cki_id	int	NO	PRI		auto_increment
usr_cki_name	varchar(255)	YES
usr_cki_phone	varchar(255)	YES
usr_cki_phone_indicative	varchar(255)	YES
usr_cki_email	varchar(255)	YES
usr_cki_country	varchar(255)	YES
usr_cki_code	varchar(255)	NO	UNI
usr_cki_check_in	date	NO
usr_cki_check_out	date	NO
usr_cki_prp_id	int	NO	MUL
usr_cki_subscribed	tinyint(1)	NO		1
usr_cki_active	tinyint(1)	NO		1
usr_cki_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
usr_cki_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP
usr_cki_data	int	YES	MUL
usr_cki_cityTax	float	YES
payment_id	int	YES	MUL

Row count: 2

Sample Data (first 3 rows):

usr_cki_id	usr_cki_name	usr_cki_phone	usr_cki_phone_indicative	usr_cki_email	usr_cki_country	usr_cki_code	usr_cki_check_in	usr_cki_check_out	usr_cki_prp_id	usr_cki_subscribed	usr_cki_active	usr_cki_created_at	usr_cki_updated_at	usr_cki_data	usr_cki_cityTax	payment_id
1	John Smith	+1 555 123 4567	+1	john@example.com	United States	GUEST001	2024-07-25	2024-07-30	1	1	1	2025-07-20 04:11:40	2025-07-20 04:11:40		5
2	Sarah Johnson	+44 20 7946 0958	+44	sarah@example.com	United Kingdom	GUEST002	2024-07-28	2024-08-02	2	1	1	2025-07-20 04:11:40	2025-07-20 04:11:40		4.5

📋 Table: users_region

Column	Type	Null	Key	Default	Extra
usr_reg_id	int	NO	PRI		auto_increment
usr_reg_email	varchar(255)	NO
usr_reg_size	int	NO
usr_reg_1	int	YES	MUL
usr_reg_2	int	YES	MUL
usr_reg_3	int	YES	MUL
usr_created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
usr_updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Row count: 0

🎯 Bot Architecture Suggestions

Recommended Bots:

🧹 Cleaning Bot - Manages clinnco database, schedules cleanings, tracks completion
🏠 Management Bot - Manages timelystay database, handles reservations, property info
📊 Reporting Bot - Generates reports on reservations, cleanings, revenue
💬 Customer Service Bot - Answers customer questions, handles inquiries
🔧 Developer Bot - Creates/modifies code, handles system changes
📱 Notification Bot - Sends alerts, reminders, status updates

Key Questions for You:

What are the main workflows for cleaning scheduling and management?
What types of reports do you need most frequently?
What customer questions come up most often?
What integrations do you need (Airbnb, VRBO, etc.)?
What are your pain points in the current process?