Bingair

Tables (6)

item (Untitled2)

  • Key (id) — int — Primary key — NOT NULL
  • Key (id2) — int — Foreign key → reservation.Key — NOT NULL
  • Key (id22) — int — Foreign key → reservation.Key — NOT NULL
  • Key (userid) — varchar — Foreign key → reservation.Key — NOT NULL
  • Field (orderid) — varchar
  • Field (orderuser) — varchar
  • Field (item) — varchar
  • Field (price) — int

mypage (Untitled6)

  • Field

passport (Untitled5)

  • Key (id) — int — Primary key — NOT NULL
  • Key (userid) — varchar — Foreign key → user.Key — NOT NULL
  • Field (passportnum) — varchar
  • Field (expirydate) — varchar

reservation (Untitled3)

  • Key (id) — int — Primary key — NOT NULL
  • Key (id2) — int — Foreign key → passport.Key — NOT NULL
  • Key (userid) — varchar — Foreign key → passport.Key — NOT NULL
  • Field (reservarionid) — varchar
  • Field (departure) — varchar
  • Field (destination) — varchar

ticket (Untitled4)

  • Key (id) — int — Primary key — NOT NULL
  • Key (id2) — int — Foreign key → reservation.Key — NOT NULL
  • Key (id22) — int — Foreign key → reservation.Key — NOT NULL
  • Key (userid) — varchar — Foreign key → reservation.Key — NOT NULL
  • Field (seatnum) — int
  • Field (airline) — varchar

user (Untitled)

  • Key (userid) — varchar — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (gender) — varchar
  • Field (age) — int