blog
Tables (6)
categories (카테고리)
- id — int — Primary key — NOT NULL
- name — varchar
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
- level — enum('0', '1')
- parent_id — int
- content — text
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
images (이미지 파일)
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → posts.id — NOT NULL
- order — int
- url — varchar
post_category (게시글-카테고리 중간 테이블)
- id — int — Primary key — NOT NULL
posts (게시글)
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL
- title — varchar
- content — text
- views — int
- likes — int
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
users (사용자)
- id — int — Primary key — NOT NULL
- email — varchar
- name — varchar
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime