moodify
Tables (7)
board_comments
- comment_id — INT
- post_id — INT
- user_id — INT
- username — VARCHAR(100)
- content — TEXT
board_likes
- like_id — INT
- post_id — INT
- user_id — INT
board_posts
- post_id — INT
- user_id — INT
- username — VARCHAR(100)
- title — VARCHAR(255)
- content — TEXT
- emotion — VARCHAR(50)
- view_count — INT
- like_count — INT
emotion_history
- emotion_id — INT
- user_id — INT
- input_text — TEXT
- detected_emotion — VARCHAR(50)
playlist_songs
- id — INT
- playlist_id — INT
- title — VARCHAR(255)
- video_url — TEXT
- thumbnail_url — TEXT
playlists
- playlist_id — INT
- user_id — INT
- title — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
users
- user_id — INT
- username — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL