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