Field	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI	NULL	auto_increment
name	varchar(255)	NO		NULL	
email	varchar(255)	NO		NULL	
mobile	varchar(15)	NO		NULL	
password	varchar(255)	YES		NULL	
address	text	YES		NULL	
pin_code	varchar(10)	NO		NULL	
user_type	enum('seller','buyer','both','')	NO		buyer	
reliability_score	int(11)	YES		0	
buyer_rating_avg	decimal(3,2)	YES		0.00	
buyer_rating_count	int(11)	YES		0	
seller_rating_avg	decimal(3,2)	YES		0.00	
seller_rating_count	int(11)	YES		0	
renter_reliability_score	int(11)	YES		0	
seller_reliability_score	int(11)	YES		0	
buyer_rent_reliability_score	decimal(3,2)	YES		0.00	
buyer_buy_reliability_score	decimal(3,2)	YES		0.00	
buyer_overall_reliability_score	decimal(3,2)	YES		0.00	
seller_rent_reliability_score	decimal(3,2)	YES		0.00	
seller_sell_reliability_score	decimal(3,2)	YES		0.00	
delivery_rental_reliability_score	decimal(3,2)	YES		0.00	
delivery_sale_reliability_score	decimal(3,2)	YES		0.00	
role	enum('buyer','seller','admin','super_admin','delivery')	YES		buyer	
is_blocked	tinyint(1)	YES		0	
bgv_cleared	tinyint(1)	NO		0	
products_uploaded_count	int(11)	YES		0	
subscription_tier	varchar(50)	YES		free	
subscription_expires_at	datetime	YES		NULL	
otp	varchar(6)	YES		NULL	
otp_expires_at	datetime	YES		NULL	
is_verified	tinyint(1)	NO		0	
created_at	datetime	YES		NULL	
updated_at	datetime	YES		NULL	
daily_posts_count	int(11)	YES		0	
weekly_posts_count	int(11)	YES		0	
monthly_posts_count	int(11)	YES		0	
last_post_date	date	YES		NULL	
posting_limit_charges_paid	decimal(10,2)	YES		0.00