{"works_on": {"columns": [[0, "Essn", "INTEGER", 0, null, 1], [1, "Pno", "INTEGER", 0, null, 2], [2, "Hours", "REAL", 0, null, 0]], "primary_keys": ["Essn", "Pno"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Essn"], [1, 1, "Pno"]]], "check_constraints": []}, "employee": {"columns": [[0, "Fname", "TEXT", 0, null, 0], [1, "Minit", "TEXT", 0, null, 0], [2, "Lname", "TEXT", 0, null, 0], [3, "Ssn", "INTEGER", 0, null, 1], [4, "Bdate", "TEXT", 0, null, 0], [5, "Address", "TEXT", 0, null, 0], [6, "Sex", "TEXT", 0, null, 0], [7, "Salary", "INTEGER", 0, null, 0], [8, "Super_ssn", "INTEGER", 0, null, 0], [9, "Dno", "INTEGER", 0, null, 0]], "primary_keys": ["Ssn"], "foreign_keys": [], "unique_constraints": [], "check_constraints": []}, "department": {"columns": [[0, "Dname", "TEXT", 0, null, 0], [1, "Dnumber", "INTEGER", 0, null, 1], [2, "Mgr_ssn", "INTEGER", 0, null, 0], [3, "Mgr_start_date", "TEXT", 0, null, 0]], "primary_keys": ["Dnumber"], "foreign_keys": [], "unique_constraints": [], "check_constraints": []}, "project": {"columns": [[0, "Pname", "TEXT", 0, null, 0], [1, "Pnumber", "INTEGER", 0, null, 1], [2, "Plocation", "TEXT", 0, null, 0], [3, "Dnum", "INTEGER", 0, null, 0]], "primary_keys": ["Pnumber"], "foreign_keys": [], "unique_constraints": [], "check_constraints": []}, "dependent": {"columns": [[0, "Essn", "INTEGER", 0, null, 1], [1, "Dependent_name", "TEXT", 0, null, 2], [2, "Sex", "TEXT", 0, null, 0], [3, "Bdate", "TEXT", 0, null, 0], [4, "Relationship", "TEXT", 0, null, 0]], "primary_keys": ["Essn", "Dependent_name"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Essn"], [1, 1, "Dependent_name"]]], "check_constraints": []}, "dept_locations": {"columns": [[0, "Dnumber", "INTEGER", 0, null, 1], [1, "Dlocation", "TEXT", 0, null, 2]], "primary_keys": ["Dnumber", "Dlocation"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Dnumber"], [1, 1, "Dlocation"]]], "check_constraints": []}}
CREATE TABLE works_on (
    Essn INTEGER   PRIMARY KEY,
    Pno INTEGER   PRIMARY KEY,
    Hours REAL,
    PRIMARY KEY (Essn, Pno),
    UNIQUE (Essn, Pno)
);

CREATE TABLE employee (
    Fname TEXT,
    Minit TEXT,
    Lname TEXT,
    Ssn INTEGER   PRIMARY KEY,
    Bdate TEXT,
    Address TEXT,
    Sex TEXT,
    Salary INTEGER,
    Super_ssn INTEGER,
    Dno INTEGER
);

CREATE TABLE department (
    Dname TEXT,
    Dnumber INTEGER   PRIMARY KEY,
    Mgr_ssn INTEGER,
    Mgr_start_date TEXT
);

CREATE TABLE project (
    Pname TEXT,
    Pnumber INTEGER   PRIMARY KEY,
    Plocation TEXT,
    Dnum INTEGER
);

CREATE TABLE dependent (
    Essn INTEGER   PRIMARY KEY,
    Dependent_name TEXT   PRIMARY KEY,
    Sex TEXT,
    Bdate TEXT,
    Relationship TEXT,
    PRIMARY KEY (Essn, Dependent_name),
    UNIQUE (Essn, Dependent_name)
);

CREATE TABLE dept_locations (
    Dnumber INTEGER   PRIMARY KEY,
    Dlocation TEXT   PRIMARY KEY,
    PRIMARY KEY (Dnumber, Dlocation),
    UNIQUE (Dnumber, Dlocation)
);