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)