Database & Prisma Schema
Prisma Schema
model Person {
id Int @id @default(autoincrement())
name String
email String @unique
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
}
The Person model represents a user in the database. Each person has a unique id, name, email, and timestamps for creation and updates. Prisma manages migrations and type safety for all database operations.
Database Structure
- Table:
Person - Primary Key:
id(auto-increment integer) - Fields:
name,email(unique),createdAt,updatedAt
The database is managed via Prisma migrations and connects to a PostgreSQL instance for reliable, scalable data storage.