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