Changes between Version 7 and Version 8 of ERdiagram

Timestamp:

09/24/25 22:30:23 (10 hours ago)

Author:

221007

Comment:

--

ERdiagram

@@ -3 +3 @@
 
 [[Image(er_diagram_reportium.jpg, align=center)]]
+
+
+== Податочни побарувања ==
+
+=== Ентитети ===
+
+==== Strong Entities ====
+
+Person
+
+* **Primary Key (PK):** person_id
+* **Attributes:**
+  * name
+  * surname
+  * address
+  * gender
+  * date_of_birth
+  * contact_phone
+  * is_alive
+  * is_stub
+
+Institution
+
+* **Primary Key (PK):** institution_id
+* **Attributes:**
+  * name
+  * address
+  * type
+  * year_established
+  * city
+
+Report
+
+* **Primary Key (PK):** report_id
+* **Attributes:
+  * report_type
+  * date
+  * notes
+  * person_id (Foreign Key)
+
+CrimeType
+
+* **Primary Key (PK):** crime_type_id
+* **Attributes:**
+  * label
+  * severity_level
+
+Punishment
+
+* **Primary Key (PK):** punishment_id
+* **Attributes:**
+  * value
+  * value_unit
+  * punishment_type
+
+Diagnosis
+
+* **Primary Key (PK):** diagnosis_id
+* **Attributes:**
+  * description
+  * therapy
+  * severity
+  * is_chronic
+
+Doctor
+
+* **Primary Key (PK):** doctor_id
+* **Attributes:**
+  * surname
+  * years_of_experience
+  * specialization
+  * name
+  * is_active
+
+Role
+* **Primary Key (PK):** role_id
+* **Attributes:**
+  * role_name
+  * description
+
+==== Weak Entities ====
+
+FilterSession
+
+* **Primary Key (PK):** session_id
+* **Attributes:**
+  * filter_description
+  * searched_at
+  * user_id (Foreign Key)
+
+ReportiumUser
+
+* **Primary Key (PK):** reportium_user_id
+* **Attributes:**
+  * password_hash
+  * is_active
+  * email
+  * surname
+
+UserProfile
+
+* **Primary Key (PK):** profile_id
+* **Attributes:**
+  * profile_created_at
+  * user_id (Foreign Key)
+  * username
+  * has_fs_own
+  * has_fs_stored
+
+UserProfileLog
+
+* **Primary Key (PK):** log_id
+* **Attributes:**
+  * change_description
+  * profile_id (Foreign Key)
+  * changed_at
+
+==== Report Subtypes ====
+
+AcademicReport
+* **Primary Key (PK):** report_id (inherited)
+* **Additional Attributes:**
+  * field
+  * description
+
+CriminalReport
+
+* **Primary Key (PK):** report_id (inherited)
+* **Additional Attributes:**
+  * location
+  * resolved
+  * from_type
+
+MedicalReport
+
+* **Primary Key (PK):** report_id (inherited)
+* **Additional Attributes:**
+  * doctor_surname
+  * next_control_date
+
+EmploymentReport
+
+* **Primary Key (PK):** report_id (inherited)
+* **Additional Attributes:**
+  * position_description
+  * start_date
+  * end_date
+  * income_per_month
+
+ExportLog
+
+* **Primary Key (PK):** export_id
+* **Additional Attributes:**
+  * export_date
+  * export_format
+  * filter_summary
+  * file_name
+  * session_id (Foreign Key)