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