logo
ExamplesEditorPricingDocs
37.1kSign in

Twitch live streaming database schema

How a live streaming platform models its data: broadcast sessions with start and end times, VODs and clips derived from them, tiered and gifted subscriptions, bits, chat, moderation logs and raids.

Twitch ER diagram

Twitch live streaming database schema 11 n1 n1 n1 n1 11 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idBIGINT loginVARCHAR display_nameVARCHAR emailVARCHAR bit_balanceINTEGER is_partnerBOOLEAN created_atTIMESTAMPTZ channels user_idBIGINT titleVARCHAR category_idBIGINT follower_countINTEGER is_matureBOOLEAN chat_slow_secondsSMALLINT subscribers_only_…BOOLEAN created_atTIMESTAMPTZ categories idBIGINT nameVARCHAR slugVARCHAR box_art_keyVARCHAR is_gameBOOLEAN viewer_countINTEGER streams idBIGINT channel_user_idBIGINT titleVARCHAR started_atTIMESTAMPTZ ended_atTIMESTAMPTZ peak_viewersINTEGER average_viewersINTEGER languageVARCHAR was_recordedBOOLEAN stream_category_seg… idBIGINT stream_idBIGINT category_idBIGINT started_atTIMESTAMPTZ ended_atTIMESTAMPTZ vods idBIGINT stream_idBIGINT duration_secondsINTEGER storage_keyVARCHAR view_countINTEGER expires_atTIMESTAMPTZ is_muted_segmentsBOOLEAN clips idBIGINT slugVARCHAR stream_idBIGINT vod_idBIGINT creator_user_idBIGINT titleVARCHAR offset_secondsINTEGER duration_secondsSMALLINT view_countINTEGER created_atTIMESTAMPTZ channel_subscriptio… idBIGINT channel_user_idBIGINT subscriber_user_idBIGINT gifter_user_idBIGINT tierVARCHAR price_centsINTEGER currency_codeCHAR streak_monthsSMALLINT started_atTIMESTAMPTZ ends_atTIMESTAMPTZ auto_renewBOOLEAN cheers idBIGINT channel_user_idBIGINT stream_idBIGINT user_idBIGINT bitsINTEGER messageVARCHAR is_anonymousBOOLEAN cheered_atTIMESTAMPTZ chat_messages idBIGINT channel_user_idBIGINT stream_idBIGINT user_idBIGINT bodyVARCHAR sent_atTIMESTAMPTZ deleted_atTIMESTAMPTZ moderation_actions idBIGINT channel_user_idBIGINT target_user_idBIGINT moderator_user_idBIGINT actionVARCHAR message_idBIGINT duration_secondsINTEGER reasonVARCHAR created_atTIMESTAMPTZ raids idBIGINT from_stream_idBIGINT to_channel_user_idBIGINT viewer_countINTEGER raided_atTIMESTAMPTZ

Related database schemas

PostgreSQL
Media & content

News site paywall database schema

How a digital newspaper models a metered paywall: articles with revisions, the per-reader meter, plans and subscriptions, gift links, newsletters and moderated comments.

PostgreSQL
Media & content

YouTube video platform database schema

How a video platform models its data: channels and uploads, encoded renditions, view counts rolled up per day, likes, one-level comment threads, subscriptions, playlists, monetisation and community posts.

PostgreSQL
Media & content

Blog & CMS database schema

A content management schema that survives contact with editors: posts with an append-only revision history, categories and tags, threaded comments, a real media library, slug redirects and a double opt-in newsletter list.

MySQL
Media & content

Goodreads book cataloguing database schema

How a book cataloguing site models its data: works split from editions and ISBNs, contributors with roles, default and custom shelves, reading progress, ratings and reviews, series ordering and a friend activity feed.