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