Database Tables - Canaccom Travel Group Platform

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI	NULL	auto_increment
booking_date	date	YES	MUL	NULL
event_name	varchar(255)	YES		NULL
event_id	int	YES		NULL
team_id	int	NO	MUL	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	MUL	NULL
commission_rate	decimal(5,2)	YES		10.00
commission_amount	decimal(10,2)	YES		NULL
commission_paid	tinyint(1)	YES	MUL	0
commission_paid_date	date	YES		NULL
arrival_date	date	NO	MUL	NULL
departure_date	date	NO	MUL	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	MUL	draft
hotel_confirmed	tinyint(1)	YES	MUL	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	MUL	0
contract_sent_date	datetime	YES		NULL
contract_received	tinyint(1)	YES	MUL	0
contract_received_date	datetime	YES		NULL
rooming_list_submitted	tinyint(1)	YES	MUL	0
rooming_list_submission_date	datetime	YES		NULL
stay_confirmation_sent	tinyint(1)	YES	MUL	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	MUL	NULL
created_at	timestamp	YES	MUL	CURRENT_TIMESTAMP	DEFAULT_GENERATED
updated_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP
team_options_token	varchar(64)	YES	UNI	NULL
team_options_sent_at	datetime	YES		NULL
team_options_submitted_at	datetime	YES		NULL
team_selected_hotel_id	int	YES		NULL
team_selection_comments	text	YES		NULL
block_booking_id	int	YES		NULL
rooming_list_hotel_sync_required	tinyint(1)	NO		0
rooming_list_hotel_last_sent_at	datetime	YES		NULL
rooming_list_last_updated_at	datetime	YES		NULL
team_code_of_conduct_acknowledged_at	datetime	YES		NULL
team_code_of_conduct_acknowledged_by	varchar(255)	YES		NULL
team_code_of_conduct_ack_source	varchar(64)	YES		NULL
season_label	varchar(32)	YES		NULL

Sample Data (First 20 rows)

id	booking_date	event_name	event_id	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	team_options_token	team_options_sent_at	team_options_submitted_at	team_selected_hotel_id	team_selection_comments	block_booking_id	rooming_list_hotel_sync_required	rooming_list_hotel_last_sent_at	rooming_list_last_updated_at	team_code_of_conduct_acknowledged_at	team_code_of_conduct_acknowledged_by	team_code_of_conduct_ack_source	season_label
8	2026-06-25		NULL	51	CIHA U18 Female	NULL	Jason	Johnson	4037719054	[email protected]					NULL	NULL	NULL	NULL	110	10.00	NULL	0	NULL	2026-07-17	2026-07-19	16:00:00	12:00:00	0	2	NULL	NULL	NULL	confirmed	0	NULL	NULL	NULL	0	NULL	0	NULL	1	2026-06-25 08:32:50	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-06-25 08:25:39	2026-06-25 08:58:57	772c58255fe5d6445b83642eb43bd0bd53fe69551425b87df0639a0e021be8ff	2026-06-25 08:26:12	2026-06-25 08:27:54	15	NULL	NULL	0	2026-06-25 08:58:57	2026-06-25 08:50:26	2026-06-25 08:31:02	[email protected]	rooming_list_modal	NULL
9	2026-06-25	2026 Hockey Calgary Thanksgiving Classic	7	51	CIHA U18 Female	NULL	Jason	Johnson	4037719054	[email protected]					NULL	NULL	NULL	NULL	110	10.00	NULL	0	NULL	2026-11-12	2026-11-15	16:00:00	12:00:00	0	3	NULL	NULL	NULL	confirmed	0	NULL	NULL	NULL	0	NULL	0	NULL	1	2026-06-25 10:19:18	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-06-25 10:07:23	2026-06-25 11:40:58	36a6e533125f7457fb810c65f73ac6b8c0ca306f29cdd51f5a65de897b3812c7	2026-06-25 10:08:32	2026-06-25 10:10:51	17	NULL	NULL	0	2026-06-25 11:40:58	2026-06-25 10:48:30	NULL	NULL	NULL	NULL