Marklet

Database Schema

Application Store Database

Database schema structure containing Users, Apps, Categories, Reviews, and Downloads tables.

Tables Structure

  1. 1Usersid, name, email, password, created_at
  2. 2Appsid, name, description, category_id, icon_url, model_url, download_url, version, file_size, created_at
  3. 3Categoriesid, name
  4. 4Reviewsid, user_id, app_id, rating, comment, created_at
  5. 5Downloadsid, user_id, app_id, downloaded_at