portfolio-blog

Tables (6)

Post

  • Key (id) — int — Primary key — NOT NULL
  • Key (categoryId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — string
  • Field (content) — text
  • Field (createdAt) — datetime(6)
  • Field (updatedAt) — datetime(6)

Untitled (Category)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar

Untitled (Tag)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar

Untitled (PostTag)

  • Key (postId) — int — Foreign key → Post.Key — NOT NULL
  • Key (tagId) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Comment)

  • Key (id) — int — Primary key — NOT NULL
  • Key (postId) — int — Foreign key → Post.Key — NOT NULL
  • Field (comment) — varchar
  • Field2 (createdAt) — datetime(6)

Untitled (Image)

  • Key (id) — int — Primary key — NOT NULL
  • Key (postId) — int — Foreign key → Post.Key — NOT NULL
  • Field (url) — varchar
  • Field2 (uploadedAt) — datetime(6)