ER 図

スキーマをエンティティ関連図として表示します。

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
}

スキーマを貼り付けると図を描画します。