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