Database Tables - Canaccom Travel Group Platform

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI	NULL	auto_increment
quote_request_id	int	NO		NULL
sent_at	datetime	YES		NULL
recipient	varchar(255)	NO
subject	varchar(500)	NO
body_html	longtext	YES		NULL
body_text	text	YES		NULL
email_type	varchar(100)	NO		availability_request
sent_by	int	YES		NULL
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Sample Data (First 20 rows)

id	quote_request_id	sent_at	recipient	subject	body_html	body_text	email_type	sent_by	created_at
1	1	2026-03-12 14:55:41	[email protected]	Availability & Rate Request — CIHA U18 Female (May 20–May 25, 2026)	<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Group Accommodation Request</title> </head> <body style="margin:0;padding:0;background:#f4f7fb;"> <div style="display:none;max-height:0;overflow:hidden;opacity:0;color:transparent;">Availability & Rate Request — CIHA U18 Female (May 20–May 25, 2026)</div> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#f4f7fb;"> <tr> <td align="center" style="padding:32px 16px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="max-width:640px;"> <tr> <td style="padding:0 0 16px 0;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:linear-gradient(135deg,#231f20 0%,#3276B7 100%);border-radius:20px 20px 0 0;"> <tr> <td align="center" style="padding:28px 32px;"> <img src="http://localhost:8000/images/canaccom_white.png" alt="Canaccom Travel Group" style="display:block;margin:0 auto;height:auto;max-width:140px;width:100%;border:0;"> </td> </tr> </table> </td> </tr> <tr> <td style="background:#ffffff;border-radius:0 0 20px 20px;box-shadow:0 12px 30px rgba(35,31,32,0.08);"> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%"> <tr> <td style="padding:32px 32px 12px 32px;font-family:Arial,Helvetica,sans-serif;font-size:28px;font-weight:700;line-height:1.2;color:#231f20;"> Group Accommodation Request </td> </tr> <tr> <td style="padding:0 32px 8px 32px;font-family:Arial,Helvetica,sans-serif;font-size:16px;line-height:1.6;color:#4b5563;"> </td> </tr> <tr> <td style="padding:0 32px 8px 32px;font-family:Arial,Helvetica,sans-serif;font-size:16px;line-height:1.6;color:#4b5563;"> <div style="font-family:Arial,Helvetica,sans-serif;font-size:15px;line-height:1.7;color:#374151;"><p>Dear Jason Johnson,</p><p><br></p><p>We are writing on behalf of <strong>CIHA U18 Female</strong> to request availability and rates for an upcoming group stay.</p><p><br></p><p><strong>TRIP DETAILS</strong></p><p>Arrival: May 20, 2026</p><p>Departure: May 25, 2026</p><p>Nights: 5</p><p>Rooms: 18 total</p><p><br></p><p><strong>ROOM TYPE BREAKDOWN</strong></p><p>2 Queen Beds: 15 rooms</p><p>1 King Bed: 3 rooms</p><p><br></p><p><strong>AMENITIES REQUIRED</strong></p><p>Breakfast Included, Equipment Storage, Meeting Room</p><p><br></p><p><strong>ADDITIONAL REQUESTS</strong></p><p>Thank you for your time</p><p><br></p><p><strong>Commissionable rates (12.00%)</strong></p><p><br></p><p>Can you please advise if you have the availability and what commissionable (12.00%) rates you are able to offer.</p><p><br></p><p>Thank you in advance for your assistance. I look forward to your response.</p><p><br></p><p>Warmest Regards,</p><p><br></p><p>Jason Johnson</p><p>Group Travel Advisor</p><p>The Canaccom Team</p><p>CANACCOM - Group Travel</p><p>Phone: 403-338-0959</p><p>Toll Free: 888-699-8886</p><p>Email: <a href="mailto:[email protected]">[email protected]</a></p><p>Website: <a href="https://www.canaccom.com">www.canaccom.com</a></p></div> </td> </tr> <tr> <td style="padding:20px 32px 8px 32px;font-family:Arial,Helvetica,sans-serif;font-size:13px;line-height:1.6;color:#6b7280;"> If the button does not work, copy and paste this link into your browser:<br> <a href="" style="color:#3276B7;text-decoration:underline;word-break:break-all;"></a> </td> </tr> <tr> <td style="padding:20px 32px 32px 32px;border-top:1px solid #e5e7eb;font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:1.6;color:#6b7280;"> Canaccom Travel Group \| 403-338-0959 \| [email protected]<br> Canaccom Travel Group </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </body> </html>	Group Accommodation Request Dear Jason Johnson, We are writing on behalf of CIHA U18 Female to request availability and rates for an upcoming group stay. TRIP DETAILS Arrival: May 20, 2026 Departure: May 25, 2026 Nights: 5 Rooms: 18 total ROOM TYPE BREAKDOWN 2 Queen Beds: 15 rooms 1 King Bed: 3 rooms AMENITIES REQUIRED Breakfast Included, Equipment Storage, Meeting Room ADDITIONAL REQUESTS Thank you for your time Commissionable rates (12.00%) Can you please advise if you have the availability and what commissionable (12.00%) rates you are able to offer. Thank you in advance for your assistance. I look forward to your response. Warmest Regards, Jason Johnson Group Travel Advisor The Canaccom Team CANACCOM - Group Travel Phone: 403-338-0959 Toll Free: 888-699-8886 Email: [email protected] Website: www.canaccom.com Canaccom Travel Group \| 403-338-0959 \| [email protected] Canaccom Travel Group	availability_request	0	2026-03-12 07:55:41
2	1	2026-03-12 15:30:39	[email protected]	Availability & Rate Request — CIHA U18 Female (May 20–May 25, 2026)	<p>Dear Jason Johnson,</p><p><br></p><p>We are writing on behalf of <strong>CIHA U18 Female</strong> to request availability and rates for an upcoming group stay.</p><p><br></p><p><strong>TRIP DETAILS</strong></p><p>Arrival: May 20, 2026</p><p>Departure: May 25, 2026</p><p>Nights: 5</p><p>Rooms: 18 total</p><p><br></p><p><strong>ROOM TYPE BREAKDOWN</strong></p><p>2 Queen Beds: 15 rooms</p><p>1 King Bed: 3 rooms</p><p><br></p><p><strong>AMENITIES REQUIRED</strong></p><p>Breakfast Included, Equipment Storage, Meeting Room</p><p><br></p><p><strong>ADDITIONAL REQUESTS</strong></p><p>Thank you for your time</p><p><br></p><p><strong>Commissionable rates (12.00%)</strong></p><p><br></p><p>Can you please advise if you have the availability and what commissionable (12.00%) rates you are able to offer.</p><p><br></p><p>Thank you in advance for your assistance. I look forward to your response.</p><p><br></p><p>Warmest Regards,</p><p><br></p><p>Jason Johnson</p><p>Group Travel Advisor</p><p>The Canaccom Team</p><p>CANACCOM - Group Travel</p><p>Phone: 403-338-0959</p><p>Toll Free: 888-699-8886</p><p>Email: <a href="mailto:[email protected]">[email protected]</a></p><p>Website: <a href="https://www.canaccom.com">www.canaccom.com</a></p>	Dear Jason Johnson, We are writing on behalf of CIHA U18 Female to request availability and rates for an upcoming group stay. TRIP DETAILS Arrival: May 20, 2026 Departure: May 25, 2026 Nights: 5 Rooms: 18 total ROOM TYPE BREAKDOWN 2 Queen Beds: 15 rooms 1 King Bed: 3 rooms AMENITIES REQUIRED Breakfast Included, Equipment Storage, Meeting Room ADDITIONAL REQUESTS Thank you for your time Commissionable rates (12.00%) Can you please advise if you have the availability and what commissionable (12.00%) rates you are able to offer. Thank you in advance for your assistance. I look forward to your response. Warmest Regards, Jason Johnson Group Travel Advisor The Canaccom Team CANACCOM - Group Travel Phone: 403-338-0959 Toll Free: 888-699-8886 Email: [email protected] Website: www.canaccom.com	availability_request	0	2026-03-12 08:30:39