Data model scope - Kosudo/nextSIS GitHub Wiki

I could design this data model here using a fairly abstracted entity-relationship diagram but there's a problem - I can't identify a particularly good free or open source cross-platform tool to do it. Then I thought that it would be better - at the design stage - to just write up the data model in MySQL (yes) and then you can see everything in phpMySQL's Designer Mode. Also, this way, we're going to be very clear about exactly what properties of the fields are going to be, because what you see is what you're going to get.

All that then remains is to upload the SQL code after design changes. It's not completely ideal - but unless anyone has any better ideas (I'm open to them...)

In describing the fields I'm only doing so where explanations seem to be required, which might be for most of them, but I'm not guaranteeing it will be for all.