2334r

Tables (3)

City

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE
  • id (id2) — BIGINT — Foreign key → Untitled2.id — NOT NULL
  • start — City — Foreign key → Untitled2.start — NOT NULL
  • end — City — Foreign key → Untitled2.end — NOT NULL

Untitled2

  • id — BIGINT — Primary key — NOT NULL
  • start — City — Primary key — NOT NULL
  • end — City — Primary key — NOT NULL
  • distance — DOUBLE
  • weight — DOUBLE
  • mode — VARCHAR(255)
  • id (id2) — BIGINT — Foreign key → City.id — NOT NULL

Untitled3

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Key3 — Primary key — NOT NULL
  • Key4 — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4