{"people": {"columns": [[0, "People_ID", "INT", 0, null, 1], [1, "Age", "INT", 0, null, 0], [2, "Name", "TEXT", 0, null, 0], [3, "Nationality", "TEXT", 0, null, 0], [4, "Graduation_College", "TEXT", 0, null, 0]], "primary_keys": ["People_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "People_ID"]]], "check_constraints": []}, "company": {"columns": [[0, "Company_ID", "REAL", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Headquarters", "TEXT", 0, null, 0], [3, "Industry", "TEXT", 0, null, 0], [4, "Sales_in_Billion", "REAL", 0, null, 0], [5, "Profits_in_Billion", "REAL", 0, null, 0], [6, "Assets_in_Billion", "REAL", 0, null, 0], [7, "Market_Value_in_Billion", "REAL", 0, null, 0]], "primary_keys": ["Company_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Company_ID"]]], "check_constraints": []}, "employment": {"columns": [[0, "Company_ID", "INT", 0, null, 1], [1, "People_ID", "INT", 0, null, 2], [2, "Year_working", "INT", 0, null, 0]], "primary_keys": ["Company_ID", "People_ID"], "foreign_keys": [[0, 0, "people", "People_ID", "People_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "company", "Company_ID", "Company_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Company_ID"], [1, 1, "People_ID"]]], "check_constraints": []}}
CREATE TABLE people (
    People_ID INT   PRIMARY KEY,
    Age INT,
    Name TEXT,
    Nationality TEXT,
    Graduation_College TEXT,
    UNIQUE (People_ID)
);

CREATE TABLE company (
    Company_ID REAL   PRIMARY KEY,
    Name TEXT,
    Headquarters TEXT,
    Industry TEXT,
    Sales_in_Billion REAL,
    Profits_in_Billion REAL,
    Assets_in_Billion REAL,
    Market_Value_in_Billion REAL,
    UNIQUE (Company_ID)
);

CREATE TABLE employment (
    Company_ID INT   PRIMARY KEY,
    People_ID INT   PRIMARY KEY,
    Year_working INT,
    PRIMARY KEY (Company_ID, People_ID),
    UNIQUE (Company_ID, People_ID),
    FOREIGN KEY (People_ID) REFERENCES people(People_ID),
    FOREIGN KEY (Company_ID) REFERENCES company(Company_ID)
);