everyDay

Tables (3)

post

  • post_id — Primary key — NOT NULL
  • id — varchar(50) — Foreign key → user.id — NOT NULL
  • title — varchar(100)
  • content — longtext
  • author — varchar(20)
  • vote_count — int(11)
  • create_at — datetime
  • update_at — datetime
  • Field

post_coment

  • coment_id — bigint(20) — Primary key — NOT NULL
  • post_id — Foreign key → post.post_id — NOT NULL
  • id — varchar(50) — Foreign key → post.id — NOT NULL
  • content — longtext
  • Field
  • parent_comment_id

user

  • id — varchar(50) — Primary key — NOT NULL
  • password — varchar(255)
  • username — varchar(15)
  • create_at — datetime
  • update_at — datetime