subway

Tables (3)

INTER_STATION (InterStations)

  • id (PK) — bigint — Primary key — NOT NULL
  • distance (Field) — bigint
  • up_station_id (FK) — bigint — Foreign key → STATION.id — NOT NULL
  • down_station_id (FK1) — bigint — Foreign key → STATION.id — NOT NULL
  • line_id (FK2) — bigint — Foreign key → LINE.id — NOT NULL

LINE (lines)

  • id (PK) — bigint — Primary key — NOT NULL
  • line_name (Field) — varchar
  • line_color (Field1) — varchar

STATION (Stations)

  • id (PK) — bigint — Primary key — NOT NULL
  • station_name (Field) — varchar