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