{"station": {"columns": [[0, "Station_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Annual_entry_exit", "REAL", 0, null, 0], [3, "Annual_interchanges", "REAL", 0, null, 0], [4, "Total_Passengers", "REAL", 0, null, 0], [5, "Location", "TEXT", 0, null, 0], [6, "Main_Services", "TEXT", 0, null, 0], [7, "Number_of_Platforms", "INT", 0, null, 0]], "primary_keys": ["Station_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Station_ID"]]], "check_constraints": []}, "train": {"columns": [[0, "Train_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Time", "TEXT", 0, null, 0], [3, "Service", "TEXT", 0, null, 0]], "primary_keys": ["Train_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Train_ID"]]], "check_constraints": []}, "train_station": {"columns": [[0, "Train_ID", "INT", 0, null, 1], [1, "Station_ID", "INT", 0, null, 2]], "primary_keys": ["Train_ID", "Station_ID"], "foreign_keys": [[0, 0, "station", "Station_ID", "Station_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "train", "Train_ID", "Train_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Train_ID"], [1, 1, "Station_ID"]]], "check_constraints": []}}
CREATE TABLE station (
    Station_ID INT   PRIMARY KEY,
    Name TEXT,
    Annual_entry_exit REAL,
    Annual_interchanges REAL,
    Total_Passengers REAL,
    Location TEXT,
    Main_Services TEXT,
    Number_of_Platforms INT,
    UNIQUE (Station_ID)
);

CREATE TABLE train (
    Train_ID INT   PRIMARY KEY,
    Name TEXT,
    Time TEXT,
    Service TEXT,
    UNIQUE (Train_ID)
);

CREATE TABLE train_station (
    Train_ID INT   PRIMARY KEY,
    Station_ID INT   PRIMARY KEY,
    PRIMARY KEY (Train_ID, Station_ID),
    UNIQUE (Train_ID, Station_ID),
    FOREIGN KEY (Station_ID) REFERENCES station(Station_ID),
    FOREIGN KEY (Train_ID) REFERENCES train(Train_ID)
);