UMC-Mission
Tables (8)
food_categories (선호 음식 카테고리)
- id — Primary key — NOT NULL
- name
- Field
inquiries
- id — Primary key — NOT NULL
- id (id2) — Foreign key → stores.id — NOT NULL
- title
- content
- image
- type
missions
- Key — Primary key — NOT NULL
- id — Foreign key → stores.id — NOT NULL
- id (id2) — Foreign key → users.id — NOT NULL
- goal
- reward
- state (status)
- time_limit
review_images
- id — Primary key — NOT NULL
- store_id — Foreign key → reviews.id — NOT NULL
- user_id — Foreign key → reviews.store_id — NOT NULL
- review_id — Foreign key → reviews.user_id — NOT NULL
- image_url
reviews
- id — Primary key — NOT NULL
- store_id — Foreign key → stores.id — NOT NULL
- user_id — Foreign key → users.id — NOT NULL
- content
- rate
stores
- id — Primary key — NOT NULL
- name
- address
- state
user_prefer_food (선호 음식)
- id — Primary key — NOT NULL
- user_Id (user_id) — Foreign key → users.id — NOT NULL
- food
- category_id — Foreign key → food_categories.id — NOT NULL
users
- id — Primary key — NOT NULL
- name
- gender
- birth
- address
- email
- point
- phone_number