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