CREATE TABLE reservations (
  idReservation               INT            NOT NULL,
  idEntity                    INT            NOT NULL,
  name                        VARCHAR(255)   NULL,
  mainFlag BOOLEAN,                -- ← aqui
  phone                       VARCHAR(50)    NULL,
  mail                        VARCHAR(255)   NULL,
  zipCode                     VARCHAR(20)    NULL,
  addressDetails              VARCHAR(255)   NULL,
  address                     VARCHAR(255)   NULL,
  neighborhood                VARCHAR(100)   NULL,
  number                      VARCHAR(20)    NULL,
  city                        VARCHAR(100)   NULL,
  country                     VARCHAR(100)   NULL,
  stateName                   VARCHAR(100)   NULL,
  stateCode                   VARCHAR(10)    NULL,
  federalRegistrationNumber   VARCHAR(50)    NULL,
  documentType                INT            NULL,
  checkIn                     DATETIME       NULL,
  checkOut                    DATETIME       NULL,
  dateAdd                     DATETIME       NULL,
  dateUp                      DATETIME       NULL,
  status                      INT            NULL,
  integrator                  VARCHAR(100)   NULL,
  channel                     VARCHAR(100)   NULL,
  raw_json                    JSON           NULL,
  PRIMARY KEY (idReservation, idEntity)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
