team2 practice

테이블 (6)

댓글 (Comment)

  • Filed (Column Name) — Key — 기본 키 — NOT NULL
  • Comment Id (comment_id) — PK
  • Diary Id (diary_id) — FK
  • User ID (user_id) — FK
  • Content (content)
  • Created At (created_at)
  • Filed (Column Name3) — Key — 외래 키 → 회원.Filed — NOT NULL
  • Filed (Column Name2) — Key — 외래 키 → 일기.Filed — NOT NULL

일기 (Diary)

  • Filed (Column Name) — Key — 기본 키 — NOT NULL
  • Diary Id (diary_id) — PK
  • User Id (user_id) — FK
  • TItle (title)
  • Content (content)
  • Is Public (is_public)
  • Emotion Tag (emotion_tag)
  • Rating (rating)
  • Content Type (content_type)
  • OTT (ott)
  • Watched Date (wached_date)
  • Filed (Column Name2) — Key — 외래 키 → 회원.Filed — NOT NULL

좋아요 (Like)

  • Filed (Column Name) — Key — 기본 키 — NOT NULL
  • Like Id (like_id) — PK
  • Diary Id (diary_id) — FK
  • User ID (user_id) — FK
  • Created At (created_at)
  • Filed (Column Name2) — Key — 외래 키 → 일기.Filed — NOT NULL
  • Filed (Column Name3) — Key — 외래 키 → 회원.Filed — NOT NULL

통계 (Statistic)

  • Filed (Column Name) — Key — 기본 키 — NOT NULL
  • Statistic Id (statistic_id) — PK
  • User ID (user_id) — FK
  • Content Type (content_type)
  • Genre (genre)
  • Emotion Tag (Emotion_tag)
  • Watch Count (watch_count) — PK
  • Avg Rating (average_rating)
  • Period (period)
  • Filed (Column Name2) — Key — 외래 키 → 회원.Filed — NOT NULL

팔로우 (Follow)

  • Filed (Coiumn Name) — Key — 기본 키 — NOT NULL
  • Filed (Column Name) — Key — 외래 키 → 회원.Filed — NOT NULL
  • Filed (Column Name2) — Key — 외래 키 → 회원.Filed — NOT NULL
  • Follow Id (follow_id) — PK
  • Follower Id (follower_id) — FK
  • Following Id (following_id) — FK

회원 (User)

  • Filed (Column Name) — Key — 기본 키 — NOT NULL
  • User Id (user_id) — PK
  • Username (username)
  • Email (email)
  • Password (password)
  • Profile Img (profile_img)
  • Bio (bio)