6150_w4_Fisherman
Tables (10)
Booking (Untitled6)
- BookingID (Key) — Primary key — NOT NULL
- BookingName (Field)
- BookingPhNum (Field2)
- BookingDate (Field3)
- BookingTime (Field4)
- BookingNumPeople (Field5)
- VenueID (Key2) — Foreign key → Venue.VenueID — NOT NULL
Chef (Untitled3)
- ChefID (Key) — Primary key — NOT NULL
- PaymentID (Key4) — Foreign key → ChefsBanquet.PaymentID — NOT NULL
- FishermanID (Key2) — Foreign key → ChefsBanquet.FishermanID — NOT NULL
- ChefID (Key22) — Foreign key → ChefsBanquet.ChefID — NOT NULL
- PikachuID (Key3) — Foreign key → ChefsBanquet.PikachuID — NOT NULL
- PaymentID (Key43) — Foreign key — NOT NULL
- FishermanID (Key33) — Foreign key — NOT NULL
- ChefID (Key223) — Foreign key — NOT NULL
- PaymentID (Key422) — Foreign key — NOT NULL
- FishermanID (Key2222) — Foreign key — NOT NULL
- PikachuID (Key322) — Foreign key — NOT NULL
- PaymentID (Key42) — Foreign key → ChefsBanquet.PaymentID — NOT NULL
- ChefName (Field)
- ChefQualification (Field2)
ChefsBanquet (Untitled7)
- PaymentID (Key4) — Foreign key → Payment.PaymentID — NOT NULL
- FishermanID (Key) — Foreign key → Fisherman.FishermanID — NOT NULL
- ChefID (Key2) — Foreign key → Chef.ChefID — NOT NULL
- PikachuID (Key3) — Foreign key → Pikachu.PikachuID — NOT NULL
- PaymentID (Key42) — Foreign key → Fisherman.PaymentID — NOT NULL
- AllergyReq (Field)
- TotalCost (Field2)
Fisherman (Untitled4)
- FishermanID (Key) — Primary key — NOT NULL
- PaymentID (Key4) — Foreign key → ChefsBanquet.PaymentID — NOT NULL
- FishermanName (Field2)
- FishermanPhNum (Field3)
- FishermanRate (Field)
Payment (Untitled8)
- PaymentID (Key) — Primary key — NOT NULL
- VoucherID (Key2) — Foreign key → Voucher.VoucherID — NOT NULL
- PaymentMethod (Field)
Pikachu (Untitled5)
- PikachuID (Key) — Primary key — NOT NULL
- PaymentID (Key4) — Foreign key → ChefsBanquet.PaymentID — NOT NULL
- PaymentID (Key42) — Foreign key → ChefsBanquet.PaymentID — NOT NULL
- PikachuLevel (Field)
- PikachuID (Key2) — Foreign key → Pikachu.PikachuID — NOT NULL
Room(WE) (Untitled2)
- RoomNum (Key) — Primary key — NOT NULL
- VenueID (Key4) — Foreign key → Venue.VenueID — NOT NULL
- MaxCapacity (Field)
TraningSession (Untitled10)
Venue (Untitled)
- VenueID (Key) — Primary key — NOT NULL
- RoomNum (Key3) — Foreign key → Room(WE).RoomNum — NOT NULL
- VenueADR (Field)
- VenuePhone (Field2)
- BookingID (Key2) — Foreign key → Booking.BookingID — NOT NULL
Voucher (Untitled9)
- VoucherID (Key2) — Primary key — NOT NULL
- VoucherDesc (Field)
- ExpDate (Field2)