restaurant

Tables (12)

award (Untitled8)

  • awardID (Key) — NOT NULL — Primary key — NOT NULL
  • awardName (Field) — NOT NULL

chef (Untitled6)

  • chefID (Key) — NOT NULL — Primary key — NOT NULL
  • chefName (Field) — NOT NULL
  • specialty (Field2) — NOT NULL
  • dateOfBirth (Field3) — NOT NULL

chefObtain (Untitled11)

  • awardID (Key) — NOT NULL — Foreign key → award.awardID — NOT NULL
  • chefID (Key2) — NOT NULL — Foreign key → chef.chefID — NOT NULL
  • year (Field) — NOT NULL

cook (Untitled5)

  • dishID (Key) — NOT NULL — Foreign key → dish.dishID — NOT NULL
  • chefID (Key2) — NOT NULL — Foreign key → chef.chefID — NOT NULL

customer (Untitled3)

  • customerID (Key) — NOT NULL — Primary key — NOT NULL
  • customerName (Field) — NOT NULL
  • dateOfBirth (Field2) — NOT NULL
  • preference (Field3) — NOT NULL

dish (Untitled2)

  • dishID (Key) — NOT NULL — Primary key — NOT NULL
  • dishName (Field) — NOT NULL
  • price (Field2) — NOT NULL
  • cuisinType (Field3) — NOT NULL
  • isSeasonal (Field4) — NOT NULL

reservation (Untitled12)

  • reservationDate (Key3) — NOT NULL — Primary key — NOT NULL
  • customerID (Key) — NOT NULL — Foreign key → customer.customerID — NOT NULL
  • restaurantID (Key2) — NOT NULL — Foreign key → restaurant.restaurantID — NOT NULL
  • numberOfPeopel (Field) — NOT NULL

restaurant (Untitled)

  • restaurantID (Key) — NOT NULL — Primary key — NOT NULL
  • restaurantName (Field) — NOT NULL
  • location (Field2) — NOT NULL
  • establishedYear (Field3) — NOT NULL
  • avgRate' (Field4) — NOT NULL

restaurantObtain (Untitled10)

  • awardID (Key) — NOT NULL — Foreign key → award.awardID — NOT NULL
  • restaurantID (Key2) — NOT NULL — Foreign key → restaurant.restaurantID — NOT NULL
  • year (Field) — NOT NULL

review (Untitled7)

  • customerID (Key) — NOT NULL — Foreign key → customer.customerID — NOT NULL
  • restaurantID (Key2) — NOT NULL — Foreign key → restaurant.restaurantID — NOT NULL
  • rating (Field) — NOT NULL
  • comment (Field2) — NOT NULL
  • reviewDate (Field3) — NOT NULL

serve (Untitled4)

  • restaurantID (Key) — NOT NULL — Foreign key → restaurant.restaurantID — NOT NULL
  • dishId (Key2) — NOT NULL — Foreign key → dish.dishID — NOT NULL

work (Untitled9)

  • restaurantID (Key) — NOT NULL — Foreign key → restaurant.restaurantID — NOT NULL
  • chefID (Key2) — NOT NULL — Foreign key → chef.chefID — NOT NULL