CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutSign UpSign In
sagemathinc

Real-time collaboration for Jupyter Notebooks, Linux Terminals, LaTeX, VS Code, R IDE, and more,
all in one place.

GitHub Repository: sagemathinc/cocalc
Path: blob/master/src/packages/util/db-schema/README.md
Views: 687

Database Schema

The files here define permissions and tables for our database.

The most important tables are:

  • accounts: id's and information about all registered users

  • projects: id's and information (e.g., who can use) all projects

  • public_paths: which paths in projects are public

  • server_settings: how the server is configured

  • site_licenses: all the site licenses that people have bought

I think that if we had just those and nothing else then we could recreate the site, and only loose the history of editing files, the logs from what has happened in projects, and all analytics.