muse
Tables (8)
column_comments (칼럼 댓글)
- id — BIGSERIAL — Primary key
- column_id — BIGSERIAL — Foreign key → columns.id — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — NOT NULL
columns (칼럼)
- id — BIGSERIAL — Primary key
- author_id — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — NOT NULL
follows (팔로잉)
- id — BIGSERIAL — Primary key — NOT NULL
- from_user_id (누가) — BIGSERIAL — Foreign key → users.id — NOT NULL
- to_user_id (누구를) — BIGSERIAL — Foreign key → users.id — NOT NULL
song_review_comments (노래 리뷰 댓글)
- id — BIGSERIAL — Primary key
- review_id — BIGSERIAL — Foreign key → song_reviews.id — NOT NULL
- writer_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — NOT NULL
song_reviews (노래 리뷰)
- id — BIGSERIAL — Primary key
- user_id — Foreign key → users.id — NOT NULL
- song_id — BIGSERIAL — Foreign key → songs.id — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — NOT NULL
song_star_ratings (노래 별점)
- id — BIGSERIAL — Primary key
- user_id — Foreign key → users.id — NOT NULL
- song_id — BIGSERIAL — Foreign key → songs.id — NOT NULL
- score — REAL — NOT NULL
songs
- id — BIGSERIAL — Primary key
- title — VARCHAR(255) — NOT NULL
- artist — VARCHAR(255) — NOT NULL
- spotify_id — VARCHAR(100) — NOT NULL
- playlist_genre — VARCHAR(100)
- energy — REAL
- tempo — REAL
- danceability — REAL
- loudness — REAL
- valence — REAL
- speechiness — REAL
- instrumentalness — REAL
- acousticness — REAL
- time_signature — INT
- mode — INT
- duration_ms — REAL
users (유저)
- id — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL