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: teams
49 rowsStructure
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | NULL | auto_increment |
| organization_id | int | YES | MUL | NULL | |
| team_name | varchar(255) | NO | MUL | NULL | |
| team_logo | varchar(255) | YES | NULL | ||
| contact_fname | varchar(100) | NO | NULL | ||
| contact_lname | varchar(100) | NO | NULL | ||
| contact_phone | varchar(20) | NO | NULL | ||
| contact_email | varchar(255) | NO | MUL | NULL | |
| secondary_contact_fname | varchar(100) | YES | NULL | ||
| secondary_contact_lname | varchar(100) | YES | NULL | ||
| secondary_contact_email | varchar(255) | YES | NULL | ||
| secondary_contact_phone | varchar(20) | YES | NULL | ||
| tertiary_contact_fname | varchar(100) | YES | NULL | ||
| tertiary_contact_lname | varchar(100) | YES | NULL | ||
| tertiary_contact_email | varchar(255) | YES | NULL | ||
| tertiary_contact_phone | varchar(20) | YES | NULL | ||
| username | varchar(100) | YES | UNI | NULL | |
| password_hash | varchar(255) | YES | NULL | ||
| two_factor_secret | varchar(255) | YES | NULL | ||
| two_factor_enabled | tinyint(1) | YES | 0 | ||
| last_login | datetime | YES | NULL | ||
| login_attempts | int | YES | 0 | ||
| account_locked | tinyint(1) | YES | 0 | ||
| locked_until | datetime | YES | NULL | ||
| status | enum('active','inactive','pending') | YES | MUL | active | |
| notes | text | YES | NULL | ||
| created_at | timestamp | YES | MUL | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
| updated_at | timestamp | YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
Sample Data (First 20 rows)
| id | organization_id | team_name | team_logo | contact_fname | contact_lname | contact_phone | contact_email | secondary_contact_fname | secondary_contact_lname | secondary_contact_email | secondary_contact_phone | tertiary_contact_fname | tertiary_contact_lname | tertiary_contact_email | tertiary_contact_phone | username | password_hash | two_factor_secret | two_factor_enabled | last_login | login_attempts | account_locked | locked_until | status | notes | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | NULL | CIHA U15 Prep | uploads/team-logos/688d9aefeadb3_CIHA_U15_Prep.png | Moe | Jamal | 4039936999 | [email protected] | Jereme | Young | [email protected] | 4035858155 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | Need a study space and equipment storage | 2025-08-01 21:39:28 | 2025-08-27 10:41:47 |
| 2 | NULL | CIHA U15 | uploads/team-logos/688db32ebfcf7_CIHA_U15.png | Moe | Jamal | 4039936999 | [email protected] | Jereme | Young | [email protected] | 4035858155 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-01 22:55:04 | 2025-08-10 08:19:31 |
| 3 | NULL | CIHA U17 Prep | uploads/team-logos/688da9401022d_CIHA_U17_Prep.png | Moe | Jamal | 4039936999 | [email protected] | Jereme | Young | [email protected] | 4035858155 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-01 22:59:28 | 2025-08-03 11:54:04 |
| 4 | NULL | Brooks Rush Volleyball U15G | uploads/team-logos/688db2afc5d9a_Brooks_Rush_Volleyball_U15G.png | Melissa | Radford | 7803851003 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-01 23:09:00 | 2025-08-03 11:54:04 |
| 5 | NULL | Calgary Northstars U13AA Green | uploads/team-logos/688dacd65c082_Calgary_Northstars_U13AA.png | Sarah | Palinkas | 4036506153 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-01 23:14:46 | 2025-08-03 11:54:04 |
| 6 | NULL | Calgary Northstars U15AAA | uploads/team-logos/688db25f5ce1d_Calgary_Northstars_U15AAA.png | Allison | Howse | 4032223333 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-01 23:36:52 | 2025-08-03 11:54:04 |
| 7 | NULL | CIHA U18 Prep | uploads/team-logos/688db3434095e_CIHA_U18_Prep.png | Moe | Jamal | 4039936999 | [email protected] | Jereme | Young | [email protected] | 4035858155 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-01 23:42:11 | 2025-08-03 11:54:04 |
| 8 | NULL | Canada West U14G | uploads/team-logos/688dc1e993ae8_Canada_West_U14G.png | Bruce | Edwards | 4032023666 | [email protected] | Saveah | Reinhardt | [email protected] | 4034986333 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-01 23:44:08 | 2025-08-03 11:54:04 |
| 9 | NULL | Faly Blue U10 | uploads/team-logos/688e60e9bb32f_Faly_Blue_U10.png | Dionne | Anderson | 6047648128 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-01 23:46:49 | 2025-08-03 11:54:04 |
| 10 | NULL | Calgary Northstars U17AAA | uploads/team-logos/688dbc14005ce_Calgary_Northstars_U17AAA.png | Melissa | O'Neal | 4038085295 | [email protected] | Colm | McCabe | [email protected] | 4034777994 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 00:19:48 | 2025-08-03 11:54:04 |
| 11 | NULL | Calgary Northstars U18AAA | uploads/team-logos/688dbd5d8f35d_Calgary_Northstars_U18AAA.png | Marcus | Cheung | 4037038888 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 00:25:17 | 2025-08-03 11:54:04 |
| 12 | NULL | Calgary Northstars U18AA Gold | uploads/team-logos/688dbde009f1c_Calgary_Northstars_U18AA_Gold.png | Melissa | O'Neal | 4038085295 | [email protected] | Ty | Bilcke | [email protected] | 4033899196 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 00:27:28 | 2025-08-03 11:54:04 |
| 13 | NULL | Calgary Northstars U15A | uploads/team-logos/688dbe9c7ecd3_Calgary_Northstars_U15A.png | Chris | Dietzen | 4039885149 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 00:30:36 | 2025-08-03 11:54:04 |
| 14 | NULL | PCFAC U13AAF | uploads/team-logos/688e60240fbee_PCFAC_U13AAF.png | Kirby | Aldred | 7809333672 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 11:59:48 | 2025-08-03 11:54:04 |
| 15 | NULL | KC Shamrocks | uploads/team-logos/688e617b1dede_KC_Shamrocks.png | Marisa | Anusic | 7802712352 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 12:05:31 | 2025-08-03 11:54:04 |
| 16 | NULL | LFC U12B Red | uploads/team-logos/688e62169085f_LFC_U12B_Red.png | Danielle | Aubin | 4033934393 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 12:08:06 | 2025-08-03 11:54:04 |
| 17 | NULL | Okanagan FC | uploads/team-logos/688e637c2b62f_Okanagan_FC.png | Lori | Barr | 2508698224 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 12:14:04 | 2025-08-03 11:54:04 |
| 18 | NULL | Burnaby FC Blaze | uploads/team-logos/688e646d3c00b_Burnaby_FC_Blaze.png | Andrew | Blunt | 6043513060 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 12:18:05 | 2025-08-03 11:54:04 |
| 19 | NULL | NWSC U15 Wolves | uploads/team-logos/688e6531621e2_NWSC_U15_Wolves.png | Matt | Brabbins | 6043196795 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 12:21:21 | 2025-08-03 11:54:04 |
| 20 | NULL | St. Albert Slash U18AAA | uploads/team-logos/688e65d8d8e42_St._Albert_Slash_U18AAA.png | Ryan | Brady | 7809063415 | [email protected] | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | active | NULL | 2025-08-02 12:24:08 | 2025-08-03 11:54:04 |