bookTrainErd

Tables (16)

deploy

  • id — Long — Primary key — NOT NULL
  • departureTime — LocalDateTime
  • arrivalTime — LocalDateTime
  • departurePlace — String
  • arrivalPlace — String
  • train_id — Long — Foreign key → train.id — NOT NULL

ktx

  • id — Long — Foreign key → train.id — NOT NULL

ktx_room

  • id — Long — Primary key — NOT NULL
  • grade — Grade
  • room_name — String
  • ktx_id — Long — Foreign key → ktx.id — NOT NULL
  • ktx_seat_id — Long — Foreign key → ktx_seat.id — NOT NULL

ktx_seat

  • id — Long — Primary key — NOT NULL

ktx_seat_normal

  • id (id2) — Long — Foreign key → ktx_seat.id — NOT NULL
  • K1A — Boolean
  • K2A — Boolean
  • ..... (....) — Boolean — skip
  • K14D (K16D) — Boolean

ktx_seat_vip

  • id — Long — Foreign key → ktx_seat.id — NOT NULL
  • K1A — Boolean
  • K1B — Boolean
  • K1C — Boolean
  • ..... — Boolean — skip
  • K14C (K16C) — Boolean

member

  • id — Long — Primary key — NOT NULL
  • login_id — String
  • password — String
  • name — String
  • age — String
  • authorizations — Authorizations

mugunghwa

  • id — Long — Foreign key → train.id — NOT NULL

mugunghwa_room

  • id — Long — Primary key — NOT NULL
  • room_name — String
  • mugunghwa_id — Long — Foreign key → mugunghwa.id — NOT NULL
  • mugunghwa_seat_id — Long — Foreign key → mugunghwa_seat.id — NOT NULL

mugunghwa_seat

  • id — Long — Primary key — NOT NULL
  • M1 — Boolean
  • .... (.....) — Boolean — skip
  • M72 — Boolean

passenger

  • id — Long — Primary key — NOT NULL
  • toddler — Integer
  • kids — Integer
  • adult — Integer
  • senior — Integer

reservation

  • id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → member.id — NOT NULL
  • deploy_id — Long — Foreign key → deploy.id — NOT NULL
  • passenger_id — Long — Foreign key → passenger.id — NOT NULL
  • fee — Long
  • seats — String
  • room_name — String
  • grade — Grade

saemaul

  • id — Long — Foreign key → train.id — NOT NULL

saemaul_room

  • id — Long — Primary key — NOT NULL
  • room_name — String
  • saemaul_id — Long — Foreign key → saemaul.id — NOT NULL
  • saemaul_seat_id — Long — Foreign key → saemaul_seat.id — NOT NULL

saemaul_seat

  • id — Long — Primary key — NOT NULL
  • S1A — Boolean
  • S2A — Boolean
  • .... (...) — Boolean — skip
  • S14D — Boolean

train

  • id — Long — Primary key — NOT NULL
  • DTYPE — String
  • train_name — String