s

Tables (10)

Cafeteria_MealSet

  • cafeteria_id — INT — Primary key — NOT NULL
  • restaurant_id — INT — Foreign key → Restaurants.restaurant_id — NOT NULL
  • mealset_date — DATE
  • mealset_type — VARCHAR(255)

Cafeteria_Menu

  • cafeteria_id — INT — Foreign key → Cafeteria_MealSet.cafeteria_id — NOT NULL
  • menu_name — VARCHAR(255)

Coupons

  • coupon_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • coupon_name — VARCHAR(255)
  • coupon_price — INT
  • coupon_used — BOOLEAN

Menus_Price

  • price_id — INT — Primary key — NOT NULL
  • snack_id — INT — Foreign key → SnackBar_Menu.snack_id
  • cafeteria_id — INT — Foreign key → Cafeteria_MealSet.cafeteria_id
  • start_date — DATE
  • end_date — DATE
  • open_time — TIME
  • end_time — TIME
  • comment — VARCHAR(255)

Payment

  • payment_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • restaurant_id — INT — Foreign key → Restaurants.restaurant_id — NOT NULL
  • order_time — DATETIME
  • total_price — INT
  • payment_method — VARCHAR(255)

Payment_Menus

  • payment_menu_id — INT — Primary key — NOT NULL
  • payment_id — INT — Foreign key → Payment.payment_id — NOT NULL
  • snack_id — INT — Foreign key → SnackBar_Menu.snack_id
  • cafeteria_id — INT — Foreign key → Cafeteria_MealSet.cafeteria_id
  • quantity — INT
  • price — INT

Restaurants

  • restaurant_id — INT — Primary key — NOT NULL
  • restaurant_name — VARCHAR(255)
  • restaurant_type — VARCHAR(255)

Restaurants_Time

  • restaurant_id — INT — Foreign key → Restaurants.restaurant_id — NOT NULL
  • meal_type — VARCHAR(255)
  • open_time — TIME
  • close_time — TIME

SnackBar_Menu

  • snack_id — INT — Primary key — NOT NULL
  • restaurant_id — INT — Foreign key → Restaurants.restaurant_id — NOT NULL
  • menu_name — VARCHAR(255)
  • menu_image — VARCHAR(255)

Users

  • user_id — INT — Primary key — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • credit — INT
  • id — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(255)