CREATE TABLE `clients` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `chat_id` INT NOT NULL, 
  `type_id` INT NOT NULL,
  `sex_id` INT NOT NULL
  `age` VARCHAR(15),
  `schedule` VARCHAR(50),
  `category` VARCHAR(64),
  `country_id` INT NOT NULL,
  `city_id` INT NOT NULL,
  `user_id`BIGINT NOT NULL,
  `additional_info` VARCHAR(255) DEFAULT NULL,  
  `is_bot` BOOLEAN NOT NULL DEFAULT FALSE,
  `price_type` VARCHAR(50) DEFAULT NULL,
  `price_value` INT NOT NULL DEFAULT 0,      
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `clients` 
(`chat_id`, `type_id`, `age`, `schedule`, `category`, `country_id`, `city_id`, `user_id`, `additional_info`, `is_bot`, `price_type`, `price_value`) 
VALUES
(7657656, 1234567, '45', 'evening', 'nanny', 8234567, 9234567, 5464567, 'Looking for experienced caregiver', false, 'hourly', 1000),
(8234567, 2345678, '32', 'morning', 'babysitter', 7234567, 8234567, 6234567, 'Need evening care', false, 'monthly', 2500),
(9234567, 3456789, '28', 'full-day', 'tutor', 6234567, 7234567, 7234567, 'Math tutor needed', false, 'hourly', 800),
(1234567, 4567890, '55', 'partially', 'nanny', 5234567, 6234567, 8234567, 'English speaking preferred', false, 'monthly', 3000),
(2345678, 5678901, '41', 'evening', 'babysitter', 4234567, 5234567, 9234567, 'Special needs experience', false, 'hourly', 1200),
(3456789, 6789012, '38', 'morning', 'tutor', 3234567, 4234567, 1234567, 'Science and arts focus', false, 'hourly', 900),
(4567890, 7890123, '29', 'full-day', 'nanny', 2234567, 3234567, 2234567, 'Driver license required', false, 'monthly', 3500),
(5678901, 8901234, '51', 'partially', 'babysitter', 1234567, 2234567, 3234567, 'First aid certified needed', false, 'hourly', 1100),
(6789012, 9012345, '35', 'evening', 'tutor', 9234567, 1234567, 4234567, 'Language teaching experience', false, 'hourly', 950),
(7890123, 1123456, '44', 'morning', 'nanny', 8234567, 9234567, 5234567, 'Cooking skills required', false, 'monthly', 2800);

-- category table ? or tag table ot inprove  intelligence searching

/*

{
  "status": "success",
  "data": {
    "items": [
      {
        "id": 1,
        "chat_id": 7657656,
        "type_id": 1234567,
        "age": "45",
        "schedule": "evening",
        "category": "nanny",
        "country_id": 8234567,
        "city_id": 9234567,
        "user_id": 5464567,
        "additional_info": "Looking for experienced caregiver",
        "is_bot": false,
        "price_type": "hourly",
        "price_value": 1000,
        "created_at": "2025-09-10T10:00:00Z",
        "updated_at": "2025-09-10T10:00:00Z"
      },
      {
        "id": 2,
        "chat_id": 8234567,
        "type_id": 2345678,
        "age": "32",
        "schedule": "morning",
        "category": "babysitter",
        "country_id": 7234567,
        "city_id": 8234567,
        "user_id": 6234567,
        "additional_info": "Need evening care",
        "is_bot": false,
        "price_type": "monthly",
        "price_value": 2500,
        "created_at": "2025-09-10T10:00:00Z",
        "updated_at": "2025-09-10T10:00:00Z"
      },
      {
        "id": 3,
        "chat_id": 9234567,
        "type_id": 3456789,
        "age": "28",
        "schedule": "full-day",
        "category": "tutor",
        "country_id": 6234567,
        "city_id": 7234567,
        "user_id": 7234567,
        "additional_info": "Math tutor needed",
        "is_bot": false,
        "price_type": "hourly",
        "price_value": 800,
        "created_at": "2025-09-10T10:00:00Z",
        "updated_at": "2025-09-10T10:00:00Z"
      }
    ],
    "pagination": {
      "total": 10,
      "page": 1,
      "limit": 3,
      "hasMore": true
    }
  }
}
*/