UMC-4th-mission

Tables (10)

Food category (food_category)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(15) — NOT NULL

Member Agree (member_agree)

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
  • id (terms_id) — BIGINT — Foreign key → Terms.id — NOT NULL
  • created period (created_at) — DATETIME(6)
  • updated period (updated_at) — DATETIME(6)

Mission (mission)

  • id — BIGINT — Primary key — NOT NULL
  • id (store_id) — BIGINT — Foreign key → Store.id — NOT NULL
  • description — VARCHAR(500)

Preference (preference)

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
  • id (food_id) — BIGINT — Foreign key → Food category.id — NOT NULL

Review (review)

  • id — BIGINT — Primary key — NOT NULL
  • id (store_id) — BIGINT — Foreign key → Store.id — NOT NULL
  • id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
  • rating — FLOAT
  • body — VARCHAR(1000)

Review Image (review_image)

  • id — BIGINT — Primary key — NOT NULL
  • id (review_id) — BIGINT — Foreign key → Review.id — NOT NULL
  • image url (img_url) — VARCHAR(20)
  • created period (created_at) — DATETIME(6)
  • updated period (updated_at) — DATETIME(6)

Store (restaurant)

  • id — BIGINT — Primary key — NOT NULL
  • id (food_category_id) — BIGINT — Foreign key → Food category.id — NOT NULL
  • name — VARCHAR(50)
  • address — VARCHAR(100)
  • rating — FLOAT
  • open time (open_time) — TIME
  • close time (close_time) — TIME
  • created period (created_at) — DATETIME(6)
  • updated period (updated_at) — DATETIME(6)

Terms (terms)

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(20)
  • body — TEXT
  • created period (created_at) — DATETIME(6)
  • updated period (updated_at) — DATETIME(6)

User (user)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • gender — VARCHAR(5)
  • birthday — VARCHAR(10)
  • address — VARCHAR(40)
  • specific address (spec_address) — VARCHAR(40)
  • status — VARCHAR(15)
  • point — INTEGER
  • created period (created_at) — DATETIME(6)
  • updated period (updated_at) — DATETIME(6)
  • inactive date (inactive_date) — DATETIME

User Mission (user_mission)

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
  • id (mission_id) — BIGINT — Foreign key → Mission.id — NOT NULL
  • created period (created_at) — DATETIME(6)
  • updated period (updated_at) — DATETIME(6)