LV5 ERD

Tables (3)

Comment

  • id (comment_id) — Long — Primary key — NOT NULL
  • id (post_id) — Long — Foreign key → Post.id — NOT NULL
  • content — String
  • like — Integer

Post

  • id (post_id) — Long — Primary key — NOT NULL
  • username — String — Foreign key → Users.username — NOT NULL
  • title — String
  • content — String
  • like — Integer
  • createdAt — LocalDateTime
  • modifiedAt — LocalDateTime

Users

  • username — String — Primary key — NOT NULL
  • password — String
  • role — RoleType