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