chapter3-team3

Tables (3)

comments (Untitled3)

  • Key (id) — number — Primary key — NOT NULL
  • Key (postId) — number — Foreign key → post.Key — NOT NULL
  • Key (userId) — number — Foreign key → post.Key — NOT NULL
  • Field (commet) — string
  • Field (createdAt) — date
  • Field (updatedAt) — date

post (Untitled2)

  • Key (id) — number — Primary key — NOT NULL
  • Key (userId) — number — Foreign key → users.Key — NOT NULL
  • Field (title) — string
  • Field (content) — string
  • Field (createdAt) — date
  • Field (updatedAt) — date

users (Untitled)

  • Key (id) — number — Primary key — NOT NULL
  • Field (nickName) — string
  • Field2 (password) — string
  • Field3 (profileUrl) — string
  • Field4 (createdAt) — date
  • Field (updatedAt) — date