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