media_variant

24 rows where media = 258

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
6169 BR-KLASSIK 258 DS 1 RHEBA44_ZT unknown  
6170 BR-KLASSIK 258 Pre-Stream 2 RHEBA44_ZP unknown  
6171 BR-KLASSIK 258 In-Stream 3 RHEBA44_ZI unknown  
6172 BR-KLASSIK 258 HpT 4 RHEBA44_ZH unknown  
6173 BR-KLASSIK 258 Ø 5 RHEBA44_ZD unknown  
6174 BR-KLASSIK 258 0500-0600 6 RHEBA44_FAGA unknown  
6175 BR-KLASSIK 258 0600-0700 7 RHEBA44_GAHA unknown  
6176 BR-KLASSIK 258 0700-0800 8 RHEBA44_HAIA unknown  
6177 BR-KLASSIK 258 0800-0900 9 RHEBA44_IAJA unknown  
6178 BR-KLASSIK 258 0900-1000 10 RHEBA44_JAKA unknown  
6179 BR-KLASSIK 258 1000-1100 11 RHEBA44_KALA unknown  
6180 BR-KLASSIK 258 1100-1200 12 RHEBA44_LAMA unknown  
6181 BR-KLASSIK 258 1200-1300 13 RHEBA44_MANA unknown  
6182 BR-KLASSIK 258 1300-1400 14 RHEBA44_NAOA unknown  
6183 BR-KLASSIK 258 1400-1500 15 RHEBA44_OAPA unknown  
6184 BR-KLASSIK 258 1500-1600 16 RHEBA44_PAQA unknown  
6185 BR-KLASSIK 258 1600-1700 17 RHEBA44_QARA unknown  
6186 BR-KLASSIK 258 1700-1800 18 RHEBA44_RASA unknown  
6187 BR-KLASSIK 258 1800-1900 19 RHEBA44_SATA unknown  
6188 BR-KLASSIK 258 1900-2000 20 RHEBA44_TAUA unknown  
6189 BR-KLASSIK 258 2000-2100 21 RHEBA44_UAVA unknown  
6190 BR-KLASSIK 258 2100-2200 22 RHEBA44_VAWA unknown  
6191 BR-KLASSIK 258 2200-2300 23 RHEBA44_WAXA unknown  
6192 BR-KLASSIK 258 2300-2400 24 RHEBA44_XAYA unknown  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);
CREATE INDEX ix_media_variant_media ON media_variant (media);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);