Beat Buddy

Tables (4)

Chat

  • chat_id (Key) — Primary key — NOT NULL
  • created_at (Field)
  • chat_type (Field2)

Message

  • message_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • chat_id (Key3) — Foreign key → Chat.chat_id — NOT NULL
  • chat_id (Field)
  • sender_id (Field2)
  • content (Field3)
  • sent_at (Field4)
  • music_id (Field5)

Music

  • music_id (Key) — Primary key — NOT NULL
  • message_id (Key2) — Foreign key → Message.message_id — NOT NULL
  • user_id (Key22) — Foreign key → Message.user_id — NOT NULL
  • chat_id (Key3) — Foreign key → Message.chat_id — NOT NULL
  • title (Field)
  • artist (Field2)
  • album_cover (Field3)
  • api_source_id (Field4)
  • bpm (Field5)
  • genre (Field6)
  • mood (Field7)
  • energy (Field8)

User

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • nickname (Field3)
  • profile_image (Field4)
  • created_at (Field5)