SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE employees ( id SERIAL PRIMARY KEY, manager_id INT REFERENCES employees(id), full_name VARCHAR, address VARCHAR, phone VARCHAR, hired_at TIMESTAMP, fired_at TIMESTAMP ); CREATE TABLE order_states ( id SERIAL PRIMARY KEY, state VARCHAR ); CREATE TABLE orders ( id SERIAL PRIMARY KEY, customer VARCHAR, address VARCHAR, courier_id INT REFERENCES employees(id), price NUMERIC ); CREATE TABLE trace ( id BIGSERIAL PRIMARY KEY, state_id INT REFERENCES order_states(id), order_id INT REFERENCES orders(id), updated_at TIMESTAMP );