mulo

Tables (15)

friendships

  • friendship_id — BIGINT — Primary key — NOT NULL
  • requester_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • addressee_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

lock_drafts

  • lock_draft_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • place_id — BIGINT — Foreign key → places.place_id
  • music_track_id — BIGINT — Foreign key → music_tracks.music_track_id
  • weather_condition — VARCHAR(50)
  • temperature — NUMERIC(4, 1)
  • mood — VARCHAR(30)
  • comment — VARCHAR(80)
  • photo_url — VARCHAR(2048)
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

lock_photos

  • lock_photo_id — BIGINT — Primary key — NOT NULL
  • record_id — BIGINT — Foreign key → records.record_id — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL
  • mime_type — VARCHAR(50) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

monthly_mood_stats

  • mood_stat_id — BIGINT — Primary key — NOT NULL
  • monthly_report_id — BIGINT — Foreign key → monthly_reports.monthly_report_id — NOT NULL
  • mood — VARCHAR(30) — NOT NULL
  • count — INTEGER — NOT NULL
  • ratio — NUMERIC(5, 4) — NOT NULL

monthly_photo_scene_stats

  • photo_scene_stat_id — BIGINT — Primary key — NOT NULL
  • monthly_report_id — BIGINT — Foreign key → monthly_reports.monthly_report_id — NOT NULL
  • scene_tag — VARCHAR(100) — NOT NULL
  • count — INTEGER — NOT NULL
  • ratio — NUMERIC(5, 4) — NOT NULL

monthly_reports

  • monthly_report_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • report_year — SMALLINT — NOT NULL
  • report_month — SMALLINT — NOT NULL
  • lock_count — INTEGER — NOT NULL
  • top_place_id — BIGINT — Foreign key → places.place_id
  • top_artist_name — VARCHAR(255)
  • ai_recap_text — TEXT
  • ai_recap_status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

music_tracks

  • music_track_id — BIGINT — Primary key — NOT NULL
  • external_track_id — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • artist_name — VARCHAR(255) — NOT NULL
  • album_name — VARCHAR(255)
  • album_image_url — VARCHAR(2048)
  • external_url — VARCHAR(2048)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

places

  • place_id — BIGINT — Primary key — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • external_place_id — VARCHAR(100)
  • place_name — VARCHAR(100)
  • address — VARCHAR(255)
  • road_address — VARCHAR(255)
  • latitude — NUMERIC(9, 6) — NOT NULL
  • longitude — NUMERIC(9, 6) — NOT NULL
  • sido — VARCHAR(50)
  • sigungu — VARCHAR(50)
  • eup_myeon_dong — VARCHAR(50)
  • eup_myeon_dong_code — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

recommendation_playlist_items

  • recommendation_playlist_item_id — BIGINT — Primary key — NOT NULL
  • recommendation_playlist_id — BIGINT — Foreign key → recommendation_playlists.recommendation_playlist_id — NOT NULL
  • music_track_id — BIGINT — Foreign key → music_tracks.music_track_id — NOT NULL
  • rank_no — INTEGER — NOT NULL

recommendation_playlists

  • recommendation_playlist_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

records

  • record_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • place_id — BIGINT — Foreign key → places.place_id — NOT NULL
  • music_track_id — BIGINT — Foreign key → music_tracks.music_track_id — NOT NULL
  • weather_condition — VARCHAR(50) — NOT NULL
  • temperature — NUMERIC(4, 1)
  • mood — VARCHAR(30) — NOT NULL
  • comment — VARCHAR(80)
  • status — VARCHAR(20) — NOT NULL
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

refresh_tokens

  • refresh_token_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(254) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

vote_answers

  • vote_answer_id — BIGINT — Primary key — NOT NULL
  • vote_question_id — BIGINT — Foreign key → vote_questions.vote_question_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • selected_option — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

vote_questions

  • vote_question_id — BIGINT — Primary key — NOT NULL
  • question_text — TEXT — NOT NULL
  • option_a — VARCHAR(255) — NOT NULL
  • option_b — VARCHAR(255) — NOT NULL
  • vote_date — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL