솔루션챌린지
테이블 (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