NTS

Tables (6)

Comment (Untitled2)

  • pk (댓글PK) — bigint — Primary key — NOT NULL
  • pk (회원PK) — bigint — Foreign key → Member.pk — NOT NULL
  • pk (게시글PK) — bigint — Foreign key → Post.pk — NOT NULL
  • content (내용) — String
  • parent (부모PK) — bigint
  • isDeleted (삭제여부) — boolean

HashTag (Untitled5)

  • pk (태그PK) — bigint — Primary key — NOT NULL
  • name (이름) — String

Likes (Untitled4)

  • pk (좋아요PK) — bigint — Primary key — NOT NULL
  • pk (회원PK) — bigint — Foreign key → Member.pk — NOT NULL
  • pk (게시글PK) — bigint — Foreign key → Post.pk — NOT NULL

Member (Untitled3)

  • pk (회원PK) — bigint — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • nickname (닉네임) — String

Post (Untitled)

  • pk (게시글PK) — bigint — Primary key — NOT NULL
  • pk (회원PK) — bigint — Foreign key → Member.pk — NOT NULL
  • title (제목) — String
  • content (본문) — String
  • createdAt (등록시간) — LocalDateTime
  • views (조회수) — bigint
  • likes (좋아요수) — bigint

PostTag (Untitled6)

  • pk (Key) — bigint — Primary key — NOT NULL
  • pk (게시글PK) — bigint — Foreign key → Post.pk — NOT NULL
  • pk (태그PK) — bigint — Foreign key → HashTag.pk — NOT NULL