a

Tables (18)

Untitled

    chat_messages

    • id — BIGSERIAL
    • chat_room_id — BIGINT — NOT NULL
    • sender_id — BIGINT — NOT NULL
    • message_type — VARCHAR(20) — NOT NULL
    • text_content — TEXT
    • track_id — BIGINT
    • post_id — BIGINT
    • is_read — BOOLEAN — NOT NULL
    • created_at — TIMESTAMP — NOT NULL

    chat_room_members

    • chat_room_id — BIGINT — Primary key — NOT NULL
    • user_id — BIGINT — Primary key — NOT NULL
    • joined_at — TIMESTAMP — NOT NULL

    chat_rooms

    • id — BIGSERIAL
    • type — VARCHAR(20) — NOT NULL
    • title — VARCHAR(255)
    • created_at — TIMESTAMP — NOT NULL

    follows

    • follower_id — BIGINT — Primary key — NOT NULL
    • followee_id — BIGINT — Primary key — NOT NULL
    • created_at — TIMESTAMP — NOT NULL

    locations

    • id — BIGSERIAL
    • city_name — VARCHAR(100) — NOT NULL
    • country_code — CHAR(2) — NOT NULL
    • timezone — VARCHAR(50)
    • lat — NUMERIC(9,6)
    • lon — NUMERIC(9,6)
    • provider_location_key — VARCHAR(100)

    moods

    • id — SMALLSERIAL
    • code — VARCHAR(50) — NOT NULL
    • name_ko — VARCHAR(50) — NOT NULL
    • emoji — VARCHAR(8) — NOT NULL
    • description — TEXT

    post_comments

    • id — BIGSERIAL
    • post_id — BIGINT — NOT NULL
    • user_id — BIGINT — NOT NULL
    • parent_comment_id — BIGINT
    • content — TEXT — NOT NULL
    • is_deleted — BOOLEAN — NOT NULL
    • created_at — TIMESTAMP — NOT NULL
    • updated_at — TIMESTAMP — NOT NULL

    post_likes

    • user_id — BIGINT — Primary key — NOT NULL
    • post_id — BIGINT — Primary key — NOT NULL
    • created_at — TIMESTAMP — NOT NULL

    posts

    • id — BIGSERIAL
    • user_id — BIGINT — NOT NULL
    • mood_id — SMALLINT
    • track_id — BIGINT
    • text_content — TEXT
    • image_url — TEXT
    • visibility — VARCHAR(20) — NOT NULL
    • like_count — INTEGER — NOT NULL
    • comment_count — INTEGER — NOT NULL
    • created_at — TIMESTAMP — NOT NULL
    • updated_at — TIMESTAMP — NOT NULL

    track_audio_features

    • track_id — BIGINT
    • tempo — NUMERIC(6,3)
    • time_signature — SMALLINT
    • mode — SMALLINT
    • loudness — NUMERIC(5,2)
    • danceability — NUMERIC(4,3)
    • energy — NUMERIC(4,3)
    • valence — NUMERIC(4,3)
    • acousticness — NUMERIC(4,3)
    • instrumentalness — NUMERIC(4,3)
    • liveness — NUMERIC(4,3)
    • speechiness — NUMERIC(4,3)
    • analysis_json — TEXT
    • created_at — TIMESTAMP — NOT NULL

    track_mood_tags

    • track_id — BIGINT — Primary key — NOT NULL
    • mood_id — SMALLINT — Primary key — NOT NULL
    • score — NUMERIC(3,2) — NOT NULL

    tracks

    • id — BIGSERIAL
    • spotify_track_id — VARCHAR(64) — NOT NULL
    • name — VARCHAR(255) — NOT NULL
    • artist_name — VARCHAR(255) — NOT NULL
    • album_name — VARCHAR(255)
    • album_image_url — TEXT
    • duration_ms — INTEGER
    • preview_url — TEXT
    • created_at — TIMESTAMP — NOT NULL
    • updated_at — TIMESTAMP — NOT NULL

    user_location_settings

    • user_id — BIGINT
    • use_device_location — BOOLEAN — NOT NULL
    • manual_city_name — VARCHAR(100)
    • manual_lat — NUMERIC(9,6)
    • manual_lon — NUMERIC(9,6)
    • last_resolved_location_id — BIGINT
    • updated_at — TIMESTAMP — NOT NULL

    user_mood_logs

    • id — BIGSERIAL
    • user_id — BIGINT — NOT NULL
    • mood_id — SMALLINT — NOT NULL
    • source — VARCHAR(20) — NOT NULL
    • note — TEXT
    • weather_snapshot_id — BIGINT
    • created_at — TIMESTAMP — NOT NULL

    user_voice_profiles

    • user_id — BIGINT
    • brightness — NUMERIC(4,3)
    • warmth — NUMERIC(4,3)
    • huskiness — NUMERIC(4,3)
    • energy — NUMERIC(4,3)
    • pitch_low_hz — NUMERIC(7,2)
    • pitch_high_hz — NUMERIC(7,2)
    • updated_at — TIMESTAMP — NOT NULL

    users

    • id — BIGSERIAL
    • spotify_id — VARCHAR(64)
    • email — VARCHAR(255)
    • username — VARCHAR(50) — NOT NULL
    • display_name — VARCHAR(100)
    • profile_image_url — TEXT
    • bio — TEXT
    • created_at — TIMESTAMP — NOT NULL
    • updated_at — TIMESTAMP — NOT NULL

    weather_snapshots

    • id — BIGSERIAL
    • location_id — BIGINT — NOT NULL
    • source — VARCHAR(50) — NOT NULL
    • temperature_c — NUMERIC(4,1)
    • feels_like_c — NUMERIC(4,1)
    • humidity — SMALLINT
    • condition_code — VARCHAR(50)
    • condition_text — VARCHAR(100)
    • is_raining — BOOLEAN
    • is_snowing — BOOLEAN
    • is_clear_sky — BOOLEAN
    • created_at — TIMESTAMP — NOT NULL
    • valid_until — TIMESTAMP