search

SnowEx / snowex_db

Repository for tracking and building a postgis database designed to hold data for the SnowEx campaign
2 stars 2 forks source link

entity relationship diagram #8

Open aaarendt opened 2 years ago

aaarendt commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

@aaarendt this is a very good idea!