Database Tables - Canaccom Travel Group Platform

Field	Type	Null	Default	Extra
id	int	NO	0
booking_date	date	YES	NULL
event_name	varchar(255)	YES	NULL
team_id	int	NO	NULL
team_name	varchar(255)	NO	NULL
team_logo	varchar(255)	YES	NULL
team_contact_fname	varchar(100)	NO	NULL
team_contact_lname	varchar(100)	NO	NULL
team_contact_phone	varchar(20)	NO	NULL
team_contact_email	varchar(255)	NO	NULL
team_secondary_contact_fname	varchar(100)	YES	NULL
team_secondary_contact_lname	varchar(100)	YES	NULL
team_secondary_contact_email	varchar(255)	YES	NULL
team_secondary_contact_phone	varchar(20)	YES	NULL
team_tertiary_contact_fname	varchar(100)	YES	NULL
team_tertiary_contact_lname	varchar(100)	YES	NULL
team_tertiary_contact_email	varchar(255)	YES	NULL
team_tertiary_contact_phone	varchar(20)	YES	NULL
hotel_id	int	NO	NULL
commission_rate	decimal(5,2)	YES	10.00
commission_amount	decimal(10,2)	YES	NULL
commission_paid	tinyint(1)	YES	0
commission_paid_date	date	YES	NULL
arrival_date	date	NO	NULL
departure_date	date	NO	NULL
check_in_time	time	YES	16:00:00
check_out_time	time	YES	12:00:00
total_rooms	int	NO	0
nights_stay	int	YES	NULL
total_amount	decimal(12,2)	YES	NULL
special_requests	text	YES	NULL
accessibility_requirements	text	YES	NULL
status	enum('quote request','draft','pending','confirmed','cancelled','completed')	YES	draft
hotel_confirmed	tinyint(1)	YES	0
hotel_confirmation_date	datetime	YES	NULL
hotel_confirmed_by	varchar(100)	YES	NULL
hotel_confirmation_notes	text	YES	NULL
contract_sent	tinyint(1)	YES	0
contract_sent_date	datetime	YES	NULL
contract_received	tinyint(1)	YES	0
contract_received_date	datetime	YES	NULL
rooming_list_submitted	tinyint(1)	YES	0
rooming_list_submission_date	datetime	YES	NULL
stay_confirmation_sent	tinyint(1)	YES	0
stay_confirmation_date	datetime	YES	NULL
actual_guests	int	YES	NULL
actual_rooms_used	int	YES	NULL
final_amount	decimal(12,2)	YES	NULL
internal_notes	text	YES	NULL
team_notes	text	YES	NULL
hotel_notes	text	YES	NULL
created_by	int	YES	NULL
created_at	timestamp	YES	CURRENT_TIMESTAMP	DEFAULT_GENERATED
updated_at	timestamp	YES	CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Sample Data (First 20 rows)

id	booking_date	event_name	team_id	team_name	team_logo	team_contact_fname	team_contact_lname	team_contact_phone	team_contact_email	team_secondary_contact_fname	team_secondary_contact_lname	team_secondary_contact_email	team_secondary_contact_phone	team_tertiary_contact_fname	team_tertiary_contact_lname	team_tertiary_contact_email	team_tertiary_contact_phone	hotel_id	commission_rate	commission_amount	commission_paid	commission_paid_date	arrival_date	departure_date	check_in_time	check_out_time	total_rooms	nights_stay	total_amount	special_requests	accessibility_requirements	status	hotel_confirmed	hotel_confirmation_date	hotel_confirmed_by	hotel_confirmation_notes	contract_sent	contract_sent_date	contract_received	contract_received_date	rooming_list_submitted	rooming_list_submission_date	stay_confirmation_sent	stay_confirmation_date	actual_guests	actual_rooms_used	final_amount	internal_notes	team_notes	hotel_notes	created_by	created_at	updated_at
1	2025-08-25	Circle K Classic (Calgary, Alberta)	20	St. Albert Slash U18AAA	NULL	Ryan	Brady	7809063415	[email protected]					NULL	NULL	NULL	NULL	28	10.00	NULL	0	NULL	2025-12-26	2026-01-02	16:00:00	12:00:00	0	7	NULL	NULL	NULL	confirmed	0	NULL	NULL	NULL	0	NULL	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2025-08-25 04:41:47	2025-08-25 04:41:47
2	2025-08-31	Rocky Mountain Classic (Calgary)	1	CIHA U15 Prep	NULL	Moe	Jamal	4039936999	[email protected]	Jereme	Young	[email protected]	4035858155	NULL	NULL	NULL	NULL	35	10.00	NULL	0	NULL	2025-11-12	2025-11-16	16:00:00	12:00:00	0	4	NULL	NULL	NULL	confirmed	0	NULL	NULL	NULL	0	NULL	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2025-08-31 08:46:45	2025-08-31 08:46:45