gistfile1

A Text snippet, saved for reference.

Text

1 file

Created 10 months ago

Updated 10 months ago

gistfile1.txt

1	generator client {
2	provider = "prisma-client-js"
3	engineType = "library"
4	}
5
6	datasource db {
7	provider = "postgresql"
8	}
9
10
11	// ENUMS
12
13	enum Role {
14	admin
15	}
16
17	enum TableType {
18	PHYSICAL
19	NAME_BASED
20	ONLINE
21	}
22
23	enum OrderStatus {
24	pending
25	preparing
26	served
27	paid
28	cancelled
29	}
30
31	enum PaymentMethod {
32	CASH
33	ONLINE
34	MIXED
35	CREDIT
36	}
37
38	enum CreditTransactionType {
39	CHARGE
40	PAYMENT
41	}
42
43	enum TransactionType {
44	PURCHASE
45	ORDER_CONSUMPTION
46	ADJUSTMENT
47	RETURN
48	}
49
50
51	// ADMIN PROFILE
52	model Profile {
53	id String @id @db.Uuid // references auth.users.id
54	email String @unique
55	password String
56	role Role @default(admin)
57	createdAt DateTime @default(now())
58
59	@@map("profiles")
60	}
61
62
63	// TABLES (Physical + Virtual)
64	model Table {
65	id String @id @default(uuid()) @db.Uuid
66	tableCode String @unique
67	tableType TableType
68	qrToken String @unique
69	isActive Boolean @default(true)
70	createdAt DateTime @default(now())
71
72	orders Order[]
73
74	@@map("tables")
75	}
76
77
78	// MENU
79	model MenuCategory {
80	id String @id @default(uuid()) @db.Uuid
81	name String @unique
82	createdAt DateTime @default(now())
83
84	items MenuItem[]
85
86	@@map("menu_categories")
87	}
88
89	model MenuItem {
90	id String @id @default(uuid()) @db.Uuid
91	name String
92	categoryId String @db.Uuid
93	price Decimal
94	isAvailable Boolean @default(true)
95	isSpecial Boolean @default(false)
96	createdAt DateTime @default(now())
97	updatedAt DateTime @updatedAt
98
99	category MenuCategory @relation(fields: [categoryId], references: [id])
100	orderItems OrderItem[]
101	recipes ItemRecipe[]
102
103	@@map("menu_items")
104	}
105
106
107	// CUSTOMERS (CREDIT / LEDGER)
108	model Customer {
109	id String @id @default(uuid()) @db.Uuid
110	fullName String
111	phoneNumber String @unique
112	totalDue Decimal @default(0)
113	createdAt DateTime @default(now())
114
115	orders Order[]
116	ledger CreditTransaction[]
117
118	@@map("customers")
119	}
120
121
122	// ORDERS
123	model Order {
124	id String @id @default(uuid()) @db.Uuid
125	tableId String @db.Uuid
126	customerId String? @db.Uuid
127	customerPhone String?
128	status OrderStatus @default(pending)
129
130	totalAmount Decimal @default(0)
131	discountAmount Decimal @default(0)
132	dueAmount Decimal @default(0)
133
134	cashAmount Decimal @default(0)
135	onlineAmount Decimal @default(0)
136
137	paymentMethod PaymentMethod?
138	paymentDetails String?
139	customerMessage String?
140
141	servedItemCount Int @default(0)
142
143	createdAt DateTime @default(now())
144	updatedAt DateTime @updatedAt
145
146	table Table @relation(fields: [tableId], references: [id])
147	customer Customer? @relation(fields: [customerId], references: [id])
148	items OrderItem[]
149	payments Payment[]
150	creditEntries CreditTransaction[]
151
152	@@index([tableId, status])
153	@@map("orders")
154	}
155
156
157	// ORDER ITEMS
158	model OrderItem {
159	id String @id @default(uuid()) @db.Uuid
160	orderId String @db.Uuid
161	menuItemId String @db.Uuid
162	quantity Int
163	priceSnapshot Decimal
164	createdAt DateTime @default(now())
165
166	order Order @relation(fields: [orderId], references: [id])
167	menuItem MenuItem @relation(fields: [menuItemId], references: [id])
168
169	@@map("order_items")
170	}
171
172
173	// PAYMENTS
174	model Payment {
175	id String @id @default(uuid()) @db.Uuid
176	orderId String @db.Uuid
177	method PaymentMethod
178	cashAmount Decimal @default(0)
179	onlineAmount Decimal @default(0)
180	createdAt DateTime @default(now())
181
182	order Order @relation(fields: [orderId], references: [id])
183
184	@@map("payments")
185	}
186
187
188	// CREDIT LEDGER
189	model CreditTransaction {
190	id String @id @default(uuid()) @db.Uuid
191	customerId String @db.Uuid
192	orderId String? @db.Uuid
193	amount Decimal
194	type CreditTransactionType @default(CHARGE)
195	description String?
196	createdAt DateTime @default(now())
197
198	customer Customer @relation(fields: [customerId], references: [id])
199	order Order? @relation(fields: [orderId], references: [id])
200
201	@@map("credit_transactions")
202	}
203
204
205	// INVENTORY & STOCK
206	model InventoryItem {
207	id String @id @default(uuid()) @db.Uuid
208	name String @unique
209	currentStock Int @default(0)
210	minimumStock Int @default(5)
211	unit String @default("pcs")
212	updatedAt DateTime @updatedAt
213
214	transactions InventoryTransaction[]
215	recipes ItemRecipe[]
216
217	@@map("inventory_items")
218	}
219
220	model InventoryTransaction {
221	id String @id @default(uuid()) @db.Uuid
222	inventoryItemId String @db.Uuid
223	type TransactionType
224	quantity Int
225	referenceId String?
226	createdAt DateTime @default(now())
227
228	inventoryItem InventoryItem @relation(fields: [inventoryItemId], references: [id])
229
230	@@map("inventory_transactions")
231	}
232
233	model ItemRecipe {
234	id String @id @default(uuid()) @db.Uuid
235	menuItemId String @db.Uuid
236	inventoryItemId String @db.Uuid
237	quantityRequired Int @default(1)
238
239	menuItem MenuItem @relation(fields: [menuItemId], references: [id])
240	inventoryItem InventoryItem @relation(fields: [inventoryItemId], references: [id])
241
242	@@unique([menuItemId, inventoryItemId])
243	@@map("item_recipes")
244	}
245
246
247	// PURCHASES
248	model PurchaseRecord {
249	id String @id @default(uuid()) @db.Uuid
250	itemName String
251	supplierName String?
252	supplierPhone String?
253	quantity Decimal
254	unit String
255	costPerUnit Decimal
256	totalCost Decimal
257	amountPaid Decimal @default(0)
258	remainingAmount Decimal @default(0)
259	purchaseDate DateTime @default(now())
260	paymentStatus String @default("pending")
261
262	@@map("purchase_records")
263	}
264
265