SpeedMemo

Tables (3)

DeletedMemo (삭제된 메모)

  • memoId (Key) — Long — Primary key — NOT NULL
  • childMemo (하위 메모 id) — Long — Foreign key → DeletedMemo.memoId — NOT NULL
  • memberId (Key3) — Long — Foreign key → Member.memberId — NOT NULL
  • content (Field) — String(512)
  • createAt (Field2) — LocalDateTime
  • updateAt (Field3) — LocalDateTime

Member (사용자)

  • memberId (Key) — Long — Primary key — NOT NULL
  • rootMemo (최상위 메모) — Long — Foreign key → Memo.memoId — NOT NULL
  • username (닉네임) — String(30)
  • kakaoId (카카오 id) — Long
  • joinDate (가입일) — LocalDateTime

Memo (메모)

  • memoId (Key) — Long — Primary key — NOT NULL
  • childMemoId (하위 메모 id) — Long — Foreign key → Memo.memoId — NOT NULL
  • memberId (Key3) — Long — Foreign key → Member.memberId — NOT NULL
  • content (Field) — String(512)
  • createAt (Field2) — LocalDateTime
  • updateAt (Field3) — LocalDateTime
  • accessLevel (접근제어) — String