communityDB
Tables (5)
BoardHits
- board_hit_id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → Boards.board_id — NOT NULL
- hit — INT
Boards
- board_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- image_id — INT — Foreign key → Images.image_id — NOT NULL
- title — VARCHAR(32) — NOT NULL
- content — TEXT — NOT NULL
Comments
- comment_id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → Boards.board_id — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- content — TEXT — NOT NULL
Images
- image_id — INT — Primary key — NOT NULL
- file_url — VARCHAR(128)
Users
- user_id — INT — Primary key — NOT NULL
- image_id — INT — Foreign key → Images.image_id — NOT NULL
- nickname — VARCHAR(64) — NOT NULL
- email — VARCHAR(32) — NOT NULL
- password — VARCHAR(32) — NOT NULL
- deleted_at — TIMESTAMP