Field	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI	NULL	auto_increment
product_id	int(11) unsigned	NO	MUL	NULL	
buyer_id	int(11) unsigned	NO	MUL	NULL	
seller_id	int(11) unsigned	NO	MUL	NULL	
offer_price	decimal(10,2)	NO		NULL	
rental_start_date	date	YES		NULL	
rental_end_date	date	YES		NULL	
message	text	YES		NULL	
status	enum('pending','accepted','rejected','withdrawn','negotiating')	NO		pending	
offer_type	enum('buy','rent')	YES		buy	
delivery_address	text	YES		NULL	
delivery_pin_code	varchar(20)	YES		NULL	
deposit_amount	decimal(10,2)	YES		NULL	
accepted_at	datetime	YES		NULL	
rejected_at	datetime	YES		NULL	
seller_rated_buyer	tinyint(1)	YES		0	
buyer_rated_seller	tinyint(1)	YES		0	
seller_remarks	text	YES		NULL	
can_reject_until	datetime	YES		NULL	
buyer_reliability_at_offer	decimal(3,2)	YES		NULL	
created_at	datetime	YES		NULL	
updated_at	datetime	YES		NULL	
buyer_change_count	int(10) unsigned	YES		0