stream-calculate erd
Tables (5)
advertisement (광고)
- advertisement_id (advertisementId) — INT — Primary key — NOT NULL
- video_id (videoId) — INT — Foreign key → video.video_id — NOT NULL
- created_at (createdAt) — DATETIME
user (유저)
- id — INT — Primary key — NOT NULL
- email — VARCHAR
- role — ENUM
user_advertisement (유저광고(광고시청이력))
- id — INT — Primary key — NOT NULL
- user_id (userId) — INT — Foreign key → user.id — NOT NULL
- advertisement_id (advertisementId) — INT — Foreign key → advertisement.advertisement_id — NOT NULL
- created_at (createdAt) — DATETIME
user_video (유저_동영상(시청이력))
- id — INT — Primary key — NOT NULL
- video_position (videoPosition) — INT
- created_at (createdAt) — DATETIME
- modified_at (modifiedAt) — DATETIME
- user_id (userId) — INT — Foreign key → user.id — NOT NULL
- video_id (videoId) — INT — Foreign key → video.video_id — NOT NULL
video (동영상)
- video_id (videoId) — INT — Primary key — NOT NULL
- title — VARCHAR
- duration — INT