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