related tables in dexie about dexie.js HOT 2 CLOSED

// SchoolClass.ts
export class SchoolClass extends Entity<AppDB> {
  class_id!: string;
  class_name!: string;

  delete() {
    return this.db.transaction('rw', db.classes, db.student_classes, db.instructor_classes, () => {
      db.student_classes.where({classId: this.class_id}).delete();
      db.instructor_classes.where({classId: this.class_id}).delete();
      db.classes.delete(this.class_id);
    });
  }
}

// Student.ts
export class Student extends Entity<AppDB> {
  student_id!: string;
  student_name!: string;

  delete() {
    return this.db.transaction('rw', db.students, db.student_classes, db.instructor_classes, () => {
      db.student_classes.where({student_id: this.student_id}).delete();
      db.instructor_classes.where({student_id: this.student_id}).delete();
      db.students.delete(this.student_id);
    });
  }
}

// AppDB.ts
export class AppDB extends Dexie {
  students!: EntityTable<Student, 'student_id'>;
  classes!: EntityTable<SchoolClass, 'class_id'>;
  ...
}