ㄴㅁㅇ

Tables (5)

likes

  • id — INT — Primary key — NOT NULL
  • music_id — INT — Foreign key → musics.id — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.uid

lives

  • id — INT — Primary key — NOT NULL
  • live_url — VARCHAR(150) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.uid

musics

  • id — INT — Primary key — NOT NULL
  • songName — VARCHAR(100) — NOT NULL
  • artist — VARCHAR(50) — NOT NULL
  • songImg — VARCHAR(100)
  • musicResource — VARCHAR(200)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

playlists

  • id — INT — Primary key — NOT NULL
  • playlistName — VARCHAR(100) — NOT NULL
  • music_id — INT — Foreign key → musics.id — NOT NULL
  • isLive — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.uid

users

  • uid — VARCHAR(100) — Primary key — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • profileImg — VARCHAR(255)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL