Youtube_ERD

Tables (9)

Premium

  • premium_id — INT
  • user_id — INT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — ENUM('ACTIVE','EXPIRED')
  • payment_method — VARCHAR(30)

Purchases

  • purchase_id — INT
  • user_id — INT — NOT NULL
  • item_type — ENUM('MEMBERSHIP','MOVIE','MUSIC','OTHER') — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL
  • price_cents — INT — NOT NULL
  • purchased_at — TIMESTAMP

User_Settings

  • user_id — INT
  • theme — ENUM('LIGHT','DARK','SYSTEM')
  • language — VARCHAR(30)
  • restricted_mode — ENUM('ON','OFF')
  • location — VARCHAR(60)
  • shortcuts_help_seen — BOOLEAN

Users

  • user_id — INT
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • join_date — TIMESTAMP

Video_Like

  • user_id — BIGINT — Primary key — NOT NULL
  • video_id — BIGINT — Primary key — NOT NULL
  • liked_at — TIMESTAMP

Video_View

  • video_id — BIGINT — Primary key — NOT NULL
  • view_date — DATE — Primary key — NOT NULL
  • views — INT

Video_WatchLater

  • user_id — BIGINT — Primary key — NOT NULL
  • video_id — BIGINT — Primary key — NOT NULL
  • added_at — TIMESTAMP

Videos

  • video_id — INT
  • user_id — INT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • category_id — INT
  • views — INT
  • likes — INT
  • live_flag — BOOLEAN
  • upload_date — TIMESTAMP

Watch_History

  • history_id — INT
  • user_id — INT — NOT NULL
  • video_id — INT — NOT NULL
  • watched_at — TIMESTAMP