Back to Schema

Database Tables

Connected

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

78 rows

Structure

Field Type Null Key Default Extra
id int NO PRI NULL auto_increment
booking_id int NO MUL NULL
room_id int NO MUL NULL
room_instance smallint unsigned NO 0
booking_hotel_id int YES MUL NULL
team_id int YES MUL NULL
source_type enum('room_entry','team_profile') NO room_entry
source_profile_id int YES NULL
cardholder_name varchar(150) YES NULL
card_brand varchar(30) YES NULL
card_last4 char(4) NO NULL
exp_month tinyint unsigned NO NULL
exp_year smallint unsigned NO NULL
encrypted_payload mediumtext NO NULL
nonce_b64 varchar(255) NO NULL
cipher_meta varchar(40) NO sodium_xchacha20poly1305
key_version varchar(30) NO v1
created_by_type enum('admin','team_public','system') NO admin
created_by_ref varchar(255) 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 booking_id room_id room_instance booking_hotel_id team_id source_type source_profile_id cardholder_name card_brand card_last4 exp_month exp_year encrypted_payload nonce_b64 cipher_meta key_version created_by_type created_by_ref created_at updated_at
265 8 126 0 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 ttlMiw/lJzXPU6CIOEPWPxkDTHNvMwrAKWkpgtr4SRJSJ6+kYpRSYKlJiiqHtWR0OsHqnP21oG5t10r7pK6+V/XVPqYVY4ob/ixmSAzKcFJNdJeg0vF7PLgDpnjGERdywdr+sGsh8ZRlPw== nGsUQorYR31mGRvWINrbCqP5qYhbxpai sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
266 8 126 1 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 7MsI3WKr2dhnnyzeA4+TxIp16qh4IQ/jizFsQAqfCy5Mm6Hgxe5N0qhOrqEkCzI+Yo42muDswZSssxCwwUJRXStf8ydI5TSsOQqQDUTw6C6OXA7WPMn3OMv3cbqt+Yvw3I7XNJHE9vRxJQ== fRqxeTUclV9bSdDjACdY7Ei6+TV/jLmF sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
267 8 126 2 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 iIRuOy4qcagagV8aBiFFRHr7KJxDjw0a2bLqvOp7iB1VhFP8MgXgYvtqgl9UldOmC0CMvMCiyUM3doxnCf61PE+Y2XAnTExmUs3XOpFT5fAckfm0Am7tml7qUKqcP6aTPeF3OuGxjaBbbA== wLBnmszGjvahT/UMzjnqRFJJVatBKJ/g sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
268 8 126 3 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 IS+lNDl+s1nc/2wp4bpUsP76lybKfpmON8nEzlc+pp3HLaArf9zGIO+aWD0ShOMuOtrrIs7njfpao74xoVvNZkZCzGoyB7AmYC9qbopeEp8PXiufq/OjHId4t9kyfq7lJwp+gTdNJxbBEw== 6BPoi7mcTnO8A66KxxQWmOEp5Fn3GRzF sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
269 8 126 4 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 e61LZa1buU8tZvzH9iFC2/T436WrDXy01DgRP9RQ3S0Q+BvWv/VsOR7Hx0US5mKklUO4dfA5fHAvGrzg71XCvQd/qb2UaZYZsVZfRy2GhEaOfwx5NQ9kmUdmnBexHkdscd7pgCXTrKJ1yQ== 3Jzu1D5PpdHYNXhQalls4m6EmM2JMdAR sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
270 8 126 5 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 JH3Kjh35UxVCYhwa/5Lx3dy488a8M5/VSaueoPrYaEjfyivd6JmRBfSgKJBvmR2pDxbdg09qIyXOrM+HnlbfylIwORByQhz9DNWYvC4SefiUeCXBkgItl0LxLCdROjdHMJVVPQ+lKRqIqQ== pA0eR7YPPt+rGKdx2giY7U7i7J2+FE7s sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
271 8 126 6 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 5SAckr2+yPd2vPDmFpYA+TxhMCQuvjn+hy2dAMSDcJBcSwUXplnK+sIKWgQDiQT3tAl5MxMkRBK/xAQ4uW9iDLPuf9+ENK3QKngLUq76u7OO8il5Jz/cfA6pqGlUsfG31S4QfGHRPrOedg== eblX4LhzreZUWzIF+6Gc5WeHVxcn3vrd sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
272 8 126 7 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 KiAd9MBo1lSxXEaCIrVNezYPH7pU64FjP/Icmzg2ht1gEW9kg+9eEzm+DdzYkEuAiNwQMeiW82r8JEg0oEgzs4UY0siNzVbozuZT2YB7UGWhhEqZZ/Vov4Omf5jpah2uOkyFZr4GcPGtOg== lrhzQKDYNtx+0Lpixjf6F1cDaXske+7U sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
273 8 126 8 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 etgtc5NnOv9zrX8m1iIp/9u15GNxII7A9HGErOl4ZDn8Hka0XChYqlVl1+lZu5AYyR1DIjLYOvFAa6ySkiHonogoInAtkPZedqclmQVzeVX2iHuAIW6wzyUMiELv40f/ijd74303uAzJOw== j77B6969MXyD8sYqidI1wKRghf9rkX9z sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
274 8 126 9 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 P3P4Sp+w8zxkTvhFxymgF7LdNB2mKI5Ddrr+jCJta5nBM1BgtKFHIyLCMQ7uvDtWtfLlbmTEn4h+Rm+KQoLtSVUqhqqxCRU85iCVPmwK90zeFMELk2z32/4jttmj4SGs80/j8cLGo8qZ/Q== RifK2qM2Ns2t4GuLcVZI7Nss2HWzRs7w sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
275 8 126 10 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 YHKLDZlnq4nyYfrw6etBl2SPni7831BXIuuFcx6GOHTwtQz1zAWzxP7KejKTnLWIDex27x1AwKngE4quF2Erl18on/eQR9eDMUltHmK8Uj/nkpBMEk357Rj/6RZyFYEHKwKLMhPxBM8+sg== hHWRO7SL27Nm9/sBOmNYhWojqnYEYoXn sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
276 8 126 11 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 v0TVK18XbtvI9TaSTqA6HSJAINWSdE2acPUybG5lGdvw6d+mQCN2/59l2bwzkP44gOUil17O2ObrZG5ZUyUhTgL1Bc0AiOlUMp3fY7kiyfa7mX4zKWYvOUJWRgWVK2qfgS8gUSlcNlApGA== uHr30UOR1g1rTmsSmHelhvQ3ALo1/R/z sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
277 8 127 0 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 DSTQyfABTlOTMelvR+XatzWu7zWf9ZQMAQM3wGYw+29rmAeWpqDIbLLhAkuTYM8X/SXalFzB7mUrp86jAykCLZZSVp3bVZ+wEfuUFxTolrTjw3MRR7Qb9Lb5WaZUdfRIy9QxDeIQ1aNWMg== h1EvOb8ilDxvleSanN90RPTnThKUWIs3 sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
278 8 127 1 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 sFzdAXgYxCLQS2BeRLZoAABJk2kYjBx8T7FEaF5CevE/n37yalj3FXKCz5zb1+xpTXfGtMqp3c5+LVTwCyP+vQhWhlR3WrH+LhGlmhdZfPZ19AeOcpumSVo5Lny/5LZG7DKR/+cSonaPGQ== dehZ9jsmq0CllkAChZktPij5xWymRXuv sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:50 2026-06-25 08:32:50
279 8 127 2 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 9ngtWtZNehgp7t3JH+zftIHcvzjAPqkx0lxUVLPlHu73TwViAKWtx/zh+nUwtbejXKyeBXqwi9mov+dk6zbMYfr0WORb4eY9hm6vkyhdk85aN5FPQkfgo1S7gjWIvBnat/1xoQSJix+XMQ== KybLY+QiLAxejNKHcID0PwmdWW8MIiX7 sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:51 2026-06-25 08:32:51
280 8 127 3 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 qKK3kjvkk0NtIl0292ACfmuKTA2dtm/9p+zYq7rkr5SsEi7NuA725FZnN6+lj+zkcjczIIUh1N6l3Mtwh9wWz+u76BXJRw9tXep9KpxoqHqYqK+B2XUoXpmcCSIFjBzfHtmZ91rD2ID97w== KmurKhtsZbmUqcq0jRwM8QddUQT8VPtw sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:51 2026-06-25 08:32:51
281 8 127 4 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 B1pJopWntEIx/M9ljxp+JToBeFfdeEyNszIPl0i+3KEG8w0NG2Jrj//5XRn2areXTci1z167V/nGiyu/XW60bwt+Ip3N9Nkq0ub/qutI/vASz4E/KP2BIXFf7yk2CZQu7mM0sXrPYNWCtw== EIhqcCtk1kMTYrw/O0a9mQKR7VVOIGOx sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:51 2026-06-25 08:32:51
282 8 127 5 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 go/GghNeb4CaSqzrzNSpGFu+EULK65Sx1ghSOvCz+Sf+5KIXomC720jWt6yDP1p4MdNM/4hnDl9d0rxXyM3HJTVLVT9ajP4Yl0ZHd/5TGL4gM3XyDyQwFcCjE82mra1+UbjO+i0nQp/8pA== uZl5yYl9pfXyEuRhpOBglcyQFZZZ+vsr sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:51 2026-06-25 08:32:51
283 8 127 6 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 czqjmmnjYFzX+mr0bKB1lpeA+h2P6dtQhJCfJNpKnLDUy0fwh7hdOtrhoy+BurZ9xu9GuB6oa/AfmQUplyXRlStm8TlJAZzrd84zTtEuUbz9ITt0CHGmu5FExUPNXS78itEZ0Ps2bSIw+g== 0XkYkG80Pnqu/z4vH8LXwNzzJ8Ip+RPy sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:51 2026-06-25 08:32:51
284 8 127 7 15 51 team_profile 6 Jason Johnson visa 7533 9 2028 iH50zkw5bGRX29fPixBEihfZaZFHwIc7cj0on4hMGEubyGKjR77wos3MnMWTc7mS+MaUi50YDJwM4GBOyciYuTcr+eTIaH0IinK31UDl1ouf8daNiDyZGTQmiwWiFvBZ1PVWDIKNHP70Vg== oU0QcVaeaBgjOy7LjGezAkeEOlnO9rSC sodium_xchacha20poly1305 v1 team_public rooming_token:17fe09c0702f 2026-06-25 08:32:51 2026-06-25 08:32:51