board_api
Tables (4)
board
- board_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- title — VARCHAR(30) — NOT NULL
- content — TEXT — NOT NULL
- views — INT — NOT NULL
- createAt — timestamp — NOT NULL
- modifyAt — timestamp — NOT NULL
- isDeleted — boolean — NOT NULL
commnet
- commnet_id (comment_id) — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- content — VARCHAR(100) — NOT NULL
- createAt — timestamp — NOT NULL
- modifyAt — timestamp — NOT NULL
image
- image — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL
- user_id — INT — Foreign key → board.user_id — NOT NULL
- originName — VARCHAR(100) — NOT NULL
- saveName — VARCHAR(100) — NOT NULL
- imagePath — VARCHAR(100) — NOT NULL
- imageSize — INT — NOT NULL
user
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(30) — NOT NULL
- password — VARCHAR(50) — NOT NULL