맛집 블로그 ERD
테이블 (4)
categories
- category_id — BIGINT
- name — VARCHAR(50) — NOT NULL
- slug — VARCHAR(80) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
comments
- comment_id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
posts
- post_id — BIGINT
- author_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- title — VARCHAR(150) — NOT NULL
- content — TEXT — NOT NULL
- restaurant_name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- visited_at — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — ENUM('ADMIN','USER') — NOT NULL
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL