Bootsplätze #183

New Issue

philipp · 2024-01-23T09:46:38+01:00

philipp commented

2024-01-23 09:46:38 +01:00

new table with references to boats

CREATE TABLE boathouse (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    boat_id INTEGER REFERENCES boat(id),
    aisle TEXT CHECK (aisle in ('water', 'middle', 'mountain'))
    side TEXT CHECK(side IN ('mountain-side', 'water-side')),
    level INTEGER CHECK(level BETWEEN 1 AND 4)
);

styling (3 cols)
prominently display list of boats where location='linz' but no entry in boathouse-table (as warning)

new table with references to boats ```sqlite CREATE TABLE boathouse ( id INTEGER PRIMARY KEY AUTOINCREMENT, boat_id INTEGER REFERENCES boat(id), aisle TEXT CHECK (aisle in ('water', 'middle', 'mountain')) side TEXT CHECK(side IN ('mountain-side', 'water-side')), level INTEGER CHECK(level BETWEEN 1 AND 4) ); ``` - [ ] styling (3 cols) - [x] prominently display list of boats where location='linz' but no entry in boathouse-table (as warning)

philipp changed title from ~~Bootsl~~ to Bootsplätze

2024-01-23 09:46:43 +01:00

philipp added the

feature

label 2024-01-23 09:52:16 +01:00

philipp added the

ph-next

label 2024-03-04 23:32:53 +01:00

philipp referenced this issue

2024-03-08 10:22:06 +01:00

Bootsplätze nummerieren + feld dafür in rowt eintragen -> schauen ob eh alle boote in rowt sind #220

philipp referenced this issue from a commit