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