Back to Schema

Database Tables

Connected

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: file_storage_config

15 rows

Structure

Field Type Null Key Default Extra
id int NO PRI NULL auto_increment
storage_type enum('local','s3','google_drive','dropbox') YES local
base_path varchar(500) NO NULL
booking_files_path varchar(200) YES uploads/bookings
communication_files_path varchar(200) YES uploads/communications
document_files_path varchar(200) YES uploads/documents
max_file_size int YES 10485760
allowed_extensions json YES NULL
image_compression_quality int YES 85
require_authentication tinyint(1) YES 1
public_access tinyint(1) YES 0
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 storage_type base_path booking_files_path communication_files_path document_files_path max_file_size allowed_extensions image_compression_quality require_authentication public_access created_at updated_at
1 s3 canaccom-uploads bookings communications documents 52428800 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt", "zip", "rar"] 85 1 0 2025-08-08 08:38:05 2026-04-05 11:34:08
2 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-08-10 03:37:03 2025-08-10 03:37:03
3 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-08-14 16:49:35 2025-08-14 16:49:35
4 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-08-18 19:06:15 2025-08-18 19:06:15
5 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-08-24 01:26:28 2025-08-24 01:26:28
6 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-08-24 01:26:54 2025-08-24 01:26:54
7 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-08-29 16:39:28 2025-08-29 16:39:28
8 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-09-03 11:58:40 2025-09-03 11:58:40
9 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-11-07 19:36:25 2025-11-07 19:36:25
10 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2025-12-23 10:07:14 2025-12-23 10:07:14
11 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2026-01-03 13:21:35 2026-01-03 13:21:35
12 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2026-01-03 13:24:23 2026-01-03 13:24:23
13 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2026-01-03 13:24:23 2026-01-03 13:24:23
14 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2026-01-03 13:24:23 2026-01-03 13:24:23
15 local /home/ec2-user/canaccom/uploads uploads/bookings uploads/communications uploads/documents 10485760 ["pdf", "doc", "docx", "xls", "xlsx", "jpg", "jpeg", "png", "gif", "txt"] 85 1 0 2026-04-05 11:34:08 2026-04-05 11:34:08