Changes between Version 10 and Version 11 of ERdiagram
- Timestamp:
- 09/24/25 22:35:51 (10 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERdiagram
v10 v11 11 11 ==== Strong Entities ==== 12 12 13 Person13 1. Person 14 14 15 15 * **Primary Key (PK):** person_id … … 24 24 * is_stub 25 25 26 Institution26 2. Institution 27 27 28 28 * **Primary Key (PK):** institution_id … … 34 34 * city 35 35 36 Report36 3. Report 37 37 38 38 * **Primary Key (PK):** report_id … … 43 43 * person_id (Foreign Key) 44 44 45 !CrimeType45 4. !CrimeType 46 46 47 47 * **Primary Key (PK):** crime_type_id … … 50 50 * severity_level 51 51 52 Punishment52 5. Punishment 53 53 54 54 * **Primary Key (PK):** punishment_id … … 58 58 * punishment_type 59 59 60 Diagnosis60 6. Diagnosis 61 61 62 62 * **Primary Key (PK):** diagnosis_id … … 67 67 * is_chronic 68 68 69 Doctor69 7. Doctor 70 70 71 71 * **Primary Key (PK):** doctor_id … … 77 77 * is_active 78 78 79 Role79 8. Role 80 80 * **Primary Key (PK):** role_id 81 81 * **Attributes:** … … 85 85 ==== Weak Entities ==== 86 86 87 !FilterSession87 1. !FilterSession 88 88 89 89 * **Primary Key (PK):** session_id … … 93 93 * user_id (Foreign Key) 94 94 95 !ReportiumUser95 2. !ReportiumUser 96 96 97 97 * **Primary Key (PK):** reportium_user_id … … 102 102 * surname 103 103 104 !UserProfile104 3. !UserProfile 105 105 106 106 * **Primary Key (PK):** profile_id … … 112 112 * has_fs_stored 113 113 114 !UserProfileLog114 4. !UserProfileLog 115 115 116 116 * **Primary Key (PK):** log_id … … 120 120 * changed_at 121 121 122 ==== Report Subtypes ==== 123 124 !AcademicReport 125 * **Primary Key (PK):** report_id (inherited) 126 * **Additional Attributes:** 127 * field 128 * description 129 130 !CriminalReport 131 132 * **Primary Key (PK):** report_id (inherited) 133 * **Additional Attributes:** 134 * location 135 * resolved 136 * from_type 137 138 !MedicalReport 139 140 * **Primary Key (PK):** report_id (inherited) 141 * **Additional Attributes:** 142 * doctor_surname 143 * next_control_date 144 145 !EmploymentReport 146 147 * **Primary Key (PK):** report_id (inherited) 148 * **Additional Attributes:** 149 * position_description 150 * start_date 151 * end_date 152 * income_per_month 153 154 !ExportLog 122 5. !ExportLog 155 123 156 124 * **Primary Key (PK):** export_id … … 161 129 * file_name 162 130 * session_id (Foreign Key) 131 132 ==== Report Subtypes ==== 133 134 1. !AcademicReport 135 * **Primary Key (PK):** report_id (inherited) 136 * **Additional Attributes:** 137 * field 138 * description 139 140 2. !CriminalReport 141 142 * **Primary Key (PK):** report_id (inherited) 143 * **Additional Attributes:** 144 * location 145 * resolved 146 * from_type 147 148 3. !MedicalReport 149 150 * **Primary Key (PK):** report_id (inherited) 151 * **Additional Attributes:** 152 * doctor_surname 153 * next_control_date 154 155 4. !EmploymentReport 156 157 * **Primary Key (PK):** report_id (inherited) 158 * **Additional Attributes:** 159 * position_description 160 * start_date 161 * end_date 162 * income_per_month
