Database Structure - Types and Fields

  • Address β†’ This data type stores customers and couriers’ addresses.
  • App Settings β†’ There is data on how much the restaurant, the app, and the courier will earn. In addition, the application keeps the information on social media accounts and communication tools.
  • Approvement Request β†’ For restaurants to be listed and couriers to take on delivery, they must be approved by the admin. Approval requests are stored here.
  • Cart β†’ Carts are created automatically when users sign up for the app. Cart information is stored here.
  • Cart Items β†’ Meals in the carts are stored here as Cart Items.
  • Comment β†’ Data type where user comments and ratings are stored.
  • Courier β†’ It stores the information of the couriers.
  • Favorites β†’ Customers can add and remove restaurants from their favorites. Their information is stored here.
  • Meal β†’ It is the data type in which the meals of the restaurants are stored.
  • Notifications β†’ Customers receive notifications when the status of their orders is updated. These notifications are stored here.
  • Order β†’ The orders given by the customers are visible to the restaurant, courier, and admin. It is also used for analytics.
  • Report β†’ Restaurants can be commented on. These comments can be reported by users. Admin will see these reports on a separate screen and can delete them. These reports are stored in this data type.
  • Restaurant β†’ Restaurants information's stored in this data type.
  • Ticket β†’ It is the way for users to contact the admin. Tickets are stored here.
  • Ticket Messages β†’ Ticket messages are stored here.
  • User β†’ User information's stored in this data type.
  • User Details β†’ User's details are stored here.
Share