Database Tables - Canaccom Travel Group Platform

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI	NULL	auto_increment
team_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	team_id	sent_at	recipient	subject	body_html	body_text	email_type	sent_by
1	51	2026-03-18 16:25:34	[email protected]	How to get started with Canaccom Group Travel	<!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>How to get started with Canaccom Group Travel</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;">How to get started with Canaccom Group Travel</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;"> How to get started with Canaccom Group Travel </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="font-family:Arial,Helvetica,sans-serif;font-size:15px;line-height:1.6;color:#4b5563;"><p>Good afternoon Jason,</p><p><br></p><p>The goal of CanAccom Group Travel is to simplify the task of organizing team travel. We have strong relationships with many hotels across Western Canada and beyond which we have developed over the last 15+ years. Please keep reading to see how we can assist with your team’s travel plans this season.</p><p><br></p><p>During our initial conversations, we will need to know a number of details about your team. We will then reach out to a number of properties in the area you have indicated with the goal to present you with 3 property options. Once you have had an opportunity to review them and advise us which property to book your team at, we will take care of the group contract with the hotel. We will send you a copy of the contract for your records, comprehensive booking instructions for your team, and if applicable, send to each family on your team for them to secure their individual reservations.</p><p><br></p><p>At the booking stage, we will require a valid credit card to secure the block (nothing is charged to the card at this time, however the hotel reservations systems require this to hold the block). It is very important that all bookings/amendments/ cancellations are to made through Canaccom Group Travel and NOT directly with the hotel. We will also confirm details on how the rooms will be paid at this time though in most cases this will not take place until check out. At any time during this process our Group Travel Advisors are available to answer any questions regarding the property, the status of your team’s rooming list, or anything else relating to your booking with us.</p><p><br></p><p>To have a member of the CanAccom Group Travel team proceed with a travel inquiry on your behalf, please complete the following:</p><p><br></p><p>Team Name: Upper York Admirals</p><p>Team Contact Name: Carol Orchard</p><p>Phone #:</p><p>Email: [email protected]</p><p><br></p><p>Date of Travel:</p><p>Number of Nights:</p><p>Destination: Calgary</p><p>Location of Sports venue: - Western Canadian Showdown</p><p>Number of Rooms Required:</p><p>(we will request all rooms have 2 Queen beds for QUAD Occupancy, please indicate if you require something different from that)</p><p>Will the team will be travelling with parents/families or if this is a team only/chaperoned event with or without parent rooms?</p><p><br></p><p>If your team requires group flight or coach transportation information, please indicate as such and we will be in contact with additional details regarding each of these options.</p><p><br></p><p><strong>Bussing:</strong> Let us know what you are interested in, daily – 5 days etc:</p><p><br></p><p><strong>Flights:</strong></p><p>The process is a little different though, and unlike Canaccom, there is a small cost- but it’s 100% worth it. I contract all our flights to a lady named Rhonda, she’s essentially the 5th “member” of the Canaccom team. Rhonda sources all our flights, contracts them, manages payment, manifest etc. deadlines, and then tickets the flights. And she’s always available to me if there is ever an issue- a cancellation for example. She’s awesome. Rhonda charges $52.50 per person for domestic flights, and I think $10 more for international. But again, for all she does, it’s worth not having to deal with it yourself.</p><p><br></p><p>In order to book flights, you need to be ready to pull the trigger. Once we get a quote from Rhonda we have about 24 hours to secure the seats and the fare with a deposit, which is usually around $100 per person. We cannot hold flights. Once that is done, we usually have until about a month before you travel to pay the balance and provide a manifest (passenger information that matches each individual passport). There are a couple things of note as well- you cannot book flights on a sale, it’s impossible. We will not/cannot book flights with Flair or any of the discount airlines- they cause too many problems. And payment must be made in a singular fashion- e-transfer is best as there are no fees associated with it.</p><p><br></p><p>If you have any questions, please do not hesitate to contact us. We truly look forward to working with you and your team!</p><p><br></p><p>Warmest Regards,</p><p><br></p><p>Emily Myers, Sandee Reid-Geislinger & Leanne Sheasgreen</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: [email protected]</p><p>Website: Check out our new look! www.canaccom.com</p><p><br></p><p>SPRING/SUMMER HOURS</p><p>MAY 1 – SEPTEMBER 30</p><p>MONDAY – THURSDAY 10:00AM – 4:00PM</p><p>FRIDAY 10:00AM – 2:00PM</p><p><br></p><p>Should you contact us outside of our regular office hours, you will receive a response during the next business day. If you have a time sensitive query, booking or deadline, please be assured that we note the date and time of all voicemails and emails and will ensure that requests/bookings are processed accordingly.</p><p>Please note that we are prohibited from accepting or transmitting credit card information via email or voicemail without encryption. Please call our office to provide and accept our thanks for your understanding for any inconvenience.</p><p><br></p><p>Your repeat business and referrals are our greatest achievement and are sincerely appreciated.</p><p>If you are happy, tell your friends. If you are not happy, please tell us.</p></div> </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 message was sent by Canaccom Travel Group. </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>	How to get started with Canaccom Group Travel Good afternoon Jason, The goal of CanAccom Group Travel is to simplify the task of organizing team travel. We have strong relationships with many hotels across Western Canada and beyond which we have developed over the last 15+ years. Please keep reading to see how we can assist with your team’s travel plans this season. During our initial conversations, we will need to know a number of details about your team. We will then reach out to a number of properties in the area you have indicated with the goal to present you with 3 property options. Once you have had an opportunity to review them and advise us which property to book your team at, we will take care of the group contract with the hotel. We will send you a copy of the contract for your records, comprehensive booking instructions for your team, and if applicable, send to each family on your team for them to secure their individual reservations. At the booking stage, we will require a valid credit card to secure the block (nothing is charged to the card at this time, however the hotel reservations systems require this to hold the block). It is very important that all bookings/amendments/ cancellations are to made through Canaccom Group Travel and NOT directly with the hotel. We will also confirm details on how the rooms will be paid at this time though in most cases this will not take place until check out. At any time during this process our Group Travel Advisors are available to answer any questions regarding the property, the status of your team’s rooming list, or anything else relating to your booking with us. To have a member of the CanAccom Group Travel team proceed with a travel inquiry on your behalf, please complete the following: Team Name: Upper York Admirals Team Contact Name: Carol Orchard Phone #: Email: [email protected] Date of Travel: Number of Nights: Destination: Calgary Location of Sports venue: - Western Canadian Showdown Number of Rooms Required: (we will request all rooms have 2 Queen beds for QUAD Occupancy, please indicate if you require something different from that) Will the team will be travelling with parents/families or if this is a team only/chaperoned event with or without parent rooms? If your team requires group flight or coach transportation information, please indicate as such and we will be in contact with additional details regarding each of these options. Bussing: Let us know what you are interested in, daily – 5 days etc: Flights: The process is a little different though, and unlike Canaccom, there is a small cost- but it’s 100% worth it. I contract all our flights to a lady named Rhonda, she’s essentially the 5th “member” of the Canaccom team. Rhonda sources all our flights, contracts them, manages payment, manifest etc. deadlines, and then tickets the flights. And she’s always available to me if there is ever an issue- a cancellation for example. She’s awesome. Rhonda charges $52.50 per person for domestic flights, and I think $10 more for international. But again, for all she does, it’s worth not having to deal with it yourself. In order to book flights, you need to be ready to pull the trigger. Once we get a quote from Rhonda we have about 24 hours to secure the seats and the fare with a deposit, which is usually around $100 per person. We cannot hold flights. Once that is done, we usually have until about a month before you travel to pay the balance and provide a manifest (passenger information that matches each individual passport). There are a couple things of note as well- you cannot book flights on a sale, it’s impossible. We will not/cannot book flights with Flair or any of the discount airlines- they cause too many problems. And payment must be made in a singular fashion- e-transfer is best as there are no fees associated with it. If you have any questions, please do not hesitate to contact us. We truly look forward to working with you and your team! Warmest Regards, Emily Myers, Sandee Reid-Geislinger & Leanne Sheasgreen The Canaccom Team CANACCOM- Group Travel Phone: 403-338-0959 Toll Free: 888-699-8886 Email: [email protected] Website: Check out our new look! www.canaccom.com SPRING/SUMMER HOURS MAY 1 – SEPTEMBER 30 MONDAY – THURSDAY 10:00AM – 4:00PM FRIDAY 10:00AM – 2:00PM Should you contact us outside of our regular office hours, you will receive a response during the next business day. If you have a time sensitive query, booking or deadline, please be assured that we note the date and time of all voicemails and emails and will ensure that requests/bookings are processed accordingly. *Please note that we are prohibited from accepting or transmitting credit card information via email or voicemail without encryption. Please call our office to provide and accept our thanks for your understanding for any inconvenience. Your repeat business and referrals are our greatest achievement and are sincerely appreciated. If you are happy, tell your friends. If you are not happy, please tell us. This message was sent by Canaccom Travel Group. Phone: 403-338-0959 \| Toll Free: 888-699-8886 Email: [email protected] \| Website: www.canaccom.com	adhoc	NULL