Please enable JavaScript.
Coggle requires JavaScript to display documents.
Burger Server, Resturant And User, Orders - Coggle Diagram
Burger Server
User Schema
User id (uuid)
First Name - string
Last Name - string
Email - string
Password - string with hash
isVerfied (Verification): Boolean
isDeleted (Soft Delete): boolean
Address - string
Role - string
Contact Number - string
Timestamps - Date
Resturant Schema
Restaurants Id
Name
Address
City id
City Schema
City Id
City Name
Zip Code
Placed Order Schema
Id
Restaurant Id - uuid
Order Time - Date
Estimated Delivery Time - Date
Food Status
0-pending
1 - completed
2 - cancelled
Delivery Address - String
User Id - uuid
Price - Number
Discount - Number
Total Price - Number
Comments - String
Timestamps - Date
Comment Schema
Id - uuid
Placed Order Id - uuid
User Id - uuid
Comment Text - String
Ongoing Order
Id - uuid
Placed Order Id - uuid
Offer Id - uuid
Menu Item Id - uuid
Quantity - Number
Item Price - Number
Price - Number
Comment - String
Order status
Status
1 - completed
2 - cancelled
0 - pending
Placed order id
Id
Menus
Offer Schema
Id - uuid
From Activation Date and time - Date
To Activation Date and Time - Date
Offer Price - Number
In Offer Schema
Id - uuid
Offer Id - uuid
Menu Item Id - uuid
Menu Item
Id - uuid
Item Name - String
Category Id - uuid
Description - String
Ingredients - String
Recipe - Array of Strings
Price - Number
Active - Boolean
Category
Id - uuid
Category Name - String
Resturant And
User
Orders