busstation

Tables (4)

FAVORITE_STATIONS (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • Id (id2) — BIGINT — Foreign key → USERS.Id — NOT NULL
  • Id (ID) — BIGINT — Foreign key → STATIONS.Id — NOT NULL
  • Field2

ROUTES (Untitled2)

  • IDI (d) — BIGINT — Primary key — NOT NULL
  • Id (id) — BIGINT — Foreign key → USERS.Id — NOT NULL
  • citycode — varchar
  • routeId — varchar
  • routeNo — varchar
  • routeType — varchar
  • lastSyncedAt — timestamp

STATIONS (Untitled)

  • Id (ID) — BIGINT — Primary key — NOT NULL
  • citiCode (cityCode) — varchar
  • nodeId (nodeID) — varchar
  • nodeNo — varchar
  • name — varchar
  • gpsLati — decimal
  • gpsLong — decimal
  • lastSyncedAt — timestamp

USERS (유저)

  • Id (id) — BIGINT — Primary key — NOT NULL
  • Field