Graphical representation of the pool management database

[Sebhoster]

I stumbled across https://chartdb.io and thought “why not”? So I created this mapping of the ntp pool management database for anyone who’s interested:

The database version is from somewhere between the 20th and 26th of January, newer changes are not yet reflected.

Edit: Seems like Discourse compresses images significantly. So here is the link to the chart: ChartDB - Create & Visualize Database Schema Diagrams

[ask]

Nice!

I noticed a couple missing foreign keys. Fixed now – thank you!

I’ve been doing a rewrite of how monitors are provisioned and the APIs they use, so the development instance has a lot of changes not in production yet. I put the latest schema file into the data-api repository: data-api/schema.sql at main · ntppool/data-api · GitHub