Changes between Version 4 and Version 5 of RelationModel

Timestamp:

01/13/25 10:43:08 (2 days ago)

Author:

151131

Comment:

--

RelationModel

@@ -7 +7 @@
 === Табели
 
-- User(**__ssn__**, firstName, lastName, email, password)
-- Patient(**__userId__***(User), patientId)
-- Doctor(**__userId__***(User), workingHours, licenseNumber, hospitalId)
-- Specialist(**__userId__***(User), licenseNumber, hospitalId)
-- Comment(**__commentId__**, comment, createdAt, **createdBy***(User))
-- Report(**__reportId__**, isFinished, description)
-- MedicineRecepit(**__receiptId__**, **reportId***(Report), medicineName, quantity)
-- IsApprovedMedicineRecepit(**__receiptId__***(MedicineRecepit), **__approvedBy__***(User), comment, isApproved)
-- Examination(**__examinationId__**, **doctorId***(User), **specialistId***(User), **userId***(User), **reportId***(Report), dateTime)
-- Review(**__reviewId__**, **doctorId***(User), **userId***(User), rank)
+- AppUser(**__ssn__**, email, password, firstName, lastName)
+- Patient(**__userId__**(AppUser), patientId)
+- Doctor(**__userId__**(AppUser), workingHours, licenseNumber, hospitalId)
+- Specialist(**__userId__**(AppUser), licenseNumber, hospitalId)
+- Comment(**__commentId__**, **createdBy**(AppUser), createdAt, comment)
+- Report(**__reportId__**, description, isFinished)
+- MedicineRecepit(**__medicineRecepitId__**, **reportId**(Report), medicineName, quantity)
+- IsApprovedMedicineRecepit(**__approvalId__**, **receiptId**(MedicineRecepit), **approvedBy**(AppUser), IsApproved)
+- Examination(**__examinationId__**, **patientId**(AppUser), **doctorId**(AppUser), **specialistId**(AppUser), dateTime)
+- Review(**__reviewId__**, **patientId**(AppUser), **doctorId**(AppUser), rank)
 
 === DDL скрипта за бришење на табелите и креирање на табелите