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)