dbg

Tables (4)

Comment

  • CommentID — INT — Primary key — NOT NULL
  • PostID — INT — Foreign key → Post.PostID — NOT NULL
  • UID — VARCHAR — Foreign key → User.UID — NOT NULL
  • context — VARCHAR
  • datetime — DATETIME

Like

  • PostID — INT — Foreign key → Post.PostID — NOT NULL
  • UID — VARCHAR — Foreign key → User.UID — NOT NULL

Post

  • PostID — INT — Primary key — NOT NULL
  • UID — VARCHAR — Foreign key → User.UID — NOT NULL
  • title — VARCHAR
  • context — VARCHAR
  • like
  • datetime — DATETIME

User

  • UID — VARCHAR — Primary key — NOT NULL
  • password — VARCHAR