home / PuP_PoC

weekday_weekhours

3 rows where weekhours = 23

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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)
);
Powered by Datasette · Queries took 6.435ms