UMC
Tables (6)
food (foodInfo)
- PK (food_id) — NotNull — Primary key — NOT NULL
- FK (restaurant_id) — NotNull — Foreign key → restaurant.PK — NOT NULL
- (food_name) — NotNull
- (food_pay) — NotNull
foodCategory (categoryInfo)
- PK (category_Id) — NotNull — Primary key — NOT NULL
- FK (user_id) — NotNull — Foreign key → user.PK — NOT NULL
- FK (restaurant_id) — NotNull — Foreign key → restaurant.PK — NOT NULL
- (category_name) — NotNull
mission (missionInfo)
- PK (mission_id) — NotNull — Primary key — NOT NULL
- Fk (restaurant_id) — NotNull — Foreign key → restaurant.PK — NOT NULL
- FK (user_id) — NotNull — Foreign key → user.PK — NOT NULL
- (mission_point) — NotNull
- (mission_more_than_pay) — NotNull
- (mission_date) — NotNull
restaurant (restaurantInfo)
- PK (restaurant_id) — NotNull — Primary key — NOT NULL
- (restaurant_name) — NotNull
- (retaurant_address) — NotNull
- (restaureant_food_category) — NotNull
- (restaurant_food_list) — NotNull
- (restaurant_operation) — NotNull
review (reviewInfo)
- PK (review_id) — NotNull — Primary key — NOT NULL
- FK (user_id) — NotNull — Foreign key → user.PK — NOT NULL
- FK (restaurant_id) — NotNull — Foreign key → restaurant.PK — NOT NULL
- (review_star) — NotNull
- (review_content) — NotNull
user (userInfo)
- PK (user_id) — NotNull — Primary key — NOT NULL
- (user_name) — NotNull
- (user_gender) — NotNull
- (user_birth) — NotNull
- (user_address) — NotNull
- (user_marketing) — NotNull
- (user_location) — NotNull
- (user_mission_count) — NotNull
- (user_favorite_category) — Null
- (user_nickname) — NotNull