Database Tables - Canaccom Travel Group Platform

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI	NULL	auto_increment
name	varchar(150)	NO	MUL	NULL
subject	varchar(255)	NO		NULL
body_html	mediumtext	NO		NULL
template_category	enum('hotel','team','booking')	NO	MUL	booking
is_active	tinyint(1)	NO	MUL	1
created_by	int	YES		NULL
updated_by	int	YES		NULL
created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Sample Data (First 20 rows)

id	name	subject	body_html	template_category	is_active	created_by	updated_by	created_at	updated_at
1	How to get started with Canaccom Group Travel	How to get started with Canaccom Group Travel	<p>Good afternoon XXX,</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:<br></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<br></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.<br></p>	team	1	2	2	2026-03-14 17:16:11	2026-03-14 17:16:11
2	Testing Template	This is a test	<p>This is a test 1 2 3 <br></p>	booking	1	2	2	2026-03-18 17:14:41	2026-03-18 17:14:41