System Design · Google · Medium
Design the relational schema for a video-sharing platform similar to YouTube. You must address the following points: Core tables and their important columns, data types, and constraints: users, channels, videos, video_transcodes/qualities, captions, tags, video_tags, views, likes, comments, subscriptions, playlists, playlist_videos, ad_impressions, and daily_video_metrics. Primary keys, foreign keys, uniqueness constraints, soft-delete mechanics, and a GDPR-compliant…
Checking your access…