Database Overview
67
Total Tables
Online
Connection Status
canaccom
Database Name
Available Tables
backup_restore_log
block_booking_emails
block_booking_files
block_booking_hotels
block_booking_rooms
block_bookings
booking_commissions
booking_communications
booking_documents
booking_emails
booking_files
booking_hotel_additional_costs
booking_hotel_amenities
booking_hotel_room_quantities
booking_hotel_room_types
booking_hotel_taxes
booking_hotels
booking_reminder_settings
booking_rooms
bookings
bookings_backup_2025_11_07_19_36_10
clients
communication_attachments
communication_templates
contact_change_history
contact_change_requests
contact_validation_rules
email_templates
event_facilities
event_files
events
file_storage_config
hotel_confirmations
hotel_images
hotels
invoice_emails
invoice_items
invoices
organization_card_authorization_tokens
organization_card_profiles
organizations
parent_registrations
public_registration_links
quote_request_emails
quote_request_hotels
quote_requests
room_guests
rooming_card_access_tokens
rooming_card_audit_log
rooming_cards
rooming_list_requests
stay_confirmation_files
stay_confirmation_rooms
survey_questions
survey_response_answers
survey_responses
survey_sends
surveys
team_card_profiles
team_emails
team_manager_devices
team_manager_login_tokens
team_managers
team_roster_members
team_roster_meta
teams
users
Table: quote_requests
5 rowsStructure
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | NULL | auto_increment |
| team_id | int | YES | NULL | ||
| team_name | varchar(255) | NO | |||
| status | enum('open','sent','responded','converted','archived') | NO | open | ||
| arrival_date | date | YES | NULL | ||
| departure_date | date | YES | NULL | ||
| nights_stay | int | NO | 0 | ||
| total_rooms | int | NO | 0 | ||
| breakfast_included | tinyint(1) | NO | 0 | ||
| equipment_storage | tinyint(1) | NO | 0 | ||
| meeting_room | tinyint(1) | NO | 0 | ||
| block_booking | tinyint(1) | NO | 0 | ||
| commission_rate | decimal(5,2) | NO | 12.00 | ||
| other_requests | text | YES | NULL | ||
| booking_id | int | YES | NULL | ||
| created_by | int | YES | NULL | ||
| created_at | timestamp | YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | |
| updated_at | timestamp | YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
Sample Data (First 20 rows)
| id | team_id | team_name | status | arrival_date | departure_date | nights_stay | total_rooms | breakfast_included | equipment_storage | meeting_room | block_booking | commission_rate | other_requests | booking_id | created_by | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 51 | CIHA U18 Female | sent | 2026-05-20 | 2026-05-25 | 5 | 18 | 1 | 1 | 1 | 0 | 12.00 | Thank you for your time | NULL | 2 | 2026-03-12 07:21:16 | 2026-03-12 07:55:41 |
| 2 | 1 | CIHA U15 Prep | open | 2026-04-10 | 2026-04-13 | 3 | 15 | 1 | 1 | 1 | 0 | 12.00 | NULL | 2 | 2026-03-18 16:37:53 | 2026-03-18 16:37:53 | |
| 3 | 52 | OHA Penticton - U18 Prep | converted | 2026-09-17 | 2026-09-20 | 3 | 26 | 1 | 1 | 1 | 0 | 12.00 | NULL | 2 | 2026-06-17 04:09:45 | 2026-06-23 07:14:55 | |
| 4 | 51 | CIHA U18 Female | converted | 2026-07-17 | 2026-07-19 | 2 | 30 | 1 | 1 | 1 | 0 | 12.00 | Take good care of this team | 8 | 2 | 2026-06-25 06:29:06 | 2026-06-25 08:25:39 |
| 5 | 51 | CIHA U18 Female | converted | 2026-11-12 | 2026-11-15 | 3 | 30 | 1 | 1 | 1 | 0 | 12.00 | 9 | 2 | 2026-06-25 09:54:29 | 2026-06-25 10:07:23 |