Sub_PJT1

Tables (3)

Comments (comment)

  • comment_id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → Post.post_id — NOT NULL
  • uid — char — Foreign key → User.uid — NOT NULL
  • create_date — datetime
  • Field

Post (post)

  • post_id — INT — Primary key — NOT NULL
  • uid — char — Foreign key → User.uid — NOT NULL
  • title (itle) — varchar
  • content — varchar
  • create_date — datetime

User (user)

  • uid — char — Primary key — NOT NULL
  • email — varchar
  • password — varchar
  • create_date — datetime