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