123

Tables (3)

Comment

  • id — bigint — Primary key — NOT NULL
  • id (postId) — bigint — Foreign key → Post.id — NOT NULL
  • Field (content) — text
  • Field3 (createdAt) — datetime

Post

  • id — bigint — Primary key — NOT NULL
  • id (authorId) — bigint — Foreign key → User.id — NOT NULL
  • Field (title) — varchar(50)
  • Field2 (content) — text
  • Field3 (published) — tinyint(1)
  • Field (createdAt) — datetime
  • id (id2) — bigint — Foreign key → User.id — NOT NULL

User

  • id — bigint — Primary key — NOT NULL
  • Field (email) — varchar(255)
  • Field2 (password) — varchar(255)
  • Field3 (name) — varchar(20)
  • Field (createdAt) — datetime