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
sent_at	datetime	NO	MUL	CURRENT_TIMESTAMP	DEFAULT_GENERATED
recipient	varchar(320)	NO		NULL
subject	varchar(500)	NO		NULL
body_html	mediumtext	YES		NULL
body_text	text	YES		NULL
email_type	varchar(80)	NO		adhoc
sent_by	varchar(255)	YES		NULL

Sample Data (First 20 rows)

id	booking_id	sent_at	recipient	subject	body_html	body_text	email_type	sent_by
1	3	2026-03-13 06:13:24	[email protected]	Rooming List Request - CIHA U18 Female	<!DOCTYPE html> <html lang="en" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Rooming List Request</title> <!--[if mso]> <noscript> <xml><o:OfficeDocumentSettings><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml> </noscript> <![endif]--> <style> /* Reset Quill paragraph spacing for email */ .email-body p { margin: 0 0 12px 0 !important; padding: 0 !important; } .email-body p:last-child { margin-bottom: 0 !important; } a { color: #3276B7; } </style> </head> <body style="margin:0;padding:0;background:#f4f7fb;-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%;"> <div style="display:none;max-height:0;overflow:hidden;opacity:0;color:transparent;">Complete your Canaccom rooming list request using the secure link inside.</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="600" style="max-width:600px;"> <!-- HEADER with VML gradient fallback for Outlook --> <tr> <td style="padding:0;"> <!--[if mso]> <v:rect xmlns:v="urn:schemas-microsoft-com:vml" fill="true" stroke="false" style="width:600px;height:100px;mso-position-horizontal:center;"> <v:fill type="gradient" color="#231f20" color2="#3276B7" angle="45"/> <v:textbox inset="0,0,0,0"> <![endif]--> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#231f20;background:linear-gradient(135deg,#231f20 0%,#3276B7 100%);"> <tr> <td align="center" style="padding:28px 32px;"> <img src="http://localhost:8000/images/canaccom_white.png" alt="Canaccom Travel Group" width="140" height="auto" style="display:block;margin:0 auto;height:auto;width:140px;max-width:140px;border:0;outline:none;text-decoration:none;"> </td> </tr> </table> <!--[if mso]> </v:textbox> </v:rect> <![endif]--> </td> </tr> <!-- BODY --> <tr> <td style="background:#ffffff;"> <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:26px;font-weight:700;line-height:1.2;color:#231f20;"> Rooming List Request </td> </tr> <tr> <td style="padding:0 32px 16px 32px;font-family:Arial,Helvetica,sans-serif;font-size:15px;line-height:1.7;color:#374151;" class="email-body"> <div style="margin:0 0 16px 0;"><p>Hello Jason Johnson,</p><p>Please complete the rooming list for <strong>CIHA U18 Female</strong>.</p><p>Use the secure link provided to submit guest names and any rooming notes for each room.</p><p>This link expires in 5 days. If you need a new link, please contact your Canaccom representative.</p></div> </td> </tr> <tr> <td style="padding:4px 32px 16px 32px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#f4f7fb;border-left:4px solid #3276B7;"> <tr> <td style="padding:16px 20px;font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:1.7;color:#231f20;"> <p style="margin:0 0 10px 0;font-weight:700;font-size:13px;text-transform:uppercase;letter-spacing:0.05em;color:#3276B7;">Trip Details</p><table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Event</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Circle K Classic (Calgary, Alberta)</td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;vertical-align:top;">Hotel</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Best Western Plus Calgary Centre Inn<br><span style="font-weight:400;color:#6b7280;">3630 Macleod Trail South, Calgary, AB T2G 2P9, Canada, AB, Canada</span></td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Check-in</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Wednesday, April 22, 2026 at 4:00 PM</td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Check-out</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Monday, April 27, 2026 at 12:00 PM</td></tr><tr><td style="padding:6px 0 2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;vertical-align:top;border-top:1px solid #e5e7eb;">Rooms</td><td style="padding:6px 0 2px 0;font-weight:700;font-size:13px;border-top:1px solid #e5e7eb;">17 rooms<br><span style="font-weight:400;color:#6b7280;">2× 1_king, 15× 2_queens</span></td></tr></table> </td> </tr> </table> </td> </tr> <tr> <td style="padding: 8px 32px 0 32px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0"> <tr> <td style="border-radius: 10px; background: #3276B7;"> <a href="http://localhost:8000/rooming-list.php?token=34f6612cb7f68e9d337f2ea760e536112290ca67ed848353cd1f51aed0ff130c" style="display:inline-block;padding:16px 28px;font-family:Arial,Helvetica,sans-serif;font-size:16px;font-weight:700;line-height:1.2;color:#ffffff;text-decoration:none;border-radius:10px;background:#3276B7;"> Submit Rooming List </a> </td> </tr> </table> </td> </tr> <tr> <td style="padding:12px 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="http://localhost:8000/rooming-list.php?token=34f6612cb7f68e9d337f2ea760e536112290ca67ed848353cd1f51aed0ff130c" style="color:#3276B7;text-decoration:underline;word-break:break-all;">http://localhost:8000/rooming-list.php?token=34f6612cb7f68e9d337f2ea760e536112290ca67ed848353cd1f51aed0ff130c</a> </td> </tr> <tr> <td style="padding:20px 32px 28px 32px;border-top:1px solid #e5e7eb;font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:1.6;color:#6b7280;"> This secure link expires in 5 days. If you need a fresh link, please contact your Canaccom representative. </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </body> </html>	Rooming List Request Hello Jason Johnson, Please complete the rooming list for CIHA U18 Female. Use the secure link provided to submit guest names and any rooming notes for each room. This link expires in 5 days. If you need a new link, please contact your Canaccom representative. --- Trip Details --- Event: Circle K Classic (Calgary, Alberta) Hotel: Best Western Plus Calgary Centre Inn, 3630 Macleod Trail South, Calgary, AB T2G 2P9, Canada, AB, Canada Check-in: Wednesday, April 22, 2026 at 4:00 PM Check-out: Monday, April 27, 2026 at 12:00 PM Rooms: 17 total (2× 1_king, 15× 2_queens) Submit Rooming List: http://localhost:8000/rooming-list.php?token=34f6612cb7f68e9d337f2ea760e536112290ca67ed848353cd1f51aed0ff130c This secure link expires in 5 days. If you need a fresh link, please contact your Canaccom representative. Canaccom Travel Group	rooming_list_request	NULL
2	4	2026-03-17 22:42:43	[email protected]	Rooming List Request - CIHA U18 Female	<!DOCTYPE html> <html lang="en" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Rooming List Request</title> <!--[if mso]> <noscript> <xml><o:OfficeDocumentSettings><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml> </noscript> <![endif]--> <style> /* Reset Quill paragraph spacing for email */ .email-body p { margin: 0 0 12px 0 !important; padding: 0 !important; } .email-body p:last-child { margin-bottom: 0 !important; } a { color: #3276B7; } </style> </head> <body style="margin:0;padding:0;background:#f4f7fb;-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%;"> <div style="display:none;max-height:0;overflow:hidden;opacity:0;color:transparent;">Complete your Canaccom rooming list request using the secure link inside.</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="600" style="max-width:600px;"> <!-- HEADER with VML gradient fallback for Outlook --> <tr> <td style="padding:0;"> <!--[if mso]> <v:rect xmlns:v="urn:schemas-microsoft-com:vml" fill="true" stroke="false" style="width:600px;height:100px;mso-position-horizontal:center;"> <v:fill type="gradient" color="#231f20" color2="#3276B7" angle="45"/> <v:textbox inset="0,0,0,0"> <![endif]--> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#231f20;background:linear-gradient(135deg,#231f20 0%,#3276B7 100%);"> <tr> <td align="center" style="padding:28px 32px;"> <img src="http://localhost:8000/images/canaccom_white.png" alt="Canaccom Travel Group" width="140" height="auto" style="display:block;margin:0 auto;height:auto;width:140px;max-width:140px;border:0;outline:none;text-decoration:none;"> </td> </tr> </table> <!--[if mso]> </v:textbox> </v:rect> <![endif]--> </td> </tr> <!-- BODY --> <tr> <td style="background:#ffffff;"> <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:26px;font-weight:700;line-height:1.2;color:#231f20;"> Rooming List Request </td> </tr> <tr> <td style="padding:0 32px 16px 32px;font-family:Arial,Helvetica,sans-serif;font-size:15px;line-height:1.7;color:#374151;" class="email-body"> <div style="margin:0 0 16px 0;"><p>Hello Jason Johnson,</p><p>Please complete the rooming list for <strong>CIHA U18 Female</strong>.</p><p>Use the secure link provided to submit guest names and any rooming notes for each room.</p><p>This link expires in 5 days. If you need a new link, please contact your Canaccom representative.</p></div> </td> </tr> <tr> <td style="padding:4px 32px 16px 32px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#f4f7fb;border-left:4px solid #3276B7;"> <tr> <td style="padding:16px 20px;font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:1.7;color:#231f20;"> <p style="margin:0 0 10px 0;font-weight:700;font-size:13px;text-transform:uppercase;letter-spacing:0.05em;color:#3276B7;">Trip Details</p><table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Event</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Alley-Oop Basketball Tournament</td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;vertical-align:top;">Hotel</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Element Calgary Downtown<br><span style="font-weight:400;color:#6b7280;">833 4 Ave SW, Calgary, AB T2P 3T5, Canada, Calgary, Canada, Calgary, Canada</span></td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Check-in</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Friday, June 19, 2026 at 4:00 PM</td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Check-out</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Sunday, June 21, 2026 at 12:00 PM</td></tr><tr><td style="padding:6px 0 2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;vertical-align:top;border-top:1px solid #e5e7eb;">Rooms</td><td style="padding:6px 0 2px 0;font-weight:700;font-size:13px;border-top:1px solid #e5e7eb;">14 rooms<br><span style="font-weight:400;color:#6b7280;">2× 1 King, 12× 2 Queens</span></td></tr></table> </td> </tr> </table> </td> </tr> <tr> <td style="padding: 8px 32px 0 32px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0"> <tr> <td> <!--[if mso]> <v:roundrect xmlns:v="urn:schemas-microsoft-com:vml" href="http://localhost:8000/rooming-list.php?token=b7599afdb0311d92c684158808928ca74618c1da80a5c824a5082bfceb61b5cb" style="height:52px;v-text-anchor:middle;width:260px;" arcsize="10%" stroke="f" fillcolor="#3276B7"> <w:anchorlock/> <center style="color:#ffffff;font-family:Arial,Helvetica,sans-serif;font-size:16px;font-weight:700;"> Submit Rooming List </center> </v:roundrect> <![endif]--> <!--[if !mso]><!-- --> <a href="http://localhost:8000/rooming-list.php?token=b7599afdb0311d92c684158808928ca74618c1da80a5c824a5082bfceb61b5cb" style="display:inline-block;padding:16px 28px;font-family:Arial,Helvetica,sans-serif;font-size:16px;font-weight:700;line-height:1.2;color:#ffffff;text-decoration:none;border-radius:10px;background:#3276B7;"> Submit Rooming List </a> <!--<![endif]--> </td> </tr> </table> </td> </tr> <tr> <td style="padding:12px 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="http://localhost:8000/rooming-list.php?token=b7599afdb0311d92c684158808928ca74618c1da80a5c824a5082bfceb61b5cb" style="color:#3276B7;text-decoration:underline;word-break:break-all;">http://localhost:8000/rooming-list.php?token=b7599afdb0311d92c684158808928ca74618c1da80a5c824a5082bfceb61b5cb</a> </td> </tr> <tr> <td style="padding:20px 32px 12px 32px;border-top:1px solid #e5e7eb;font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:1.6;color:#6b7280;"> This secure link expires in 5 days. If you need a fresh link, please contact your Canaccom representative. </td> </tr> <tr> <td style="padding:0 32px 28px 32px;font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:1.8;color:#6b7280;"> Phone: 403-338-0959  \|  Toll Free: 888-699-8886<br> Email: <a href="mailto:[email protected]" style="color:#3276B7;text-decoration:none;">[email protected]</a>  \|  Website: <a href="https://www.canaccom.com" style="color:#3276B7;text-decoration:none;">www.canaccom.com</a> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </body> </html>	Rooming List Request Hello Jason Johnson, Please complete the rooming list for CIHA U18 Female. Use the secure link provided to submit guest names and any rooming notes for each room. This link expires in 5 days. If you need a new link, please contact your Canaccom representative. --- Trip Details --- Event: Alley-Oop Basketball Tournament Hotel: Element Calgary Downtown, 833 4 Ave SW, Calgary, AB T2P 3T5, Canada, Calgary, Canada, Calgary, Canada Check-in: Friday, June 19, 2026 at 4:00 PM Check-out: Sunday, June 21, 2026 at 12:00 PM Rooms: 14 total (2× 1 King, 12× 2 Queens) Submit Rooming List: http://localhost:8000/rooming-list.php?token=b7599afdb0311d92c684158808928ca74618c1da80a5c824a5082bfceb61b5cb This secure link expires in 5 days. If you need a fresh link, please contact your Canaccom representative. Phone: 403-338-0959 \| Toll Free: 888-699-8886 Email: [email protected] \| Website: www.canaccom.com	rooming_list_request	NULL
3	5	2026-03-18 15:50:01	[email protected]	Your Hotel Options — CIHA U18 Female	<p>Hi Jason,</p><p><br></p><p>We are pleased to share your hotel options for the upcoming group stay.</p><p><br></p><p><strong>Stay Dates:</strong> August 13, 2026 – August 16, 2026</p><p><br></p><p>Please click the button below to review the available hotels, including room details and pricing. You will be able to select your preferred option and leave any comments for our team.</p><p><br></p><p>If you have any questions, please don't hesitate to reach out.</p><p><br></p><p>Warmest Regards,</p><p>Jason Johnson</p><p>Group Travel Advisor</p><p>CANACCOM - Group Travel</p><p>Phone: 403-338-0959 \| Toll Free: 888-699-8886</p><p>Email: <a href="mailto:[email protected]">[email protected]</a></p>	Hi Jason,We are pleased to share your hotel options for the upcoming group stay.Stay Dates: August 13, 2026 – August 16, 2026Please click the button below to review the available hotels, including room details and pricing. You will be able to select your preferred option and leave any comments for our team.If you have any questions, please don't hesitate to reach out.Warmest Regards,Jason JohnsonGroup Travel AdvisorCANACCOM - Group TravelPhone: 403-338-0959 \| Toll Free: 888-699-8886Email: [email protected]	team_options_sent	Jason Johnson
4	3	2026-03-18 16:57:34	[email protected]	Rooming List Request - CIHA U18 Female	<!DOCTYPE html> <html lang="en" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Rooming List Request</title> <!--[if mso]> <noscript> <xml><o:OfficeDocumentSettings><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml> </noscript> <![endif]--> <style> /* Reset Quill paragraph spacing for email */ .email-body p { margin: 0 0 12px 0 !important; padding: 0 !important; } .email-body p:last-child { margin-bottom: 0 !important; } a { color: #3276B7; } </style> </head> <body style="margin:0;padding:0;background:#f4f7fb;-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%;"> <div style="display:none;max-height:0;overflow:hidden;opacity:0;color:transparent;">Complete your Canaccom rooming list request using the secure link inside.</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="600" style="max-width:600px;"> <!-- HEADER with VML gradient fallback for Outlook --> <tr> <td style="padding:0;"> <!--[if mso]> <v:rect xmlns:v="urn:schemas-microsoft-com:vml" fill="true" stroke="false" style="width:600px;height:100px;mso-position-horizontal:center;"> <v:fill type="gradient" color="#231f20" color2="#3276B7" angle="45"/> <v:textbox inset="0,0,0,0"> <![endif]--> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#231f20;background:linear-gradient(135deg,#231f20 0%,#3276B7 100%);"> <tr> <td align="center" style="padding:28px 32px;"> <img src="https://canaccomconnect.com/images/canaccom_white.png" alt="Canaccom Travel Group" width="140" height="auto" style="display:block;margin:0 auto;height:auto;width:140px;max-width:140px;border:0;outline:none;text-decoration:none;"> </td> </tr> </table> <!--[if mso]> </v:textbox> </v:rect> <![endif]--> </td> </tr> <!-- BODY --> <tr> <td style="background:#ffffff;"> <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:26px;font-weight:700;line-height:1.2;color:#231f20;"> Rooming List Request </td> </tr> <tr> <td style="padding:0 32px 16px 32px;font-family:Arial,Helvetica,sans-serif;font-size:15px;line-height:1.7;color:#374151;" class="email-body"> <div style="margin:0 0 16px 0;"><p>Hello Jason Johnson,</p><p>Please complete the rooming list for <strong>CIHA U18 Female</strong>.</p><p>Use the secure link provided to submit guest names and any rooming notes for each room.</p><p>This link expires in 5 days. If you need a new link, please contact your Canaccom representative.</p></div> </td> </tr> <tr> <td style="padding:4px 32px 16px 32px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#f4f7fb;border-left:4px solid #3276B7;"> <tr> <td style="padding:16px 20px;font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:1.7;color:#231f20;"> <p style="margin:0 0 10px 0;font-weight:700;font-size:13px;text-transform:uppercase;letter-spacing:0.05em;color:#3276B7;">Trip Details</p><table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Event</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Circle K Classic (Calgary, Alberta)</td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;vertical-align:top;">Hotel</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Best Western Plus Calgary Centre Inn<br><span style="font-weight:400;color:#6b7280;">3630 Macleod Trail South, Calgary, AB T2G 2P9, Canada, AB, Canada</span></td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Check-in</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Wednesday, April 22, 2026 at 4:00 PM</td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Check-out</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Monday, April 27, 2026 at 12:00 PM</td></tr><tr><td style="padding:6px 0 2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;vertical-align:top;border-top:1px solid #e5e7eb;">Rooms</td><td style="padding:6px 0 2px 0;font-weight:700;font-size:13px;border-top:1px solid #e5e7eb;">17 rooms<br><span style="font-weight:400;color:#6b7280;">2× 1 King, 15× 2 Queens</span></td></tr></table> </td> </tr> </table> </td> </tr> <tr> <td style="padding: 8px 32px 0 32px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0"> <tr> <td> <!--[if mso]> <v:roundrect xmlns:v="urn:schemas-microsoft-com:vml" href="https://canaccomconnect.com/rooming-list.php?token=960b896a1468c56f19ad22cc698b9754fb56db6e3f9c979ddf53a3a30a2f3962" style="height:52px;v-text-anchor:middle;width:260px;" arcsize="10%" stroke="f" fillcolor="#3276B7"> <w:anchorlock/> <center style="color:#ffffff;font-family:Arial,Helvetica,sans-serif;font-size:16px;font-weight:700;"> Submit Rooming List </center> </v:roundrect> <![endif]--> <!--[if !mso]><!-- --> <a href="https://canaccomconnect.com/rooming-list.php?token=960b896a1468c56f19ad22cc698b9754fb56db6e3f9c979ddf53a3a30a2f3962" style="display:inline-block;padding:16px 28px;font-family:Arial,Helvetica,sans-serif;font-size:16px;font-weight:700;line-height:1.2;color:#ffffff;text-decoration:none;border-radius:10px;background:#3276B7;"> Submit Rooming List </a> <!--<![endif]--> </td> </tr> </table> </td> </tr> <tr> <td style="padding:12px 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="https://canaccomconnect.com/rooming-list.php?token=960b896a1468c56f19ad22cc698b9754fb56db6e3f9c979ddf53a3a30a2f3962" style="color:#3276B7;text-decoration:underline;word-break:break-all;">https://canaccomconnect.com/rooming-list.php?token=960b896a1468c56f19ad22cc698b9754fb56db6e3f9c979ddf53a3a30a2f3962</a> </td> </tr> <tr> <td style="padding:20px 32px 12px 32px;border-top:1px solid #e5e7eb;font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:1.6;color:#6b7280;"> This secure link expires in 5 days. If you need a fresh link, please contact your Canaccom representative. </td> </tr> <tr> <td style="padding:0 32px 28px 32px;font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:1.8;color:#6b7280;"> Phone: 403-338-0959  \|  Toll Free: 888-699-8886<br> Email: <a href="mailto:[email protected]" style="color:#3276B7;text-decoration:none;">[email protected]</a>  \|  Website: <a href="https://www.canaccom.com" style="color:#3276B7;text-decoration:none;">www.canaccom.com</a> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </body> </html>	Rooming List Request Hello Jason Johnson, Please complete the rooming list for CIHA U18 Female. Use the secure link provided to submit guest names and any rooming notes for each room. This link expires in 5 days. If you need a new link, please contact your Canaccom representative. --- Trip Details --- Event: Circle K Classic (Calgary, Alberta) Hotel: Best Western Plus Calgary Centre Inn, 3630 Macleod Trail South, Calgary, AB T2G 2P9, Canada, AB, Canada Check-in: Wednesday, April 22, 2026 at 4:00 PM Check-out: Monday, April 27, 2026 at 12:00 PM Rooms: 17 total (2× 1 King, 15× 2 Queens) Submit Rooming List: https://canaccomconnect.com/rooming-list.php?token=960b896a1468c56f19ad22cc698b9754fb56db6e3f9c979ddf53a3a30a2f3962 This secure link expires in 5 days. If you need a fresh link, please contact your Canaccom representative. Phone: 403-338-0959 \| Toll Free: 888-699-8886 Email: [email protected] \| Website: www.canaccom.com	rooming_list_request	NULL
5	3	2026-03-18 17:21:07	[email protected]	Rooming List Request - CIHA U18 Female	<!DOCTYPE html> <html lang="en" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Rooming List Request</title> <!--[if mso]> <noscript> <xml><o:OfficeDocumentSettings><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml> </noscript> <![endif]--> <style> /* Reset Quill paragraph spacing for email */ .email-body p { margin: 0 0 12px 0 !important; padding: 0 !important; } .email-body p:last-child { margin-bottom: 0 !important; } a { color: #3276B7; } </style> </head> <body style="margin:0;padding:0;background:#f4f7fb;-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%;"> <div style="display:none;max-height:0;overflow:hidden;opacity:0;color:transparent;">Complete your Canaccom rooming list request using the secure link inside.</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="600" style="max-width:600px;"> <!-- HEADER with VML gradient fallback for Outlook --> <tr> <td style="padding:0;"> <!--[if mso]> <v:rect xmlns:v="urn:schemas-microsoft-com:vml" fill="true" stroke="false" style="width:600px;height:100px;mso-position-horizontal:center;"> <v:fill type="gradient" color="#231f20" color2="#3276B7" angle="45"/> <v:textbox inset="0,0,0,0"> <![endif]--> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#231f20;background:linear-gradient(135deg,#231f20 0%,#3276B7 100%);"> <tr> <td align="center" style="padding:28px 32px;"> <img src="https://canaccomconnect.com/images/canaccom_white.png" alt="Canaccom Travel Group" width="140" height="auto" style="display:block;margin:0 auto;height:auto;width:140px;max-width:140px;border:0;outline:none;text-decoration:none;"> </td> </tr> </table> <!--[if mso]> </v:textbox> </v:rect> <![endif]--> </td> </tr> <!-- BODY --> <tr> <td style="background:#ffffff;"> <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:26px;font-weight:700;line-height:1.2;color:#231f20;"> Rooming List Request </td> </tr> <tr> <td style="padding:0 32px 16px 32px;font-family:Arial,Helvetica,sans-serif;font-size:15px;line-height:1.7;color:#374151;" class="email-body"> <div style="margin:0 0 16px 0;"><p>Hello Jason Johnson,</p><p>Please complete the rooming list for <strong>CIHA U18 Female</strong>.</p><p>Use the secure link provided to submit guest names and any rooming notes for each room.</p><p>This link expires in 5 days. If you need a new link, please contact your Canaccom representative.</p></div> </td> </tr> <tr> <td style="padding:4px 32px 16px 32px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%" style="background:#f4f7fb;border-left:4px solid #3276B7;"> <tr> <td style="padding:16px 20px;font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:1.7;color:#231f20;"> <p style="margin:0 0 10px 0;font-weight:700;font-size:13px;text-transform:uppercase;letter-spacing:0.05em;color:#3276B7;">Trip Details</p><table role="presentation" cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Event</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Circle K Classic (Calgary, Alberta)</td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;vertical-align:top;">Hotel</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Best Western Plus Calgary Centre Inn<br><span style="font-weight:400;color:#6b7280;">3630 Macleod Trail South, Calgary, AB T2G 2P9, Canada, AB, Canada</span></td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Check-in</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Wednesday, April 22, 2026 at 4:00 PM</td></tr><tr><td style="padding:2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;">Check-out</td><td style="padding:2px 0;font-weight:700;font-size:13px;">Monday, April 27, 2026 at 12:00 PM</td></tr><tr><td style="padding:6px 0 2px 0;color:#6b7280;white-space:nowrap;padding-right:16px;font-size:13px;vertical-align:top;border-top:1px solid #e5e7eb;">Rooms</td><td style="padding:6px 0 2px 0;font-weight:700;font-size:13px;border-top:1px solid #e5e7eb;">17 rooms<br><span style="font-weight:400;color:#6b7280;">2× 1 King, 15× 2 Queens</span></td></tr></table> </td> </tr> </table> </td> </tr> <tr> <td style="padding: 8px 32px 0 32px;"> <table role="presentation" cellspacing="0" cellpadding="0" border="0"> <tr> <td> <!--[if mso]> <v:roundrect xmlns:v="urn:schemas-microsoft-com:vml" href="https://canaccomconnect.com/rooming-list.php?token=566bef776763919ea7657f646794171652040e54f0caa8081d0a9c8c7cc92535" style="height:52px;v-text-anchor:middle;width:260px;" arcsize="10%" stroke="f" fillcolor="#3276B7"> <w:anchorlock/> <center style="color:#ffffff;font-family:Arial,Helvetica,sans-serif;font-size:16px;font-weight:700;"> Submit Rooming List </center> </v:roundrect> <![endif]--> <!--[if !mso]><!-- --> <a href="https://canaccomconnect.com/rooming-list.php?token=566bef776763919ea7657f646794171652040e54f0caa8081d0a9c8c7cc92535" style="display:inline-block;padding:16px 28px;font-family:Arial,Helvetica,sans-serif;font-size:16px;font-weight:700;line-height:1.2;color:#ffffff;text-decoration:none;border-radius:10px;background:#3276B7;"> Submit Rooming List </a> <!--<![endif]--> </td> </tr> </table> </td> </tr> <tr> <td style="padding:12px 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="https://canaccomconnect.com/rooming-list.php?token=566bef776763919ea7657f646794171652040e54f0caa8081d0a9c8c7cc92535" style="color:#3276B7;text-decoration:underline;word-break:break-all;">https://canaccomconnect.com/rooming-list.php?token=566bef776763919ea7657f646794171652040e54f0caa8081d0a9c8c7cc92535</a> </td> </tr> <tr> <td style="padding:20px 32px 12px 32px;border-top:1px solid #e5e7eb;font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:1.6;color:#6b7280;"> This secure link expires in 5 days. If you need a fresh link, please contact your Canaccom representative. </td> </tr> <tr> <td style="padding:0 32px 28px 32px;font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:1.8;color:#6b7280;"> Phone: 403-338-0959  \|  Toll Free: 888-699-8886<br> Email: <a href="mailto:[email protected]" style="color:#3276B7;text-decoration:none;">[email protected]</a>  \|  Website: <a href="https://www.canaccom.com" style="color:#3276B7;text-decoration:none;">www.canaccom.com</a> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </body> </html>	Rooming List Request Hello Jason Johnson, Please complete the rooming list for CIHA U18 Female. Use the secure link provided to submit guest names and any rooming notes for each room. This link expires in 5 days. If you need a new link, please contact your Canaccom representative. --- Trip Details --- Event: Circle K Classic (Calgary, Alberta) Hotel: Best Western Plus Calgary Centre Inn, 3630 Macleod Trail South, Calgary, AB T2G 2P9, Canada, AB, Canada Check-in: Wednesday, April 22, 2026 at 4:00 PM Check-out: Monday, April 27, 2026 at 12:00 PM Rooms: 17 total (2× 1 King, 15× 2 Queens) Submit Rooming List: https://canaccomconnect.com/rooming-list.php?token=566bef776763919ea7657f646794171652040e54f0caa8081d0a9c8c7cc92535 This secure link expires in 5 days. If you need a fresh link, please contact your Canaccom representative. Phone: 403-338-0959 \| Toll Free: 888-699-8886 Email: [email protected] \| Website: www.canaccom.com	rooming_list_request	NULL