12 lines
266 B
SQL
12 lines
266 B
SQL
create table modules (
|
|
id integer primary key,
|
|
sid text not null,
|
|
vid text not null
|
|
) strict;
|
|
|
|
create table module_measurements (
|
|
id integer primary key,
|
|
foreign key (module_id) references modules(id)
|
|
on update cascade
|
|
on delete restrict
|
|
) strict;
|