1

Tables (14)

category

  • category_id — BIGINT — Primary key — NOT NULL
  • customer_id — BIGINT — Foreign key → user_preferred_tags.customer_id — NOT NULL

comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • customer_id — BIGINT — Foreign key → recommended_videos.customer_id — NOT NULL

customer

  • customer_id — BIGINT — Primary key — NOT NULL

home_lists

  • home_list_id — BIGINT — Primary key — NOT NULL

list

  • list_id — BIGINT — Primary key — NOT NULL
  • meta_id — BIGINT — Foreign key → long_video_metadata.meta_id — NOT NULL
  • home_list_id — BIGINT — Foreign key → home_lists.home_list_id — NOT NULL

long_video_metadata (video_metadata)

  • meta_id — BIGINT — Primary key — NOT NULL

playback_logs

  • playback_log_id — BIGINT — Primary key — NOT NULL
  • history_id — BIGINT — Foreign key → watch_history.history_id — NOT NULL
  • customer_id — BIGINT — Foreign key → watch_history.customer_id — NOT NULL

recommended_videos

  • customer_id — BIGINT — Foreign key — NOT NULL

tags

  • tag_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL
  • customer_id — BIGINT — Foreign key → category.customer_id — NOT NULL

user_preferred_tags

  • customer_id — BIGINT — Foreign key — NOT NULL

video_bookmarks

  • bookmarks_id — BIGINT — Primary key — NOT NULL
  • customer_id — BIGINT — Foreign key — NOT NULL

video_likes

  • likes_id — BIGINT — Primary key — NOT NULL
  • customer_id — BIGINT — Foreign key — NOT NULL

video_translate_info

  • trans_id — BIGINT — Primary key — NOT NULL
  • meta_id — BIGINT — Foreign key — NOT NULL

watch_history

  • history_id — BIGINT — Primary key — NOT NULL
  • customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL