00000

Tables (10)

Mission

  • mission_id — INT
  • title — VARCHAR(255)
  • description — TEXT
  • reward_point — INT
  • mission_type — VARCHAR(100)
  • created_at — DATETIME

Notification

  • notification_id — INT
  • user_id — INT — Foreign key → User.user_id
  • type — VARCHAR(100)
  • content — TEXT
  • is_read — BOOLEAN
  • created_at — DATETIME

Point

  • point_id — INT
  • user_id — INT — Foreign key → User.user_id
  • amount — INT
  • reason — VARCHAR(255)
  • created_at — DATETIME

Review

  • review_id — INT
  • user_id — INT — Foreign key → User.user_id
  • store_id — INT — Foreign key → Store.store_id
  • rating — INT
  • content — TEXT
  • created_at — DATETIME

Review_Image

  • image_id — INT
  • review_id — INT — Foreign key → Review.review_id
  • image_url — VARCHAR(255)

Store

  • store_id — INT
  • name — VARCHAR(255)
  • category — VARCHAR(100)
  • address — VARCHAR(255)
  • lat — FLOAT
  • lng — FLOAT
  • description — TEXT

Store_Mission

  • store_mission_id — INT
  • store_id — INT — Foreign key → Store.store_id
  • mission_id — INT — Foreign key → Mission.mission_id

User

  • user_id — INT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • nickname — VARCHAR(100)
  • profile_image — VARCHAR(255)
  • created_at — DATETIME

User_Mission

  • user_mission_id — INT
  • user_id — INT — Foreign key → User.user_id
  • mission_id — INT — Foreign key → Mission.mission_id
  • status — VARCHAR(50)
  • started_at — DATETIME
  • completed_at — DATETIME

User_Preference

  • preference_id — INT
  • user_id — INT — Foreign key → User.user_id
  • category — VARCHAR(100)