PgHero

Space

Database Size: 11 GB

21 unused indices. Remove them for faster writes. 

rails generate migration remove_unused_indexes

And paste

remove_index :InvoiceUnit, name: "InvoiceUnit_namedPriceListId_idx"
remove_index :InvoiceUnit, name: "InvoiceUnit_transferSpecialty_doctorId_idx"
remove_index :LoyaltyTransaction, name: "LoyaltyTransaction_expiresAt_idx"
remove_index :AiCreditRoomUsage, name: "AiCreditRoomUsage_clinicDomain_day_idx"
remove_index :ExternalLab, name: "ExternalLab_clinicDomain_labType_idx"
remove_index :MedicalOrder, name: "MedicalOrder_doctorId_idx"
remove_index :MedicalOrder, name: "MedicalOrder_requestedDate_idx"
remove_index :PackageSubscriptionHold, name: "PackageSubscriptionHold_holdStartAt_holdEndAt_idx"
remove_index :PatientJourney, name: "PatientJourney_patientProfileId_status_idx"
remove_index :PayrollPeriod, name: "PayrollPeriod_clinicDomain_idx"
remove_index :Payslip, name: "Payslip_periodId_idx"
remove_index :ScheduleBlock, name: "ScheduleBlock_doctorId_from_idx"
remove_index :VacationBalance, name: "VacationBalance_clinicDomain_idx"
remove_index :VacationBalance, name: "VacationBalance_userId_idx"
remove_index :Vacation, name: "Vacation_clinicDomain_idx"
remove_index :Vacation, name: "Vacation_status_idx"
remove_index :Vacation, name: "Vacation_userId_idx"
remove_index :Accommodation, name: "Accommodation_clinicDomain_bedId_idx"
remove_index :_InvoiceToTag, name: "_InvoiceToTag_B_index"
remove_index :_TagToUser, name: "_TagToUser_B_index"
remove_index :chatbot_knowledge_chunk, name: "chatbot_knowledge_chunk_sourceId_idx"
Relation Size
Logs 9.2 GB
PatientProfile 337 MB
Invoice 149 MB
Session 118 MB
InvoiceUnit 104 MB
PaymentTransaction 81.7 MB
Session_clinicDomain_link_key 65.6 MB
Invoice_clinicDomain_serialNumber_key 54.2 MB
LoyaltyTransaction 36.5 MB
Notification 36 MB
PatientProfile_clinicDomain_link_key 31.2 MB
Session_doctorId_date_branchId_clinicDomain_idx 30.7 MB
PrescriptionUnit 30.3 MB
Logs_pkey 27.3 MB
_ExaminationToSession 23.9 MB
Session_date_clinicDomain_idx 23.1 MB
WeightTracking 22.8 MB
Session_date_patientProfileId_idx 20.6 MB
Invoice_sessionId_key 20.4 MB
UniqueText_text_clinicDomain_type_key 20 MB
UniqueText 19.2 MB
PatientProfile_clinicDomain_patientIndex_key 19.1 MB
Invoice_pkey 18.6 MB
PatientLoyalty 15.9 MB
Session_branchId_from_idx 15.7 MB
_ExaminationToSession_AB_pkey 14 MB
File 13.8 MB
Session_date_doctorId_idx 13.7 MB
Session_date_branchId_idx 13.5 MB
PaymentTransaction_method_invoiceId_idx 13.3 MB
WebSession_ip_sessionId_clinicDomain_key 13.2 MB
PaymentTransaction_invoiceId_idx 13 MB
InvoiceUnit_pkey 12.5 MB
InvoiceUnit_invoiceId_idx 11.4 MB
_ExaminationToSession_B_index 11.3 MB
VariablePropertyValue 11 MB
Session_pkey 11 MB
PaymentTransaction_pkey 10.6 MB
LoyaltyTransaction_pkey 10.5 MB
Expense 10.2 MB
Prescription 9.73 MB
_PrescriptionToPrescriptionUnit 8.9 MB
PatientLoyalty_pkey 8.89 MB
DentistProfile 8.64 MB
Invoice_orderId_key 8.01 MB
Invoice_accommodationId_key 7.87 MB
Session_patientProfileId_idx 7.73 MB
LoyaltyTransaction_patientLoyaltyId_idx 7.59 MB
FormResponseField 7.48 MB
Prescription_link_clinicDomain_key 7.41 MB
PaymentTransaction_patientProfileId_idx 7 MB
PaymentTransaction_invoiceUnitId_key 6.64 MB
PaymentTransaction_paymentProviderId_key 6.63 MB
LoyaltyTransaction_sessionId_idx 6.3 MB
PrescriptionUnit_pkey 6.02 MB
TreasuryTransaction 5.88 MB
_PrescriptionToPrescriptionUnit_B_index 5.71 MB
NutritionProfile 5.59 MB
_PrescriptionToPrescriptionUnit_AB_pkey 5.44 MB
Token_token_key 5.41 MB
Invoice_closingShiftId_idx 5.3 MB
Session_doctorId_branchId_idx 5.3 MB
PatientProfile_pkey 5.21 MB
WebSession_ip_createdAt_key 4.98 MB
InvoiceUnit_doctorId_idx 4.22 MB
InvoiceUnit_namedPriceListId_idx UNUSED 4.22 MB
InvoiceUnit_transferSpecialty_doctorId_idx UNUSED 4.22 MB
DentistProfile_patientProfileId_key 3.96 MB
DentistProfile_pkey 3.96 MB
WebSession_userId_createdAt_key 3.88 MB
PaymentTransaction_closingShiftId_idx 3.84 MB
Token 3.82 MB
SessionRequest 3.75 MB
ExtraFieldValue 3.49 MB
PatientLoyalty_patientId_key 3.44 MB
UniqueText_pkey 3.27 MB
VariablePropertyValue_pkey 3.02 MB
LoyaltyTransaction_paymentTransactionId_key 2.81 MB
WeightTracking_weightId_key 2.73 MB
NutritionProfile_patientProfileId_key 2.71 MB
WebSession_pkey 2.66 MB
DiscountPackage 2.54 MB
Notification_pkey 2.54 MB
_SessionToUniqueText 2.34 MB
AiCreditTransaction 2.23 MB
AiUsageLog 1.98 MB
Examination 1.92 MB
WeightTracking_pkey 1.89 MB
NutritionProfile_pkey 1.78 MB
TreasuryTransaction_paymentTransactionId_key 1.77 MB
LoyaltyTransaction_formResponseId_idx 1.76 MB
ExtraFieldValue_patientProfileId_extraFieldId_key 1.67 MB
DentalAction 1.66 MB
LoyaltyTransaction_expiresAt_idx UNUSED 1.55 MB
Message 1.54 MB
_SessionToUniqueText_AB_pkey 1.53 MB
_noteToWeightTracking 1.41 MB
_SessionComplaints 1.37 MB
Notification_whatsappLogId_key 1.36 MB
Prescription_pkey 1.34 MB
PackageSubscription 1.33 MB
LaserSession 1.32 MB
ExtraFieldValue_pkey 1.31 MB
Expense_paymentTransactionOfForDoctorId_key 1.25 MB
WeightTracking_heightId_key 1.25 MB
Examination_name_clinicDomain_key 1.21 MB
_noteToWeightTracking_AB_pkey 1.2 MB
File_pkey 1.19 MB
DietMealItem 1.16 MB
Expense_pkey 1.16 MB
_SessionToUniqueText_B_index 1.15 MB
ExtraFieldValue_sessionRequestId_extraFieldId_key 1.13 MB
Attendance 1.1 MB
TreasuryTransaction_pkey 1.09 MB
DiscountPackage_pkey 1 MB
User 1 MB
DiscountPackage_invoiceUnitId_key 984 KB
ImportJob 976 KB
FormResponseField_pkey 968 KB
FormField 896 KB
_SessionComplaints_AB_pkey 864 KB
Template 816 KB
Expense_quantityInLocationId_key 800 KB
Expense_paymentTransactionOfForAssistantId_key 792 KB
_ParticipantSeen 792 KB
_SessionComplaints_B_index 792 KB
_noteToWeightTracking_B_index 784 KB
Expense_invoiceUnitId_key 768 KB
_ExaminationToSessionRequest 736 KB
FormResponse 696 KB
SupportTicket 568 KB
_noteToNutritionProfile 552 KB
_NoteToPatientProfile_AB_pkey 544 KB
SessionRequest_pkey 536 KB
TreasuryTransaction_expenseId_key 528 KB
Order 512 KB
_BranchToPackageSubscription 512 KB
_ParticipantSeen_AB_pkey 504 KB
_PartitionToSession 496 KB
MedicalReport 488 KB
_ExaminationToSessionRequest_AB_pkey 480 KB
HomeExercise 464 KB
DietMeal 456 KB
Expense_closingShiftId_idx 456 KB
SessionRequest_sessionId_key 456 KB
_NoteToPatientProfile 448 KB
_SessionToTag 440 KB
VoiceNote 432 KB
_PartitionToSession_AB_pkey 424 KB
_NoteToPatientProfile_B_index 416 KB
FormOption 392 KB
_BranchToPackageSubscription_AB_pkey 392 KB
_ExaminationToSessionRequest_B_index 384 KB
ChecklistStep 376 KB
ReservationChatbot 376 KB
_medicationsHistoryToPatientProfile 352 KB
Clinic 344 KB
_noteToNutritionProfile_AB_pkey 344 KB
LaserSession_pkey 336 KB
Package 336 KB
Examination_pkey 312 KB
_BranchToPackageSubscription_B_index 312 KB
_PartitionToSession_B_index 312 KB
ClinicInvoice 304 KB
ExaminationPricePerDoctor 304 KB
PackageSubscription_invoiceId_key 304 KB
PushSubscription 304 KB
PackageSubscription_pkey 296 KB
AiCreditTransaction_pkey 288 KB
_medicationsHistoryToPatientProfile_AB_pkey 288 KB
Antenatal 280 KB
FormResponse_pkey 280 KB
ManagerPercentagePerInvoiceUnit 280 KB
AiUsageLog_pkey 272 KB
Note 264 KB
_SessionToTag_AB_pkey 264 KB
_noteToNutritionProfile_B_index 264 KB
Message_pkey 256 KB
Consumable 248 KB
PushSubscription_userId_endpoint_key 248 KB
Token_pkey 248 KB
ObstetricsProfile 240 KB
_surgeriesHistoryToPatientProfile 240 KB
_BranchToExamination 232 KB
FormOption_pkey 216 KB
RecurringExpense 216 KB
GynecologyProfile 208 KB
PackageSubscription_status_effectiveEndDate_idx 208 KB
_ParticipantSeen_B_index 208 KB
Attendance_pkey 192 KB
Branch 192 KB
DietMealItem_pkey 192 KB
FormSection 192 KB
SessionRequestSettings 192 KB
DietDay 184 KB
GlassUnit 184 KB
DentalAction_invoiceUnitId_key 176 KB
ExaminationPricePerDoctor_pkey 176 KB
Period 176 KB
_BranchToExamination_AB_pkey 176 KB
Infertility 168 KB
User_clinicDomain_email_key 168 KB
_medicationsHistoryToPatientProfile_B_index 168 KB
DentalAction_pkey 160 KB
OpeningTime 160 KB
Tag 160 KB
ReferralDoctor 152 KB
User_clinicDomain_phone_key 152 KB
_surgeriesHistoryToPatientProfile_AB_pkey 152 KB
SiteLampItem 144 KB
PackageUnit 136 KB
_BranchToExamination_B_index 136 KB
_socialHistoryToPatientProfile 136 KB
DietMealItem_mealId_order_idx 128 KB
ManagerPercentage 128 KB
TreatmentPlan 128 KB
_SessionToTag_B_index 128 KB
DietMeal_pkey 120 KB
Note_note_clinicDomain_appliesTo_key 120 KB
PackageSubscription_isOnHold_idx 120 KB
_familyHistoryToPatientProfile 120 KB
DietMeal_dayId_order_idx 112 KB
ManagerPercentagePerInvoiceUnit_pkey 112 KB
Order_pkey 112 KB
PatientProfileSettings 112 KB
Request 112 KB
Tag_name_clinicDomain_key 112 KB
_surgeriesHistoryToPatientProfile_B_index 112 KB
FormField_pkey 104 KB
GlassUnit_glassExaminationId_type_key 104 KB
Period_pkey 104 KB
Room 104 KB
_BranchToUser 104 KB
ChecklistStep_pkey 96 KB
OpeningTime_pkey 96 KB
ShareLink 96 KB
ExaminationPricePerDoctor_examinationId_doctorId_key 88 KB
GlassExamination 88 KB
GlassUnit_pkey 88 KB
Participant 88 KB
Payslip 88 KB
Room_clinicDomain_slug_key 88 KB
SessionSettings 88 KB
_ParticipantToRoom 88 KB
_socialHistoryToPatientProfile_AB_pkey 88 KB
Diet 80 KB
EmployeeEarning 80 KB
GynecologyProfile_patientProfileId_key 80 KB
PackageUnit_pkey 80 KB
Package_pkey 80 KB
PatientJourney 80 KB
_BranchToPackage 80 KB
_BranchToUser_AB_pkey 80 KB
_allergiesHistoryToPatientProfile 80 KB
Branch_clinicDomain_branchNumber_key 72 KB
ClinicFeatures 72 KB
Consumable_pkey 72 KB
GynecologyProfile_pkey 72 KB
HomeExercise_pkey 72 KB
OphthalmologySessionDetails 72 KB
SiteLamp 72 KB
Update 72 KB
VariableProperty 72 KB
_BranchToPackage_AB_pkey 72 KB
_familyHistoryToPatientProfile_AB_pkey 72 KB
_habitsToPatientProfile 72 KB
Antenatal_pkey 64 KB
Consumable_invoiceUnitId_idx 64 KB
Form 64 KB
Infertility_gynecologyProfileId_key 64 KB
Infertility_pkey 64 KB
LoyaltyRule 64 KB
ManagerPercentage_pkey 64 KB
Partition 64 KB
PatientInsurance 64 KB
PriceList 64 KB
ShareLink_link_clinicDomain_key 64 KB
UniqueTextSettings 64 KB
User_pkey 64 KB
VacationBalance 64 KB
VeterinaryProfile 64 KB
VoiceNote_pkey 64 KB
_familyHistoryToPatientProfile_B_index 64 KB
AiCreditBalance 56 KB
AiCreditRoomUsage 56 KB
Clinic_domain_key 56 KB
ExtraField 56 KB
InsuranceCompany 56 KB
MessageReaction 56 KB
ObstetricsProfile_pkey 56 KB
Participant_pkey 56 KB
Participant_userId_key 56 KB
PatientProfileSettings_clinicDomain_key 56 KB
SessionRequestSettings_clinicDomain_key 56 KB
SessionSettings_clinicDomain_key 56 KB
Treasury 56 KB
_BranchToPackage_B_index 56 KB
_BranchToUser_B_index 56 KB
_ExtraFieldToUniqueText 56 KB
_ExtraFieldToUniqueText_AB_pkey 56 KB
_ParticipantToRoom_AB_pkey 56 KB
_socialHistoryToPatientProfile_B_index 56 KB
ClinicFeatures_clinicDomain_key 48 KB
Folliculometry 48 KB
Goal 48 KB
InsurancePolicyClass 48 KB
Note_pkey 48 KB
OphthalmologyProfile 48 KB
PatientToken 48 KB
PediatricsProfile 48 KB
Request_pkey 48 KB
Shift 48 KB
SiteLampItem_pkey 48 KB
UniqueTextSettings_clinicDomain_type_key 48 KB
VariableProperty_clinicDomain_name_key 48 KB
AiCreditRoomUsage_clinicDomain_roomId_day_key 40 KB
ClinicInvoice_pkey 40 KB
Clinic_currentClinicInvoiceId_key 40 KB
DietDay_dietId_order_idx 40 KB
DietDay_pkey 40 KB
Form_name_clinicDomain_key 40 KB
InsuranceCompany_clinicDomain_name_key 40 KB
LoyaltyRule_clinicDomain_key 40 KB
Partition_clinicDomain_name_key 40 KB
RecurringExpense_pkey 40 KB
ShareLink_patientId_formId_sessionId_key 40 KB
VacationBalance_userId_year_clinicDomain_key 40 KB
_ExtraFieldToUniqueText_B_index 40 KB
_NoteToSession 40 KB
_ParticipantToRoom_B_index 40 KB
_ShiftToUser 40 KB
_allergiesHistoryToPatientProfile_AB_pkey 40 KB
_allergiesHistoryToPatientProfile_B_index 40 KB
_currentMedicationsHistoryToPatientProfile 40 KB
_habitsToPatientProfile_AB_pkey 40 KB
Branch_pkey 32 KB
ClinicManagementBot 32 KB
Clinic_pkey 32 KB
FormSection_pkey 32 KB
GlassExamination_pkey 32 KB
MessageReaction_messageId_userId_reaction_key 32 KB
OphthalmologyProfile_patientProfileId_key 32 KB
OphthalmologyProfile_pkey 32 KB
OphthalmologySessionDetails_glassExaminationId_key 32 KB
OphthalmologySessionDetails_pkey 32 KB
OphthalmologySessionDetails_sessionId_key 32 KB
OphthalmologySessionDetails_siteLampId_key 32 KB
PatientProfileSettings_pkey 32 KB
PushSubscription_pkey 32 KB
ReferralDoctor_pkey 32 KB
ReservationChatbot_sessionId_clinicDomain_key 32 KB
Room_pkey 32 KB
SessionRequestSettings_pkey 32 KB
SessionSettings_pkey 32 KB
ShareLink_pkey 32 KB
SiteLamp_pkey 32 KB
Tag_pkey 32 KB
Template_pkey 32 KB
TreatmentPlan_pkey 32 KB
_habitsToPatientProfile_B_index 32 KB
WebSession 24 KB
AccommodationService 16 KB
AccommodationService_pkey 16 KB
AccountantSettings 16 KB
AccountantSettings_clinicDomain_key 16 KB
AccountantSettings_pkey 16 KB
AiCreditBalance_clinicDomain_key 16 KB
AiCreditBalance_pkey 16 KB
AiCreditPackage 16 KB
AiCreditPackage_pkey 16 KB
AiCreditRoomUsage_clinicDomain_day_idx UNUSED 16 KB
AiCreditRoomUsage_pkey 16 KB
AiModel 16 KB
AiModel_name_key 16 KB
AiModel_pkey 16 KB
AnalysisResult_pkey 16 KB
AnalysisTemplate 16 KB
AnalysisTemplateUnit_pkey 16 KB
AnalysisTemplate_pkey 16 KB
AnalysisUnit 16 KB
AnalysisUnitResult 16 KB
AnalysisUnitResult_pkey 16 KB
AnalysisUnit_pkey 16 KB
AnalysisUnit_sourceCatalogSlug_clinicDomain_key 16 KB
AttendanceSettings 16 KB
AttendanceSettings_clinicDomain_idx 16 KB
AttendanceSettings_clinicDomain_key 16 KB
AttendanceSettings_pkey 16 KB
Bed 16 KB
Bed_number_clinicDomain_sectionId_key 16 KB
Bed_pkey 16 KB
CheckProperty 16 KB
CheckPropertyValue_pkey 16 KB
CheckPropertyValue_propertyId_patientProfileId_key 16 KB
CheckProperty_clinicDomain_name_key 16 KB
CheckProperty_pkey 16 KB
ChecklistStepHistory 16 KB
ChecklistStepHistory_pkey 16 KB
ClinicFeatures_pkey 16 KB
ClinicManagementBot_pkey 16 KB
ClinicManagementBot_threadId_key 16 KB
ClinicManagementBot_userId_clinicDomain_key 16 KB
Comment 16 KB
Comment_pkey 16 KB
Contraception 16 KB
Contraception_pkey 16 KB
Cornea 16 KB
Cornea_pkey 16 KB
CosmeticSession 16 KB
CosmeticSession_pkey 16 KB
CustomRole 16 KB
CustomRole_clinicDomain_name_key 16 KB
CustomRole_pkey 16 KB
DentalLabOrder 16 KB
DentalLabOrder_orderId_key 16 KB
DentalLabOrder_pkey 16 KB
Diet_pkey 16 KB
EmployeeContract 16 KB
EmployeeContract_clinicDomain_idx 16 KB
EmployeeContract_pkey 16 KB
EmployeeContract_userId_idx 16 KB
EmployeeDocument 16 KB
EmployeeDocument_clinicDomain_idx 16 KB
EmployeeDocument_pkey 16 KB
EmployeeDocument_userId_idx 16 KB
EmployeeEarning_clinicDomain_idx 16 KB
EmployeeEarning_expenseId_key 16 KB
EmployeeEarning_pkey 16 KB
EmployeeEarning_userId_idx 16 KB
ExternalLab 16 KB
ExternalLab_clinicDomain_labType_idx UNUSED 16 KB
ExternalLab_clinicDomain_name_labType_key 16 KB
ExternalLab_pkey 16 KB
ExtraField_pkey 16 KB
FeatureRequest 16 KB
FeatureRequest_pkey 16 KB
FeedingAssessment 16 KB
FeedingAssessment_growthVisitId_key 16 KB
FeedingAssessment_pkey 16 KB
Folliculometry_pkey 16 KB
Form_pkey 16 KB
Goal_pkey 16 KB
GrowthMeasurement 16 KB
GrowthMeasurement_growthVisitId_key 16 KB
GrowthMeasurement_pkey 16 KB
GrowthVisit 16 KB
GrowthVisit_pkey 16 KB
GynecologyBleeding 16 KB
GynecologyBleeding_pkey 16 KB
HRSettings 16 KB
HRSettings_clinicDomain_idx 16 KB
HRSettings_clinicDomain_key 16 KB
HRSettings_pkey 16 KB
HomeExerciseLog 16 KB
HomeExerciseLog_pkey 16 KB
ImportJob_clinicDomain_status_idx 16 KB
ImportJob_pkey 16 KB
InsuranceAttachment 16 KB
InsuranceAttachment_pkey 16 KB
InsuranceCompany_pkey 16 KB
InsuranceConfirmation 16 KB
InsuranceConfirmation_invoiceUnitId_key 16 KB
InsuranceConfirmation_pkey 16 KB
InsurancePolicy 16 KB
InsurancePolicyClass_insurancePolicyId_className_key 16 KB
InsurancePolicyClass_pkey 16 KB
InsurancePolicy_pkey 16 KB
InsurancePolicy_policyNumber_key 16 KB
LabTestItem 16 KB
LabTestItem_pkey 16 KB
LabTestOrder 16 KB
LabTestOrder_orderId_key 16 KB
LabTestOrder_pkey 16 KB
LaserSessionSettings 16 KB
LaserSessionSettings_clinicDomain_key 16 KB
LaserSessionSettings_pkey 16 KB
Like_pkey 16 KB
Like_userId_updateId_key 16 KB
LoyaltyFormRule_formId_loyaltyRuleId_key 16 KB
LoyaltyFormRule_pkey 16 KB
LoyaltyRule_pkey 16 KB
MedicalOrder 16 KB
MedicalOrderStatusHistory 16 KB
MedicalOrderStatusHistory_pkey 16 KB
MedicalOrder_clinicDomain_orderNumber_key 16 KB
MedicalOrder_clinicDomain_status_idx 16 KB
MedicalOrder_doctorId_idx UNUSED 16 KB
MedicalOrder_patientProfileId_idx 16 KB
MedicalOrder_pkey 16 KB
MedicalOrder_requestedDate_idx UNUSED 16 KB
MedicalReport_pkey 16 KB
MessageAttachment 16 KB
MessageAttachment_pkey 16 KB
MessageReaction_pkey 16 KB
NamedPriceList 16 KB
NamedPriceListItem_namedPriceListId_examinationId_key 16 KB
NamedPriceListItem_namedPriceListId_productId_key 16 KB
NamedPriceListItem_pkey 16 KB
NamedPriceList_clinicDomain_name_key 16 KB
NamedPriceList_pkey 16 KB
NeurologicalExam 16 KB
NeurologicalExam_growthVisitId_key 16 KB
NeurologicalExam_pkey 16 KB
PID 16 KB
PID_pkey 16 KB
PackageInsuranceConfirmation 16 KB
PackageInsuranceConfirmation_packageSubscriptionId_key 16 KB
PackageInsuranceConfirmation_pkey 16 KB
PackageSubscriptionHold 16 KB
PackageSubscriptionHold_holdStartAt_holdEndAt_idx UNUSED 16 KB
PackageSubscriptionHold_packageSubscriptionId_status_idx 16 KB
PackageSubscriptionHold_pkey 16 KB
Partition_pkey 16 KB
PatientAppSettings 16 KB
PatientAppSettings_bundleId_key 16 KB
PatientAppSettings_clinicDomain_key 16 KB
PatientAppSettings_pkey 16 KB
PatientInsurance_patientId_insurancePolicyClassId_key 16 KB
PatientInsurance_pkey 16 KB
PatientJourney_patientProfileId_clinicDomain_idx 16 KB
PatientJourney_patientProfileId_status_idx UNUSED 16 KB
PatientJourney_pkey 16 KB
PatientProfileClaim 16 KB
PatientProfileClaim_patientUserId_patientProfileId_key 16 KB
PatientProfileClaim_pkey 16 KB
PatientProfileSettings_userId_key 16 KB
PatientRelationship 16 KB
PatientRelationshipType 16 KB
PatientRelationshipType_clinicDomain_type_key 16 KB
PatientRelationshipType_pkey 16 KB
PatientRelationship_patientId_relatedPatientId_relationship_key 16 KB
PatientRelationship_pkey 16 KB
PatientToken_pkey 16 KB
PatientToken_token_key 16 KB
PatientUser 16 KB
PatientUser_phone_phoneCode_key 16 KB
PatientUser_pkey 16 KB
PatientWallet 16 KB
PatientWallet_patientId_clinicDomain_key 16 KB
PatientWallet_pkey 16 KB
PayrollPeriod 16 KB
PayrollPeriod_clinicDomain_idx UNUSED 16 KB
PayrollPeriod_clinicDomain_startDate_endDate_key 16 KB
PayrollPeriod_pkey 16 KB
Payslip_expenseId_key 16 KB
Payslip_periodId_idx UNUSED 16 KB
Payslip_periodId_userId_key 16 KB
Payslip_pkey 16 KB
Payslip_userId_idx 16 KB
PediatricsProfile_patientProfileId_key 16 KB
PediatricsProfile_pkey 16 KB
PelvisUltraSound 16 KB
PelvisUltraSound_pkey 16 KB
PhysicalExam 16 KB
PhysicalExam_growthVisitId_key 16 KB
PhysicalExam_pkey 16 KB
PhysicalTherapyCheckup 16 KB
PhysicalTherapyCheckup_pkey 16 KB
PhysicalTherapyProfile 16 KB
PhysicalTherapyProfile_patientProfileId_key 16 KB
PhysicalTherapyProfile_pkey 16 KB
PregnantUltraSound 16 KB
PregnantUltraSound_pkey 16 KB
PriceList_examinationId_insuranceCompanyId_key 16 KB
PriceList_insuranceCompanyId_serviceCode_key 16 KB
PriceList_pkey 16 KB
ReceptionChatbot 16 KB
ReceptionChatbot_pkey 16 KB
ReceptionChatbot_threadId_key 16 KB
ReceptionChatbot_userId_clinicDomain_key 16 KB
ReferenceValue 16 KB
ReferenceValue_pkey 16 KB
ReservationChatbot_pkey 16 KB
ReservationChatbot_sessionRequestId_key 16 KB
ReservationChatbot_threadId_key 16 KB
Retina 16 KB
Retina_pkey 16 KB
ScheduleBlock 16 KB
ScheduleBlock_clinicDomain_branchId_from_to_idx 16 KB
ScheduleBlock_doctorId_from_idx UNUSED 16 KB
ScheduleBlock_pkey 16 KB
Section 16 KB
Section_clinicDomain_name_key 16 KB
Section_pkey 16 KB
Shift_clinicDomain_name_key 16 KB
Shift_pkey 16 KB
SiteLamp_ophthalmologyProfileId_key 16 KB
Squint 16 KB
SquintItem 16 KB
SquintItem_pkey 16 KB
Squint_ophthalmologyProfileId_key 16 KB
Squint_pkey 16 KB
SupportTicket_pkey 16 KB
Treasury_pkey 16 KB
Treasury_recurringExpenseId_key 16 KB
UniqueTextSettings_pkey 16 KB
Update_pkey 16 KB
Vacation 16 KB
VacationBalance_clinicDomain_idx UNUSED 16 KB
VacationBalance_pkey 16 KB
VacationBalance_userId_idx UNUSED 16 KB
Vacation_clinicDomain_idx UNUSED 16 KB
Vacation_pkey 16 KB
Vacation_status_idx UNUSED 16 KB
Vacation_userId_idx UNUSED 16 KB
VariableProperty_pkey 16 KB
VeterinaryProfile_heartRateId_key 16 KB
VeterinaryProfile_mucousMembId_key 16 KB
VeterinaryProfile_pkey 16 KB
VeterinaryProfile_respRateId_key 16 KB
VeterinaryProfile_sessionId_key 16 KB
VeterinaryProfile_tempId_key 16 KB
VeterinaryProfile_weightId_key 16 KB
Vote_pkey 16 KB
Vote_userId_featureRequestId_key 16 KB
WalletTransaction 16 KB
WalletTransaction_closingShiftId_idx 16 KB
WalletTransaction_createdAt_idx 16 KB
WalletTransaction_loyaltyTransactionId_key 16 KB
WalletTransaction_paymentTransactionId_key 16 KB
WalletTransaction_pkey 16 KB
WalletTransaction_treasuryTransactionId_key 16 KB
WalletTransaction_walletId_idx 16 KB
_CustomRoleToUser 16 KB
_CustomRoleToUser_AB_pkey 16 KB
_CustomRoleToUser_B_index 16 KB
_NamedPriceListBranches_AB_pkey 16 KB
_NamedPriceListBranches_B_index 16 KB
_NoteToSession_AB_pkey 16 KB
_NoteToSession_B_index 16 KB
_ShiftToUser_AB_pkey 16 KB
_ShiftToUser_B_index 16 KB
_TreasuryToUser_AB_pkey 16 KB
_TreasuryToUser_B_index 16 KB
_currentMedicationsHistoryToPatientProfile_AB_pkey 16 KB
_currentMedicationsHistoryToPatientProfile_B_index 16 KB
Accommodation 8 KB
AccommodationServiceUnit_pkey 8 KB
Accommodation_bedId_startDate_endDate_idx 8 KB
Accommodation_clinicDomain_bedId_idx UNUSED 8 KB
Accommodation_clinicDomain_patientProfileId_idx 8 KB
Accommodation_clinicDomain_status_idx 8 KB
Accommodation_pkey 8 KB
AgentThread 8 KB
AgentThread_pkey 8 KB
AgentThread_userId_clinicDomain_agentType_idx 8 KB
AnalysisResult 8 KB
AnalysisTemplateUnit 8 KB
CheckPropertyValue 8 KB
DevelopmentalExam 8 KB
DevelopmentalExam_growthVisitId_key 8 KB
DevelopmentalExam_pkey 8 KB
Like 8 KB
LoyaltyExaminationRule_examinationId_loyaltyRuleId_key 8 KB
LoyaltyExaminationRule_pkey 8 KB
LoyaltyFormRule 8 KB
LoyaltyRedemption_pkey 8 KB
LoyaltyReward 8 KB
LoyaltyReward_pkey 8 KB
LoyaltyTierBenefit 8 KB
LoyaltyTierBenefit_loyaltyRuleId_tier_benefitType_key 8 KB
LoyaltyTierBenefit_pkey 8 KB
MedicalOrderAttachment 8 KB
MedicalOrderAttachment_pkey 8 KB
NamedPriceListItem 8 KB
PatientAiAssistant 8 KB
PatientAiAssistant_pkey 8 KB
PatientAiAssistant_threadId_key 8 KB
RadiologyOrder 8 KB
RadiologyOrder_orderId_key 8 KB
RadiologyOrder_pkey 8 KB
Star_pkey 8 KB
Star_userId_updateId_key 8 KB
VaccinationStatus 8 KB
VaccinationStatus_growthVisitId_key 8 KB
VaccinationStatus_pkey 8 KB
Vote 8 KB
_BranchToTreasury_AB_pkey 8 KB
_BranchToTreasury_B_index 8 KB
_InvoiceToTag_AB_pkey 8 KB
_InvoiceToTag_B_index UNUSED 8 KB
_NamedPriceListBranches 8 KB
_TagToUser_AB_pkey 8 KB
_TagToUser_B_index UNUSED 8 KB
_TreasuryToUser 8 KB
chatbot_knowledge_chunk 8 KB
chatbot_knowledge_chunk_pkey 8 KB
chatbot_knowledge_chunk_sourceId_idx UNUSED 8 KB
chatbot_knowledge_source 8 KB
chatbot_knowledge_source_clinicDomain_idx 8 KB
chatbot_knowledge_source_pkey 8 KB
AccommodationServiceUnit 0 Bytes
LoyaltyExaminationRule 0 Bytes
LoyaltyRedemption 0 Bytes
Star 0 Bytes
_BranchToTreasury 0 Bytes
_InvoiceToTag 0 Bytes
_TagToUser 0 Bytes