Youtube (Study Case)

This ERD represents a simplified YouTube-style video streaming platform database structure. The schema supports core features including user accounts, channels, video uploads, comments, likes, subscriptions, playlists, and watch history management. The `users` table stores account and profile information for platform users. Each user can create one channel through the `channels` table, which contains channel profile data such as channel name, description, and banner image. Uploaded videos are managed in the `videos` table. Each video belongs to a channel and includes metadata such as title, description, visibility status, thumbnail image, duration, and total view count. The interaction system includes comments and reactions. The `video_comments` table supports nested comments using a self-referencing parent comment structure. Video reactions such as likes and dislikes are stored in the `video_likes` table. Channel subscriptions are managed through the `subscriptions` table, which represents the relationship between users and subscribed channels. The playlist feature is implemented using the `playlists` and `playlist_videos` tables. This many-to-many relationship allows users to organize videos into custom playlists with display order management. User viewing activity is tracked in the `watch_history` table, including watched videos, viewing timestamps, and watched duration. This schema is designed for ERD visualization examples, relational database modeling practice, and video streaming service clone projects. The model focuses on relationship clarity and normalized database structure rather than production-level optimization.