materieelnummer_events

✎ View and edit SQL

This data as json

0 records

CREATE TABLE materieelnummer_events (
        id             INTEGER PRIMARY KEY,
        ts             REAL NOT NULL,
        station_code   TEXT NOT NULL,
        event_type     TEXT NOT NULL,
        train_nr       TEXT,
        materieel_nrs  TEXT
    );
CREATE INDEX idx_matnr_evt ON materieelnummer_events(ts);