blob: bfc98b941fa722c75c1ff7843b3918d189df0013 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE TABLE flow (
id VARCHAR(36) PRIMARY KEY,
content BLOB
);
CREATE TABLE body (
id INTEGER PRIMARY KEY,
flow_id VARCHAR(36),
type_id INTEGER,
content BLOB,
FOREIGN KEY(flow_id) REFERENCES flow(id)
);
CREATE TABLE annotation (
id INTEGER PRIMARY KEY,
flow_id VARCHAR(36),
type VARCHAR(16),
content BLOB,
FOREIGN KEY(flow_id) REFERENCES flow(id)
);
|
