{"company": {"columns": [[0, "Company_ID", "INT", 0, null, 1], [1, "Rank", "INT", 0, null, 0], [2, "Company", "TEXT", 0, null, 0], [3, "Headquarters", "TEXT", 0, null, 0], [4, "Main_Industry", "TEXT", 0, null, 0], [5, "Sales_billion", "REAL", 0, null, 0], [6, "Profits_billion", "REAL", 0, null, 0], [7, "Assets_billion", "REAL", 0, null, 0], [8, "Market_Value", "REAL", 0, null, 0]], "primary_keys": ["Company_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Company_ID"]]], "check_constraints": []}, "gas_station": {"columns": [[0, "Station_ID", "INT", 0, null, 1], [1, "Open_Year", "INT", 0, null, 0], [2, "Location", "TEXT", 0, null, 0], [3, "Manager_Name", "TEXT", 0, null, 0], [4, "Vice_Manager_Name", "TEXT", 0, null, 0], [5, "Representative_Name", "TEXT", 0, null, 0]], "primary_keys": ["Station_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Station_ID"]]], "check_constraints": []}, "station_company": {"columns": [[0, "Station_ID", "INT", 0, null, 1], [1, "Company_ID", "INT", 0, null, 2], [2, "Rank_of_the_Year", "INT", 0, null, 0]], "primary_keys": ["Station_ID", "Company_ID"], "foreign_keys": [[0, 0, "company", "Company_ID", "Company_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "gas_station", "Station_ID", "Station_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Station_ID"], [1, 1, "Company_ID"]]], "check_constraints": []}}
CREATE TABLE company (
    Company_ID INT   PRIMARY KEY,
    Rank INT,
    Company TEXT,
    Headquarters TEXT,
    Main_Industry TEXT,
    Sales_billion REAL,
    Profits_billion REAL,
    Assets_billion REAL,
    Market_Value REAL,
    UNIQUE (Company_ID)
);

CREATE TABLE gas_station (
    Station_ID INT   PRIMARY KEY,
    Open_Year INT,
    Location TEXT,
    Manager_Name TEXT,
    Vice_Manager_Name TEXT,
    Representative_Name TEXT,
    UNIQUE (Station_ID)
);

CREATE TABLE station_company (
    Station_ID INT   PRIMARY KEY,
    Company_ID INT   PRIMARY KEY,
    Rank_of_the_Year INT,
    PRIMARY KEY (Station_ID, Company_ID),
    UNIQUE (Station_ID, Company_ID),
    FOREIGN KEY (Company_ID) REFERENCES company(Company_ID),
    FOREIGN KEY (Station_ID) REFERENCES gas_station(Station_ID)
);