migrations/2020-02-04-150559_entry/up.sql


1
2
3
4
5
6
7
8
9

create table entries (
  username varchar not null references users(username),
  entry_type varchar(16) not null,
  id bigserial not null,
  timestamp timestamptz,
  payload jsonb not null,
  
  primary key(username, entry_type, id)
);