항공권시나리오
테이블 (6)
Untitled (USER)
- Key (user_id) — int — 기본 키 — NOT NULL
- Field (user_name) — VARCHAR(4)
- Field2 (like_travel_place) — VARCHAR(10)
- Field (phone_num) — int
Untitled (PASSENGER)
- Key (passenger_id) — int — 기본 키 — NOT NULL
- Field2 (passport_num) — int
- Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (reservation)
- Key (resevation_id) — int — 기본 키 — NOT NULL
- Field (reservation_status) — VARCHAR(10)
- Field2 (reserve_at) — DATE
- Key (passenger_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (ticket_id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (airline_ticket)
- Key (ticket_id) — int — 기본 키 — NOT NULL
- Field (type) — CHAR(4)
- Field2 (departure_loc) — VARCHAR(20)
- Field3 (arrival_loc) — VARCHAR(20)
- Field (departure_at) — DATETIME
- Field (return_at) — DATETIME
- Field (tax) — int
- Field (total price) — int
Untitled (payment)
- Key (payment_id) — int — 기본 키 — NOT NULL
- Field (pay_at) — DATE
- Key (passenger_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (resevation_id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled2 (flight)
- Key (flight_id) — int — 기본 키 — NOT NULL
- Field (departure_at) — DATETIME
- Field2 (arrival_at) — DATETIME
- Field3 (departure_loc) — VARCHAR(20)
- Field4 (arrival_loc) — VARCHAR(20)
- Field (flight_price) — int
- Field — int
- Key (ticket_id) — int — 외래 키 → Untitled.Key — NOT NULL