CREATE TABLE timelog ( id BIGSERIAL NOT NULL PRIMARY KEY, _start TIMESTAMP, _end TIMESTAMP, description TEXT ); CREATE TABLE turnstile ( id BIGSERIAL NOT NULL PRIMARY KEY, _datetime TIMESTAMP, direction VARCHAR(4) );