testERD

Tables (11)

agreements

  • user_id — INT
  • over_14 — BOOLEAN — NOT NULL
  • terms_of_service — BOOLEAN — NOT NULL
  • privacy_policy — BOOLEAN — NOT NULL
  • location_service — BOOLEAN
  • marketing — BOOLEAN

mission_attempts

  • id — INT
  • user_id — INT — NOT NULL
  • mission_id — INT — NOT NULL
  • store_owner_id — BIGINT — NOT NULL
  • status — ENUM('대기 중', '성공 요청', '미완료')
  • requested_at — TIMESTAMP
  • created_at — TIMESTAMP

mission_reviews

  • id — INT
  • user_id — INT — NOT NULL
  • mission_id — INT — NOT NULL
  • review_text — TEXT — NOT NULL
  • rating — TINYINT
  • created_at — TIMESTAMP

missions

  • id — INT
  • district — VARCHAR(100) — NOT NULL
  • store_name — VARCHAR(255) — NOT NULL
  • category — ENUM( '한식', '일식', '중식', '양식', '치킨', '분식', '고기/구이', '도시락', '야식', '패스트푸드', '디저트', '아시안 푸드' ) — NOT NULL
  • mission_info — VARCHAR(255) — NOT NULL
  • reward — INT — NOT NULL
  • due_date — DATETIME — NOT NULL
  • created_at — TIMESTAMP

notifications

  • id — INT
  • user_id — INT — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

user_locations

  • user_id — INT
  • district — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP

user_mission_stats

  • id — INT
  • user_id — INT — NOT NULL
  • district — VARCHAR(100) — NOT NULL
  • completed_missions — INT
  • last_rewarded_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_missions

  • id — INT
  • user_id — INT — NOT NULL
  • mission_id — INT — NOT NULL
  • status — ENUM('진행 중', '완료', '실패')
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP

user_points

  • id — INT
  • user_id — INT — NOT NULL
  • mission_id — INT
  • points — INT — NOT NULL
  • reason — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

user_preferences

  • id — INT
  • user_id — INT — NOT NULL
  • food_type — ENUM( '한식', '일식', '중식', '양식', '치킨', '분식', '고기/구이', '도시락', '야식', '패스트푸드', '디저트', '아시안 푸드' ) — NOT NULL

users

  • id — INT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gender — ENUM('남', '여', '선택안함')
  • birth_date — DATE — NOT NULL
  • address — VARCHAR(255)
  • created_at — TIMESTAMP