subway

테이블 (3)

역 (station)

  • Key (station_id) — BIGINT — 기본 키 — NOT NULL
  • Field (name)
  • Field (code)
  • Field (platform_type)
  • Field (address)
  • Field (is_express)
  • Field (x)
  • Field (z)
  • Field (is_branch)

지하철 노선도 (line)

  • Key (line_id) — BIGINT — 기본 키 — NOT NULL
  • Field (location)
  • Field (name)
  • Field (color)
  • Field (subway_type)
  • Field (is_transfer)
  • Field (code)

환승역 (line_station)

  • Key (line_station_id) — BIGINT — 기본 키 — NOT NULL
  • Key (station_id) — BIGINT — 외래 키 → 역.Key — NOT NULL
  • Key (line_id) — BIGINT — 외래 키 → 지하철 노선도.Key — NOT NULL
  • Field (is_express)