{"roller_coaster": {"columns": [[0, "Roller_Coaster_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Park", "TEXT", 0, null, 0], [3, "Country_ID", "INT", 0, null, 0], [4, "Length", "REAL", 0, null, 0], [5, "Height", "REAL", 0, null, 0], [6, "Speed", "TEXT", 0, null, 0], [7, "Opened", "TEXT", 0, null, 0], [8, "Status", "TEXT", 0, null, 0]], "primary_keys": ["Roller_Coaster_ID"], "foreign_keys": [[0, 0, "country", "Country_ID", "Country_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Roller_Coaster_ID"]]], "check_constraints": []}, "country": {"columns": [[0, "Country_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Population", "INT", 0, null, 0], [3, "Area", "INT", 0, null, 0], [4, "Languages", "TEXT", 0, null, 0]], "primary_keys": ["Country_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Country_ID"]]], "check_constraints": []}}
CREATE TABLE roller_coaster (
    Roller_Coaster_ID INT   PRIMARY KEY,
    Name TEXT,
    Park TEXT,
    Country_ID INT,
    Length REAL,
    Height REAL,
    Speed TEXT,
    Opened TEXT,
    Status TEXT,
    UNIQUE (Roller_Coaster_ID),
    FOREIGN KEY (Country_ID) REFERENCES country(Country_ID)
);

CREATE TABLE country (
    Country_ID INT   PRIMARY KEY,
    Name TEXT,
    Population INT,
    Area INT,
    Languages TEXT,
    UNIQUE (Country_ID)
);