ins

Tables (4)

comment (tbl_comment)

  • Key (comment_pk) — int — Primary key — NOT NULL
  • Key (post_pk) — int — Foreign key → post.Key — NOT NULL
  • Field (content) — vafchar(200)
  • Field (replier) — varchar

like (tbl_like)

  • Key (like_pk) — bigint — Primary key — NOT NULL
  • Key (post_pk) — int — Foreign key → post.Key — NOT NULL

post (tbl_post)

  • Key (post_pk) — int — Primary key — NOT NULL
  • Key (user_pk) — int — Foreign key → user.Key — NOT NULL
  • Field (title) — varchar(50)
  • Field (content) — varchar(500)
  • Field (file_name) — varchar
  • Field (file_path) — varchar

user (tbl_user)

  • Key (user_pk) — int — Primary key — NOT NULL
  • Field (user_id) — varchar(20)
  • Field (user_name) — varchar(10)