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)