prisma-next/examples/retail-store/migrations/app/20260513T0505_initial/contract.prisma at dfd2de069a72bdd0977eb38ca6791d016d4ff59d · prisma/prisma-next · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
// use prisma-next

type Price {
  amount   Float
  currency String
}

type Image {
  url String
}

type Address {
  streetAndNumber String
  city            String
  postalCode      String
  country         String
}

type CartItem {
  productId String
  name      String
  brand     String
  amount    Int
  price     Price
  image     Image
}

type OrderLineItem {
  productId String
  name      String
  brand     String
  amount    Int
  price     Price
  image     Image
}

type StatusEntry {
  status    String
  timestamp DateTime
}

type InvoiceLineItem {
  name      String
  amount    Int
  unitPrice Float
  lineTotal Float
}

model Product {
  id             ObjectId @id @map("_id")
  name           String
  brand          String
  code           String
  description    String
  primaryCategory String
  subCategory    String
  articleType    String
  price          Price
  image          Image
  @@map("products")
  @@textIndex([name, description], weights: "{\"name\": 10, \"description\": 1}")
  @@index([brand, subCategory])
  @@index([code], type: "hashed")
}

model User {
  id      ObjectId @id @map("_id")
  name    String
  email   String   @unique
  address Address?
  carts   Cart[]
  orders  Order[]
  @@map("users")
}

model Cart {
  id     ObjectId   @id @map("_id")
  userId ObjectId
  items  CartItem[]
  user   User       @relation(from: [userId], to: [id])
  @@map("carts")
  @@unique([userId])
}

model Order {
  id              ObjectId         @id @map("_id")
  userId          ObjectId
  items           OrderLineItem[]
  shippingAddress String
  type            String
  statusHistory   StatusEntry[]
  user            User             @relation(from: [userId], to: [id])
  invoices        Invoice[]
  @@map("orders")
  @@index([userId])
}

model Location {
  id              ObjectId @id @map("_id")
  name            String
  streetAndNumber String
  city            String
  postalCode      String
  country         String
  @@map("locations")
  @@index([city, country], collationLocale: "en", collationStrength: 2)
}

model Invoice {
  id       ObjectId          @id @map("_id")
  orderId  ObjectId
  items    InvoiceLineItem[]
  subtotal Float
  tax      Float
  total    Float
  issuedAt DateTime
  order    Order             @relation(from: [orderId], to: [id])
  @@map("invoices")
  @@index([orderId])
  @@index([issuedAt(sort: Desc)], sparse: true)
}

model Event {
  id        ObjectId @id @map("_id")
  userId    String
  sessionId String
  type      String
  timestamp DateTime
  @@map("events")
  @@discriminator(type)
  @@index([userId, timestamp(sort: Desc)])
  @@index([timestamp], expireAfterSeconds: 7776000)
}

model ViewProductEvent {
  productId   String
  subCategory String
  brand       String
  exitMethod  String?
  @@base(Event, "view-product")
}

model SearchEvent {
  query String
  @@base(Event, "search")
}

model AddToCartEvent {
  productId String
  brand     String
  @@base(Event, "add-to-cart")
}