Changes between Version 6 and Version 7 of ConceptualModel

Timestamp:

02/14/25 19:47:28 (8 days ago)

Author:

221128

Comment:

--

ConceptualModel

@@ -60 +60 @@
      * **start**: Start time of the shift.  
      * **end**: End time of the shift.
-     * **employee_id**: Foreign key referencing `Manager`.
+     * **manager_id**: Foreign key referencing `Manager`.
 
  * **Entity: Assignment**  
@@ -83 +83 @@
      * **creation_timestamp**: Timestamp when the reservation was created.  
      * **number_of_people**: Number of people in the reservation.  
-     * **customer_id**: Foreign key referencing `Customer`.  
+     * **user_id**: Foreign key referencing `User`.  
 
 
@@ -128 +128 @@
      * **timestamp**: Time when the order was placed.  
      * **status**: Status of the order.  
-     * **employee_id**: Foreign key referencing `Employee`.  
 
  * **Entity: TabOrder**  
@@ -134 +133 @@
    * **Primary Key**: `order_id`.  
    * **Attributes**:  
-     * **table_number**: Foreign key referencing `Table`.   
+     * **table_number**: Foreign key referencing `Table`.
+     * **frontstaff_id**: Foreign key referencing `FrontStaff`.  
+   
 
  * **Entity: OnlineOrder**  
@@ -140 +141 @@
    * **Primary Key**: `order_id`.  
    * **Attributes**:  
-     * **customer_id**: Foreign key referencing `Customer`.  
+     * **customer_id**: Foreign key referencing `Customer`.
+     * **delivery_adress**: Delivery adress for the order. 
+  
 
  * **Entity: Table**