감정일기
테이블 (14)
Comment (comment)
- Comment id (comment_id) — INT — 기본 키 — NOT NULL
- Member Id (member_id) — INT — 외래 키 → Member.Member Id — NOT NULL
- Context (context) — TEXTFIELD
- Created at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME
Diary (diary)
- Diary Id (diary_id) — INT — 기본 키 — NOT NULL
- Author (member_id) — INT — 외래 키 → Member.Member Id — NOT NULL
- Title (title) — VARCHAR(100)
- Context (context) — TEXTFIELD
- Recommended Music (recommended_music) — VARCHAR(255)
- Craeted at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME
Empathy (empathy)
- Emphaty (empathy_id) — INT — 기본 키 — NOT NULL
- Member Id (member_id) — INT — 외래 키 → Member.Member Id — NOT NULL
- Share Diary (share_diary) — INT — 외래 키 → Share diary.Share Diary — NOT NULL
Member (member)
- Member Id (member_id) — INT — 기본 키 — NOT NULL
- email — VARCHAR(100)
- name — VARCHAR(100)
- Favorite genre (favorite_genre) — VARCHAR(30)
- Created_at (created_at) — DATETIME
- Updated at (updated_at) — DATETIME
Mood (mood)
- Mood (mood_id) — INT — 기본 키 — NOT NULL
- Mood (mood_name) — VARCHAR(20)
Mood List (mood list)
- Mood List Id (mood_list_id) — INT — 기본 키 — NOT NULL
- Mood (mood_id) — INT — 외래 키 → Mood.Mood — NOT NULL
- Diary Id (diary_id) — INT — 외래 키 → Diary.Diary Id — NOT NULL
Notification (notification)
- Id (notification_id) — 기본 키 — NOT NULL
Recommended Music (recommended music)
- Id (id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(255)
- Artist (artist) — VARCHAR(255)
- Field3
Share diary (shared diary)
- Share Diary (share_diary) — INT — 기본 키 — NOT NULL
- Diary Id (diary_id) — INT — 외래 키 → Diary.Diary Id — NOT NULL
- Comment id (comment_id) — INT — 외래 키 → Comment.Comment id — NOT NULL
Social Account (social account)
- Id (id) — INT — 기본 키 — NOT NULL
- Member Id (member_id) — INT — 외래 키 → Member.Member Id — NOT NULL
- Provider (provider) — VARCHAR(20)
- Provider user id (provider_user_id) — VARCHAR(255)
- Email (email) — VARCHAR(100)
- Profile image (profile_image) — IMAGE
- Created at (created_at) — DATETIME
new_comment (Untitled)
- id (new_comment_id) — 기본 키 — NOT NULL
- Member Id (member_id) — INT — 외래 키 → Member.Member Id — NOT NULL
new_diary (Untitled3)
- id (new_diary_id) — 기본 키 — NOT NULL
- Share Diary (share_diary) — INT — 외래 키 → Share diary.Share Diary — NOT NULL
- Field
new_empathy (Untitled2)
- id (new_empathy_id) — 기본 키 — NOT NULL
- Emphaty (empathy_id) — INT — 외래 키 → Empathy.Emphaty — NOT NULL
noti_type (Untitled4)
- id (noti_type_id) — 기본 키 — NOT NULL