{"race": {"columns": [[0, "Race_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Class", "TEXT", 0, null, 0], [3, "Date", "TEXT", 0, null, 0], [4, "Track_ID", "TEXT", 0, null, 0]], "primary_keys": ["Race_ID"], "foreign_keys": [[0, 0, "track", "Track_ID", "Track_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Race_ID"]]], "check_constraints": []}, "track": {"columns": [[0, "Track_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Location", "TEXT", 0, null, 0], [3, "Seating", "REAL", 0, null, 0], [4, "Year_Opened", "REAL", 0, null, 0]], "primary_keys": ["Track_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Track_ID"]]], "check_constraints": []}}
CREATE TABLE race (
    Race_ID INT   PRIMARY KEY,
    Name TEXT,
    Class TEXT,
    Date TEXT,
    Track_ID TEXT,
    UNIQUE (Race_ID),
    FOREIGN KEY (Track_ID) REFERENCES track(Track_ID)
);

CREATE TABLE track (
    Track_ID INT   PRIMARY KEY,
    Name TEXT,
    Location TEXT,
    Seating REAL,
    Year_Opened REAL,
    UNIQUE (Track_ID)
);