Table accounts { account_id int [pk, increment] email varchar [not null, unique] subscription_plan varchar [not null] // BASIC, STANDARD, PREMIUM status varchar [not null] // ACTIVE, SUSPENDED, CANCELLED }

Table profiles { profile_id int [pk, increment] account_id int [ref: > accounts.account_id] name varchar [not null] avatar_url varchar maturity_limit varchar [not null] // G, PG, PG-13, R, TV-MA is_kids boolean [default: false] }

Table videos { video_id int [pk, increment] title varchar [not null] description text duration_seconds int [not null] maturity_rating varchar [not null] video_type varchar [not null] // MOVIE, EPISODE }

Table movies { movie_id int [pk, ref: - videos.video_id] // 1-to-1 matching supertype director varchar theatrical_release_date date }

Table shows { show_id int [pk, increment] title varchar [not null] maturity_rating varchar [not null] }

Table seasons { season_id int [pk, increment] show_id int [ref: > shows.show_id] season_number int [not null] }

Table episodes { episode_id int [pk, ref: - videos.video_id] // 1-to-1 matching supertype season_id int [ref: > seasons.season_id] episode_number int [not null] }

Table watch_history { history_id int [pk, increment] profile_id int [ref: > profiles.profile_id] video_id int [ref: > videos.video_id] last_watched_position_seconds int [not null, default: 0] last_updated_time timestamp [not null] is_completed boolean [default: false] }

Table cdn_nodes { node_id int [pk, increment] name varchar [not null] region varchar [not null] // US-EAST, EU-WEST, etc. ip_address varchar [not null] }

Table video_caches { cache_id int [pk, increment] video_id int [ref: > videos.video_id] cdn_node_id int [ref: > cdn_nodes.node_id] quality varchar [not null] // SD, HD, UHD_4K }

This content is reserved for Premium Members.