migrations/2020-02-04-223649_entry_data/up.sql


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

create table entry_data (
  username varchar not null,
  entry_type varchar(16) not null,
  entry_id bigint not null,
  data_type varchar(8) not null,
  data_id bigint not null,

primary key(username, entry_type, entry_id, data_type, data_id),

foreign key (username, entry_type, entry_id)
references entries(username, entry_type, id),

foreign key (data_type, data_id)
references raw_data(data_type, id)
);