Essential Database Schema for Your MVP

Define a robust database schema for your classifieds marketplace using SQL or Prisma to manage users, listings, and categories efficiently.

Database Schema Overview

A well-structured database is crucial for your MVP. Below is a sample schema using Prisma:

model User { id Int @id @default(autoincrement()) email String @unique listings Listing[] }
model Listing { id Int @id @default(autoincrement()) title String description String userId Int @relation(fields: [userId], references: [id]) }
model Category { id Int @id @default(autoincrement()) name String listings Listing[] }