__EFMigrationsHistory MedicalServices Users Patients WaitingLists

0..1
0..1
MigrationId varchar Id int Id int 1 Id int Id int
Appointments
* *
ProductVersion varchar Name varchar Username varchar UserId int 0..1 AppointmentId int
Id int
Type varchar PasswordHash varchar InsuranceCode varchar * QueueNumber int
PatientId int
Price decimal Token varchar Address varchar * Status varchar
BranchId int
Description varchar TokenExpired datetime EmergencyContact varchar
AppointmentDate date
FullName varchar
StartTime time
Email varchar
EndTime time
Phone varchar
Status varchar
Gender varchar
Note varchar
DateOfBirth date

CreatedAt datetime

InvoiceDetails
Branches
Invoices Id int
0..1
Id int 0..1 *
RevenueReports Id int InvoiceId int
Name varchar *
Id int AppointmentId int ItemType varchar
Address varchar *
FromDate date PatientId int ItemId int
Phone varchar
ToDate date IssuedDate datetime Description varchar
*
BranchId int TotalAmount decimal Quantity int

TotalAppointments int Status varchar UnitPrice decimal

TotalInvoices int Note varchar TotalPrice decimal

PaidInvoices int CreatedAt datetime

TotalRevenue decimal
Payments
Note varchar
Id int
*
InvoiceId int

Amount decimal

PaymentDate datetime

PaymentMethod varchar

TransactionCode varchar

UserRoles
*
UserId int
*
RoleId int

Roles
1
Id int RolePermissions

Name varchar *
RoleId int

Description varchar *
PermissionId int

Permissions
1
Id int

Name varchar

Code varchar

Description varchar
__EFMigrationsHistory MedicalServices Users Patients WaitingLists
0..1
0..1
MigrationId varchar Id int Id int 1 Id int Id int
Appointments
* *
ProductVersion varchar Name varchar Username varchar UserId int 0..1 AppointmentId int
Id int
Type varchar PasswordHash varchar InsuranceCode varchar * QueueNumber int
PatientId int
Price decimal Token varchar Address varchar * Status varchar
BranchId int
Description varchar TokenExpired datetime EmergencyContact varchar
AppointmentDate date
FullName varchar
StartTime time
Email varchar
EndTime time
Phone varchar
Status varchar
Gender varchar
Note varchar
DateOfBirth date

CreatedAt datetime

InvoiceDetails
Branches
Invoices Id int
0..1
Id int 0..1 *
RevenueReports Id int InvoiceId int
Name varchar *
Id int AppointmentId int ItemType varchar
Address varchar *
FromDate date PatientId int ItemId int
Phone varchar
ToDate date IssuedDate datetime Description varchar
*
BranchId int TotalAmount decimal Quantity int

TotalAppointments int Status varchar UnitPrice decimal

TotalInvoices int Note varchar TotalPrice decimal

PaidInvoices int CreatedAt datetime

TotalRevenue decimal
Payments
Note varchar
Id int
*
InvoiceId int

Amount decimal

PaymentDate datetime

PaymentMethod varchar

TransactionCode varchar

UserRoles
*
UserId int
*
RoleId int

Roles
1
Id int RolePermissions

Name varchar *
RoleId int

Description varchar *
PermissionId int

Permissions
1
Id int

Name varchar

Code varchar

Description varchar