sb05-mopl-team1

Tables (14)

Content (컨텐츠)

  • id (Key) — uuid — Primary key — NOT NULL
  • created_at (Field4) — timestamp — NOT NULL
  • updated_at (Field5) — timestamp — NOT NULL
  • type (Field) — varchar(20) — NOT NULL
  • title (Field1) — varchar(255) — NOT NULL
  • description (Field2) — text
  • thumbnail_path (Field3) — varchar(1024)
  • review_count (Field6) — int — NOT NULL — 비정규화
  • average_rating (Field7) — double — NOT NULL — 비정규화
  • popularity_score (Field8) — double — NOT NULL — 비정규화

ContentTag (컨텐츠 태그)

  • content_id (FPK) — uuid — Foreign key → Content.id — NOT NULL
  • tag_id (FPK2) — uuid — Foreign key → Tag.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL

Conversation (대화)

  • id (Key) — uuid — Primary key — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL

DirectMessage (메시지)

  • id (Key) — uuid — Primary key — NOT NULL
  • conversation_id (FK) — uuid — Foreign key → Conversation.id — NOT NULL
  • sender_id (FK2) — uuid — Foreign key → User.id
  • created_at (Field) — timestamp — NOT NULL
  • content (Field2) — text
  • updated_at (Field3) — timestamp — NOT NULL

Follow (팔로우)

  • followee_id (FPK) — uuid — Foreign key → User.id — NOT NULL
  • follower_id (FPK2) — uuid — Foreign key → User.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL

Notification (알림)

  • id (Key) — uuid — Primary key — NOT NULL
  • receiver_id (FK) — uuid — Foreign key → User.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • title (Field2) — varchar(255) — NOT NULL
  • content (Field3) — text
  • level (Field4) — varchar(20) — NOT NULL — INFO, WARNING, ERROR
  • updated_at (Field5) — timestamp — NOT NULL

Playlist (플레이리스트)

  • id (Key) — uuid — Primary key — NOT NULL
  • owner_id (FK) — uuid — Foreign key → User.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL
  • title (Field3) — varchar(255) — NOT NULL
  • description (Field4) — text
  • subscriber_count (Field5) — bigint — NOT NULL — 비정규화

PlaylistContent (플레이리스트 컨텐츠)

  • playlist_id (FPK) — uuid — Foreign key → Playlist.id — NOT NULL
  • content_id (FPK2) — uuid — Foreign key → Content.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL

PlaylistSubscriber (플레이리스트 구독자)

  • playlist_id (FPK) — uuid — Foreign key → Playlist.id — NOT NULL
  • subscriber_id (FPK2) — uuid — Foreign key → User.id — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL

ReadStatus (읽음 상태)

  • conversation_id (FPK) — uuid — Foreign key → Conversation.id — NOT NULL
  • participant_id (FPK2) — uuid — Foreign key → User.id — NOT NULL
  • last_read_at (Field) — timestamp — NOT NULL
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL

Review (리뷰)

  • id (Key) — uuid — Primary key — NOT NULL
  • content_id (FK) — uuid — Foreign key → Content.id — NOT NULL
  • author_id (FK2) — uuid — Foreign key → User.id
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL
  • text (Field3) — text
  • rating (Field4) — double — NOT NULL — 0.0 ~ 5.0

Tag (태그)

  • id (Key) — uuid — Primary key — NOT NULL
  • name (Field) — varchar(50) — NOT NULL — UNIQUE
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL

User (사용자)

  • id (Key) — uuid — Primary key — NOT NULL
  • created_at (Field) — timestamp — NOT NULL
  • updated_at (Field2) — timestamp — NOT NULL
  • auth_provider (Field3) — varchar(20) — NOT NULL — EMAIL, GOOGLE, KAKAO
  • email (Field4) — varchar(255) — NOT NULL — Unique
  • name (Field5) — varchar(50) — NOT NULL
  • password (Field6) — varchar(255) — NOT NULL
  • profile_image_url (Field7) — varchar(1024)
  • role (Field8) — varchar(20) — NOT NULL — USER, ADMIN
  • locked (Field9) — tinyint(1) — NOT NULL
  • deleted_at (Field10) — timestamp

WatchingSession (시청 세션)

  • id (Key) — uuid — Primary key — NOT NULL
  • content_id (FK) — uuid — NOT NULL
  • watcher_id (FK2) — uuid — NOT NULL
  • created_at (Field) — timestamp — NOT NULL