5.6
Tables (4)
comments
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → posts.id — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- comment — TEXT — NOT NULL
- created_at — TIMESTAMP
posts
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — INT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- created_at — TIMESTAMP