memoUpgrade

Tables (4)

comment (Untitled2)

  • commentId (댓글아이디) — Long — Primary key — NOT NULL
  • memoId (메모아이디) — Long — Foreign key → memo.memoId — NOT NULL
  • commentContents (댓글내용) — VarChar(200)
  • CreatedAt (댓글작성일) — Datetime
  • ModifiedAt (댓글수정일) — Datetime

draft (Untitled3)

  • id (작성아이디) — Long — Primary key — NOT NULL
  • userId (유저아이디) — Long — Foreign key → user.userId — NOT NULL
  • memoId (메모아이디) — Long — Foreign key → memo.memoId — NOT NULL

memo

  • memoId (메모아이디) — Long — Primary key — NOT NULL
  • userId (유저아이디) — Long — Foreign key → user.userId — NOT NULL
  • title (제목) — VarChar(50)
  • memoContents (메모내용) — VarChar(200)
  • CreationDate (작성일) — Datetime
  • ModifiedDate (수정일) — Datetime
  • isDeleted (삭제여부) — tinyint

user (Untitled)

  • userId (유저아이디) — Long — Primary key — NOT NULL
  • name (유저이름) — VarChar(50)
  • email (유저이메일) — VarChar(50)
  • CreatedAt (유저생성일) — Datetime
  • ModifiedAt (유저데이터변경일) — Datetime