miniblog

Tables (5)

comment (Untitled3)

  • Id (Key2) — Long — Primary key — NOT NULL
  • blogId (Key3) — Long — Foreign key → post.Id — NOT NULL
  • userId (Key22) — Long — Foreign key → user.id — NOT NULL
  • content (Field2) — String
  • created_at (Field3) — datetime
  • modified_at (Field4) — datetime

commentLike (Untitled5)

  • Id (Key) — Long — Primary key — NOT NULL
  • userId (Key222) — Long — Foreign key → comment.userId — NOT NULL
  • commentId (Key2) — Long — Foreign key → user.id — NOT NULL

post (Untitled)

  • Id (Key) — Long — Primary key — NOT NULL
  • userId (Key22) — Long — Foreign key → user.id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • created_at (Field4) — datetime
  • modified_at (Field5) — datetime

postLike (Untitled4)

  • Id (Key) — Long — Primary key — NOT NULL
  • PostId (Key2) — Long — Foreign key → post.Id — NOT NULL
  • UserId (Key22) — Long — Foreign key → user.id — NOT NULL

user (Untitled2)

  • id (Key2) — Long — Primary key — NOT NULL
  • username (Field3) — String
  • password (Field) — char