umc_mission2
Tables (8)
food_categories
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- description — VARCHAR(255)
inquiries
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- image_url — VARCHAR(255)
- type — VARCHAR(50)
- created_at — DATETIME
missions
- id — INT — Primary key — NOT NULL
- store_id — INT — NOT NULL
- user_id — INT — NOT NULL
- goal — VARCHAR(255)
- reward — VARCHAR(100)
- status — VARCHAR(50)
- time_limit — DATETIME
preferred_foods
- user_id — INT — Primary key — NOT NULL
- category_id — INT — Primary key — NOT NULL
review_images
- id — INT — Primary key — NOT NULL
- review_id — INT — NOT NULL
- image_url — VARCHAR(255)
reviews
- id — INT — Primary key — NOT NULL
- store_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT
- rating — TINYINT
- created_at — DATETIME
stores
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- address — VARCHAR(255)
- status — VARCHAR(50)
users
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- gender — ENUM('Male', 'Female', 'Other')
- birth — DATE
- address — VARCHAR(255)
- email — VARCHAR(100)
- point — INT
- phone_number — VARCHAR(20)