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)

  • LevelsGained (Field)

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)