Kingdom's assignment

Tables (3)

Comment

  • CommentId — INT
  • PostId — INT — NOT NULL
  • UserId — INT — NOT NULL
  • Content — TEXT — NOT NULL
  • CommentDate — datetime

Post

  • PostId — INT
  • UserId — INT — NOT NULL
  • Title — VARCHAR(100) — NOT NULL
  • Content — TEXT — NOT NULL
  • CreatedAt — DATETIME — NOT NULL
  • Writer — varchar(20)
  • view — Int
  • comment_view — Int

Users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(30)
  • password — VARCHAR(20) — NOT NULL