17 lines
385 B
MySQL
17 lines
385 B
MySQL
|
CREATE TABLE segments (
|
||
|
|
id TEXT PRIMARY KEY,
|
||
|
|
type TEXT NOT NULL,
|
||
|
|
scope TEXT NOT NULL,
|
||
|
|
topic TEXT,
|
||
|
|
collection TEXT REFERENCES collection(id)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE segment_metadata (
|
||
|
|
segment_id TEXT REFERENCES segments(id) ON DELETE CASCADE,
|
||
|
|
key TEXT NOT NULL,
|
||
|
|
str_value TEXT,
|
||
|
|
int_value INTEGER,
|
||
|
|
float_value REAL,
|
||
|
|
PRIMARY KEY (segment_id, key)
|
||
|
|
);
|