항공권시나리오

테이블 (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