Changes between Version 11 and Version 12 of ERdiagram
- Timestamp:
- 09/24/25 22:38:58 (10 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERdiagram
v11 v12 50 50 * severity_level 51 51 52 5. Punishment53 52 54 * **Primary Key (PK):** punishment_id 55 * **Attributes:** 56 * value 57 * value_unit 58 * punishment_type 59 60 6. Diagnosis 53 5. Diagnosis 61 54 62 55 * **Primary Key (PK):** diagnosis_id … … 67 60 * is_chronic 68 61 69 7. Doctor62 6. Doctor 70 63 71 64 * **Primary Key (PK):** doctor_id … … 77 70 * is_active 78 71 79 8. Role72 7. Role 80 73 * **Primary Key (PK):** role_id 81 74 * **Attributes:** … … 83 76 * description 84 77 85 ==== Weak Entities ==== 86 87 1. !FilterSession 78 8. !FilterSession 88 79 89 80 * **Primary Key (PK):** session_id … … 93 84 * user_id (Foreign Key) 94 85 95 2. !ReportiumUser86 9. !ReportiumUser 96 87 97 88 * **Primary Key (PK):** reportium_user_id … … 102 93 * surname 103 94 104 3. !UserProfile95 10. !UserProfile 105 96 106 97 * **Primary Key (PK):** profile_id … … 112 103 * has_fs_stored 113 104 114 4. !UserProfileLog 105 ==== Weak Entities ==== 106 107 1. Punishment 108 109 * **Primary Key (PK):** punishment_id 110 * **Attributes:** 111 * value 112 * value_unit 113 * punishment_type 114 115 2. !UserProfileLog 115 116 116 117 * **Primary Key (PK):** log_id … … 120 121 * changed_at 121 122 122 5. !ExportLog123 3. !ExportLog 123 124 124 125 * **Primary Key (PK):** export_id
