블로그 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