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)