솔루션챌린지

테이블 (5)

Category (카테고리)

  • category_id (PK) — Long — 기본 키 — NOT NULL
  • title — varchar
  • subtitle — varchar
  • color — varchar
  • member_id (member) — Long — 외래 키 → Member.member_id — NOT NULL

Contents (컨텐츠)

  • contents_id (PK) — Long — 기본 키 — NOT NULL
  • category_id (category) — Long — 외래 키 → Category.category_id — NOT NULL
  • diary_id (diary) — Long — 외래 키 → Diary.diary_id — NOT NULL
  • check — boolean
  • photoUrl — varchar
  • text — varchar

Diary (다이어리)

  • diary_id (PK) — Long — 기본 키 — NOT NULL
  • member_id (member) — Long — 외래 키 → Member.member_id — NOT NULL
  • date — varchar

Diary_Emoji (다이어리 이모지)

  • diary_like_id (PK) — Long — 기본 키 — NOT NULL
  • member_id (member ID) — Long — 외래 키 → Member.member_id — NOT NULL
  • diary_id (diary ID) — Long — 외래 키 → Diary.diary_id — NOT NULL
  • emoji — varchar

Member (유저)

  • member_id (PK) — Long — 기본 키 — NOT NULL
  • name — varchar
  • gender — varchar
  • email — varchar
  • illness — varchar
  • type — varchar