Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
branch_id	int(11)	NO	MUL	NULL	
client_name	varchar(200)	NO		NULL	
contact_no	varchar(20)	NO		NULL	
email	varchar(150)	YES		NULL	
gst_number	varchar(50)	YES		NULL	
address	text	NO		NULL	
location	varchar(100)	YES		NULL	
city	varchar(100)	YES		NULL	
state	varchar(100)	YES		NULL	
pincode	varchar(20)	YES		NULL	
client_logo	varchar(255)	YES		NULL	
commission_percentage	decimal(10,2)	YES		0.00	
cod_amount	decimal(10,2)	YES		0.00	
cod_percentage	decimal(10,2)	YES		0.00	
min_cod_amount	decimal(10,2)	YES		0.00	
status	enum('active','inactive')	YES	MUL	active	
created_by	int(11)	YES		NULL	
created_at	timestamp	NO		current_timestamp()	
updated_by	int(11)	YES		NULL	
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
