hour
16 rows
This data as json, CSV (advanced)
| id ▼ | code | name |
|---|---|---|
| 1 | 6 | 6 Uhr |
| 2 | 7 | 7 Uhr |
| 3 | 8 | 8 Uhr |
| 4 | 9 | 9 Uhr |
| 5 | 10 | 10 Uhr |
| 6 | 11 | 11 Uhr |
| 7 | 12 | 12 Uhr |
| 8 | 13 | 13 Uhr |
| 9 | 14 | 14 Uhr |
| 10 | 15 | 15 Uhr |
| 11 | 16 | 16 Uhr |
| 12 | 17 | 17 Uhr |
| 13 | 18 | 18 Uhr |
| 14 | 19 | 19 Uhr |
| 15 | 20 | 20 Uhr |
| 16 | 21 | 21 Uhr |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE hour ( id INTEGER NOT NULL, code INTEGER, name VARCHAR(250), PRIMARY KEY (id), UNIQUE (id), UNIQUE (name) ); CREATE INDEX ix_hour_code ON hour (code);