SPRING_CRUD

Tables (4)

Comment

  • commentId — bigint — Primary key — NOT NULL
  • postId — Foreign key → Post.postId — NOT NULL
  • userId — bigint — Foreign key → User.userId — NOT NULL
  • userId (content) — text — NOT NULL

Post

  • postId — Primary key — NOT NULL
  • userId — bigint — Foreign key → User.userId — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — TEXT — NOT NULL
  • status — varchar(100) — NOT NULL
  • created_at — date — NOT NULL

Untitled (like)

  • Key (likeId) — bigint — Primary key — NOT NULL
  • userId — bigint — Foreign key → User.userId — NOT NULL
  • postId — Foreign key → Post.postId — NOT NULL

User

  • userId — bigint — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL