board

Tables (5)

account

  • id — int — Primary key — NOT NULL
  • account — varchar(64) — NOT NULL
  • password — varchar(64) — NOT NULL
  • role — int — NOT NULL
  • profile_pic — text
  • email — varchar(128) — NOT NULL
  • reg_date — timestamp — NOT NULL

board

  • id — int — Primary key — NOT NULL
  • password — varchar(64) — NOT NULL
  • title — varchar(64) — NOT NULL
  • post — text
  • likes — int — NOT NULL
  • dislikes — int — NOT NULL
  • reg_date — timestamp — NOT NULL
  • edit_date — timestamp

comments

  • id — int — Primary key — NOT NULL
  • account_id — int — NOT NULL
  • post_id — unsigned — NOT NULL
  • comment — text — NOT NULL
  • post_date — timestamp — NOT NULL
  • Field — timestamp

likedislike

  • account_id — int — NOT NULL
  • id — int — NOT NULL
  • liked — bit
  • disliked — bit
  • checked — bit

scrap

  • id — int — Primary key — NOT NULL
  • account_id — int — NOT NULL
  • post_id — int — NOT NULL