블로그 DB
테이블 (6)
admin (Untitled3)
- id (Key) — uuid — 기본 키 — NOT NULL
- email (Field) — varchar(64) — NOT NULL
- display_name (Field2) — varchar(64) — NOT NULL
- password (Field3) — varchar(128) — NOT NULL
category (Untitled2)
- id (Key) — uuid — 기본 키 — NOT NULL
- name (Field) — varchar(64) — NOT NULL
- description (Field2) — varchar(255)
comment (Untitled4)
- id (Key) — uuid — 기본 키 — NOT NULL
- commenter (Field) — varchar(64) — NOT NULL
- password (Field2) — varchar(128) — NOT NULL
- content (Field3) — varchar(255)
- reply_id (Field4) — uuid
post (Untitled)
- slug (Key) — varchar(64) — 기본 키 — NOT NULL
- title (Field) — varchar(64) — NOT NULL
- content (Field2) — text — NOT NULL
- access_level (Field4) — enum — NOT NULL
- thumbnail (Field5) — varchar(255)
post_category (Untitled5)
- category_id (Key2) — uuid — 외래 키 → category.id — NOT NULL
- post_slug (Key) — varchar(64) — 외래 키 → post.slug — NOT NULL
post_comment (Untitled6)
- comment_id (Key2) — uuid — 외래 키 → comment.id — NOT NULL
- post_slug (Key) — varchar(64) — 외래 키 → post.slug — NOT NULL