entity relationship diagram

[aaarendt]

I think the documentation and especially the hackweek tutorials would benefit from a diagram showing relationships between the tables. I sketched out some very rough ideas here in a diagrams.net graphic.

We might want a proper entity relationship diagram just for the docs, but one that includes pictures of people in the snow say for tutorial purposes.

[aaarendt]

I think a key component of understanding the database structure is conveying what constitutes a unique row object. I suspect people might not initially realize that for every unique site_id there can be multiple unique rows of layer data, whereas every point id corresponds to a unique row. I think a graphic can convey that well.

[micah-prime]

@aaarendt this is a very good idea!