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: team_manager_login_tokens
6 rowsStructure
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | NULL | auto_increment |
| varchar(255) | NO | MUL | NULL | ||
| token_hash | char(64) | NO | UNI | NULL | |
| otp_hash | char(64) | NO | NULL | ||
| otp_attempts | smallint unsigned | NO | 0 | ||
| expires_at | datetime | NO | MUL | NULL | |
| used_at | datetime | YES | NULL | ||
| ip_address | varchar(64) | YES | NULL | ||
| created_at | timestamp | YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
Sample Data (First 20 rows)
| id | token_hash | otp_hash | otp_attempts | expires_at | used_at | ip_address | created_at | |
|---|---|---|---|---|---|---|---|---|
| 1 | [email protected] | bdb68d625d202b4a0698220d193f85b46051c08edde13570d30f9972d143ef7d | a52587fb039b4c8fb8a8f33e4a3d2e355da17a6f0309b0c1bda0187405442a3f | 0 | 2026-06-16 20:30:51 | 2026-06-16 19:21:05 | 127.0.0.1 | 2026-06-16 19:15:52 |
| 2 | [email protected] | e6714167c4a313515e341da983564cecea662b4e9b504f887b10d563babc3dde | 873986d822a399ac75aa91330b924f6ad3798931f62722e0d2e73a8524ea7071 | 0 | 2026-06-17 04:41:06 | 2026-06-17 03:27:00 | 127.0.0.1 | 2026-06-17 03:26:06 |
| 3 | [email protected] | 0d72cea9dcb7955eb960dc1f43fbd0071f19e7a34e215d7cb4bb18f2fde00b76 | 0ee20b34b7fa3d8c88c6591fff3a1677e29fd80cdf2131e9e70cd9226f5b6401 | 0 | 2026-06-17 06:11:52 | 2026-06-17 04:57:23 | 127.0.0.1 | 2026-06-17 04:56:52 |
| 4 | [email protected] | 9b0d85906a8dab36b861882819746da55c1db6a9185032b0080c76ef7211b71d | 69a622e7112dd76c7b39b1a3721738260605cf2686683d72bf89b569f21e41a6 | 0 | 2026-06-17 07:07:13 | 2026-06-17 05:52:24 | 162.158.146.239 | 2026-06-17 05:52:13 |
| 5 | [email protected] | ed7f2fb15ea832bea4ca4b0386c935672745f3bba588eafbac56450085a3ecd5 | 5973c8ab00c483473091f1ab5f6b4fef726e2402071dbabe93856036fcb6fcd1 | 0 | 2026-06-23 16:30:25 | 2026-06-23 15:16:35 | 162.158.146.239 | 2026-06-23 15:15:25 |
| 6 | [email protected] | 093f1be4a4e5f1a29be1f267dab7256b28f8a2dc4c451b44f19d72ab09db098a | 0f7b201a8523e1201ccf787af0ee665bbc90253d5df7bc294009b131d16db7da | 0 | 2026-06-25 11:30:09 | 2026-06-25 10:15:34 | 162.158.146.238 | 2026-06-25 10:15:09 |