We need to add support for defining curricula in the lessons app

[timlinux]

See updated schema below which includes the curricula model.

@Charlotte-Morgan please comment if there are specific attributes you would like to see in the curruciculum form / output report.

[Gustry]

Between worksheet and curriculum:

• Each curriculum has zero or more worksheets but also each worksheet can be in zero or more curriculum. So it's becoming a many to many relationship (missing on the drawing)
• Each worksheet in a curriculum can have a different order in the curriculum, so we need another sequence number in this many to many relationship.

[timlinux]

Thanks @Gustry - I have updated the diagram accordingly here:

[ismailsunni]

• We need to implement the front end. ☝️ February 25, 2018 5:45 AM

[Gustry]

You need to implement everything, only models are there ;-)

[ismailsunni]

Hehe, sure @Gustry

@timlinux Is there any discussion about how will the front end look like? If not, perhaps I will create some mock-up before coding

[timlinux]

@ismailsunni yes please go ahead and make a mockup and then we can discuss it (and also show it to @Charlotte-Morgan).

[haubourg]

@timlinux Hi Tim,
if you plan to store personal data of students, please take attention to the European General Data Protection Regulation at https://www.eugdpr.org/ that instores privacy by design.
That may require some user features to allow data download or deletion. Data encryption and explicit user agreement are also mandatory.
Even if you are hosted outside of EU, as soon as EU citizen are in the database, we are submitted to it.
Cheers Régis

[timlinux]

@haubourg thanks for your comment. It does not really relate to the curriculum aspect (which details only how a collection of lessons can be created and named and printed out) so can I suggest to create a separate issue for this?

Also please comment in that ticket on whether law has any impact on us as a non-eu based project (QGIS is registered in Switzerland). We do plan to deploy under SSL regardless and having a mechanisme that course attendees can request their data to be removed sounds fine.

[timlinux]

Updated diagram based on our discussions today: