Database Overview
58
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
organizations
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
teams
users
Table: bookings
5 rowsStructure
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | NULL | auto_increment |
| booking_date | date | YES | MUL | NULL | |
| event_name | varchar(255) | YES | NULL | ||
| event_id | int | YES | NULL | ||
| team_id | int | NO | MUL | NULL | |
| team_name | varchar(255) | NO | NULL | ||
| team_logo | varchar(255) | YES | NULL | ||
| team_contact_fname | varchar(100) | NO | NULL | ||
| team_contact_lname | varchar(100) | NO | NULL | ||
| team_contact_phone | varchar(20) | NO | NULL | ||
| team_contact_email | varchar(255) | NO | NULL | ||
| team_secondary_contact_fname | varchar(100) | YES | NULL | ||
| team_secondary_contact_lname | varchar(100) | YES | NULL | ||
| team_secondary_contact_email | varchar(255) | YES | NULL | ||
| team_secondary_contact_phone | varchar(20) | YES | NULL | ||
| team_tertiary_contact_fname | varchar(100) | YES | NULL | ||
| team_tertiary_contact_lname | varchar(100) | YES | NULL | ||
| team_tertiary_contact_email | varchar(255) | YES | NULL | ||
| team_tertiary_contact_phone | varchar(20) | YES | NULL | ||
| hotel_id | int | NO | MUL | NULL | |
| commission_rate | decimal(5,2) | YES | 10.00 | ||
| commission_amount | decimal(10,2) | YES | NULL | ||
| commission_paid | tinyint(1) | YES | MUL | 0 | |
| commission_paid_date | date | YES | NULL | ||
| arrival_date | date | NO | MUL | NULL | |
| departure_date | date | NO | MUL | NULL | |
| check_in_time | time | YES | 16:00:00 | ||
| check_out_time | time | YES | 12:00:00 | ||
| total_rooms | int | NO | 0 | ||
| nights_stay | int | YES | NULL | ||
| total_amount | decimal(12,2) | YES | NULL | ||
| special_requests | text | YES | NULL | ||
| accessibility_requirements | text | YES | NULL | ||
| status | enum('quote request','draft','pending','confirmed','cancelled','completed') | YES | MUL | draft | |
| hotel_confirmed | tinyint(1) | YES | MUL | 0 | |
| hotel_confirmation_date | datetime | YES | NULL | ||
| hotel_confirmed_by | varchar(100) | YES | NULL | ||
| hotel_confirmation_notes | text | YES | NULL | ||
| contract_sent | tinyint(1) | YES | MUL | 0 | |
| contract_sent_date | datetime | YES | NULL | ||
| contract_received | tinyint(1) | YES | MUL | 0 | |
| contract_received_date | datetime | YES | NULL | ||
| rooming_list_submitted | tinyint(1) | YES | MUL | 0 | |
| rooming_list_submission_date | datetime | YES | NULL | ||
| stay_confirmation_sent | tinyint(1) | YES | MUL | 0 | |
| stay_confirmation_date | datetime | YES | NULL | ||
| actual_guests | int | YES | NULL | ||
| actual_rooms_used | int | YES | NULL | ||
| final_amount | decimal(12,2) | YES | NULL | ||
| internal_notes | text | YES | NULL | ||
| team_notes | text | YES | NULL | ||
| hotel_notes | text | YES | NULL | ||
| created_by | int | YES | MUL | NULL | |
| created_at | timestamp | YES | MUL | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
| updated_at | timestamp | YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP | |
| team_options_token | varchar(64) | YES | UNI | NULL | |
| team_options_sent_at | datetime | YES | NULL | ||
| team_options_submitted_at | datetime | YES | NULL | ||
| team_selected_hotel_id | int | YES | NULL | ||
| team_selection_comments | text | YES | NULL | ||
| block_booking_id | int | YES | NULL | ||
| rooming_list_hotel_sync_required | tinyint(1) | NO | 0 | ||
| rooming_list_hotel_last_sent_at | datetime | YES | NULL | ||
| rooming_list_last_updated_at | datetime | YES | NULL | ||
| team_code_of_conduct_acknowledged_at | datetime | YES | NULL | ||
| team_code_of_conduct_acknowledged_by | varchar(255) | YES | NULL | ||
| team_code_of_conduct_ack_source | varchar(64) | YES | NULL |
Sample Data (First 20 rows)
| id | booking_date | event_name | event_id | team_id | team_name | team_logo | team_contact_fname | team_contact_lname | team_contact_phone | team_contact_email | team_secondary_contact_fname | team_secondary_contact_lname | team_secondary_contact_email | team_secondary_contact_phone | team_tertiary_contact_fname | team_tertiary_contact_lname | team_tertiary_contact_email | team_tertiary_contact_phone | hotel_id | commission_rate | commission_amount | commission_paid | commission_paid_date | arrival_date | departure_date | check_in_time | check_out_time | total_rooms | nights_stay | total_amount | special_requests | accessibility_requirements | status | hotel_confirmed | hotel_confirmation_date | hotel_confirmed_by | hotel_confirmation_notes | contract_sent | contract_sent_date | contract_received | contract_received_date | rooming_list_submitted | rooming_list_submission_date | stay_confirmation_sent | stay_confirmation_date | actual_guests | actual_rooms_used | final_amount | internal_notes | team_notes | hotel_notes | created_by | created_at | updated_at | team_options_token | team_options_sent_at | team_options_submitted_at | team_selected_hotel_id | team_selection_comments | block_booking_id | rooming_list_hotel_sync_required | rooming_list_hotel_last_sent_at | rooming_list_last_updated_at | team_code_of_conduct_acknowledged_at | team_code_of_conduct_acknowledged_by | team_code_of_conduct_ack_source |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2025-08-25 | Circle K Classic (Calgary, Alberta) | 5 | 20 | St. Albert Slash U18AAA | NULL | Ryan | Brady | 7809063415 | [email protected] | NULL | NULL | NULL | NULL | 28 | 10.00 | NULL | 0 | NULL | 2025-12-26 | 2026-01-02 | 16:00:00 | 12:00:00 | 0 | 7 | NULL | NULL | NULL | completed | 0 | NULL | NULL | NULL | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-25 04:41:47 | 2026-03-12 21:43:29 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | ||||
| 2 | 2025-08-31 | Rocky Mountain Classic (Calgary) | 4 | 1 | CIHA U15 Prep | NULL | Moe | Jamal | 4039936999 | [email protected] | Jereme | Young | [email protected] | 4035858155 | NULL | NULL | NULL | NULL | 35 | 10.00 | NULL | 0 | NULL | 2025-11-12 | 2025-11-16 | 16:00:00 | 12:00:00 | 0 | 4 | NULL | NULL | NULL | confirmed | 0 | NULL | NULL | NULL | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-31 08:46:45 | 2026-03-15 20:36:19 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL |
| 3 | 2026-03-08 | Circle K Classic (Calgary, Alberta) | 5 | 51 | CIHA U18 Female | NULL | Jason | Johnson | 4037719054 | [email protected] | NULL | NULL | NULL | NULL | 88 | 10.00 | NULL | 0 | NULL | 2026-04-22 | 2026-04-27 | 16:00:00 | 12:00:00 | 0 | 5 | NULL | NULL | NULL | confirmed | 0 | NULL | NULL | NULL | 0 | NULL | 0 | NULL | 1 | 2026-03-18 16:53:45 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-08 19:13:32 | 2026-03-18 16:58:41 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | 2026-03-18 16:53:45 | 2026-03-18 16:58:41 | [email protected] | rooming_list_modal | ||||
| 4 | 2026-03-17 | Alley-Oop Basketball Tournament | 6 | 51 | CIHA U18 Female | NULL | Jason | Johnson | 4037719054 | [email protected] | NULL | NULL | NULL | NULL | 742 | 10.00 | NULL | 0 | NULL | 2026-06-19 | 2026-06-21 | 16:00:00 | 12:00:00 | 0 | 2 | NULL | NULL | NULL | confirmed | 0 | NULL | NULL | NULL | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-17 22:25:53 | 2026-03-17 22:40:32 | NULL | NULL | NULL | NULL | NULL | 2 | 0 | NULL | NULL | NULL | NULL | NULL | ||||
| 5 | 2026-03-18 | NULL | 51 | CIHA U18 Female | NULL | Jason | Johnson | 4037719054 | [email protected] | NULL | NULL | NULL | NULL | 51 | 10.00 | NULL | 0 | NULL | 2026-08-13 | 2026-08-16 | 16:00:00 | 12:00:00 | 0 | 3 | NULL | NULL | NULL | pending | 0 | NULL | NULL | NULL | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-18 15:48:51 | 2026-03-18 15:50:01 | 2136ccdc083ca03edb9c76554e93eba58911e4f8a0c2f1c81530274e882cd72d | 2026-03-18 15:50:01 | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL |