_memory
| type | name | tbl_name | rootpage | sql |
|---|---|---|---|---|
| table | audio_type | audio_type | 2 | CREATE TABLE audio_type ( id INTEGER NOT NULL, name VARCHAR(250), position INTEGER, PRIMARY KEY (id), UNIQUE (id), UNIQUE (name) ) |
| table | combi_type | combi_type | 5 | CREATE TABLE combi_type ( id INTEGER NOT NULL, name VARCHAR(250), position INTEGER, PRIMARY KEY (id), UNIQUE (id), UNIQUE (name) ) |
| table | area | area | 8 | CREATE TABLE area ( id INTEGER NOT NULL, name VARCHAR(250), position INTEGER, PRIMARY KEY (id), UNIQUE (id), UNIQUE (name) ) |
| table | publisher | publisher | 11 | CREATE TABLE publisher ( id INTEGER NOT NULL, name VARCHAR(250), position INTEGER, PRIMARY KEY (id), UNIQUE (id), UNIQUE (name) ) |
| table | variant_type | variant_type | 14 | CREATE TABLE variant_type ( id INTEGER NOT NULL, name VARCHAR(250), position INTEGER, PRIMARY KEY (id), UNIQUE (id), UNIQUE (name) ) |
| table | variant | variant | 17 | CREATE TABLE variant ( id INTEGER NOT NULL, code VARCHAR(250), name VARCHAR(250), PRIMARY KEY (id), UNIQUE (id) ) |
| table | media | media | 19 | CREATE TABLE media ( id INTEGER NOT NULL, title VARCHAR(250), study_code VARCHAR(100), position INTEGER, audio_type INTEGER, combi_type INTEGER, area INTEGER, publisher INTEGER, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(audio_type) REFERENCES audio_type (id), FOREIGN KEY(combi_type) REFERENCES combi_type (id), FOREIGN KEY(area) REFERENCES area (id), FOREIGN KEY(publisher) REFERENCES publisher (id) ) |
| table | variant_types | variant_types | 21 | CREATE TABLE variant_types ( variant_type_id INTEGER NOT NULL, variant_id INTEGER NOT NULL, variant_pos_in_type INTEGER, PRIMARY KEY (variant_type_id, variant_id), FOREIGN KEY(variant_type_id) REFERENCES variant_type (id), FOREIGN KEY(variant_id) REFERENCES variant (id) ) |
| table | media_variant | media_variant | 23 | CREATE TABLE media_variant ( id INTEGER NOT NULL, media INTEGER, variant INTEGER, study_code VARCHAR(100), study_status VARCHAR(7), raw_sample INTEGER, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(media) REFERENCES media (id), FOREIGN KEY(variant) REFERENCES variant (id) ) |