{"employee": {"columns": [[0, "Employee_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Age", "INT", 0, null, 0], [3, "City", "TEXT", 0, null, 0]], "primary_keys": ["Employee_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Employee_ID"]]], "check_constraints": []}, "shop": {"columns": [[0, "Shop_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Location", "TEXT", 0, null, 0], [3, "District", "TEXT", 0, null, 0], [4, "Number_products", "INT", 0, null, 0], [5, "Manager_name", "TEXT", 0, null, 0]], "primary_keys": ["Shop_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Shop_ID"]]], "check_constraints": []}, "hiring": {"columns": [[0, "Shop_ID", "INT", 0, null, 0], [1, "Employee_ID", "INT", 0, null, 1], [2, "Start_from", "TEXT", 0, null, 0], [3, "Is_full_time", "bool", 0, null, 0]], "primary_keys": ["Employee_ID"], "foreign_keys": [[0, 0, "employee", "Employee_ID", "Employee_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "shop", "Shop_ID", "Shop_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 1, "Employee_ID"]]], "check_constraints": []}, "evaluation": {"columns": [[0, "Employee_ID", "TEXT", 0, null, 1], [1, "Year_awarded", "TEXT", 0, null, 2], [2, "Bonus", "REAL", 0, null, 0]], "primary_keys": ["Employee_ID", "Year_awarded"], "foreign_keys": [[0, 0, "employee", "Employee_ID", "Employee_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Employee_ID"], [1, 1, "Year_awarded"]]], "check_constraints": []}}
CREATE TABLE employee (
    Employee_ID INT   PRIMARY KEY,
    Name TEXT,
    Age INT,
    City TEXT,
    UNIQUE (Employee_ID)
);

CREATE TABLE shop (
    Shop_ID INT   PRIMARY KEY,
    Name TEXT,
    Location TEXT,
    District TEXT,
    Number_products INT,
    Manager_name TEXT,
    UNIQUE (Shop_ID)
);

CREATE TABLE hiring (
    Shop_ID INT,
    Employee_ID INT   PRIMARY KEY,
    Start_from TEXT,
    Is_full_time bool,
    UNIQUE (Employee_ID),
    FOREIGN KEY (Employee_ID) REFERENCES employee(Employee_ID),
    FOREIGN KEY (Shop_ID) REFERENCES shop(Shop_ID)
);

CREATE TABLE evaluation (
    Employee_ID TEXT   PRIMARY KEY,
    Year_awarded TEXT   PRIMARY KEY,
    Bonus REAL,
    PRIMARY KEY (Employee_ID, Year_awarded),
    UNIQUE (Employee_ID, Year_awarded),
    FOREIGN KEY (Employee_ID) REFERENCES employee(Employee_ID)
);