gistfile1

Database models for RMS

Text

1 file

Created 10 months ago

Updated 10 months ago

gistfile1.txt

1	generator client {
2	provider = "prisma-client-js"
3	}
4
5	datasource db {
6	provider = "postgresql"
7	url = env("DATABASE_URL")
8	}
9
10
11	// ENUMS
12
13
14	enum Role {
15	admin
16	}
17
18	enum TableType {
19	PHYSICAL
20	NAME_BASED
21	ONLINE
22	}
23
24	enum OrderStatus {
25	pending
26	preparing
27	served
28	paid
29	cancelled
30	}
31
32	enum PaymentMethod {
33	CASH
34	ONLINE
35	MIXED
36	CREDIT
37	}
38
39
40	// ADMIN PROFILE
41	model Profile {
42	id String @id @db.Uuid // references auth.users.id
43	email String @unique
44	password String
45	role Role @default(admin)
46	createdAt DateTime @default(now())
47
48	@@map("profiles")
49	}
50
51
52	// TABLES (Physical + Virtual)
53	model Table {
54	id String @id @default(uuid()) @db.Uuid
55	tableCode String @unique
56	tableType TableType
57	qrToken String @unique
58	isActive Boolean @default(true)
59	createdAt DateTime @default(now())
60
61	orders Order[]
62
63	@@map("tables")
64	}
65
66
67	// MENU
68	model MenuCategory {
69	id String @id @default(uuid()) @db.Uuid
70	name String @unique
71	createdAt DateTime @default(now())
72
73	items MenuItem[]
74
75	@@map("menu_categories")
76	}
77
78	model MenuItem {
79	id String @id @default(uuid()) @db.Uuid
80	name String
81	categoryId String
82	price Decimal
83	isAvailable Boolean @default(true)
84	isSpecial Boolean @default(false)
85	createdAt DateTime @default(now())
86	updatedAt DateTime @updatedAt
87
88	category MenuCategory @relation(fields: [categoryId], references: [id])
89	orderItems OrderItem[]
90
91	@@map("menu_items")
92	}
93
94
95	// CUSTOMERS (CREDIT / LEDGER)
96
97	model Customer {
98	id String @id @default(uuid()) @db.Uuid
99	fullName String
100	phoneNumber String @unique
101	totalDue Decimal @default(0)
102	createdAt DateTime @default(now())
103
104	orders Order[]
105	ledger CreditTransaction[]
106
107	@@map("customers")
108	}
109
110	// ORDERS
111	model Order {
112	id String @id @default(uuid()) @db.Uuid
113	tableId String
114	customerId String?
115	customerPhone String?
116	status OrderStatus @default(pending)
117
118	totalAmount Decimal @default(0)
119	discountAmount Decimal @default(0)
120	dueAmount Decimal @default(0)
121
122	cashAmount Decimal @default(0)
123	onlineAmount Decimal @default(0)
124
125	paymentMethod PaymentMethod?
126	paymentDetails String?
127	customerMessage String?
128
129	servedItemCount Int @default(0)
130
131	createdAt DateTime @default(now())
132	updatedAt DateTime @updatedAt
133
134	table Table @relation(fields: [tableId], references: [id])
135	customer Customer? @relation(fields: [customerId], references: [id])
136	items OrderItem[]
137	payments Payment[]
138	creditEntries CreditTransaction[]
139
140	@@index([tableId, status])
141	@@map("orders")
142	}
143
144
145	// ORDER ITEMS
146	model OrderItem {
147	id String @id @default(uuid()) @db.Uuid
148	orderId String
149	menuItemId String
150	quantity Int
151	priceSnapshot Decimal
152	createdAt DateTime @default(now())
153
154	order Order @relation(fields: [orderId], references: [id])
155	menuItem MenuItem @relation(fields: [menuItemId], references: [id])
156
157	@@map("order_items")
158	}
159
160	// PAYMENTS
161	model Payment {
162	id String @id @default(uuid()) @db.Uuid
163	orderId String
164	method PaymentMethod
165	cashAmount Decimal @default(0)
166	onlineAmount Decimal @default(0)
167	createdAt DateTime @default(now())
168
169	order Order @relation(fields: [orderId], references: [id])
170
171	@@map("payments")
172	}
173
174	// CREDIT LEDGER
175	model CreditTransaction {
176	id String @id @default(uuid()) @db.Uuid
177	customerId String
178	orderId String
179	amount Decimal
180	createdAt DateTime @default(now())
181
182	customer Customer @relation(fields: [customerId], references: [id])
183	order Order @relation(fields: [orderId], references: [id])
184
185	@@map("credit_transactions")
186	}
187
188
189	// INVENTORY
190	model Inventory {
191	id String @id @default(uuid()) @db.Uuid
192	itemName String
193	supplierName String?
194	supplierPhone String?
195	quantity Decimal
196	unit String
197	costPerUnit Decimal
198	totalCost Decimal
199	amountPaid Decimal @default(0)
200	remainingAmount Decimal @default(0)
201	purchaseDate DateTime @default(now())
202	paymentStatus String @default("pending")
203
204	@@map("inventory")
205	}
206