was_board
Tables (3)
User
- id — int — Primary key — NOT NULL
- email — VARCHAR(30) — NOT NULL
- password — VARCHAR(60) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
comment
- id — INT — Primary key — NOT NULL
- content — varchar(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- user_id — int — Foreign key → User.id — NOT NULL
- post_id — int — Foreign key → post.id — NOT NULL
post
- id — int — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(10000)
- user_id — int — Foreign key → User.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- view_count — int — NOT NULL