Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
partner_name	varchar(100)	NO		NULL	
partner_code	varchar(50)	NO	UNI	NULL	
api_url	varchar(255)	YES		NULL	
api_key	text	YES		NULL	
username	varchar(100)	YES		NULL	
password	varchar(255)	YES		NULL	
token	text	YES		NULL	
client_id	varchar(100)	YES		NULL	
client_secret	text	YES		NULL	
preference_order	int(11)	YES	MUL	0	
priority	int(11)	YES		0	
status	enum('active','inactive')	YES	MUL	active	
remarks	text	YES		NULL	
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()
