Database Tables - Canaccom Travel Group Platform

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI	NULL	auto_increment
request_type	enum('hotel_contact','team_contact')	NO	MUL	NULL
entity_id	int	NO		NULL
booking_id	int	YES	MUL	NULL
contact_position	enum('contact_1','contact_2','contact_3','primary','secondary','tertiary')	NO		NULL
old_name	varchar(200)	YES		NULL
old_title	varchar(100)	YES		NULL
old_email	varchar(255)	YES		NULL
old_phone	varchar(20)	YES		NULL
new_name	varchar(200)	YES		NULL
new_title	varchar(100)	YES		NULL
new_email	varchar(255)	YES		NULL
new_phone	varchar(20)	YES		NULL
status	enum('pending','approved_master','approved_booking_only','rejected')	YES	MUL	pending
decision_reason	text	YES		NULL
requested_by	int	YES	MUL	NULL
requested_at	timestamp	YES	MUL	CURRENT_TIMESTAMP	DEFAULT_GENERATED
decided_by	int	YES	MUL	NULL
decided_at	timestamp	YES		NULL
is_significant_change	tinyint(1)	YES		0
is_minor_change	tinyint(1)	YES		0
confidence_score	decimal(3,2)	YES		0.00
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED
updated_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP