ERD

Tables (3)

Comments (Untitled3)

  • CommentId (PK) — BIGINT — Primary key — NOT NULL
  • content (Field) — VARCHAR — NOT NULL
  • nickname (Field2) — VARCHAR — NOT NULL
  • createtime (Field3) — DATETIME — NOT NULL
  • updatetime (Field4) — DATETIME — NOT NULL
  • PostId (FK1) — BIGINT — Foreign key → Posts.PostId — NOT NULL
  • UserId (FK2) — BIGINT — Foreign key → Users.UserId — NOT NULL

Posts (Untitled2)

  • PostId (PK) — BIGINT — Primary key — NOT NULL
  • content (Field) — TEXT — NOT NULL
  • likecount (Field2) — BIGINT — NOT NULL
  • viewcount (Field3) — BIGINT — NOT NULL
  • createtime (Field4) — DATETIME — NOT NULL
  • updatetime (Field5) — DATETIME — NOT NULL
  • imgurl (Field6) — VARCHAR
  • UserId (FK) — BIGINT — Foreign key → Users.UserId — NOT NULL

Users (Untitled)

  • UserId (PK) — BIGINT — Primary key — NOT NULL
  • email (Unique) — VARCHAR — NOT NULL
  • password (Field2) — VARCHAR — NOT NULL
  • nickname (Field3) — VARCHAR — NOT NULL