Database Structure

Each customer in AI-School receives a separate database in Google Cloud. Security rules can be set on this database, and the administrator can set permissions for reading and writing to this database per role.

Default Database

In addition to customer databases, there is a default database. This stores data applicable to all AI-School customers, such as news articles and documentation.

We have chosen to also store account information on this database. If a customer database falls into the wrong hands, the chats and chat messages that may contain sensitive information cannot be linked to accounts.

Chats and chat messages are stored anonymously in customer databases and cannot be linked to names.

Tenant Databases

Each AI-School customer receives their own database where all chats, chat messages, schools, groups, students, and staff are stored. Upon leaving the platform, all data will be immediately destroyed.

Accounts are stored per customer in a tenant silo on Google Cloud. These accounts can also be deleted in bulk, and a Cloud Function ensures that all associated account records are automatically deleted from the default database.

Database Security

Databases are secured using Security Rules. During an audit, we can provide access to this code if desired.