=== tbf_customers ===
CREATE TABLE `tbf_customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `password_hash` varchar(255) DEFAULT NULL,
  `google_id` varchar(255) DEFAULT NULL,
  `otp` varchar(10) DEFAULT NULL,
  `otp_expires` datetime DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` enum('M','F','O') DEFAULT NULL,
  `address_line` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `pincode` varchar(10) DEFAULT NULL,
  `passport_no` varchar(30) DEFAULT NULL,
  `passport_expiry` date DEFAULT NULL,
  `preferred_seat` enum('WINDOW','MIDDLE','AISLE') DEFAULT NULL,
  `preferred_meal` enum('VEG','NON_VEG','JAIN','VEGAN','NO_PREF') DEFAULT 'NO_PREF',
  `total_bookings` int(11) DEFAULT 0,
  `total_spent` decimal(12,2) DEFAULT 0.00,
  `avatar_url` varchar(500) DEFAULT NULL,
  `last_login_at` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `idx_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

=== tbf_b2b_agencies ===
CREATE TABLE `tbf_b2b_agencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agency_name` varchar(150) NOT NULL,
  `contact_person` varchar(100) NOT NULL,
  `email` varchar(190) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `pan_number` varchar(20) DEFAULT NULL,
  `gst_number` varchar(50) DEFAULT NULL,
  `wallet_balance` decimal(10,2) DEFAULT 0.00,
  `markup_type` enum('percentage','fixed') DEFAULT 'percentage',
  `markup_value` decimal(10,2) DEFAULT 0.00,
  `status` enum('pending','active','suspended') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

=== tbf_b2b_agents ===
NOT FOUND

=== tbf_b2b_wallet_transactions ===
NOT FOUND

=== tbf_b2c_users ===
CREATE TABLE `tbf_b2c_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(190) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `user_type` enum('b2c','corporate') DEFAULT 'b2c',
  `company_name` varchar(150) DEFAULT NULL,
  `gst_number` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

=== holiday_leads ===
CREATE TABLE `holiday_leads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_id` int(11) DEFAULT NULL,
  `package_title` varchar(500) DEFAULT NULL,
  `destination` varchar(100) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(20) NOT NULL,
  `travel_date` date DEFAULT NULL,
  `num_adults` int(11) DEFAULT 2,
  `num_children` int(11) DEFAULT 0,
  `message` text DEFAULT NULL,
  `source` varchar(50) DEFAULT 'website',
  `status` varchar(20) DEFAULT 'new',
  `assigned_to` varchar(100) DEFAULT '',
  `priority` enum('low','medium','high','urgent') DEFAULT 'medium',
  `follow_up_date` datetime DEFAULT NULL,
  `last_contacted` datetime DEFAULT NULL,
  `lead_score` int(11) DEFAULT 0,
  `tags` varchar(500) DEFAULT '',
  `utm_source` varchar(100) DEFAULT '',
  `utm_medium` varchar(100) DEFAULT '',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `auto_contacted` tinyint(4) DEFAULT 0,
  `intent_score` int(11) DEFAULT 0,
  `followup_24h` tinyint(4) DEFAULT 0,
  `followup_72h` tinyint(4) DEFAULT 0,
  `wa_deeplink` text DEFAULT NULL,
  `auto_messages` text DEFAULT NULL,
  `closing_tier` varchar(20) DEFAULT NULL,
  `closing_offer_at` datetime DEFAULT NULL,
  `closing_wa_link` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `package_id` (`package_id`),
  KEY `idx_priority` (`priority`),
  KEY `idx_followup` (`follow_up_date`),
  CONSTRAINT `holiday_leads_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

=== agents ===
NOT FOUND

=== b2b_partners ===
NOT FOUND