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