sql/0001_init.sql


1
2
3
4
5
6
7
8
9
10
11
12

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)
);