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