CREATE TABLE location
(
    locationID   INTEGER
        constraint location_pk
            primary key,
    locationcity TEXT,
    address      TEXT,
    state        TEXT,
    zipcode      INTEGER,
    officephone  TEXT
);
location
CREATE TABLE position
(
    positionID        INTEGER
        constraint position_pk
            primary key,
    positiontitle     TEXT,
    educationrequired TEXT,
    minsalary         TEXT,
    maxsalary         TEXT
);
position
CREATE TABLE employee
(
    ssn         TEXT
            primary key,
    lastname    TEXT,
    firstname   TEXT,
    hiredate    TEXT,
    salary      TEXT,
    gender      TEXT,
    performance TEXT,
    positionID  INTEGER,
    locationID  INTEGER,
    foreign key (locationID) references location(locationID),
    foreign key (positionID) references position(positionID)
);
employee
original_column_name,column_name,column_description,data_format,value_description
locationID,location id,the unique id for location,integer,
locationcity,location city,the location city,text,
address,,the detailed address of the location,text,
state,,the state abbreviation,text,
zipcode,zip code,zip code of the location,integer,
officephone,office phone,the office phone number of the location,text,
location
original_column_name,column_name,column_description,data_format,value_description
ssn,social security number,employee's ssn,text,
lastname,last name,employee's last name,text,
firstname,first name,employee's first name,text,"commonsense evidence:
employee's full name is firstname lastname . "
hiredate,hire date,employee's hire date,text,yyyy-mm-dd
salary,,employee's salary,text,the unit is dollar per year
gender,,employee's gender,text,
performance,,employee's performance,text,Good / Average/ Poor
positionID,position id,the unique id for position,integer,
locationID,location id,the unique id for location,integer,
employee
original_column_name,column_name,column_description,data_format,value_description
positionID,position id,the unique id for position,integer,
positiontitle,position title,the position title,text,
educationrequired ,education required,the required education year,text,"commonsense evidence:
Generally, more complex work requires more education year. "
minsalary,minimum salary,minimum salary of this position ,text,
maxsalary,maximum salary,maximum salary of this position ,text,
position