title11

Tables (6)

Comment (댓글)

  • commentid (Key) — Long — Primary key — NOT NULL
  • postid (Key2) — Long — Foreign key → Post.postid — NOT NULL
  • userId (Key22) — Long — Foreign key → Post.userId — NOT NULL
  • content (Field) — VARCHAR
  • createdAt (Field2) — VARCHAR
  • likecount (Field3)

CommentLike (댓글좋아요)

  • commentid (Key2) — Long — Foreign key → Comment.commentid — NOT NULL
  • userId (Key3) — Long — Foreign key → User.userId — NOT NULL

Like (Untitled)

  • postid (Key) — Long — Foreign key → Post.postid — NOT NULL
  • userId (Key3) — Long — Foreign key → User.userId — NOT NULL

Post (게시글)

  • postid (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • title (Field) — VARCHAR
  • content (Field2) — VARCHAR
  • createdAt (Field3) — VARCHAR
  • likecount (Field4)

Role (권한)

  • user (Field)
  • admin (Field2)

User (회원)

  • userId (Key) — Long — Primary key — NOT NULL
  • username (Field) — VARCHAR
  • password (Field2) — VARCHAR
  • createdAt (Field3) — DATE
  • role (Field4) — VARCHAR