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: rooming_cards
85 rowsStructure
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180 | 3 | 86 | 0 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | q3As3a3thIZdbviOGRxmqF1SGLAINbvLZ9O3cLgfyNlnSBYH68BnrK9UuojHBDmXtJZ1+aZ8jM8yimX8tnXBoj5JWkqXW8gB14lyNYw+nBOfvEWyXRZ5cvG3pgkG75koSnadhuNa1rdAzA== | 6jYuGyiN5k+pL6IucRtpP4K66FgZ+XWs | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:46 | 2026-03-13 23:11:46 |
| 181 | 3 | 86 | 1 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | UlNtzyxWUfUvOvf5CgC8v1KBVD3pDCEpSYYm8HvrvJ+C6nNYhew5tJ452cpSuC0U1uNBumAKm05QGrW633bDmZlfeNqRfAfNhVeodDQ1qLgY6qKm9WOvO5OavkROmVd7CTtOgE1Iz0yoNg== | HZhq2VbNnRve2MWFMq1rqoxhLLZaqX9F | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:46 | 2026-03-13 23:11:46 |
| 182 | 3 | 87 | 0 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | ToDJNjciKAtofDb1QpHfadgI00KdBwEWRvKLdXpjssRIEWs68KY9Wgsy/eELCNesGEeYUAN50T7bX03kLGHdj4eyyXS/m/5IG3j5R1+CXCOOQAVjx8+vaz5g+pacbgSoI7c583Arh8nOfQ== | RreEjixaq97Vl/w872ssNKstroyjiaD7 | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:46 | 2026-03-13 23:11:46 |
| 183 | 3 | 87 | 1 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | 6TvjQQ8XufikfBdaAlFPmnRuGCT6D6FFoXKQicB69kqs9JpTOLxjDKNjSnooFS1/XrDET8vFpOWbJ6vo9KCkNOu7bo0K9kMCwBl/zYlV3RWV4N0k92Gh7xcM78eBXKm1bfvgceD94RO0+A== | 5XMDEFeN1aYmPyttQWBqYZ3KnLqf6lX+ | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:46 | 2026-03-13 23:11:46 |
| 184 | 3 | 88 | 0 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | JRFCmKa4mcutaa9g+lGvgU9xK36rCdoSeUDPbLGJz8vxjqk4oTnfNGgTgQyd58C8d0m4Tpy7rmG06eZfVftCC+wcbWO0vPJnJWKFJxLRi0Lgb80wVl75buLggZEujtN648OGJAi8Uq8paA== | 9d6+1PwxMmZDfuLEQGOiIUZhp/oAIAVd | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:46 | 2026-03-13 23:11:46 |
| 185 | 3 | 88 | 1 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | qvtKwxZgkd3UWwMCj9COGqZuDJZbJbsVSbdyTqealYeVyY0Eh1GBbSJyhY6xhf6hhBqyWSKzGj++qKyWvsU3usVPHWHuF6Lymj8ZpvSXKYzfMGWEiGT/U+2W1PRQ0Nj96Np2mGxquX3mww== | 7CGEZRdvNrHjksAVcvp+TagIZnH6mEMF | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:47 | 2026-03-13 23:11:47 |
| 186 | 3 | 89 | 0 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | O1Guh2kODTrX45nR/0/eWUlpWwlLMbvkT7dE2dB0RaasUoYKWblukL0GzIComEfSGdrgVD3e/SJypEc/BQ4dnxIqbzQWCeOihZr88wZNGd6SQePHMkEl6Lw+3+OGSkKUbd2eMRIiJcUgmQ== | LIG0G2q46Ffe4ghB/xiJDvzsiQ8KMPol | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:47 | 2026-03-13 23:11:47 |
| 187 | 3 | 89 | 1 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | ApTSAmRKkHYTyA69jPMWH6lmLE2ebqvUJyFeTa4I/1ICfotqeoAiSUKnt/GEmg+q3zPyq5GIniPrryRFcl5GBFwveOXwNqaFuAa5XoPR0VBk6QyTcxX18lKNXJLjLOq5F8fFF+4HHSiJOQ== | DS6HXxXWyHhDXTwGXmNNaNBQI4X2WP2n | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:47 | 2026-03-13 23:11:47 |
| 188 | 3 | 90 | 0 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | bboILRbgpeTCjNdotMuqEazZRUyCXyTgvH0Fbgpnym4qJvh61aOjmkyBP6hqesDACSNgdM2pUlPGyGuIOmRcZA9GUfE1WgEEavX2i/L6vwfPX4IXgtsMSTeKGrnBrp5iyiL4LtvnLZ6yyg== | xUwDMyGQZeOo1NVuc/f6bPnBebPXy7eo | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:47 | 2026-03-13 23:11:47 |
| 189 | 3 | 90 | 1 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | ffGQomD+ACFKNUF71JzCj6Zm8Zzyk65SN6Brh5HG2Ws8V9TJOvl5oLbs6h0E28Ga0lc24Kw4KyhDt4zDVTAqKbYFTO3DUweW2VwGoxnU6Wb5nMx/hqpg7HrsJPHmqvbVhI/iRCmV/vyMGA== | oCxozl2VVK/EkZBwWY94D6t7xsSdoYHB | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:47 | 2026-03-13 23:11:47 |
| 190 | 3 | 91 | 0 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | f8LYyq2DKgh52q+c3f/gFId/9dzIiq+Ipnvs6acuKo62OvNcfSltjLvYufUN0b9BuVwUzVpLNJgftIEkeetrJ5POAULMUbI8QM4i9M2ynl4RAI4EsPPojDPmaCcpvtruUTCWkPrg3bRU7g== | ljLeeiNU3+nL2u1+2Me23eJ9VYCJS5nW | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:47 | 2026-03-13 23:11:47 |
| 191 | 3 | 91 | 1 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | U0NmOZw8R6mLB764YmFj5Nm9T4EV6KAgkYCJwBbWzCz1K1UipDN8IOHhclnbVt8+iDQB/CXlcAbA97vsHn8kWIQan4ZzwJoFByaTMVxdd6LqmClt/9rHyGfaS+DlVLJwNkBGCBKMvNoQKA== | +FmOrXGKztbvpJQIstJQmtWxE65w6u21 | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:48 | 2026-03-13 23:11:48 |
| 192 | 3 | 91 | 2 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | 0LPIr3IYMJjlY5rwHpS+a9Q3bVRv2SuTGBbdMcobPLLVwRhmX1ALx2MSMaU+LuVb6qCDI5yHYD6QKpsu5BZHHM1MvCq1pePPPeLf7LyJ6FwLpr6hHgVgFW6dCQm4vagl6HSaYAxofeeQ8A== | hER4wrUw9LXpnWPeqsFPeMDLAXXqk5JE | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:48 | 2026-03-13 23:11:48 |
| 193 | 3 | 91 | 3 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | anM7CCXepOmNoVvVXaIQLQcqGqtIh+MeB9UIMKQJ7kaYurWxIKjPqiGnMPm49quEN1+5DkEdUh4upt+RwdeTte4T6S/dIdcobcvC1LqA1A50LA3E0pv6+z2g4OnQX2f0evj3DcVzh6crYg== | JdKQosXU9qaST0kPFeSnO7ZvA9lkXmnD | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:48 | 2026-03-13 23:11:48 |
| 194 | 3 | 91 | 4 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | 15e8pYFNIehLBIBicA+YT/K4yVZ2CPed0GpahV2JHWj9I+rraXyuHFOfRakgww42ntKVo0iDKbAGHQPVnuH2idcLk8sElbzfeMWXS+FLtMT7v50uk1cH1hh7M1lkznu+vFbtpVBHib8HoA== | 4eth8Uzucu+LNTWxMwBqiVE1m1N/D8/z | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:48 | 2026-03-13 23:11:48 |
| 195 | 3 | 91 | 5 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | oWrjuZlPpcd/iFsKaD8IX7uyjDhDuizgiqdVOLN5xo/om3hE5nOO4KEpzLB/iIsILMisqwlVZgFrTJJN91eXDFaiuIs6xeB4abvC39ZvRrwEz/2oIyat1t53CFEDXsZAUwO9qkeQmPbkRQ== | yCdM0KSIL/xWyvpufJ059hQ0th/ixQUf | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:48 | 2026-03-13 23:11:48 |
| 196 | 3 | 91 | 6 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | wm5/aEha1RdIQJFwYqFH26NNJ6f7gikOvt3LUyBcLHJzrHLaBzUpuDe9YT044GEu+9SyN4oKgF4B4aUBuX3Q2ekTAGBa0Ofl+7MokBNpOiPQ5Ej2VdahyRDVtZvv7teZGT+M9WyPgSxbWA== | u7V/q19lI34aYJ6aVX9KkcBErs+/DXkp | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:48 | 2026-03-13 23:11:48 |
| 197 | 3 | 91 | 7 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | +cbNDBjzx5TRmSnr/894T23OIls0e8hw/FlOBmTFmuyifAy6mI05xA0p4SQZqKBSxWS4a+UHb/NR/+ABGzWhW5c/WQjseQeGtS0DjbEwELpxFY58IcrIHiRoNIL4ygZTA2OpjZJXdJVJEg== | IpZUOnE9jeAhZysf4j4gKGZLRbC0YXjT | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:48 | 2026-03-13 23:11:48 |
| 198 | 3 | 91 | 8 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | wxZ9Po2l/+weyJjGryC64U3Shgd8ixbpdE3lDO+Bz/5k1W1qaO2vvie6iwh1KoZkAj1tPs+lDP2wtnkJ0b8ngsFK0zWtNbwnk3WTPmdxeRxbte7OGUxDDSoa2rdrNBNYQ/deTIsLo6Ro3Q== | ZrNLgfxQy63c4zj2dT/kYl6pZEgSbnGg | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:48 | 2026-03-13 23:11:48 |
| 199 | 3 | 91 | 9 | 6 | 51 | team_profile | 1 | Jason Johnson | visa | 9677 | 8 | 2028 | H1MfOab1zO/aLUNUA0zkyunwM2S8UaUlUSLvBQnBHWY74jEFxifbAV6lR49rxn1xBIFwC46t5VuMQgs96gE+kZ5kO1rh/W3zqmngJMOrF7m7Kd4fBAnKCzxWP1+vPJ4bIAUCDPKng4Bu7Q== | h12trsWansI9hik5i7SlVZI8X0/oFz1L | sodium_xchacha20poly1305 | v1 | admin | admin | 2026-03-13 23:11:49 | 2026-03-13 23:11:49 |