Blog_Blue

Tables (4)

Comment (comments)

  • ID (id) — uint — Primary key — NOT NULL
  • UserID (user_id) — uint — Foreign key → User.ID — NOT NULL
  • PostID (id2) — string — Foreign key → Post.ID — NOT NULL
  • Content (contents) — string
  • CreatedAt (created_at) — bigint
  • UpdatedAt (updated_at) — bigint
  • DeletedAt (deleted_at) — bigint

Like (likes)

  • ID (id) — int — Primary key — NOT NULL
  • PostID (post_id) — uid — Foreign key → Post.ID — NOT NULL
  • UserID (user_id) — int — Foreign key → User.ID — NOT NULL
  • CreatedAt (created_at) — bigint

Post (posts)

  • ID (id) — stirng — Primary key — NOT NULL
  • AuthorID (author_id) — int — Foreign key → User.ID — NOT NULL
  • Title (title) — string
  • Content (content) — string
  • Created_at (created_at) — bigint
  • Updated_at (updated_at) — bigint
  • Deleted_at (deleted_at) — bigint

User (users)

  • ID (id) — uint — Primary key — NOT NULL
  • Email (email) — string
  • Password (password) — string
  • UserName (user_name) — string
  • CreatedAt (joined_at) — bigint
  • UpdatedAt (updated_at) — bigint
  • DeletedAt (deleted_at) — bigint