데일리메이트

테이블 (5)

Diary (일기)

  • diaryId (DIARY_ID) — INT — 기본 키 — NOT NULL
  • userId (USER_ID) — INT — 외래 키 → User.userId — NOT NULL
  • date (DATE) — DATE
  • title (TITLE) — VARCHAR(255)
  • content (CONTENT) — VARCHAR(1000)
  • image (IMAGE) — VARCHAR(255)
  • like (LIKE) — INT

DiaryComment (일기 댓글)

  • diaryId (DIARY_ID) — INT — 외래 키 → Diary.diaryId — NOT NULL
  • userId (USER_ID) — VARCHAR(500)
  • content (CONTENT) — VARCHAR(255)
  • like (LIKE) — INT

Friend (친구목록)

  • userId (USER_ID) — INT — 외래 키 → User.userId — NOT NULL
  • friendId (FRIEND_ID) — INT

Todo (할 일)

  • id (ID) — INT — 기본 키 — NOT NULL
  • userId (USER_ID) — INT — 외래 키 → User.userId — NOT NULL
  • content (CONTENT) — VARCHAR(255)
  • isDone (ISDONE) — TINYINT
  • date (DATE) — DATE
  • Field

User (유저)

  • userId (USER_ID) — INT — 기본 키 — NOT NULL
  • password (PASSWORD) — VARCHAR(10) — NOT NULL
  • nickname (NICKNAME) — VARCHAR(10) — NOT NULL
  • image (IMAGE) — VARCHAR(255)
  • introduction (INTRODUCTION) — VARCHAR(255)