13 lines
432 B
SQL
13 lines
432 B
SQL
create table if not exists journal_entries (
|
|
id integer primary key autoincrement,
|
|
value text not null,
|
|
date text not null
|
|
);
|
|
|
|
create table if not exists contact_mentions (
|
|
entry_id integer not null references journal_entries(id) on delete cascade,
|
|
contact_id integer not null references contacts(id) on delete cascade,
|
|
input_text text not null,
|
|
byte_range_start integer not null,
|
|
byte_range_end integer not null
|
|
);
|