chore/academic calendar schema

[czaja307]

No description provided.

[mateusz-plaska]

This is db schema for academic calendar. I have added two extra tables which are not currently in existing model. I think tables "holidays" and "events" might be useful in the future but that is only my suggestion.

[czaja307]

here are some comments:

1. I prefer using text over varchars whenever possible, when using postgreSQL(https://stackoverflow.com/questions/4848964/difference-between-text-and-varchar-character-varying)
2. I'm not a fan of storing recurring holidays this way - either omit it and store new instance in every calendar (personally i'd go with this one) or create new table with recurring holidays
3. Events calendar is scope of another task feat/event calendar #3 (it needs some more discussion so leave it or now - you can post the current events table there for future reference)

[mateusz-plaska]

Right, here is the corrected schema - without 'current events' table.
Should I add this table to the schema? And if so, how should it look like (id, academic_calendar_id, event_id - taken this from the 'events calendar' table of another task)?
But will this table be necessary and useful for us?

[czaja307]

Schema looks good, great job!
When it comes to events table you can add your version of it as-is into the #3 - it's a solid starting point for that task, which comes later in our roadmap.