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)