a
Tables (18)
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