Changes between Initial Version and Version 1 of RelationalSchema

Timestamp:

01/05/25 20:01:46 (10 months ago)

Author:

221128

Comment:

--

RelationalSchema

@@ +1 @@
+
+
+== Relational Mapping - Partial Transformation  
+=== Notations  
+* Primary keys are marked with **__bold and underlined letters__** \\   
+* Foreign keys are marked with *
+=== Relational Schema
+1. User(**__id__**, email, street, city, phone_number, password)  
+2. Employee(**__user_id__***, net_salary, gross_salary)  
+3. Customer(**__user_id__***)  
+4. Manager(**__user_id__***)  
+5. FrontStaff(**__employee_id__***, tip_percent, staff_role_id*)  
+6. BackStaff(**__employee_id__***, staff_role_id*)  
+7. StaffRole(**__staff_role_id__**, name)  
+8. Shift(**__shift_id__**, date, start, end, manager_id*)  
+9. Assignment(**__id__**, clock_in_time, clock_out_time, manager_id*, employee_id*, shift_id*)  
+
+10. Reservation(**__id__**, stay_length, datetime, creation_timestamp, number_of_people, user_id*)  
+11. Reservation_managed_FrontStaff(**__reservation_id__***, **__employee_id__***, **__table_number__***)  
+
+12. Category(**__id__**, name, is_available)  
+13. Product(**__id__**, name, price, tax_class, description, manage_inventory, category_id*)  
+14. Inventory(**__product_id__***, quantity, restock_level)  
+15. OrderItem(**__id__**, quantity, price, is_processed, timestamp, product_id*, order_id*)  
+
+16. Order(**__id__**, timestamp, status)  
+17. TabOrder(**__order_id__***, table_number*, frontstaff_id*)  
+18. OnlineOrder(**__order_id__***, **__customer_id__***, delivery_adress)  
+19. Table(**__table_number__**, seat_capacity)  
+20. Payment(**__id__**, tip_amount, timestamp, payment_type, amount, order_id*)  
+
+== DDL Script for Dropping and Creating Tables
+[attachment:​ddl (1).sql​]
+== DML Script for Populating Tables with Data 
+[attachment:dml (1).sql​]
+== Tables
+[[Image(schema1.png)]]