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
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