3 rows where weekhours = 9

View and edit SQL

Link weekday weekhours
Mo 1 9 9
Mo-So 8 9 9
Mo-Fr 9 9 9

Advanced export

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

CSV options:

CREATE TABLE weekday_weekhours (
	weekday INTEGER NOT NULL, 
	weekhours INTEGER NOT NULL, 
	PRIMARY KEY (weekday, weekhours), 
	FOREIGN KEY(weekday) REFERENCES weekday (id), 
	FOREIGN KEY(weekhours) REFERENCES weekhour (id)
);