[
    {
        "Tables_in_bealinspect": "categories"
    },
    {
        "Tables_in_bealinspect": "items"
    },
    {
        "Tables_in_bealinspect": "items_events"
    },
    {
        "Tables_in_bealinspect": "products_autocomplete"
    },
    {
        "Tables_in_bealinspect": "users"
    },
    {
        "Tables_in_bealinspect": "users_forget"
    },
    {
        "Tables_in_bealinspect": "users_subscriptions"
    }
][
    {
        "Table": "users",
        "Create Table": "CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_owner` int(11) NOT NULL,
  `login` varchar(100) NOT NULL,
  `password` varchar(250) NOT NULL,
  `secret` varchar(250) NOT NULL,
  `id_root_item` text NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `user_type` varchar(30) NOT NULL,
  `notification_email` int(11) NOT NULL,
  `valid_email` smallint(6) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  `superadmin` tinyint(4) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB AUTO_INCREMENT=6886 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"
    }
][
    {
        "Table": "users_forget",
        "Create Table": "CREATE TABLE `users_forget` (
  `credential` varchar(191) NOT NULL,
  `id_user` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`credential`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"
    }
][
    {
        "Table": "users_subscriptions",
        "Create Table": "CREATE TABLE `users_subscriptions` (
  `id` int(11) NOT NULL,
  `subscription` varchar(50) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `type` varchar(30) NOT NULL,
  `date_subscription_start` date NOT NULL,
  `date_subscription_end` date NOT NULL,
  `date_still_active` date NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"
    }
][
    {
        "utilisateurs_forget": "647"
    }
][
    {
        "count(*)": "781"
    }
]{
    "1000213": "Absorbeur d'\u00e9nergie",
    "1000208": "Amarrages",
    "1000228": "Autobloquants",
    "1000215": "Ancrage Provisoire Classe B",
    "1000214": "Anneaux\/Sangles\/Express",
    "1000216": "Antichute \u00e0 Rappel automatique",
    "1000217": "Antichute Mobile",
    "1000205": "Appareils m\u00e9talliques",
    "1000218": "Assureur",
    "1000219": "Bloqueur",
    "1000231": "Casques",
    "1000204": "Casques Pro",
    "1000105": "Casques Sport",
    "1000220": "Cha\u00eene de relais",
    "1000201": "Corde Semi-Statiques (Type A \/ Type B)",
    "1000227": "Cordelettes",
    "1000101": "Cordes Dynamiques",
    "1000102": "Cordes Sp\u00e9l\u00e9ologie-Canyonisme",
    "1000107": "Descendeurs",
    "1000111": "Divers",
    "1000209": "Echelle",
    "1000226": "Emerillons",
    "1000109": "Frontales",
    "1000110": "Gants",
    "1000212": "Gants Pro",
    "1000202": "Harnais Pro",
    "1000104": "Harnais sport",
    "1000225": "Kit crevasse",
    "1000203": "Longes",
    "1000224": "Longe antichute",
    "1000103": "Longes dynamiques",
    "1000113": "Longes de maintien",
    "1000229": "Mousquetons",
    "1000206": "Mousquetons et Maillons Pro",
    "1000106": "Mousquetons et Maillons Sport",
    "1000221": "Multiplicateur",
    "1000222": "Porte mat\u00e9riels",
    "1000230": "Poulies",
    "1000207": "Poulies Pro",
    "1000108": "Poulies Sport",
    "1000210": "Prot\u00e8ge-cordes",
    "1000211": "Sacs Pro",
    "1000112": "Sacs Sport",
    "318": "Harnais enfant",
    "319": "Harnais Adulte",
    "588": "Mousqueton \u00e0 vis"
}[
    {
        "id_type": "-1"
    },
    {
        "id_type": "5"
    },
    {
        "id_type": "6"
    },
    {
        "id_type": "9"
    },
    {
        "id_type": "14"
    },
    {
        "id_type": "15"
    },
    {
        "id_type": "18"
    },
    {
        "id_type": "19"
    },
    {
        "id_type": "20"
    },
    {
        "id_type": "23"
    },
    {
        "id_type": "24"
    },
    {
        "id_type": "30"
    },
    {
        "id_type": "32"
    },
    {
        "id_type": "35"
    },
    {
        "id_type": "47"
    },
    {
        "id_type": "57"
    },
    {
        "id_type": "58"
    },
    {
        "id_type": "63"
    },
    {
        "id_type": "64"
    },
    {
        "id_type": "67"
    },
    {
        "id_type": "68"
    },
    {
        "id_type": "69"
    },
    {
        "id_type": "70"
    },
    {
        "id_type": "71"
    },
    {
        "id_type": "72"
    },
    {
        "id_type": "73"
    },
    {
        "id_type": "74"
    },
    {
        "id_type": "75"
    },
    {
        "id_type": "76"
    },
    {
        "id_type": "77"
    },
    {
        "id_type": "79"
    },
    {
        "id_type": "80"
    },
    {
        "id_type": "83"
    },
    {
        "id_type": "84"
    },
    {
        "id_type": "85"
    },
    {
        "id_type": "86"
    },
    {
        "id_type": "88"
    },
    {
        "id_type": "93"
    },
    {
        "id_type": "97"
    },
    {
        "id_type": "98"
    },
    {
        "id_type": "100"
    },
    {
        "id_type": "101"
    },
    {
        "id_type": "103"
    },
    {
        "id_type": "106"
    },
    {
        "id_type": "107"
    },
    {
        "id_type": "109"
    },
    {
        "id_type": "110"
    },
    {
        "id_type": "112"
    },
    {
        "id_type": "113"
    },
    {
        "id_type": "114"
    },
    {
        "id_type": "116"
    },
    {
        "id_type": "117"
    },
    {
        "id_type": "120"
    },
    {
        "id_type": "121"
    },
    {
        "id_type": "122"
    },
    {
        "id_type": "123"
    },
    {
        "id_type": "124"
    },
    {
        "id_type": "125"
    },
    {
        "id_type": "126"
    },
    {
        "id_type": "127"
    },
    {
        "id_type": "128"
    },
    {
        "id_type": "130"
    },
    {
        "id_type": "131"
    },
    {
        "id_type": "132"
    },
    {
        "id_type": "133"
    },
    {
        "id_type": "134"
    },
    {
        "id_type": "135"
    },
    {
        "id_type": "136"
    },
    {
        "id_type": "137"
    },
    {
        "id_type": "138"
    },
    {
        "id_type": "139"
    },
    {
        "id_type": "141"
    },
    {
        "id_type": "142"
    },
    {
        "id_type": "146"
    },
    {
        "id_type": "149"
    },
    {
        "id_type": "153"
    },
    {
        "id_type": "156"
    },
    {
        "id_type": "157"
    },
    {
        "id_type": "158"
    },
    {
        "id_type": "159"
    },
    {
        "id_type": "160"
    },
    {
        "id_type": "161"
    },
    {
        "id_type": "162"
    },
    {
        "id_type": "163"
    },
    {
        "id_type": "164"
    },
    {
        "id_type": "165"
    },
    {
        "id_type": "166"
    },
    {
        "id_type": "167"
    },
    {
        "id_type": "168"
    },
    {
        "id_type": "170"
    },
    {
        "id_type": "171"
    },
    {
        "id_type": "174"
    },
    {
        "id_type": "175"
    },
    {
        "id_type": "176"
    },
    {
        "id_type": "178"
    },
    {
        "id_type": "179"
    },
    {
        "id_type": "180"
    },
    {
        "id_type": "182"
    },
    {
        "id_type": "183"
    },
    {
        "id_type": "184"
    },
    {
        "id_type": "189"
    },
    {
        "id_type": "191"
    },
    {
        "id_type": "192"
    },
    {
        "id_type": "193"
    },
    {
        "id_type": "194"
    },
    {
        "id_type": "195"
    },
    {
        "id_type": "196"
    },
    {
        "id_type": "197"
    },
    {
        "id_type": "198"
    },
    {
        "id_type": "199"
    },
    {
        "id_type": "203"
    },
    {
        "id_type": "204"
    },
    {
        "id_type": "205"
    },
    {
        "id_type": "209"
    },
    {
        "id_type": "210"
    },
    {
        "id_type": "212"
    },
    {
        "id_type": "213"
    },
    {
        "id_type": "215"
    },
    {
        "id_type": "222"
    },
    {
        "id_type": "223"
    },
    {
        "id_type": "224"
    },
    {
        "id_type": "225"
    },
    {
        "id_type": "230"
    },
    {
        "id_type": "231"
    },
    {
        "id_type": "232"
    },
    {
        "id_type": "234"
    },
    {
        "id_type": "240"
    },
    {
        "id_type": "241"
    },
    {
        "id_type": "244"
    },
    {
        "id_type": "245"
    },
    {
        "id_type": "247"
    },
    {
        "id_type": "250"
    },
    {
        "id_type": "251"
    },
    {
        "id_type": "256"
    },
    {
        "id_type": "263"
    },
    {
        "id_type": "264"
    },
    {
        "id_type": "267"
    },
    {
        "id_type": "268"
    },
    {
        "id_type": "270"
    },
    {
        "id_type": "271"
    },
    {
        "id_type": "272"
    },
    {
        "id_type": "273"
    },
    {
        "id_type": "276"
    },
    {
        "id_type": "279"
    },
    {
        "id_type": "280"
    },
    {
        "id_type": "281"
    },
    {
        "id_type": "282"
    },
    {
        "id_type": "287"
    },
    {
        "id_type": "288"
    },
    {
        "id_type": "289"
    },
    {
        "id_type": "290"
    },
    {
        "id_type": "292"
    },
    {
        "id_type": "293"
    },
    {
        "id_type": "294"
    },
    {
        "id_type": "295"
    },
    {
        "id_type": "296"
    },
    {
        "id_type": "298"
    },
    {
        "id_type": "300"
    },
    {
        "id_type": "304"
    },
    {
        "id_type": "305"
    },
    {
        "id_type": "306"
    },
    {
        "id_type": "307"
    },
    {
        "id_type": "309"
    },
    {
        "id_type": "310"
    },
    {
        "id_type": "311"
    },
    {
        "id_type": "312"
    },
    {
        "id_type": "313"
    },
    {
        "id_type": "314"
    },
    {
        "id_type": "316"
    },
    {
        "id_type": "320"
    },
    {
        "id_type": "321"
    },
    {
        "id_type": "322"
    },
    {
        "id_type": "323"
    },
    {
        "id_type": "328"
    },
    {
        "id_type": "335"
    },
    {
        "id_type": "336"
    },
    {
        "id_type": "337"
    },
    {
        "id_type": "338"
    },
    {
        "id_type": "340"
    },
    {
        "id_type": "341"
    },
    {
        "id_type": "342"
    },
    {
        "id_type": "344"
    },
    {
        "id_type": "345"
    },
    {
        "id_type": "346"
    },
    {
        "id_type": "347"
    },
    {
        "id_type": "348"
    },
    {
        "id_type": "349"
    },
    {
        "id_type": "350"
    },
    {
        "id_type": "351"
    },
    {
        "id_type": "352"
    },
    {
        "id_type": "353"
    },
    {
        "id_type": "354"
    },
    {
        "id_type": "355"
    },
    {
        "id_type": "357"
    },
    {
        "id_type": "358"
    },
    {
        "id_type": "359"
    },
    {
        "id_type": "360"
    },
    {
        "id_type": "361"
    },
    {
        "id_type": "362"
    },
    {
        "id_type": "363"
    },
    {
        "id_type": "364"
    },
    {
        "id_type": "365"
    },
    {
        "id_type": "366"
    },
    {
        "id_type": "367"
    },
    {
        "id_type": "368"
    },
    {
        "id_type": "369"
    },
    {
        "id_type": "373"
    },
    {
        "id_type": "382"
    },
    {
        "id_type": "383"
    },
    {
        "id_type": "384"
    },
    {
        "id_type": "386"
    },
    {
        "id_type": "387"
    },
    {
        "id_type": "389"
    },
    {
        "id_type": "390"
    },
    {
        "id_type": "395"
    },
    {
        "id_type": "396"
    },
    {
        "id_type": "405"
    },
    {
        "id_type": "420"
    },
    {
        "id_type": "422"
    },
    {
        "id_type": "423"
    },
    {
        "id_type": "424"
    },
    {
        "id_type": "425"
    },
    {
        "id_type": "426"
    },
    {
        "id_type": "427"
    },
    {
        "id_type": "428"
    },
    {
        "id_type": "429"
    },
    {
        "id_type": "432"
    },
    {
        "id_type": "435"
    },
    {
        "id_type": "436"
    },
    {
        "id_type": "437"
    },
    {
        "id_type": "438"
    },
    {
        "id_type": "439"
    },
    {
        "id_type": "440"
    },
    {
        "id_type": "441"
    },
    {
        "id_type": "444"
    },
    {
        "id_type": "451"
    },
    {
        "id_type": "452"
    },
    {
        "id_type": "453"
    },
    {
        "id_type": "454"
    },
    {
        "id_type": "457"
    },
    {
        "id_type": "458"
    },
    {
        "id_type": "459"
    },
    {
        "id_type": "460"
    },
    {
        "id_type": "461"
    },
    {
        "id_type": "463"
    },
    {
        "id_type": "464"
    },
    {
        "id_type": "465"
    },
    {
        "id_type": "466"
    },
    {
        "id_type": "469"
    },
    {
        "id_type": "470"
    },
    {
        "id_type": "471"
    },
    {
        "id_type": "472"
    },
    {
        "id_type": "473"
    },
    {
        "id_type": "474"
    },
    {
        "id_type": "477"
    },
    {
        "id_type": "478"
    },
    {
        "id_type": "479"
    },
    {
        "id_type": "481"
    },
    {
        "id_type": "482"
    },
    {
        "id_type": "483"
    },
    {
        "id_type": "484"
    },
    {
        "id_type": "487"
    },
    {
        "id_type": "488"
    },
    {
        "id_type": "489"
    },
    {
        "id_type": "492"
    },
    {
        "id_type": "493"
    },
    {
        "id_type": "494"
    },
    {
        "id_type": "502"
    },
    {
        "id_type": "503"
    },
    {
        "id_type": "504"
    },
    {
        "id_type": "505"
    },
    {
        "id_type": "506"
    },
    {
        "id_type": "507"
    },
    {
        "id_type": "508"
    },
    {
        "id_type": "509"
    },
    {
        "id_type": "510"
    },
    {
        "id_type": "511"
    },
    {
        "id_type": "512"
    },
    {
        "id_type": "513"
    },
    {
        "id_type": "514"
    },
    {
        "id_type": "515"
    },
    {
        "id_type": "516"
    },
    {
        "id_type": "517"
    },
    {
        "id_type": "518"
    },
    {
        "id_type": "524"
    },
    {
        "id_type": "525"
    },
    {
        "id_type": "526"
    },
    {
        "id_type": "527"
    },
    {
        "id_type": "529"
    },
    {
        "id_type": "530"
    },
    {
        "id_type": "533"
    },
    {
        "id_type": "534"
    },
    {
        "id_type": "535"
    },
    {
        "id_type": "536"
    },
    {
        "id_type": "537"
    },
    {
        "id_type": "538"
    },
    {
        "id_type": "540"
    },
    {
        "id_type": "542"
    },
    {
        "id_type": "544"
    },
    {
        "id_type": "548"
    },
    {
        "id_type": "549"
    },
    {
        "id_type": "550"
    },
    {
        "id_type": "551"
    },
    {
        "id_type": "552"
    },
    {
        "id_type": "561"
    },
    {
        "id_type": "562"
    },
    {
        "id_type": "563"
    },
    {
        "id_type": "564"
    },
    {
        "id_type": "566"
    },
    {
        "id_type": "567"
    },
    {
        "id_type": "570"
    },
    {
        "id_type": "571"
    },
    {
        "id_type": "572"
    },
    {
        "id_type": "573"
    },
    {
        "id_type": "574"
    },
    {
        "id_type": "578"
    },
    {
        "id_type": "581"
    },
    {
        "id_type": "582"
    },
    {
        "id_type": "583"
    },
    {
        "id_type": "584"
    },
    {
        "id_type": "585"
    },
    {
        "id_type": "586"
    },
    {
        "id_type": "587"
    },
    {
        "id_type": "588"
    },
    {
        "id_type": "589"
    },
    {
        "id_type": "590"
    },
    {
        "id_type": "592"
    },
    {
        "id_type": "593"
    },
    {
        "id_type": "594"
    },
    {
        "id_type": "595"
    },
    {
        "id_type": "597"
    },
    {
        "id_type": "599"
    },
    {
        "id_type": "600"
    },
    {
        "id_type": "601"
    },
    {
        "id_type": "602"
    },
    {
        "id_type": "603"
    },
    {
        "id_type": "604"
    },
    {
        "id_type": "606"
    },
    {
        "id_type": "610"
    },
    {
        "id_type": "611"
    },
    {
        "id_type": "615"
    },
    {
        "id_type": "616"
    },
    {
        "id_type": "617"
    },
    {
        "id_type": "618"
    },
    {
        "id_type": "619"
    },
    {
        "id_type": "621"
    },
    {
        "id_type": "622"
    },
    {
        "id_type": "627"
    },
    {
        "id_type": "628"
    },
    {
        "id_type": "629"
    },
    {
        "id_type": "630"
    },
    {
        "id_type": "631"
    },
    {
        "id_type": "632"
    },
    {
        "id_type": "633"
    },
    {
        "id_type": "634"
    },
    {
        "id_type": "635"
    },
    {
        "id_type": "636"
    },
    {
        "id_type": "637"
    },
    {
        "id_type": "638"
    },
    {
        "id_type": "639"
    },
    {
        "id_type": "640"
    },
    {
        "id_type": "641"
    },
    {
        "id_type": "642"
    }
]<br>