This project is the 2020 version of https://www.mehr-schulferien.de

The webpage provides information about school vacations and public holidays in Germany.

See the contributing guide for more information about setting up your development environment and opening pull requests.

The situation: We have countries, federal_states, counties, cities and schools. They all have different possibilities to set vacation dates or public holidays.

We aim to be able to render all pages on the fly. So our main problem is to make it possible that we can read the needed data fast. That is the idea behind the data model.

Locations are the table which stores countries, federal_states, counties, cities and schools. They are all linked to the parent_location. By that, we can walk up the tree.

A city can have multiple zip_codes and one zip_code can belong to multiple cities. Therefore we have a zip_code_mapping table which connects them to the location of a city.

Religion stores available religions. holiday_or_vacation_types stores the types of different holidays and vacations. periods store the actual dates.

This document will be updated regularly.

The seedings process is not finalized yet. Until then you have to do the following steps:

• priv/repo/reset-db.sh

The list will get longer while other entities get ready for seeding. The README will be updated regularly.

To start your Phoenix server:

• Install dependencies with mix deps.get
• Create and migrate your database with priv/repo/reset-db.sh
• Install Node.js dependencies with (cd assets && npm install)
• Start Phoenix endpoint with iex -S mix phx.server

Now you can visit localhost:4000 from your browser.