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