streaming
Tables (5)
Untitled (video_history)
- history_id — PK — Primary key — NOT NULL
- video_id — FK — Foreign key → video.video_id — NOT NULL
- user_id — FK — Foreign key → video.id — NOT NULL
- last_play_time (마지막으로 재생된 시간) — Not Null
- current_position — Not Null
ad
- ad_id — PK — Primary key — NOT NULL
- ad_name (광고제목) — Not Null
- ad_play_count (광고재생횟수) — Not Null
user
- id — PK — Primary key — NOT NULL
- kakao_id — Not Null
- password — Not Null
- role — Not Null
video
- video_id (영상id) — PK — Primary key — NOT NULL
- id (user_id) — FK — Foreign key → user.id — NOT NULL
- title (영상제목) — Not Null
- views (조회수) — Not Null
- play_time (재생시간) — Not Null
- play_count (재생횟수) — Not Null
- status (영상상태) — Not Null
video_ad
- id — PK — Primary key — NOT NULL
- video_id — FK — Foreign key → video.video_id — NOT NULL
- ad_id — FK — Foreign key → ad.ad_id — NOT NULL