Database data exampels system default data

Here we do in deeper about the data in the database and how it can look like.

These tables only contain user generated data:

• periods
• ovulations

These tables only contain system default data:

• app_settings
• app_settings_group

This table contains a mix of user generated data and system default data:

• symptoms
• symptoms_date

Example data

periods

contains which dates a user has entered that they have had a period. The dates are group into different periods by using period_id. Consecutive days have the same period_id. Period_id is generated from (function name) in PeriodDatabaseHelper.

id	date	period_id
1	2024-07-01	1
2	2024-07-02	1
3	2024-07-03	1
4	2024-07-04	1
5	2024-07-05	1
6	2024-08-03	2
7	2024-08-04	2
8	2024-08-05	2
9	2024-08-06	2
10	2024-08-07	2

ovulations

Contains which dates a user has entered that they have had ovulation.

id	date
1	2024-07-15
1	2024-08-17