weekday

7 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ code name name_short
1 1 Montag Mo
2 2 Dienstag Di
3 3 Mittwoch Mi
4 4 Donnerstag Do
5 5 Freitag Fr
6 6 Samstag Sa
7 7 Sonntag So

Advanced export

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

CSV options: 

CREATE TABLE weekday (
	id INTEGER NOT NULL, 
	code INTEGER, 
	name VARCHAR(250), 
	name_short VARCHAR(2), 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	UNIQUE (name), 
	UNIQUE (name_short)
);
CREATE UNIQUE INDEX ix_weekday_code ON weekday (code);