JSON to SQL converter

Your JSON

xxxxxxxxxx
 
{
  "countries": [
    {
      "name": "USA",
      "id": 2,
      "population": 350
    },
    {
      "name": "Germany",
      "id": 5,
      "population": 80
    },
    {
      "name": "Japan",
      "id": 9,
      "population": 140
    }
  ]
}

Your SQL

1CREATE TABLE Model (
2  id TEXT,
3  PRIMARY KEY (id)
4);
5
6CREATE TABLE Model_countries (
7  Model_id TEXT,
8  name TEXT,
9  id INT,
10  population INT,
11  PRIMARY KEY (id),
12  FOREIGN KEY (Model_id) REFERENCES Model(id)
13);