community

Tables (3)

Comment (comment)

  • commentId (comment_id) — bigint — Primary key — NOT NULL
  • postId (post_id) — bigint — Foreign key → Post.postId — NOT NULL
  • userId (user_id) — bigint — Foreign key → User.userId — NOT NULL
  • comment — varchar(255)
  • password — varchar(255)
  • createdAt (created_at) — LocalDateTime
  • modifiedAt (modified_at) — LocalDateTime

Post (post)

  • postId (post_id) — bigint — Primary key — NOT NULL
  • userId (user_id) — bigint — Foreign key → User.userId — NOT NULL
  • title — varchar(255)
  • content — varchar(255)
  • createdAt (created_at) — LocalDateTime

User (user)

  • userId (user_id) — bigint — Primary key — NOT NULL
  • username — varchar(255)
  • password — varchar(255)
  • nickname — varchar(255)