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