Metro

Tables (3)

Driver (철도 기관사)

  • id — Long — Primary key — NOT NULL
  • serial (일련번호) — String
  • password (암호) — String
  • name (이름) — String

Line (노선)

  • lineId (노선번호) — Long — Primary key — NOT NULL
  • openYear (개통년도) — int
  • lineName (노선명) — String

Station (정거장)

  • id (정거장번호) — Long — Primary key — NOT NULL
  • lineId (노선번호) — Long — Foreign key → Line.lineId — NOT NULL
  • stationName (역명) — String