umc_week1
Tables (7)
Accepted Mission (accepted_mission)
- User Id (user_id) — BIGINT — Foreign key → User.User Id — NOT NULL
- Mission Id (mission_id) — BIGINT — Foreign key → Mission.Mission Id — NOT NULL
- Status (status) — VARCHAR(255)
Food Category (food_category)
- Food Id (food_id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
Food Preference (food_preference)
- User Id (user_id) — BIGINT — Foreign key → User.User Id — NOT NULL
- Food Id (food_id) — BIGINT — Foreign key → Food Category.Food Id — NOT NULL
Mission (mission)
- Mission Id (mission_id) — BIGINT — Primary key — NOT NULL
- Store Id (store_id) — BIGINT — Foreign key → Store.Store Id — NOT NULL
- Point (point) — INT
- Detail (detail) — VARCHAR(255)
- Deadline (deadline) — CHAR(8)
- Created Date (created_at) — CHAR(8)
Review (review)
- Review Id (review_id) — BIGINT — Primary key — NOT NULL
- User Id (user_id) — BIGINT — Foreign key → User.User Id — NOT NULL
- Store Id (store_id) — BIGINT — Foreign key → Store.Store Id — NOT NULL
- Star (star) — INT
- Detail (detail) — VARCHAR(255)
- Created Date (created_at) — CHAR(8)
- Updated Date (updated_at) — CHAR(8)
Store (store)
- Store Id (store_id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Location (location) — VARCHAR(255)
- Food Category (food_id) — BIGINT — Foreign key → Food Category.Food Id — NOT NULL
User (user)
- User Id (user_id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(8)
- Address (address) — VARCHAR(255)
- Point (point) — INT
- Completed Mission (completed_mission) — INT
- Created Date (created_at) — CHAR(8)
- Updated Date (updated_at) — CHAR(8)
- Phone (phone) — VARCHAR(255)
- Email (email) — VARCHAR(255)