bio_data_guide add relational diagrams for example datasets

I have previously used quickDBD to create diagrams of how the occurence, MoF, event, etc files/tables connect with each other. I find these views tremendously useful and would like to encourage including them for the example datasets.

Then again... does anyone else find database diagrams useful or is it just me?

bare-minimum example (tier 0):

more detailed example:

Sep 17 '21 20:09 7yl4r

I think those are very helpful!

Sep 17 '21 20:09 MathewBiddle

it would be interesting to put that subsample example in this visual https://github.com/ioos/bio_data_guide/issues/41

Sep 17 '21 20:09 MathewBiddle

Yes very helpful. Only question for me is if separating event MOFs from occurrence MOFs will give the impression they are separate files?

Sep 17 '21 20:09 AbbyBenson

When I made this I think I was thinking that they were separate files.

So each row in the MoF table has both an eventID and measurementID column and only one should ever be filled out?

Sep 17 '21 21:09 7yl4r

All of them will have an eventID but only the ones that are linked to occurrences will have occurrenceIDs. See the table at the very bottom here.

Sep 17 '21 21:09 AbbyBenson

I've never used measurementID.

Sep 17 '21 21:09 AbbyBenson

All of them will have an eventID but only the ones that are linked to occurrences will have occurrenceIDs. See the table at the very bottom here.

Ah, that makes perfect sense. I will update the diagram before posting it elsewhere.

Sep 17 '21 22:09 7yl4r

There's also a great R package for this called dm https://cynkra.github.io/dm/

I personally find them very helpful though they made need some explanation for those unfamiliar with them.

Jan 19 '22 16:01 Br-Johnson