Diary App
테이블 (3)
일기 (diary)
- diary_id (Key) — INT — 기본 키 — NOT NULL
- user_id (Key2) — INT — 외래 키 → 회원.user_id — NOT NULL
- diary_title (Field) — VARCHAR(256)
- diary_body (Field2) — TEXT
- diary_emotion (Field3) — INT — NOT NULL
- diary_created_date (Field4) — DATE — NOT NULL
- diary_is_deleted (Field5) — Boolean — NOT NULL
일기 요약 (diary_summary)
- diary_summary_id (Key) — INT — 기본 키 — NOT NULL
- diary_id (Key2) — INT — 외래 키 → 일기.diary_id — NOT NULL
- diary_summary_body (Field) — TEXT
- diary_summary_ai_emotion (Field2) — INT
- diary_summary_created_date (Field3) — DATE — NOT NULL
회원 (user)
- user_id (Key) — INT — 기본 키 — NOT NULL
- user_name (Field) — VARCHAR(256) — NOT NULL
- user_nickname (Field2) — VARCHAR(50)
- user_email (Field3) — VARCHAR(320) — NOT NULL
- user_password (Field4) — VARCHAR(64) — NOT NULL
- user_birth (Field5) — DATE — NOT NULL
- user_gender (Field6) — ENUM — NOT NULL
- user_joined_date (Field7) — DATE — NOT NULL
- user_is_deleted (Field8) — BOOLEAN — NOT NULL