Platform Architecture

// Database Markup Language (DBML) for Pass-Exams Platform
// This diagram illustrates our user-centric, sandboxed data model.

// The 'users' table is the root for all user-specific data.
// The 'id' is the Firebase Auth UID, acting as the primary key.
Table users {
  id varchar [primary key, note: 'Firebase Auth UID']
  email varchar [unique, not null]
  displayName varchar
  photoURL varchar
  createdAt timestamp
  subscriptionStatus varchar
  isCustomer boolean
}

// A sub-collection under 'users'.
// Stores custom quizzes created by a user.
Table exams {
  id varchar [primary key, note: 'Auto-generated ID']
  user_id varchar [not null, ref: > users.id]
  title varchar [not null]
  description text
  public boolean [default: false]
  createdAt timestamp
}

// A sub-collection under 'users'.
// Stores questions a user has bookmarked for review.
Table bookmarkedQuestions {
  question_id varchar [primary key, note: 'The ID of the bookmarked question']
  user_id varchar [not null, ref: > users.id]
  quiz_id varchar [not null]
  createdAt timestamp
}