seedmint
Web Studio
Generar
Studio
Diagrama
Datos
Historial
Explorar
Idiomas de datos
Formatos
Hoja de ruta
GitHub
Toggle Sidebar
Diagrama
Mira tu esquema como un diagrama entidad-relación.
Generar datos
Exportar
Tu esquema
model User { id Int @id @default(autoincrement()) name String email String @unique phone String? createdAt DateTime @default(now()) addresses Address[] orders Order[] reviews Review[] } model Address { id Int @id @default(autoincrement()) userId Int user User @relation(fields: [userId], references: [id]) street String city String country String zipCode String isDefault Boolean } model Category { id Int @id @default(autoincrement()) name String slug String @unique products Product[] } model Product { id Int @id @default(autoincrement()) categoryId Int category Category @relation(fields: [categoryId], references: [id]) name String sku String @unique price Float stock Int createdAt DateTime @default(now()) reviews Review[] } model Order { id Int @id @default(autoincrement()) userId Int user User @relation(fields: [userId], references: [id]) total Float status OrderStatus createdAt DateTime @default(now()) items OrderItem[] payment Payment? } model OrderItem { id Int @id @default(autoincrement()) orderId Int order Order @relation(fields: [orderId], references: [id]) productId Int quantity Int unitPrice Float } model Payment { id Int @id @default(autoincrement()) orderId Int @unique order Order @relation(fields: [orderId], references: [id]) amount Float method PaymentMethod paidAt DateTime } model Review { id Int @id @default(autoincrement()) userId Int user User @relation(fields: [userId], references: [id]) productId Int product Product @relation(fields: [productId], references: [id]) rating Int comment String? createdAt DateTime @default(now()) } enum OrderStatus { PENDING PAID SHIPPED DELIVERED CANCELLED } enum PaymentMethod { CARD BANK_TRANSFER CASH WALLET }
Pega un esquema para dibujarlo.