API
Tables (6)
departuretime
- departureid — INT
- slotid — INT
- minute — VARCHAR(10)
- isactive — BOOLEAN
- lastmodified — TIMESTAMP
- miniute — VARCHAR(255)
operationtime
- operationid — INT
- routeid — INT
- starttime — TIME
- endtime — TIME
- weekdayonly — BOOLEAN
- lastmodified — TIMESTAMP
route
- routeid — INT
- routename — VARCHAR(100)
- description — TEXT
- pathcoordinates — TEXT
- isactive — BOOLEAN
stop
- stopid — INT
- routeid — INT
- stopname — VARCHAR(100)
- latitude — DOUBLE
- longitude — DOUBLE
- sequencenumber — INT
- estimatedtime — INT
timeslot
- slotid — INT
- stopid — INT
- hourrange — VARCHAR(20)
- isactive — BOOLEAN
- lastmodified — TIMESTAMP
token
- tokenid — INT
- admin_email — VARCHAR(100) — NOT NULL
- token — VARCHAR(255)
- expiretime — DATETIME
- isactive — BOOLEAN
- lastmodified — TIMESTAMP
- created_at — DATETIME