Database data exampels system default data

Database Schema Documentation

Table: periods

Column	Type	Constraints	Description
id	INTEGER	PRIMARY KEY, AUTOINCREMENT	Unique identifier for each period entry
date	TEXT		Date of the period
period_id	INTEGER		Identifier to group dates together

Example Data

id	date	period_id
1	2024-07-01	101
2	2024-07-02	101
3	2024-08-01	102
4	2024-08-02	102
5	2024-08-15	103

---

Table: symptoms

Column	Type	Constraints	Description
id	INTEGER	PRIMARY KEY, AUTOINCREMENT	Unique identifier for each symptom
symptom_name	TEXT	NOT NULL	Name of the symptom
active	INTEGER	NOT NULL	Status of the symptom (1 for active)
color	TEXT	DEFAULT 'Black'	Color associated with the symptom

Example Data

id	symptom_name	active	color
1	Heavy_Flow	1	Black
2	Medium_Flow	1	Black
3	Light_Flow	1	Black

---

Table: symptom_date

Column	Type	Constraints	Description
id	INTEGER	PRIMARY KEY, AUTOINCREMENT	Unique identifier for each symptom date entry
symptom_date	TEXT	NOT NULL	Date associated with the symptom
symptom_id	INTEGER	FOREIGN KEY (symptom_id) REFERENCES symptoms(id)	References the symptoms table

Example Data

id	symptom_date	symptom_id
1	2024-07-01	1
2	2024-07-02	2
3	2024-08-01	3

---

Table: app_settings_group

Column	Type	Constraints	Description
id	INTEGER	PRIMARY KEY, AUTOINCREMENT	Unique identifier for each settings group
group_label	TEXT	NOT NULL	Label for the settings group

Example Data

id	group_label
1	Colors
2	Reminders
3	Other

---

Table: app_settings

Column	Type	Constraints	Description
id	INTEGER	PRIMARY KEY, AUTOINCREMENT	Unique identifier for each setting
setting_key	TEXT	NOT NULL	Key for the setting
setting_label	TEXT	NOT NULL	Label for the setting
setting_value	TEXT	NOT NULL	Value of the setting
group_label_id	INTEGER	FOREIGN KEY (group_label_id) REFERENCES app_settings_group(id)	References the app_settings_group table
setting_type	TEXT		Type of setting (e.g., LI, NO, SW)

Example Data

id	setting_key	setting_label	setting_value	group_label_id	setting_type
1	period_color	Period Color	Red	1	LI
2	selection_color	Selection Color	Grey	1	LI
3	period_selection_color	Period Selection Color	DarkGray	1	LI
4	expected_period_color	Expected Period Color	Yellow	1	LI
5	reminder_days	Days Before Reminder	0	2	NO
6	luteal_period_calculation	Luteal Phase Calculation	0	3	SW
7	period_history	Period history	5	3	NO
8	ovulation_history	Ovulation history	5	3	NO
9	lang	Language	en	3	LI
10	cycle_numbers_show	Show cycle numbers	1	3	SW

---

Table: ovulations

Column	Type	Constraints	Description
id	INTEGER	PRIMARY KEY, AUTOINCREMENT	Unique identifier for each ovulation entry
date	TEXT		Date of ovulation

Example Data

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

---