miji

Tables (9)

User (Untitled)

  • user_Id (Key) — Primary key — NOT NULL
  • oauth_id (nickname) — VARCHAR — NOT NULL
  • nickname (Field2) — VARCHAR — NOT NULL
  • prof_image_url (Field3) — VARCHAR — NOT NULL
  • created_at (Field) — datetime — NOT NULL
  • deleted_at (Field4) — datetime
  • adventure_state (Field5) — enum — WISHLIST , IN_PROGRESS , COMPLETED

adventure_record (Untitled7)

  • adventure_record_id (Key) — Primary key — NOT NULL
  • user_Id (Key2) — Foreign key → User.user_Id — NOT NULL
  • photo_spot_Id (Key3) — Foreign key → photo_spot.photo_spot_Id — NOT NULL
  • challenge_id (Key4) — Foreign key → challenge.challenge_id — NOT NULL
  • created_at (Field) — datetime — NOT NULL
  • turnaround_time (Field2)

badge (Untitled4)

  • badge_id (Key) — Primary key — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • description (Field2) — VARCHAR — NOT NULL
  • badge_icon_url (Field3) — VARCHAR — 디바이스 저장으로 제거될 가능성 있는 필드

challenge (Untitled6)

  • challenge_id (Key) — Primary key — NOT NULL
  • user_Id (Key2) — Foreign key → User.user_Id — NOT NULL
  • photo_spot_Id (Key3) — Foreign key → photo_spot.photo_spot_Id — NOT NULL
  • score (Field)
  • s3_url (Field2)
  • started_at (Field3) — dateime — NOT NULL
  • completed_at (Field4) — datetime

hint (Untitled8)

  • hint_id (Key) — Primary key — NOT NULL
  • photo_spot_Id (Key2) — Foreign key → photo_spot.photo_spot_Id — NOT NULL
  • order (Field) — NOT NULL
  • content (Field2) — NOT NULL

photo_spot (Untitled3)

  • photo_spot_Id (Key) — Primary key — NOT NULL
  • url (Field) — VARCHAR — NOT NULL — 후보키 / index
  • address (Field2)
  • lattitude (Field3)
  • longitude (Field4)

user_badge (Untitled5)

  • user_badge_id (Key2) — Primary key — NOT NULL
  • user_Id (Key) — Foreign key → User.user_Id — NOT NULL
  • badge_id (Key3) — Foreign key → badge.badge_id — NOT NULL
  • earned_at (Field) — datetime — NOT NULL

user_hint_progress (Untitled9)

  • user_hint_progress_id (Key) — Primary key — NOT NULL
  • user_Id (Key2) — Foreign key → User.user_Id — NOT NULL
  • photo_spot_Id (Key3) — Foreign key → photo_spot.photo_spot_Id — NOT NULL
  • opened_hint_count (Field)
  • updated_at (Field2) — datetime — NOT NULL

wishlist (Untitled2)

  • wishlist_Id (Key) — Primary key — NOT NULL
  • user_Id (Key3) — Foreign key → User.user_Id — NOT NULL
  • photo_spot_Id (Key2) — Foreign key → photo_spot.photo_spot_Id — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field3) — datetime — NOT NULL
  • adventure_state (Field2) — enum — WISHLIST , IN_PROGRESS , COMPLETED