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