Database Tables - Canaccom Travel Group Platform

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI	NULL	auto_increment
booking_id	int	NO	MUL	NULL
room_id	int	YES	MUL	NULL
communication_type	enum('email','phone','meeting','text','video_call','other')	NO	MUL	NULL
direction	enum('outbound','inbound')	NO	MUL	NULL
contact_type	enum('team','hotel','internal')	NO	MUL	NULL
contact_name	varchar(200)	YES		NULL
contact_email	varchar(255)	YES		NULL
contact_phone	varchar(20)	YES		NULL
contact_job_title	varchar(100)	YES		NULL
subject	varchar(255)	YES		NULL
message	text	YES		NULL
message_summary	text	YES		NULL
email_recipients	text	YES		NULL
email_cc	text	YES		NULL
email_bcc	text	YES		NULL
email_attachments	text	YES		NULL
call_duration	int	YES		NULL
meeting_notes	text	YES		NULL
follow_up_required	tinyint(1)	YES		0
follow_up_date	date	YES	MUL	NULL
status	enum('sent','delivered','read','failed','scheduled','completed')	YES	MUL	sent
sent_at	datetime	YES	MUL	NULL
delivered_at	datetime	YES		NULL
read_at	datetime	YES		NULL
requires_response	tinyint(1)	YES		0
response_received	tinyint(1)	YES		0
response_received_at	datetime	YES		NULL
response_notes	text	YES		NULL
priority	enum('low','normal','high','urgent')	YES	MUL	normal
category	enum('confirmation','pricing','rooming_list','special_requests','payment','emergency','general')	YES	MUL	general
internal_notes	text	YES		NULL
created_by	int	YES	MUL	NULL
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED
updated_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP