dev-blog

테이블 (4)

게시글 (blog.Post)

  • post_idx (idx) — INT — 기본 키 — NOT NULL
  • category_idx — INT — 외래 키 → 카테고리.category_idx — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • tags — VARCHAR(100)
  • description — VARCHAR(255)
  • content — TEXT
  • thumbnail — VARCHAR(255)
  • is_temp — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

사용자 세션 (users.Session)

  • session_idx (idx) — INT — 기본 키 — NOT NULL
  • session_id — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

카테고리 (blog.Category)

  • category_idx (idx) — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

포트폴리오 (portfolio.Item)

  • item_idx (idx) — INT — 기본 키 — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL