Changes between Version 26 and Version 27 of SQL & DDL

Timestamp:

09/23/25 21:33:11 (3 weeks ago)

Author:

213231

Comment:

--

SQL & DDL

@@ -22 +22 @@
 **Product**\\
 - ProductID (PK)
+- PrcurementID (FK -> Prcurement)
 - Model
 - Price
@@ -38 +39 @@
 - TransactionID (PK)
 - EmployeeID (FK → Employee)
-- CustomerID (FK → Customer)
-- ProductID (FK → Product)
 - ProcurementDate
 - Quantity
@@ -55 +54 @@
 **CustomerFeedback**\\
 - FeedbackID (PK)
-- TransactionID (FK)
 - CustomerID (FK)
-- ProductID (FK)
 - Rating (1-5)
 - Comment
@@ -64 +61 @@
 **Maintenance**\\
 - MainID (PK)
-- EmployeeID (FK → Employee)
-- ProductID (FK → Product)
 - MainDate
 - Description
@@ -79 +74 @@
 * Wallet **\\
 
-- WalletID (PK)
+- WalletID (PK)a
 - CustomerID (FK → Customer)
+- ProcurementRequestID (FK -> ProcurementRequest)
 - Balance
 - CardNumber