Vorsorgekompass service
navida_user_plan table
The information regarding user examinations is stored in the navida_user_plan table. Some important columns in that table include:
- user_plan_id - identifier of the examination the user should take
- user_id - id of the user
- age_created - the age of the user at the time this record was created
- source_user_plan_id, source_rule_id - used for mapping from NAVIDA classic
navida_examination table
The navida_examination table stores information regarding the rules by which the user plan is being calculated.
| id | examination_id | rule_id | min_age | max_age | iteration_frequency | iteration_period | gender | timestamp |
|---|---|---|---|---|---|---|---|---|
| integer PRIMARY_KEY | integer | integer | integer | integer | integer | integer | string | timestamp |
Updating the user plan (CURRENTLY UNDER IMPLEMENTATION)
Rules for examinations are subject to be changed, added or removed. This needs to be reflected in the navida_user_table, the solution can be described by the following diagram.