WAS
Tables (3)
comment
- id — char(36) — Primary key — NOT NULL
- nickname — varchar(50) — NOT NULL
- content — varchar(500) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
- user_id — char(36) — Foreign key → user.id — NOT NULL
- post_id — char(36) — Foreign key → post.id — NOT NULL
post
- id — char(36) — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- nickname — varchar(50) — NOT NULL
- content — varchar(1000) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
- view_count — uint — NOT NULL
- user_id — char(36) — Foreign key → user.id — NOT NULL
user
- id — char(36) — Primary key — NOT NULL
- email — varchar(100) — NOT NULL
- nickname — varchar(50) — NOT NULL
- password — char(60)
- salt — char(29)
- access_token — char(40)
- created_at — datetime — NOT NULL