감정일기

테이블 (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