TripTales Elite Check Panel

Live diagnostics • system explorer • real website data

Server Elements File View Database

Database Structure

Table: admins

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
username	varchar(100)	YES	UNI
password	varchar(255)	YES
created_at	timestamp	YES		current_timestamp()

Table: bucket_list

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
post_id	int(11)	NO
created_at	timestamp	YES		current_timestamp()

Table: bucketlist

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
post_id	int(11)	NO
created_at	timestamp	YES		current_timestamp()

Table: comment_likes

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
comment_id	int(11)	NO	MUL
user_id	int(11)	NO

Table: comments

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
post_id	int(11)	NO	MUL
user_id	int(11)	NO	MUL
comment	text	NO
created_at	timestamp	YES		current_timestamp()

Table: conversations

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_one	int(11)	NO	MUL
user_two	int(11)	NO
created_at	timestamp	YES		current_timestamp()

Table: follows

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
follower_id	int(11)	NO	MUL
following_id	int(11)	NO	MUL
created_at	timestamp	YES		current_timestamp()

Table: location_activities

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO
activity_name	varchar(150)	NO
activity_price	decimal(10,2)	NO
created_at	timestamp	YES		current_timestamp()

Table: location_details

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO	MUL
to_do	text	YES
to_see	text	YES
to_eat	text	YES
created_at	timestamp	YES		current_timestamp()

Table: location_food_budget

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO	MUL
food_type	enum('budget','standard','luxury')	NO
price_per_day	decimal(10,2)	NO

Table: location_gallery

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO	MUL
image_path	varchar(255)	NO
created_at	timestamp	YES		current_timestamp()

Table: location_hotels

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO
budget_type	enum('low','medium','high')	NO
hotel_name	varchar(150)	NO
hotel_price	decimal(10,2)	NO
created_at	timestamp	YES		current_timestamp()

Table: location_nearby

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO
nearby_location_id	int(11)	NO
created_at	timestamp	YES		current_timestamp()

Table: location_reviews

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO	MUL
user_id	int(11)	NO	MUL
rating	decimal(2,1)	YES
review_text	text	YES
created_at	timestamp	YES		current_timestamp()
reviewer_name	varchar(100)	YES

Table: location_stays

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO	MUL
stay_type	enum('budget','standard','luxury')	NO
hotel_name	varchar(150)	NO
price_per_night	decimal(10,2)	NO
created_at	timestamp	YES		current_timestamp()

Table: location_transport

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO	MUL
mode	varchar(100)	NO
price	decimal(10,2)	NO
is_local	tinyint(1)	YES		0

Table: location_trip_budget

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
location_id	int(11)	NO	MUL
days	int(11)	NO
estimated_budget	decimal(10,2)	NO

Table: locations

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
name	varchar(100)	NO
state	varchar(100)	NO
cover_image	varchar(255)	NO
short_description	varchar(5000)	YES
base_food_per_day	int(11)	YES		0
base_stay_per_day	int(11)	YES		0
local_transport_per_day	int(11)	YES		0
status	enum('active','hidden')	YES		active
created_at	timestamp	YES		current_timestamp()
best_time	varchar(100)	YES
ideal_days	int(11)	YES
vibe	varchar(100)	YES
avg_rating	decimal(2,1)	YES		0.0

Table: messages

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
sender_id	int(11)	NO
receiver_id	int(11)	NO
message	text	NO
created_at	timestamp	YES		current_timestamp()

Table: notifications

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
actor_id	int(11)	NO	MUL
type	enum('like','follow')	NO
post_id	int(11)	YES	MUL
is_read	tinyint(1)	YES		0
created_at	timestamp	YES		current_timestamp()

Table: post_comments

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
post_id	int(11)	NO
user_id	int(11)	NO
comment	text	NO
created_at	timestamp	YES		current_timestamp()
likes	int(11)	YES		0
pinned	tinyint(1)	YES		0

Table: post_likes

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
post_id	int(11)	NO	MUL
created_at	timestamp	YES		current_timestamp()

Table: posts

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO	MUL
image	varchar(255)	NO
media	text	YES
caption	text	YES
tags	varchar(255)	YES
location	varchar(100)	YES
created_at	timestamp	YES		current_timestamp()

Table: reports

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
post_id	int(11)	NO	MUL
reported_by	int(11)	NO	MUL
reason	varchar(255)	YES
status	enum('pending','reviewed','resolved')	YES		pending
created_at	timestamp	YES		current_timestamp()

Table: review_images

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
review_id	int(11)	YES	MUL
image_path	varchar(255)	YES

Table: sidebar_widgets

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
type	enum('trending','unexplored')	NO
title	varchar(100)	NO
content	text	NO
created_at	timestamp	YES		current_timestamp()

Table: user_follows

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
follower_id	int(11)	NO	MUL
following_id	int(11)	NO
created_at	timestamp	YES		current_timestamp()

Table: users

Column	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI		auto_increment
email	varchar(255)	NO	UNI
password	varchar(255)	NO
created_at	timestamp	YES		current_timestamp()
full_name	varchar(100)	YES
mobile	varchar(20)	YES
username	varchar(50)	YES	UNI
traveler_type	varchar(255)	YES
budget_style	varchar(20)	YES
profile_pic	varchar(255)	YES
bio	varchar(150)	YES
state	varchar(100)	YES
status	enum('active','banned','frozen')	YES		active
banned_at	datetime	YES
theme	tinyint(1)	YES		0
dnd	tinyint(1)	YES		0
newsletter	tinyint(1)	YES		1