Database Structure

Data Types


  • Acquired Products → When the user purchases a product, a new entry is created. In this entry, information about the product purchased by the user and the coupon code (if any) defined for the user are stored here.
  • App Settings → It contains only one entry. It is managed in the admin dashboard. The commission percentage to be applied in product sales is stored here.
  • The admin must approve approvement Request → Users to list the product they want to sell. The information on the products requesting approval is stored here.
  • Bookmarks → The products bookmarked by the users are stored here.
  • Comment → The comments made by the users to the products are stored here.
  • Newsletter Subscribers → Emails of users who subscribe to the application's newsletter are stored here.
  • Product → Product information is stored here.
  • Product Code → An entry is created for each product of the software type, and the codes and code numbers of these products are stored here.
  • Product Gallery → Galleries can be created for the products to be more understandable to the users. Doing so is entirely optional. It is presented on the product page in a slider.
  • Question → Questions about the product are stored here.
  • Report → Users can report another user's comment or question. The admin reviews the reported content, and the admin can delete this content if a correct report is made.
  • Transactions → A transaction entry is created every time the user purchases a product. It is used for the "Analytics" tab on the Dashboard pages.
  • User → User information is stored here.
🔒
Not everyone can access all data. The privacy rules can be defined by who can access which data. Thus, only users with the allowed role can access specific data. Take a closer look at how privacy rules are set up in this template. → https://www.notion.so/rapid-dev/Privacy-Rules-21f7dfc6a3544d70b5db365b14473697