-
Database
Design a schema for user-generated content
Plans tables, indexes, and relationships for posts, comments, and likes with sane defaults and soft-delete support.
Free Prompt
Design a database schema for user-generated content in my app. Include tables, indexes, and relationships for posts, comments, and likes. Use sane defaults, add soft-delete support, and explain your choices for keys and indexes.
What This Does / How This Helps
Plans a solid schema for posts, comments, and likes before you write a line of code — with indexes, relationships, and soft deletes baked in. Getting this right up front saves you from painful migrations and slow queries once real data starts piling up.
Want to skip doing this by hand?
Fortivibe audits your app for all of the areas these prompts cover (and more).