MarsBlog
개인 블로그
테이블 (10)
Category
- id — SERIAL
- name — VARCHAR(255) — NOT NULL
- icon — VARCHAR(255)
- parentId — INT — 외래 키 → Category.id
Comment
- id — SERIAL
- content — TEXT — NOT NULL
- createdAt — TIMESTAMPTZ
- updatedAt — TIMESTAMPTZ
- postId — INT — 외래 키 → Post.id — NOT NULL
- authorId — INT — 외래 키 → User.id — NOT NULL
- parentId — INT — 외래 키 → Comment.id
- isSecret — BOOLEAN
Like
- id — SERIAL
- postId — INT — 외래 키 → Post.id — NOT NULL
- userId — INT — 외래 키 → User.id — NOT NULL
Portfolio
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- link — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- thumbnail — VARCHAR(255)
- startDate — TIMESTAMPTZ — NOT NULL
- endDate — TIMESTAMPTZ
- isActive — BOOLEAN
- createdAt — TIMESTAMPTZ
- updatedAt — TIMESTAMPTZ
Post
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- thumbnail — VARCHAR(255)
- createdAt — TIMESTAMPTZ
- updatedAt — TIMESTAMPTZ
- published — BOOLEAN
- authorId — INT — 외래 키 → User.id — NOT NULL
SocialLogin
- id — SERIAL
- provider — VARCHAR(255) — NOT NULL
- userId — INT — 외래 키 → User.id — NOT NULL
Tag
- id — SERIAL
- name — VARCHAR(255) — NOT NULL
User
- id — SERIAL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — Role
- createdAt — TIMESTAMPTZ
- updatedAt — TIMESTAMPTZ
_PostCategories
- A — INT — 기본 키 — 외래 키 → Post.id — NOT NULL
- B — INT — 기본 키 — 외래 키 → Category.id — NOT NULL
_PostTags
- A — INT — 기본 키 — 외래 키 → Post.id — NOT NULL
- B — INT — 기본 키 — 외래 키 → Tag.id — NOT NULL