d
Tables (4)
COMMENT
- commentId (Key) — long — Primary key — NOT NULL
- commentContent (댓글내용) — String
- createAt (작성시간) — LocalDataTime
- postId (Key1) — long — Foreign key → POST.postId — NOT NULL
- userId (Key3) — long — Foreign key → USER.userId — NOT NULL
LIKE
- likeId (Key) — long — Primary key — NOT NULL
- like (좋아요) — long
- userId (Key2) — long — Foreign key → USER.userId — NOT NULL
- postId (Key3) — long — Foreign key → POST.postId — NOT NULL
POST
- postId (Key) — long — Primary key — NOT NULL
- title (제목) — String
- contents (내용) — String
- createAt (작성시간) — LocalDataTime
- modifiedAt (수정시간) — LocalDataTime
- commentsNum (댓글수) — long
- likeNum (좋아요수) — long
- userId (Key2) — long — Foreign key → USER.userId — NOT NULL
USER
- userId (Key) — long — Primary key — NOT NULL
- username (유저명) — string
- password (비밀번호) — string