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