PgHero

Space

Database Size: 14.6 GB

293 unused indices. Remove them for faster writes.

rails generate migration remove_unused_indexes

And paste

remove_index :InvoiceUnit, name: "InvoiceUnit_transferSpecialty_doctorId_idx"
remove_index :InvoiceUnit, name: "InvoiceUnit_namedPriceListId_idx"
remove_index :InvoiceUnit, name: "InvoiceUnit_productBundleId_idx"
remove_index :Invoice, name: "Invoice_exchangeRateId_idx"
remove_index :PaymentTransaction, name: "PaymentTransaction_exchangeRateId_idx"
remove_index :SessionRequest, name: "SessionRequest_clinicDomain_patientUserId_status_createdAt_idx"
remove_index :PrescriptionUnit, name: "PrescriptionUnit_drugId_idx"
remove_index :LoyaltyTransaction, name: "LoyaltyTransaction_notifiedExpiringAt_idx"
remove_index :Drug, name: "Drug_genericName_idx"
remove_index :TreasuryTransaction, name: "TreasuryTransaction_movementSource_sourceId_idx"
remove_index :DrugIngredient, name: "DrugIngredient_name_idx"
remove_index :TreasuryTransaction, name: "TreasuryTransaction_exchangeRateId_idx"
remove_index :File, name: "File_assetType_idx"
remove_index :File, name: "File_comparisonGroupId_idx"
remove_index :Expense, name: "Expense_settlementRef_idx"
remove_index :Expense, name: "Expense_exchangeRateId_idx"
remove_index :BookingLinkEvent, name: "BookingLinkEvent_sessionRequestId_idx"
remove_index :SessionRequest, name: "SessionRequest_clinicDomain_status_waitlistWindowFrom_waitl_idx"
remove_index :Drug, name: "Drug_atcCode_idx"
remove_index :SessionRequest, name: "SessionRequest_acceptedById_acceptedAt_idx"
remove_index :FinancialOutboxEvent, name: "FinancialOutboxEvent_clinicDomain_sourceType_sourceId_idx"
remove_index :SessionRequest, name: "SessionRequest_rescheduledFromRequestId_idx"
remove_index :SessionRequest, name: "SessionRequest_patientUserId_idx"
remove_index :SessionRequest, name: "SessionRequest_rescheduledFromSessionId_idx"
remove_index :PackageSubscription, name: "PackageSubscription_isOnHold_idx"
remove_index :PackageSubscription, name: "PackageSubscription_pricingNamedPriceListId_idx"
remove_index :Examination, name: "Examination_procedureCodeId_idx"
remove_index :Order, name: "Order_clinicDomain_channel_status_idx"
remove_index :FinancialOutboxEvent, name: "FinancialOutboxEvent_dependsOnEventId_idx"
remove_index :PlatformAdminLog, name: "PlatformAdminLog_createdAt_idx"
remove_index :NurseTask, name: "NurseTask_clinicDomain_accommodationId_status_dueAt_idx"
remove_index :NurseTask, name: "NurseTask_clinicDomain_branchId_sectionId_status_dueAt_idx"
remove_index :Order, name: "Order_cashDrawerSessionId_idx"
remove_index :TelemedicineUsageLog, name: "TelemedicineUsageLog_clinicDomain_createdAt_idx"
remove_index :TelemedicineUsageLog, name: "TelemedicineUsageLog_clinicDomain_eventType_createdAt_idx"
remove_index :PlatformAdminLog, name: "PlatformAdminLog_type_idx"
remove_index :PlatformAdminLog, name: "PlatformAdminLog_userId_idx"
remove_index :PlatformAdminLog, name: "PlatformAdminLog_clinicDomain_idx"
remove_index :PlatformAdminLog, name: "PlatformAdminLog_operationType_idx"
remove_index :AiCreditRoomUsage, name: "AiCreditRoomUsage_clinicDomain_day_idx"
remove_index :OnboardingExperienceEvent, name: "OnboardingExperienceEvent_sessionKey_createdAt_idx"
remove_index :WalletTransaction, name: "WalletTransaction_exchangeRateId_idx"
remove_index :DietDayBlockMeal, name: "DietDayBlockMeal_dayBlockId_order_idx"
remove_index :ScheduleBlock, name: "ScheduleBlock_doctorId_from_idx"
remove_index :Accommodation, name: "Accommodation_bedId_startDate_endDate_idx"
remove_index :Accommodation, name: "Accommodation_clinicDomain_bedId_idx"
remove_index :Accommodation, name: "Accommodation_clinicDomain_patientProfileId_idx"
remove_index :Accommodation, name: "Accommodation_clinicDomain_status_idx"
remove_index :AiModelSyncLog, name: "AiModelSyncLog_runAt_idx"
remove_index :AnalysisResult, name: "AnalysisResult_medicalOrderId_idx"
remove_index :AnalysisResult, name: "AnalysisResult_patientProfileId_createdAt_idx"
remove_index :AttendanceAlert, name: "AttendanceAlert_clinicDomain_createdAt_idx"
remove_index :BiometricDevice, name: "BiometricDevice_clinicDomain_isActive_idx"
remove_index :BookingLink, name: "BookingLink_clinicDomain_isActive_createdAt_idx"
remove_index :BranchPublicProfile, name: "BranchPublicProfile_clinicDomain_idx"
remove_index :ClinicActivity, name: "ClinicActivity_authorId_idx"
remove_index :ClinicActivity, name: "ClinicActivity_clinicDomain_createdAt_idx"
remove_index :ClinicActivity, name: "ClinicActivity_onboardingProjectId_createdAt_idx"
remove_index :ClinicActivity, name: "ClinicActivity_onboardingProjectId_onboardingEntityType_onb_idx"
remove_index :ClinicContract, name: "ClinicContract_subscriptionId_idx"
remove_index :DietDayBlock, name: "DietDayBlock_clinicDomain_isActive_idx"
remove_index :DietDayBlock, name: "DietDayBlock_clinicDomain_totalCalories_idx"
remove_index :DietDayBlock, name: "DietDayBlock_clinicDomain_usageCount_idx"
remove_index :DietMealBlock, name: "DietMealBlock_clinicDomain_totalCalories_idx"
remove_index :DoctorPublicProfile, name: "DoctorPublicProfile_clinicDomain_idx"
remove_index :EmployeeContract, name: "EmployeeContract_clinicDomain_idx"
remove_index :EmployeeContract, name: "EmployeeContract_clinicDomain_status_endDate_idx"
remove_index :EmployeeContract, name: "EmployeeContract_userId_idx"
remove_index :EmployeeDocument, name: "EmployeeDocument_clinicDomain_idx"
remove_index :EmployeeViolationHistory, name: "EmployeeViolationHistory_violationId_changedAt_idx"
remove_index :EmployeeViolation, name: "EmployeeViolation_clinicDomain_status_idx"
remove_index :EmployeeViolation, name: "EmployeeViolation_clinicDomain_userId_idx"
remove_index :ExternalLab, name: "ExternalLab_clinicDomain_labType_idx"
remove_index :FeatureRequest, name: "FeatureRequest_clinicDomain_idx"
remove_index :FileFavorite, name: "FileFavorite_userId_createdAt_idx"
remove_index :FileVersion, name: "FileVersion_fileId_createdAt_idx"
remove_index :GiftCard, name: "GiftCard_clinicDomain_status_idx"
remove_index :GiftCard, name: "GiftCard_issuedForReturnId_idx"
remove_index :InsuranceCompany, name: "InsuranceCompany_nphiesPayerDirectoryId_idx"
remove_index :InsuranceConfirmation, name: "InsuranceConfirmation_nphiesAuthorizationId_idx"
remove_index :InsurancePolicy, name: "InsurancePolicy_policyHolderOrganizationId_idx"
remove_index :IntakeFormBinding, name: "IntakeFormBinding_formId_idx"
remove_index :LabReflexRule, name: "LabReflexRule_clinicDomain_enabled_ifUnitId_idx"
remove_index :LabTestItem, name: "LabTestItem_analysisUnitId_idx"
remove_index :LoyaltyTierBenefit, name: "LoyaltyTierBenefit_loyaltyRuleId_tier_idx"
remove_index :MedicalOrder, name: "MedicalOrder_assignedToId_status_idx"
remove_index :MedicalOrder, name: "MedicalOrder_clinicDomain_fulfillment_status_idx"
remove_index :MedicalOrder, name: "MedicalOrder_clinicDomain_hasCritical_criticalAcknowledgedA_idx"
remove_index :MedicalOrder, name: "MedicalOrder_clinicDomain_status_idx"
remove_index :MedicalOrder, name: "MedicalOrder_doctorId_idx"
remove_index :MedicalOrder, name: "MedicalOrder_patientProfileId_idx"
remove_index :MedicalOrder, name: "MedicalOrder_reflexParentOrderId_idx"
remove_index :MedicalOrder, name: "MedicalOrder_requestedDate_idx"
remove_index :NurseCarePlanItem, name: "NurseCarePlanItem_carePlanId_idx"
remove_index :NurseCarePlanTemplate, name: "NurseCarePlanTemplate_clinicDomain_isActive_idx"
remove_index :NurseCarePlan, name: "NurseCarePlan_clinicDomain_patientProfileId_idx"
remove_index :NurseTaskHistory, name: "NurseTaskHistory_taskId_idx"
remove_index :OnboardingConfigurationSnapshot, name: "OnboardingConfigurationSnapshot_checksum_idx"
remove_index :OnboardingEvent, name: "OnboardingEvent_projectId_createdAt_idx"
remove_index :OnboardingEvent, name: "OnboardingEvent_projectId_type_idx"
remove_index :OnboardingExperienceEvent, name: "OnboardingExperienceEvent_eventType_createdAt_idx"
remove_index :OnboardingExperienceEvent, name: "OnboardingExperienceEvent_projectId_createdAt_idx"
remove_index :OnboardingProject, name: "OnboardingProject_engineerId_idx"
remove_index :OnboardingProject, name: "OnboardingProject_health_targetGoLiveAt_idx"
remove_index :OnboardingProject, name: "OnboardingProject_onboardingManagerId_idx"
remove_index :OnboardingScopeRevision, name: "OnboardingScopeRevision_projectId_createdAt_idx"
remove_index :OnboardingTrainingAssignment, name: "OnboardingTrainingAssignment_targetUserId_idx"
remove_index :PackageSubscriptionHold, name: "PackageSubscriptionHold_holdStartAt_holdEndAt_idx"
remove_index :PatientPaymentMethodConfig, name: "PatientPaymentMethodConfig_clinicDomain_enabled_idx"
remove_index :PatientPaymentSubmission, name: "PatientPaymentSubmission_clinicDomain_status_createdAt_idx"
remove_index :PatientPaymentSubmission, name: "PatientPaymentSubmission_patientProfileId_status_idx"
remove_index :PatientPaymentSubmission, name: "PatientPaymentSubmission_sessionId_status_idx"
remove_index :PatientUser, name: "PatientUser_deletedAt_idx"
remove_index :PaymentIntent, name: "PaymentIntent_clinicDomain_status_createdAt_idx"
remove_index :PaymentIntent, name: "PaymentIntent_invoiceId_idx"
remove_index :PaymentIntent, name: "PaymentIntent_orderId_idx"
remove_index :PaymentIntent, name: "PaymentIntent_packageId_idx"
remove_index :PaymentIntent, name: "PaymentIntent_packageSubscriptionId_idx"
remove_index :PaymentIntent, name: "PaymentIntent_paymentLinkId_idx"
remove_index :PaymentIntent, name: "PaymentIntent_sessionRequestId_idx"
remove_index :PaymentIntent, name: "PaymentIntent_treasuryId_idx"
remove_index :PaymentLink, name: "PaymentLink_invoiceId_idx"
remove_index :PaymentWebhookEvent, name: "PaymentWebhookEvent_providerEventId_idx"
remove_index :PerformanceCycle, name: "PerformanceCycle_clinicDomain_status_idx"
remove_index :PerformanceReview, name: "PerformanceReview_userId_idx"
remove_index :Plan, name: "Plan_organizationType_isActive_idx"
remove_index :ProgramItem, name: "ProgramItem_treatmentPlanId_order_idx"
remove_index :RecurringExpense, name: "RecurringExpense_treasuryId_idx"
remove_index :SalesDailyReport, name: "SalesDailyReport_clinicDomain_day_idx"
remove_index :SalesReviewRun, name: "SalesReviewRun_clinicDomain_day_idx"
remove_index :SalesReviewSetting, name: "SalesReviewSetting_enabled_idx"
remove_index :TelemedicineRecording, name: "TelemedicineRecording_providerRecordingId_idx"
remove_index :TelemedicineRecording, name: "TelemedicineRecording_telemedicineRoomId_status_idx"
remove_index :TelemedicineRoom, name: "TelemedicineRoom_sessionId_status_idx"
remove_index :TelemedicineTranscript, name: "TelemedicineTranscript_clinicDomain_patientProfileId_idx"
remove_index :TelemedicineTranscript, name: "TelemedicineTranscript_clinicDomain_sessionId_idx"
remove_index :TelemedicineTranscript, name: "TelemedicineTranscript_clinicDomain_status_idx"
remove_index :TreasuryPosition, name: "TreasuryPosition_currency_idx"
remove_index :VacationHistory, name: "VacationHistory_vacationId_idx"
remove_index :Vacation, name: "Vacation_clinicDomain_idx"
remove_index :Vacation, name: "Vacation_directManagerId_idx"
remove_index :Vacation, name: "Vacation_status_idx"
remove_index :Vacation, name: "Vacation_userId_idx"
remove_index :WorkShift, name: "WorkShift_clinicDomain_isActive_idx"
remove_index :WorkShift, name: "WorkShift_clinicDomain_sectionId_isDefaultForSection_idx"
remove_index :_CustomRoleToUser, name: "_CustomRoleToUser_B_index"
remove_index :BiometricPunch, name: "BiometricPunch_userId_punchAt_idx"
remove_index :CashDrawerSession, name: "CashDrawerSession_clinicDomain_branchId_status_idx"
remove_index :CashDrawerSession, name: "CashDrawerSession_shiftId_idx"
remove_index :ClinicActivityMention, name: "ClinicActivityMention_userId_readAt_idx"
remove_index :ClinicActivityRevision, name: "ClinicActivityRevision_activityId_createdAt_idx"
remove_index :ClinicCurrencyConfig, name: "ClinicCurrencyConfig_clinicDomain_idx"
remove_index :ClinicFormularyItem, name: "ClinicFormularyItem_clinicDomain_isStocked_idx"
remove_index :ClinicFormularyItem, name: "ClinicFormularyItem_productId_idx"
remove_index :ClinicalCode, name: "ClinicalCode_code_idx"
remove_index :ClinicalCode, name: "ClinicalCode_systemId_isActive_idx"
remove_index :ControlledSubstanceEntry, name: "ControlledSubstanceEntry_clinicDomain_branchId_drugId_creat_idx"
remove_index :ControlledSubstanceEntry, name: "ControlledSubstanceEntry_clinicDomain_branchId_registerBook_idx"
remove_index :ControlledSubstanceEntry, name: "ControlledSubstanceEntry_dispenseOrderId_idx"
remove_index :ControlledSubstanceEntry, name: "ControlledSubstanceEntry_drugId_idx"
remove_index :ControlledSubstanceEntry, name: "ControlledSubstanceEntry_productId_idx"
remove_index :CoverageVerification, name: "CoverageVerification_patientInsuranceId_purpose_serviceDate_idx"
remove_index :CoverageVerification, name: "CoverageVerification_patientInsuranceId_verifiedAt_idx"
remove_index :DemoRequestNote, name: "DemoRequestNote_demoRequestId_createdAt_idx"
remove_index :DemoRequestRateBucket, name: "DemoRequestRateBucket_expiresAt_idx"
remove_index :DemoRequest, name: "DemoRequest_market_status_createdAt_idx"
remove_index :DietFoodSwap, name: "DietFoodSwap_alternativeId_idx"
remove_index :DietFoodSwap, name: "DietFoodSwap_foodId_order_idx"
remove_index :DietPlanBlockDay, name: "DietPlanBlockDay_planBlockId_order_idx"
remove_index :DietPlanBlock, name: "DietPlanBlock_clinicDomain_avgDailyCalories_idx"
remove_index :DietPlanBlock, name: "DietPlanBlock_clinicDomain_isActive_idx"
remove_index :DispenseItem, name: "DispenseItem_dispenseOrderId_idx"
remove_index :DispenseItem, name: "DispenseItem_drugId_idx"
remove_index :DispenseItem, name: "DispenseItem_externalPrescriptionItemId_idx"
remove_index :DispenseItem, name: "DispenseItem_prescriptionUnitId_idx"
remove_index :DispenseItem, name: "DispenseItem_productId_idx"
remove_index :DispenseOrder, name: "DispenseOrder_clinicDomain_createdAt_idx"
remove_index :DispenseOrder, name: "DispenseOrder_clinicDomain_status_idx"
remove_index :DispenseOrder, name: "DispenseOrder_externalPrescriptionId_idx"
remove_index :DoctorReview, name: "DoctorReview_doctorId_status_publishedAt_idx"
remove_index :DoctorReview, name: "DoctorReview_patientUserId_idx"
remove_index :DrugInteraction, name: "DrugInteraction_ingredientA_idx"
remove_index :DrugInteraction, name: "DrugInteraction_ingredientB_idx"
remove_index :EmailDelivery, name: "EmailDelivery_clinicDomain_createdAt_idx"
remove_index :EmailDelivery, name: "EmailDelivery_to_status_idx"
remove_index :EmailSuppression, name: "EmailSuppression_email_idx"
remove_index :EmployeeInsurance, name: "EmployeeInsurance_clinicDomain_userId_idx"
remove_index :EmployeeStatusHistory, name: "EmployeeStatusHistory_userId_changedAt_idx"
remove_index :ExchangeRate, name: "ExchangeRate_clinicDomain_fromCurrency_toCurrency_purpose_e_idx"
remove_index :ExternalLabPrice, name: "ExternalLabPrice_analysisTemplateId_idx"
remove_index :ExternalLabPrice, name: "ExternalLabPrice_analysisUnitId_idx"
remove_index :ExternalPrescriptionItem, name: "ExternalPrescriptionItem_drugId_idx"
remove_index :ExternalPrescriptionItem, name: "ExternalPrescriptionItem_externalPrescriptionId_idx"
remove_index :ExternalPrescription, name: "ExternalPrescription_clinicDomain_status_idx"
remove_index :FinancialPeriodWriteFence, name: "FinancialPeriodWriteFence_clinicDomain_releasedAt_periodSta_idx"
remove_index :FinancialPeriodWriteFence, name: "FinancialPeriodWriteFence_financialPeriodId_idx"
remove_index :FxConversion, name: "FxConversion_sourceTreasuryId_occurredAt_idx"
remove_index :FxRevaluationLine, name: "FxRevaluationLine_exchangeRateId_idx"
remove_index :FxRevaluationLine, name: "FxRevaluationLine_foreignCurrency_idx"
remove_index :FxRevaluationLine, name: "FxRevaluationLine_itemType_sourceId_idx"
remove_index :FxRevaluationRateSnapshot, name: "FxRevaluationRateSnapshot_exchangeRateId_idx"
remove_index :FxRevaluationRun, name: "FxRevaluationRun_clinicDomain_periodEnd_idx"
remove_index :FxRevaluationRun, name: "FxRevaluationRun_clinicDomain_status_periodEnd_idx"
remove_index :FxRevaluationRun, name: "FxRevaluationRun_financialPeriodId_idx"
remove_index :GiftCardTransaction, name: "GiftCardTransaction_giftCardId_idx"
remove_index :GiftCardTransaction, name: "GiftCardTransaction_orderId_idx"
remove_index :IntakeRedFlagRule, name: "IntakeRedFlagRule_formFieldId_idx"
remove_index :InvoicePaymentApplication, name: "InvoicePaymentApplication_clinicDomain_occurredAt_idx"
remove_index :InvoicePaymentApplication, name: "InvoicePaymentApplication_reversalOfId_idx"
remove_index :InvoiceReceivablePosition, name: "InvoiceReceivablePosition_clinicDomain_currency_idx"
remove_index :InvoiceReceivablePosition, name: "InvoiceReceivablePosition_clinicDomain_lastEventAt_idx"
remove_index :InvoiceUnitOption, name: "InvoiceUnitOption_name_value_idx"
remove_index :LabNotificationRule, name: "LabNotificationRule_clinicDomain_idx"
remove_index :MobileAppRevision, name: "MobileAppRevision_configId_createdAt_idx"
remove_index :NphiesAccount, name: "NphiesAccount_certificateExpiresAt_idx"
remove_index :NphiesAccount, name: "NphiesAccount_clinicDomain_isActive_idx"
remove_index :NphiesAuthorization, name: "NphiesAuthorization_clinicDomain_preAuthRef_idx"
remove_index :NphiesAuthorization, name: "NphiesAuthorization_eligibilityVerificationId_idx"
remove_index :NphiesAuthorization, name: "NphiesAuthorization_nphiesMessageId_idx"
remove_index :NphiesClaim, name: "NphiesClaim_appealedById_idx"
remove_index :NphiesClaim, name: "NphiesClaim_clinicDomain_receivablePostingStatus_idx"
remove_index :NphiesClaim, name: "NphiesClaim_clinicDomain_status_idx"
remove_index :NphiesClaim, name: "NphiesClaim_eligibilityVerificationId_idx"
remove_index :NphiesClaim, name: "NphiesClaim_nphiesMessageId_idx"
remove_index :NphiesClaim, name: "NphiesClaim_originalClaimId_idx"
remove_index :NphiesClaim, name: "NphiesClaim_relatedClaimId_idx"
remove_index :NphiesDisclosure, name: "NphiesDisclosure_actorId_idx"
remove_index :NphiesDisclosure, name: "NphiesDisclosure_clinicDomain_disclosedAt_idx"
remove_index :NphiesDisclosure, name: "NphiesDisclosure_infoRequestId_idx"
remove_index :NphiesDisclosure, name: "NphiesDisclosure_nphiesMessageId_idx"
remove_index :NphiesInfoRequestAttachment, name: "NphiesInfoRequestAttachment_requestId_idx"
remove_index :NphiesInfoRequest, name: "NphiesInfoRequest_assignedToId_idx"
remove_index :NphiesInfoRequest, name: "NphiesInfoRequest_clinicDomain_status_receivedAt_idx"
remove_index :NphiesInfoRequest, name: "NphiesInfoRequest_inboundMessageId_idx"
remove_index :NphiesInfoRequest, name: "NphiesInfoRequest_nphiesAuthorizationId_idx"
remove_index :NphiesInfoRequest, name: "NphiesInfoRequest_nphiesClaimId_idx"
remove_index :NphiesMessage, name: "NphiesMessage_clinicDomain_direction_eventCode_idx"
remove_index :NphiesMessage, name: "NphiesMessage_clinicDomain_mode_idx"
remove_index :NphiesMessage, name: "NphiesMessage_clinicDomain_sourceType_status_idx"
remove_index :NphiesMessage, name: "NphiesMessage_clinicDomain_status_nextAttemptAt_createdAt_idx"
remove_index :NphiesMessage, name: "NphiesMessage_status_nextAttemptAt_createdAt_idx"
remove_index :NphiesPayerDirectory, name: "NphiesPayerDirectory_isActive_idx"
remove_index :NphiesPaymentNotice, name: "NphiesPaymentNotice_clinicDomain_status_idx"
remove_index :NphiesPaymentNotice, name: "NphiesPaymentNotice_nphiesMessageId_idx"
remove_index :NphiesPaymentNotice, name: "NphiesPaymentNotice_reconciliationId_idx"
remove_index :NphiesPaymentReconciliationLine, name: "NphiesPaymentReconciliationLine_claimBusinessIdentifier_idx"
remove_index :NphiesPaymentReconciliationLine, name: "NphiesPaymentReconciliationLine_nphiesClaimId_idx"
remove_index :NphiesPaymentReconciliation, name: "NphiesPaymentReconciliation_clinicDomain_paymentDate_idx"
remove_index :NphiesPaymentReconciliation, name: "NphiesPaymentReconciliation_nphiesMessageId_idx"
remove_index :OnboardingBlocker, name: "OnboardingBlocker_ownerId_dueAt_idx"
remove_index :OnboardingBlocker, name: "OnboardingBlocker_reasonKey_category_idx"
remove_index :OnboardingBlocker, name: "OnboardingBlocker_sourceTaskId_idx"
remove_index :OnboardingCalendarAttendee, name: "OnboardingCalendarAttendee_userId_eventId_idx"
remove_index :OnboardingCalendarEvent, name: "OnboardingCalendarEvent_onboardingProjectId_startAt_idx"
remove_index :OnboardingCalendarEvent, name: "OnboardingCalendarEvent_status_startAt_idx"
remove_index :OnboardingHandoffItem, name: "OnboardingHandoffItem_handoffId_sortOrder_idx"
remove_index :OnboardingMigrationReview, name: "OnboardingMigrationReview_importJobId_idx"
remove_index :OnboardingTaskDependency, name: "OnboardingTaskDependency_projectId_idx"
remove_index :OnboardingTemplate, name: "OnboardingTemplate_familyKey_status_revision_idx"
remove_index :OnboardingUatRun, name: "OnboardingUatRun_projectId_executedAt_idx"
remove_index :OrderReturnItem, name: "OrderReturnItem_orderReturnId_idx"
remove_index :PatientAllergy, name: "PatientAllergy_atcPrefix_idx"
remove_index :PatientAllergy, name: "PatientAllergy_clinicDomain_isActive_idx"
remove_index :PatientAllergy, name: "PatientAllergy_ingredientName_idx"
remove_index :PatientUserStorePriceList, name: "PatientUserStorePriceList_clinicDomain_idx"
remove_index :PatientUserStorePriceList, name: "PatientUserStorePriceList_namedPriceListId_idx"
remove_index :PaymentSettlementRecord, name: "PaymentSettlementRecord_clinicDomain_paymentIntentId_idx"
remove_index :PaymentSettlementRecord, name: "PaymentSettlementRecord_clinicDomain_settledAt_idx"
remove_index :PolicyHolderOrganization, name: "PolicyHolderOrganization_clinicDomain_idx"
remove_index :SalesAgentDailyScore, name: "SalesAgentDailyScore_clinicDomain_userId_day_idx"
remove_index :SessionDeviceUsage, name: "SessionDeviceUsage_clinicDomain_assetId_usedAt_idx"
remove_index :SessionDeviceUsage, name: "SessionDeviceUsage_clinicDomain_usedAt_idx"
remove_index :SessionDiagnosis, name: "SessionDiagnosis_sessionId_idx"
remove_index :SpecialtyPracticeCode, name: "SpecialtyPracticeCode_clinicDomain_idx"
remove_index :StaffDevice, name: "StaffDevice_deviceToken_idx"
remove_index :StaffDevice, name: "StaffDevice_userId_idx"
remove_index :TaxBracket, name: "TaxBracket_clinicDomain_kind_order_idx"
remove_index :TelemedicineDailyReconciliation, name: "TelemedicineDailyReconciliation_clinicDomain_date_idx"
remove_index :TelemedicineMeteringFailure, name: "TelemedicineMeteringFailure_clinicDomain_createdAt_idx"
remove_index :TelemedicineMeteringFailure, name: "TelemedicineMeteringFailure_resolvedAt_idx"
remove_index :TelemedicineMinuteTransaction, name: "TelemedicineMinuteTransaction_clinicDomain_createdAt_idx"
remove_index :TelemedicineMinuteTransaction, name: "TelemedicineMinuteTransaction_clinicDomain_type_createdAt_idx"
remove_index :TelemedicineMinuteTransaction, name: "TelemedicineMinuteTransaction_sessionId_idx"
remove_index :TelemedicineMinuteUsage, name: "TelemedicineMinuteUsage_sessionId_idx"
remove_index :TreasuryCashCount, name: "TreasuryCashCount_clinicDomain_countedAt_idx"
remove_index :TreasuryCashCount, name: "TreasuryCashCount_clinicDomain_status_countedAt_idx"
remove_index :TreasuryCashCount, name: "TreasuryCashCount_treasuryId_currency_countedAt_idx"
remove_index :WaitlistOffer, name: "WaitlistOffer_sessionRequestId_createdAt_idx"
remove_index :WorkScheduleException, name: "WorkScheduleException_clinicDomain_date_idx"
remove_index :_DietPlanBlockToDietTag, name: "_DietPlanBlockToDietTag_B_index"
remove_index :_ExaminationToPatientOperation, name: "_ExaminationToPatientOperation_B_index"
remove_index :_InvoiceToTag, name: "_InvoiceToTag_B_index"
remove_index :_TagToUser, name: "_TagToUser_B_index"
Relation Size
Logs 11.5 GB
PatientProfile 435 MB
Invoice 231 MB
Session 181 MB
InvoiceUnit 157 MB
PaymentTransaction 120 MB
Session_clinicDomain_link_key 91.2 MB
Invoice_clinicDomain_serialNumber_key 82 MB
Notification 57.4 MB
Session_doctorId_date_branchId_clinicDomain_idx 56.5 MB
Invoice_clinicDomain_txCurrency_createdAt_idx 56.4 MB
Logs_pkey 53.9 MB
Invoice_clinicDomain_createdAt_idx 49.5 MB
PrescriptionUnit 44.1 MB
Session_clinicDomain_from_idx 42.2 MB
Session_date_clinicDomain_idx 40.8 MB
PatientProfile_clinicDomain_link_key 40 MB
LoyaltyTransaction 38.3 MB
Session_clinicDomain_isOperation_date_idx 37 MB
_ExaminationToSession 34.8 MB
Session_date_patientProfileId_idx 33.7 MB
WeightTracking 32.4 MB
File 29.4 MB
Invoice_sessionId_key 29.4 MB
UniqueText_text_clinicDomain_type_key 27.8 MB
PatientProfile_clinicDomain_patientIndex_key 27.1 MB
UniqueText 26.6 MB
Session_branchId_from_idx 26.2 MB
PaymentTransaction_clinicDomain_createdAt_idx 25.9 MB
Session_date_doctorId_idx 24 MB
Session_date_branchId_idx 23.9 MB
Invoice_pkey 23.8 MB
PatientLoyalty 23.4 MB
InvoiceUnit_examinationId_invoiceId_idx 21.6 MB
_ExaminationToSession_AB_pkey 20.6 MB
PaymentTransaction_method_invoiceId_idx 19.3 MB
InvoiceUnit_pkey 19.1 MB
VariablePropertyValue 19 MB
PaymentTransaction_invoiceId_idx 18.9 MB
PatientLoyalty_pkey 17.8 MB
Session_pkey 17.1 MB
UniqueText_clinicDomain_type_createdAt_idx 16.8 MB
InvoiceUnit_invoiceId_idx 16.7 MB
_ExaminationToSession_B_index 16.5 MB
Prescription 15 MB
PaymentTransaction_pkey 14.6 MB
Session_acceptedFromSessionRequestId_key 14.5 MB
Expense 14.3 MB
DentistProfile 14 MB
TreasuryTransaction 13.6 MB
WebSession_ip_sessionId_clinicDomain_key 13.2 MB
_PrescriptionToPrescriptionUnit 12.9 MB
LoyaltyTransaction_pkey 12.7 MB
Session_patientProfileId_idx 12 MB
Prescription_link_clinicDomain_key 11.7 MB
Invoice_orderId_key 10.5 MB
Invoice_accommodationId_key 10.3 MB
FormResponseField 10.2 MB
PaymentTransaction_patientProfileId_idx 9.73 MB
PrescriptionUnit_pkey 8.67 MB
NutritionProfile 8.42 MB
Session_doctorId_branchId_idx 8.42 MB
_PrescriptionToPrescriptionUnit_B_index 8.4 MB
PaymentTransaction_invoiceUnitId_key 8.23 MB
PaymentTransaction_paymentProviderId_key 8.14 MB
SessionRequest 7.96 MB
Invoice_closingShiftId_idx 7.95 MB
_PrescriptionToPrescriptionUnit_AB_pkey 7.9 MB
Prescription_patientProfileId_clinicDomain_id_idx 7.77 MB
LoyaltyTransaction_patientLoyaltyId_idx 7.72 MB
File_patientProfileId_clinicDomain_createdAt_idx 7.49 MB
LoyaltyTransaction_sessionId_idx 7.15 MB
PatientProfile_pkey 6.92 MB
Drug 6.82 MB
InvoiceUnit_transferSpecialty_doctorId_idx UNUSED 6.8 MB
InvoiceUnit_doctorId_idx 6.79 MB
InvoiceUnit_namedPriceListId_idx UNUSED 6.77 MB
BookingLinkEvent 6.53 MB
ExtraFieldValue 6.4 MB
InvoiceUnit_productBundleId_idx UNUSED 6.15 MB
Invoice_exchangeRateId_idx UNUSED 5.71 MB
DentistProfile_patientProfileId_key 5.6 MB
DentistProfile_pkey 5.6 MB
Notification_userId_createdAt_idx 5.59 MB
Token_token_key 5.41 MB
VariablePropertyValue_pkey 5.34 MB
PaymentTransaction_closingShiftId_idx 5.31 MB
PatientLoyalty_patientId_key 5.16 MB
AiCreditTransaction 5.05 MB
WebSession_ip_createdAt_key 4.98 MB
WeightTracking_weightId_key 4.79 MB
PaymentTransaction_insuranceClaimId_idx 4.71 MB
Token 4.65 MB
UniqueText_pkey 4.52 MB
PaymentTransaction_exchangeRateId_idx UNUSED 4.45 MB
BookingLinkEvent_clinicDomain_bookingLinkId_type_createdAt_idx 4.34 MB
NutritionProfile_patientProfileId_key 4.32 MB
Notification_pkey 4.13 MB
DiscountPackage 4 MB
LoyaltyTransaction_paymentTransactionId_key 3.93 MB
FinancialOutboxEvent 3.89 MB
AiUsageLog 3.88 MB
TreasuryTransaction_paymentTransactionId_key 3.88 MB
WebSession_userId_createdAt_key 3.88 MB
PaymentDoctorCommission 3.76 MB
SessionRequest_clinicDomain_link_key 3.68 MB
TreasuryTransaction_treasuryId_occurredAt_id_idx 3.64 MB
BookingLinkEvent_clinicDomain_createdAt_idx 3.55 MB
ExtraFieldValue_patientProfileId_extraFieldId_key 3.33 MB
PatientProfile_referredById_idx 3.27 MB
DrugIngredient 3.27 MB
SessionStatusHistory 3.09 MB
SessionRequest_clinicDomain_bookingLinkId_status_createdAt_idx 3.06 MB
SessionRequest_clinicDomain_patientUserId_status_createdAt_idx UNUSED 3.05 MB
WeightTracking_pkey 3.02 MB
Examination 2.96 MB
PaymentDoctorCommission_clinicDomain_doctorId_createdAt_idx 2.95 MB
PlatformAdminLog 2.84 MB
NutritionProfile_pkey 2.79 MB
Notification_dedupeKey_key 2.71 MB
PrescriptionUnit_drugId_idx UNUSED 2.69 MB
WebSession_pkey 2.66 MB
TreasuryTransaction_idempotencyKey_key 2.58 MB
ExtraFieldValue_pkey 2.52 MB
SessionRequest_clinicDomain_normalizedPhone_status_date_idx 2.5 MB
DietMealItem 2.48 MB
ExtraFieldValue_weightTrackingId_extraFieldId_key 2.41 MB
TreasuryTransaction_pkey 2.34 MB
_noteToWeightTracking 2.33 MB
LoyaltyTransaction_formResponseId_idx 2.2 MB
PackageSubscription 2.16 MB
DrugIngredient_drugId_name_key 2.06 MB
LoyaltyTransaction_notifiedExpiringAt_idx UNUSED 2.05 MB
TreasuryTransaction_reversalOfId_key 2.03 MB
File_pkey 2.01 MB
LoyaltyTransaction_expiresAt_idx 1.98 MB
Prescription_pkey 1.95 MB
Notification_whatsappLogId_key 1.92 MB
Attendance 1.89 MB
LoyaltyTransaction_packageSubscriptionId_idx 1.88 MB
WeightTracking_heightId_key 1.88 MB
_noteToWeightTracking_AB_pkey 1.84 MB
Expense_paymentTransactionOfForDoctorId_key 1.8 MB
Message 1.8 MB
Expense_pkey 1.72 MB
DentalAction 1.71 MB
ExtraFieldValue_sessionRequestId_extraFieldId_key 1.71 MB
DiscountPackage_pkey 1.68 MB
Drug_registrySource_registryCode_key 1.67 MB
File_pairedFileId_key 1.67 MB
DiscountPackage_invoiceUnitId_key 1.63 MB
LaserSession 1.62 MB
Examination_name_clinicDomain_key 1.6 MB
TreasuryTransaction_insuranceClaimId_key 1.59 MB
User 1.52 MB
FormResponseField_pkey 1.44 MB
Drug_tradeName_idx 1.37 MB
Drug_genericName_idx UNUSED 1.34 MB
PaymentDoctorCommission_doctorId_createdAt_idx 1.31 MB
DrugIngredient_pkey 1.25 MB
Expense_paymentDoctorCommissionId_key 1.22 MB
TreasuryTransaction_expenseId_key 1.2 MB
_noteToWeightTracking_B_index 1.2 MB
TreasuryTransaction_movementSource_sourceId_idx UNUSED 1.19 MB
ImportJob 1.16 MB
Order 1.12 MB
SessionStatusHistory_pkey 1.08 MB
TreasuryTransaction_treasuryId_positionVersionAfter_idx 1.08 MB
FormField 1.05 MB
Expense_invoiceUnitId_key 1.02 MB
FormResponse 1.02 MB
Expense_quantityInLocationId_key 1.02 MB
_ExaminationToSessionRequest 1.02 MB
SupportTicket 1.01 MB
Template 1.01 MB
_ParticipantSeen 1.01 MB
File_sessionId_idx 1020 KB
Expense_paymentTransactionOfForAssistantId_key 1010 KB
PaymentDoctorCommission_pkey 1010 KB
Consumable 976 KB
_PartitionToSession 960 KB
DrugIngredient_name_idx UNUSED 936 KB
PaymentDoctorCommission_paymentTransactionId_idx 912 KB
VoiceNote 856 KB
HomeExercise 848 KB
DietMeal 832 KB
_NoteToPatientProfile 808 KB
_ExaminationToSessionRequest_AB_pkey 800 KB
_noteToNutritionProfile 800 KB
Attendance_userId_clinicDomain_attendanceAt_idx 792 KB
_PartitionToSession_AB_pkey 784 KB
TreasuryTransaction_exchangeRateId_idx UNUSED 776 KB
File_assetType_idx UNUSED 760 KB
ChecklistStep 752 KB
File_comparisonGroupId_idx UNUSED 752 KB
DietMealItem_pkey 736 KB
_BranchToPackageSubscription 736 KB
Attendance_clinicDomain_attendanceAt_idx 704 KB
MedicalReport 704 KB
BookingLinkEvent_pkey 696 KB
Expense_closingShiftId_idx 688 KB
SessionRequest_sessionId_key 688 KB
Expense_externalLabId_idx 672 KB
Expense_settlementRef_idx UNUSED 672 KB
_NoteToPatientProfile_AB_pkey 672 KB
ManagerPercentagePerInvoiceUnit 664 KB
SessionRequest_pkey 656 KB
AiCreditTransaction_pkey 648 KB
DietMealItem_mealId_order_idx 640 KB
Expense_sourceSessionId_category_idx 632 KB
PushSubscription 632 KB
_PartitionToSession_B_index 632 KB
AiUsageLog_pkey 616 KB
_ExaminationToSessionRequest_B_index 616 KB
Antenatal 608 KB
Expense_exchangeRateId_idx UNUSED 592 KB
PackageSubscription_status_effectiveEndDate_idx 584 KB
PushSubscription_userId_endpoint_key 584 KB
_SessionToTag 584 KB
_BranchToPackageSubscription_AB_pkey 576 KB
Drug_pkey 568 KB
_ParticipantSeen_AB_pkey 568 KB
_noteToNutritionProfile_AB_pkey 520 KB
_surgeriesHistoryToPatientProfile 512 KB
DietMeal_dayId_order_idx 488 KB
FormOption 488 KB
GlassUnit 488 KB
DietMeal_pkey 480 KB
Package 472 KB
_medicationsHistoryToPatientProfile 472 KB
SessionRequest_clinicDomain_acceptedAt_idx 456 KB
_BranchToPackageSubscription_B_index 440 KB
PackageSubscription_invoiceId_key 432 KB
PackageSubscription_pkey 424 KB
Token_pkey 416 KB
_NoteToPatientProfile_B_index 416 KB
FormResponse_pkey 408 KB
LaserSession_pkey 400 KB
TreatmentPlan 400 KB
Examination_pkey 392 KB
FinancialOutboxEvent_clinicDomain_sourceType_sourceId_idemp_key 392 KB
PaymentManagerCommission 392 KB
_medicationsHistoryToPatientProfile_AB_pkey 392 KB
SiteLampItem 384 KB
ObstetricsProfile 376 KB
GynecologyProfile 368 KB
_SessionToTag_AB_pkey 360 KB
BookingLinkEvent_sessionRequestId_idx UNUSED 352 KB
Clinic 344 KB
FormResponse_sessionId_idx 344 KB
_noteToNutritionProfile_B_index 344 KB
GlassUnit_glassExaminationId_type_key 336 KB
DietDay 328 KB
SessionRequest_clinicDomain_status_waitlistWindowFrom_waitl_idx UNUSED 328 KB
User_clinicDomain_email_key 328 KB
Consumable_pkey 312 KB
ExaminationPricePerDoctor 312 KB
ClinicInvoice 304 KB
PaymentDoctorCommission_bulkExpenseId_idx 304 KB
SessionRequest_clinicDomain_status_waitlistClaimExpiresAt_idx 304 KB
Drug_atcCode_idx UNUSED 296 KB
Drug_isControlled_idx 296 KB
Drug_region_isActive_idx 296 KB
Infertility 296 KB
Message_pkey 296 KB
SessionRequest_acceptedById_acceptedAt_idx UNUSED 296 KB
_BranchToExamination 288 KB
_surgeriesHistoryToPatientProfile_AB_pkey 288 KB
FinancialOutboxEvent_clinicDomain_sourceType_sourceId_idx UNUSED 280 KB
FinancialOutboxEvent_pkey 280 KB
User_clinicDomain_phone_key 280 KB
FinancialOutboxEvent_status_nextAttemptAt_createdAt_idx 272 KB
ManagerPercentagePerInvoiceUnit_pkey 272 KB
SessionRequestSettings 272 KB
SessionSettings 264 KB
Consumable_invoiceUnitId_idx 256 KB
WalletTransaction 256 KB
Request 248 KB
OnboardingConfigurationSnapshot 240 KB
SessionRequest_rescheduledFromRequestId_idx UNUSED 240 KB
_BranchToExamination_AB_pkey 240 KB
Attendance_pkey 232 KB
DietFood 232 KB
FormOption_pkey 232 KB
Note 232 KB
Order_pkey 232 KB
RecurringExpense 232 KB
SessionRequest_patientUserId_idx UNUSED 232 KB
Treasury 232 KB
SessionRequest_rescheduledFromSessionId_idx UNUSED 224 KB
_ParticipantSeen_B_index 224 KB
_medicationsHistoryToPatientProfile_B_index 224 KB
Period 216 KB
_NoteToSession 216 KB
_socialHistoryToPatientProfile 216 KB
GlassExamination 208 KB
GlassUnit_pkey 208 KB
PackageSubscription_isOnHold_idx UNUSED 208 KB
_surgeriesHistoryToPatientProfile_B_index 208 KB
Branch 200 KB
PaymentManagerCommission_clinicDomain_managerId_createdAt_idx 200 KB
User_clinicDomain_employeeNumber_key 200 KB
_BranchToExamination_B_index 200 KB
DentalAction_invoiceUnitId_key 192 KB
ExaminationPricePerDoctor_pkey 192 KB
FormSection 192 KB
OpeningTime 192 KB
_familyHistoryToPatientProfile 192 KB
ChecklistStepHistory 184 KB
Diet 184 KB
PackageUnit 184 KB
Token_userId_idx 184 KB
ChecklistStep_pkey 176 KB
PackageSubscription_pricingNamedPriceListId_idx UNUSED 176 KB
ReferralDoctor 176 KB
Note_note_clinicDomain_appliesTo_key 168 KB
OphthalmologySessionDetails 168 KB
Tag 168 KB
DentalAction_pkey 160 KB
GynecologyProfile_patientProfileId_key 160 KB
ManagerPercentage 160 KB
SiteLamp 160 KB
TelemedicineUsageLog 160 KB
_NoteToSession_B_index 160 KB
OperationDetails 152 KB
Period_pkey 152 KB
_SessionToTag_B_index 152 KB
_currentMedicationsHistoryToPatientProfile 152 KB
DietMealBlockItem 144 KB
Tag_name_clinicDomain_key 144 KB
_NoteToSession_AB_pkey 144 KB
_habitsToPatientProfile 144 KB
_socialHistoryToPatientProfile_AB_pkey 144 KB
ClinicInvoiceInstallment 136 KB
Infertility_gynecologyProfileId_key 136 KB
OpeningTime_pkey 136 KB
Order_clinicDomain_refundStartedAt_idx 136 KB
Order_clinicDomain_returnedAt_idx 136 KB
_familyHistoryToPatientProfile_AB_pkey 136 KB
ClinicPublicProfile 128 KB
DoctorPublicProfile 128 KB
GynecologyProfile_pkey 128 KB
HomeExercise_pkey 128 KB
PatientProfileSettings 128 KB
PatientWallet 128 KB
PaymentManagerCommission_managerId_createdAt_idx 128 KB
Antenatal_pkey 120 KB
ClinicFeatures 120 KB
Examination_procedureCodeId_idx UNUSED 120 KB
FormField_pkey 120 KB
FormResponse_sessionRequestId_idx 120 KB
MessageReaction 120 KB
NurseTask 120 KB
NurseTask_clinicDomain_accommodationId_status_dueAt_idx UNUSED 120 KB
NurseTask_clinicDomain_assignedNurseId_status_dueAt_idx 120 KB
NurseTask_clinicDomain_branchId_sectionId_status_dueAt_idx UNUSED 120 KB
PackageUnit_pkey 120 KB
Payslip 120 KB
VariableProperty 120 KB
_BranchToUser 120 KB
_socialHistoryToPatientProfile_B_index 120 KB
Infertility_pkey 112 KB
NurseTask_clinicDomain_carePlanItemId_dueAt_key 112 KB
NurseTask_clinicDomain_status_dueAt_idx 112 KB
OnboardingTask 112 KB
Order_clinicDomain_channel_patientUserId_idx 112 KB
Order_clinicDomain_channel_status_idx UNUSED 112 KB
PatientJourney 112 KB
PaymentManagerCommission_pkey 112 KB
Room 112 KB
SiteLampItem_pkey 112 KB
VoiceNote_pkey 112 KB
_allergiesHistoryToPatientProfile 112 KB
AiCreditRoomUsage 104 KB
DietMealBlock 104 KB
EmployeeEarning 104 KB
FinancialOutboxEvent_dependsOnEventId_idx UNUSED 104 KB
ManagerPercentage_pkey 104 KB
Package_pkey 104 KB
Participant 104 KB
PatientToken 104 KB
PlatformAdminLog_createdAt_idx UNUSED 104 KB
PlatformAdminLog_pkey 104 KB
ShareLink 104 KB
TelemedicineUsageLog_clinicDomain_createdAt_idx UNUSED 104 KB
TelemedicineUsageLog_clinicDomain_eventType_createdAt_idx UNUSED 104 KB
_BranchToPackage 104 KB
_ParticipantToRoom 104 KB
_currentMedicationsHistoryToPatientProfile_AB_pkey 104 KB
_familyHistoryToPatientProfile_B_index 104 KB
AiCreditRoomUsage_clinicDomain_roomId_day_key 96 KB
Consumable_isStockTracked_idx 96 KB
PaymentManagerCommission_paymentTransactionId_idx 96 KB
PerformanceReview 96 KB
Request_patientId_seenAt_idx 96 KB
TelemedicineRoom 96 KB
_BranchToPackage_AB_pkey 96 KB
_habitsToPatientProfile_AB_pkey 96 KB
ExaminationPricePerDoctor_examinationId_doctorId_key 88 KB
ExtraField 88 KB
Folliculometry 88 KB
Order_cashDrawerSessionId_idx UNUSED 88 KB
OvulationCycle 88 KB
Request_pkey 88 KB
Room_clinicDomain_slug_key 88 KB
VacationBalance 88 KB
VariableProperty_clinicDomain_name_key 88 KB
_BranchToUser_AB_pkey 88 KB
AiCreditBalance 80 KB
AttendanceAlert 80 KB
DietDay_dietId_order_idx 80 KB
DietDay_pkey 80 KB
Form 80 KB
ObstetricsProfile_pkey 80 KB
OphthalmologyProfile 80 KB
PatientInsurance 80 KB
ShareLink_link_clinicDomain_key 80 KB
UniqueTextSettings 80 KB
_ExtraFieldToUniqueText 80 KB
_ExtraFieldToUniqueText_AB_pkey 80 KB
_currentMedicationsHistoryToPatientProfile_B_index 80 KB
Branch_clinicDomain_branchNumber_key 72 KB
ClinicInvoiceItem 72 KB
ClinicSubscription 72 KB
Goal 72 KB
Partition 72 KB
PatientWallet_patientId_clinicDomain_key 72 KB
PlatformAdminLog_type_idx UNUSED 72 KB
PlatformAdminLog_userId_idx UNUSED 72 KB
PriceList 72 KB
ScheduleBlock 72 KB
Update 72 KB
User_pkey 72 KB
AiModel 64 KB
DietDayBlockMeal 64 KB
GlassExamination_pkey 64 KB
InsuranceCompany 64 KB
LoyaltyRule 64 KB
MessageReaction_messageId_userId_reaction_key 64 KB
OnboardingExperienceEvent 64 KB
OphthalmologySessionDetails_glassExaminationId_key 64 KB
OphthalmologySessionDetails_pkey 64 KB
OphthalmologySessionDetails_sessionId_key 64 KB
OphthalmologySessionDetails_siteLampId_key 64 KB
Participant_pkey 64 KB
Participant_userId_key 64 KB
PlatformAdminLog_clinicDomain_idx UNUSED 64 KB
SiteLamp_pkey 64 KB
TreatmentPlanSettings 64 KB
Vacation 64 KB
VeterinaryProfile 64 KB
_BranchToPackage_B_index 64 KB
_BranchToUser_B_index 64 KB
_ParticipantToRoom_AB_pkey 64 KB
_allergiesHistoryToPatientProfile_AB_pkey 64 KB
_habitsToPatientProfile_B_index 64 KB
AiModelSyncLog 56 KB
CheckProperty 56 KB
ChecklistStepHistory_pkey 56 KB
ClinicFeatures_clinicDomain_key 56 KB
Clinic_domain_key 56 KB
DietDayBlock 56 KB
DietFood_name_quantity_clinicDomain_key 56 KB
Note_pkey 56 KB
PatientProfileSettings_clinicDomain_key 56 KB
PatientToken_token_key 56 KB
PaymentManagerCommission_bulkExpenseId_idx 56 KB
PediatricsProfile 56 KB
PlatformAdminLog_operationType_idx UNUSED 56 KB
ProgramItem 56 KB
PushSubscription_pkey 56 KB
SalesDailyReport 56 KB
SessionRequestSettings_clinicDomain_key 56 KB
SessionSettings_clinicDomain_key 56 KB
Shift 56 KB
TelemedicineConsent 56 KB
VacationBalance_userId_year_clinicDomain_key 56 KB
WalletTransaction_createdAt_idx 56 KB
WalletTransaction_pkey 56 KB
_allergiesHistoryToPatientProfile_B_index 56 KB
Accommodation 48 KB
AnalysisUnit 48 KB
Bed 48 KB
ClinicActivity 48 KB
CosmeticSession 48 KB
GrowthMeasurement 48 KB
InsuranceConfirmation 48 KB
InsurancePolicy 48 KB
InsurancePolicyClass 48 KB
MedicalOrder 48 KB
MessageReaction_pkey 48 KB
NamedPriceList 48 KB
NamedPriceListItem 48 KB
NurseCarePlanItem 48 KB
NurseTaskHistory 48 KB
Objective 48 KB
OnboardingEvent 48 KB
OphthalmologyProfile_patientProfileId_key 48 KB
OphthalmologyProfile_pkey 48 KB
PatientPaymentSubmission 48 KB
PatientUser 48 KB
PayrollPeriod 48 KB
ReferenceValue 48 KB
ReferralDoctor_pkey 48 KB
ScheduleBlock_clinicDomain_branchId_from_to_idx 48 KB
Tag_pkey 48 KB
TelemedicineMinuteBalance 48 KB
TreasuryPosition 48 KB
UniqueTextSettings_clinicDomain_type_key 48 KB
WalletTransaction_paymentTransactionId_key 48 KB
_CustomRoleToUser 48 KB
_ExtraFieldToUniqueText_B_index 48 KB
_FileTags 48 KB
_ParticipantToRoom_B_index 48 KB
_ShiftToUser 48 KB
_TreasuryToUser 48 KB
AiCreditBalance_clinicDomain_key 40 KB
AiCreditRoomUsage_clinicDomain_day_idx UNUSED 40 KB
AnalysisTemplateUnit 40 KB
ClinicFeatures_pkey 40 KB
ClinicInvoiceInstallment_invoiceId_seq_key 40 KB
ClinicInvoiceInstallment_pkey 40 KB
ClinicInvoiceInstallment_status_dueDate_idx 40 KB
ClinicInvoice_pkey 40 KB
Clinic_currentClinicInvoiceId_key 40 KB
DietDayBlockMeal_dayBlockId_mealBlockId_order_key 40 KB
DietMealBlockItem_blockId_order_idx 40 KB
Diet_pkey 40 KB
Form_name_clinicDomain_key 40 KB
InsuranceCompany_clinicDomain_name_key 40 KB
LoyaltyRule_clinicDomain_key 40 KB
OnboardingExperienceEvent_sessionKey_createdAt_idx UNUSED 40 KB
OnboardingTask_projectId_templateKey_key 40 KB
PackageSubscriptionUnit 40 KB
Partition_clinicDomain_name_key 40 KB
PatientInsurance_patientId_startDate_endDate_idx 40 KB
PatientJourney_patientProfileId_clinicDomain_idx 40 KB
PatientWallet_patientUserId_clinicDomain_key 40 KB
RecurringExpense_pkey 40 KB
ShareLink_patientId_formId_sessionId_key 40 KB
SiteLamp_ophthalmologyProfileId_key 40 KB
SupportTicket_pkey 40 KB
TelemedicineUsageLog_clinicDomain_eventType_providerEventId_key 40 KB
TelemedicineUsageLog_pkey 40 KB
Treasury_pkey 40 KB
TreatmentPlan_pkey 40 KB
WalletTransaction_closingShiftId_idx 40 KB
WalletTransaction_exchangeRateId_idx UNUSED 40 KB
WalletTransaction_loyaltyTransactionId_key 40 KB
WalletTransaction_treasuryTransactionId_key 40 KB
WalletTransaction_walletId_idx 40 KB
_BranchToTreasury 40 KB
AiCreditRoomUsage_pkey 32 KB
Branch_pkey 32 KB
CheckProperty_clinicDomain_name_key 32 KB
Clinic_pkey 32 KB
DietDayBlockMeal_dayBlockId_order_idx UNUSED 32 KB
DietMealBlockItem_pkey 32 KB
Folliculometry_pkey 32 KB
FormSection_pkey 32 KB
NurseTask_pkey 32 KB
OvulationCycle_gynecologyProfileId_idx 32 KB
OvulationCycle_pkey 32 KB
PatientInsurance_latestVerificationId_key 32 KB
PatientInsurance_patientId_insurancePolicyClassId_idx 32 KB
PatientInsurance_pkey 32 KB
PatientProfileSettings_pkey 32 KB
PatientWallet_pkey 32 KB
Payslip_pkey 32 KB
Room_pkey 32 KB
ScheduleBlock_doctorId_from_idx UNUSED 32 KB
SessionRequestSettings_bookingLinkId_key 32 KB
SessionRequestSettings_pkey 32 KB
SessionSettings_pkey 32 KB
ShareLink_pkey 32 KB
Template_pkey 32 KB
VacationBalance_clinicDomain_idx 32 KB
VariableProperty_pkey 32 KB
WalletTransaction_branchId_idx 32 KB
_FileTags_AB_pkey 32 KB
WebSession 24 KB
AccommodationService 16 KB
AccommodationServiceUnit_pkey 16 KB
AccommodationService_pkey 16 KB
Accommodation_bedId_startDate_endDate_idx UNUSED 16 KB
Accommodation_clinicDomain_bedId_idx UNUSED 16 KB
Accommodation_clinicDomain_patientProfileId_idx UNUSED 16 KB
Accommodation_clinicDomain_status_idx UNUSED 16 KB
Accommodation_pkey 16 KB
AccountantSettings 16 KB
AccountantSettings_clinicDomain_key 16 KB
AccountantSettings_pkey 16 KB
Addon 16 KB
Addon_key_key 16 KB
Addon_pkey 16 KB
AdvanceRequest 16 KB
AdvanceRequest_clinicDomain_status_idx 16 KB
AdvanceRequest_earningId_key 16 KB
AdvanceRequest_pkey 16 KB
AdvanceRequest_userId_idx 16 KB
AiCreditBalance_pkey 16 KB
AiCreditPackage 16 KB
AiCreditPackage_pkey 16 KB
AiFeatureSetting 16 KB
AiFeatureSetting_clinicDomain_feature_key 16 KB
AiFeatureSetting_pkey 16 KB
AiModelSyncLog_pkey 16 KB
AiModelSyncLog_runAt_idx UNUSED 16 KB
AiModel_name_key 16 KB
AiModel_pkey 16 KB
AnalysisResult_medicalOrderId_idx UNUSED 16 KB
AnalysisResult_patientProfileId_createdAt_idx UNUSED 16 KB
AnalysisResult_pkey 16 KB
AnalysisTemplate 16 KB
AnalysisTemplateUnit_pkey 16 KB
AnalysisTemplate_pkey 16 KB
AnalysisUnitResult 16 KB
AnalysisUnitResult_pkey 16 KB
AnalysisUnit_pkey 16 KB
AnalysisUnit_sourceCatalogSlug_clinicDomain_key 16 KB
AttendanceAlert_clinicDomain_createdAt_idx UNUSED 16 KB
AttendanceAlert_pkey 16 KB
AttendanceAlert_userId_alertDate_kind_key 16 KB
AttendanceSettings 16 KB
AttendanceSettings_clinicDomain_key 16 KB
AttendanceSettings_pkey 16 KB
Bed_number_clinicDomain_sectionId_key 16 KB
Bed_pkey 16 KB
BiometricDevice 16 KB
BiometricDevice_clinicDomain_isActive_idx UNUSED 16 KB
BiometricDevice_clinicDomain_serialNumber_key 16 KB
BiometricDevice_pkey 16 KB
BookingLink 16 KB
BookingLink_clinicDomain_isActive_createdAt_idx UNUSED 16 KB
BookingLink_clinicDomain_slug_key 16 KB
BookingLink_code_key 16 KB
BookingLink_pkey 16 KB
BranchPublicProfile 16 KB
BranchPublicProfile_branchId_key 16 KB
BranchPublicProfile_clinicDomain_idx UNUSED 16 KB
BranchPublicProfile_pkey 16 KB
CheckPropertyValue_pkey 16 KB
CheckPropertyValue_propertyId_patientProfileId_key 16 KB
CheckProperty_pkey 16 KB
ClinicActivity_authorId_idx UNUSED 16 KB
ClinicActivity_clinicDomain_createdAt_idx UNUSED 16 KB
ClinicActivity_onboardingProjectId_createdAt_idx UNUSED 16 KB
ClinicActivity_onboardingProjectId_onboardingEntityType_onb_idx UNUSED 16 KB
ClinicActivity_pkey 16 KB
ClinicContact 16 KB
ClinicContact_clinicDomain_idx 16 KB
ClinicContact_pkey 16 KB
ClinicContract 16 KB
ClinicContract_clinicDomain_idx 16 KB
ClinicContract_pkey 16 KB
ClinicContract_subscriptionId_idx UNUSED 16 KB
ClinicInvoiceItem_pkey 16 KB
ClinicInvoiceRefund 16 KB
ClinicInvoiceRefund_installmentId_idx 16 KB
ClinicInvoiceRefund_invoiceId_idx 16 KB
ClinicInvoiceRefund_pkey 16 KB
ClinicInvoiceRefund_refundedAt_idx 16 KB
ClinicPublicProfile_clinicDomain_key 16 KB
ClinicPublicProfile_pkey 16 KB
ClinicPublicProfile_slug_key 16 KB
ClinicSequence 16 KB
ClinicSequence_clinicDomain_key_key 16 KB
ClinicSequence_pkey 16 KB
ClinicSubscriptionAddon_pkey 16 KB
ClinicSubscriptionAddon_subscriptionId_addonId_key 16 KB
ClinicSubscription_clinicId_key 16 KB
ClinicSubscription_pkey 16 KB
ClinicSubscription_status_currentPeriodEnd_idx 16 KB
Comment 16 KB
Comment_pkey 16 KB
Contraception 16 KB
Contraception_pkey 16 KB
Cornea 16 KB
Cornea_pkey 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
DietDayBlockMeal_pkey 16 KB
DietDayBlock_clinicDomain_isActive_idx UNUSED 16 KB
DietDayBlock_clinicDomain_totalCalories_idx UNUSED 16 KB
DietDayBlock_clinicDomain_usageCount_idx UNUSED 16 KB
DietDayBlock_pkey 16 KB
DietFood_clinicDomain_isActive_idx 16 KB
DietFood_clinicDomain_usageCount_idx 16 KB
DietFood_pkey 16 KB
DietMealBlock_clinicDomain_isActive_idx 16 KB
DietMealBlock_clinicDomain_totalCalories_idx UNUSED 16 KB
DietMealBlock_clinicDomain_usageCount_idx 16 KB
DietMealBlock_pkey 16 KB
DietOutputSettings 16 KB
DietOutputSettings_clinicDomain_key 16 KB
DietOutputSettings_pkey 16 KB
DietTag 16 KB
DietTag_clinicDomain_type_isActive_idx 16 KB
DietTag_name_type_clinicDomain_key 16 KB
DietTag_pkey 16 KB
Diet_clinicDomain_isTemplate_isActive_idx 16 KB
DoctorPublicProfile_clinicDomain_idx UNUSED 16 KB
DoctorPublicProfile_doctorId_key 16 KB
DoctorPublicProfile_pkey 16 KB
DoctorPublicProfile_slug_key 16 KB
DrugForm 16 KB
DrugForm_code_key 16 KB
DrugForm_pkey 16 KB
DrugRoute 16 KB
DrugRoute_code_key 16 KB
DrugRoute_pkey 16 KB
EmployeeContract 16 KB
EmployeeContract_clinicDomain_contractNumber_key 16 KB
EmployeeContract_clinicDomain_idx UNUSED 16 KB
EmployeeContract_clinicDomain_status_endDate_idx UNUSED 16 KB
EmployeeContract_pkey 16 KB
EmployeeContract_renewedFromId_key 16 KB
EmployeeContract_userId_idx UNUSED 16 KB
EmployeeDeduction 16 KB
EmployeeDeduction_clinicDomain_status_idx 16 KB
EmployeeDeduction_clinicDomain_userId_dueMonth_idx 16 KB
EmployeeDeduction_earningId_key 16 KB
EmployeeDeduction_pkey 16 KB
EmployeeDeduction_violationId_key 16 KB
EmployeeDocument 16 KB
EmployeeDocument_clinicDomain_idx UNUSED 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
EmployeeOnboarding 16 KB
EmployeeOnboardingTask 16 KB
EmployeeOnboardingTask_onboardingId_order_idx 16 KB
EmployeeOnboardingTask_pkey 16 KB
EmployeeOnboardingTemplate 16 KB
EmployeeOnboardingTemplateItem 16 KB
EmployeeOnboardingTemplateItem_pkey 16 KB
EmployeeOnboardingTemplateItem_templateId_order_idx 16 KB
EmployeeOnboardingTemplate_clinicDomain_name_key 16 KB
EmployeeOnboardingTemplate_pkey 16 KB
EmployeeOnboarding_clinicDomain_status_idx 16 KB
EmployeeOnboarding_pkey 16 KB
EmployeeOnboarding_userId_key 16 KB
EmployeeShiftAssignment 16 KB
EmployeeShiftAssignment_clinicDomain_userId_startDate_idx 16 KB
EmployeeShiftAssignment_pkey 16 KB
EmployeeShiftAssignment_shiftId_idx 16 KB
EmployeeViolation 16 KB
EmployeeViolationHistory 16 KB
EmployeeViolationHistory_pkey 16 KB
EmployeeViolationHistory_violationId_changedAt_idx UNUSED 16 KB
EmployeeViolation_clinicDomain_caseNumber_key 16 KB
EmployeeViolation_clinicDomain_status_idx UNUSED 16 KB
EmployeeViolation_clinicDomain_userId_idx UNUSED 16 KB
EmployeeViolation_pkey 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_clinicDomain_idx UNUSED 16 KB
FeatureRequest_pkey 16 KB
FeedingAssessment 16 KB
FeedingAssessment_growthVisitId_key 16 KB
FeedingAssessment_pkey 16 KB
FileFavorite_fileId_userId_key 16 KB
FileFavorite_pkey 16 KB
FileFavorite_userId_createdAt_idx UNUSED 16 KB
FileVersion 16 KB
FileVersion_fileId_createdAt_idx UNUSED 16 KB
FileVersion_fileId_versionNumber_key 16 KB
FileVersion_pkey 16 KB
Folliculometry_ovulationCycleId_idx 16 KB
Form_pkey 16 KB
GiftCard 16 KB
GiftCard_clinicDomain_status_idx UNUSED 16 KB
GiftCard_codeHash_key 16 KB
GiftCard_issuedForReturnId_idx UNUSED 16 KB
GiftCard_pkey 16 KB
Goal_pkey 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_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_nphiesPayerDirectoryId_idx UNUSED 16 KB
InsuranceCompany_pkey 16 KB
InsuranceConfirmation_invoiceUnitId_key 16 KB
InsuranceConfirmation_nphiesAuthorizationId_idx UNUSED 16 KB
InsuranceConfirmation_pkey 16 KB
InsurancePolicyClass_insurancePolicyId_className_key 16 KB
InsurancePolicyClass_pkey 16 KB
InsurancePolicy_pkey 16 KB
InsurancePolicy_policyHolderOrganizationId_idx UNUSED 16 KB
InsurancePolicy_policyNumber_key 16 KB
IntakeFormBinding 16 KB
IntakeFormBinding_clinicDomain_isActive_idx 16 KB
IntakeFormBinding_formId_idx UNUSED 16 KB
IntakeFormBinding_pkey 16 KB
LabReflexRule 16 KB
LabReflexRule_clinicDomain_enabled_ifUnitId_idx UNUSED 16 KB
LabReflexRule_clinicDomain_ifUnitId_thenAddUnitId_key 16 KB
LabReflexRule_pkey 16 KB
LabTestItem 16 KB
LabTestItem_analysisUnitId_idx UNUSED 16 KB
LabTestItem_analysisUnitResultId_key 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
LoyaltyExaminationRule_examinationId_loyaltyRuleId_key 16 KB
LoyaltyExaminationRule_pkey 16 KB
LoyaltyFormRule_formId_loyaltyRuleId_key 16 KB
LoyaltyFormRule_pkey 16 KB
LoyaltyPackageRule_packageId_loyaltyRuleId_key 16 KB
LoyaltyPackageRule_pkey 16 KB
LoyaltyRedemption_appliedToInvoiceId_idx 16 KB
LoyaltyRedemption_pkey 16 KB
LoyaltyReward 16 KB
LoyaltyReward_pkey 16 KB
LoyaltyRule_pkey 16 KB
LoyaltyTierBenefit 16 KB
LoyaltyTierBenefit_loyaltyRuleId_tier_idx UNUSED 16 KB
LoyaltyTierBenefit_pkey 16 KB
MedicalOrderStatusHistory 16 KB
MedicalOrderStatusHistory_pkey 16 KB
MedicalOrder_assignedToId_status_idx UNUSED 16 KB
MedicalOrder_clinicDomain_fulfillment_status_idx UNUSED 16 KB
MedicalOrder_clinicDomain_hasCritical_criticalAcknowledgedA_idx UNUSED 16 KB
MedicalOrder_clinicDomain_orderNumber_key 16 KB
MedicalOrder_clinicDomain_status_idx UNUSED 16 KB
MedicalOrder_doctorId_idx UNUSED 16 KB
MedicalOrder_expenseId_key 16 KB
MedicalOrder_fulfillmentTokenHash_key 16 KB
MedicalOrder_invoiceUnitId_key 16 KB
MedicalOrder_patientProfileId_idx UNUSED 16 KB
MedicalOrder_pkey 16 KB
MedicalOrder_reflexParentOrderId_idx UNUSED 16 KB
MedicalOrder_requestedDate_idx UNUSED 16 KB
MedicalReport_pkey 16 KB
MessageAttachment 16 KB
MessageAttachment_pkey 16 KB
NamedPriceListItem_namedPriceListId_examinationId_key 16 KB
NamedPriceListItem_namedPriceListId_packageId_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
NurseCarePlan 16 KB
NurseCarePlanItem_carePlanId_idx UNUSED 16 KB
NurseCarePlanItem_pkey 16 KB
NurseCarePlanTemplate 16 KB
NurseCarePlanTemplateItem 16 KB
NurseCarePlanTemplateItem_pkey 16 KB
NurseCarePlanTemplateItem_templateId_idx 16 KB
NurseCarePlanTemplate_clinicDomain_isActive_idx UNUSED 16 KB
NurseCarePlanTemplate_clinicDomain_sectionId_idx 16 KB
NurseCarePlanTemplate_pkey 16 KB
NurseCarePlan_clinicDomain_accommodationId_status_idx 16 KB
NurseCarePlan_clinicDomain_patientProfileId_idx UNUSED 16 KB
NurseCarePlan_pkey 16 KB
NurseTaskHistory_pkey 16 KB
NurseTaskHistory_taskId_idx UNUSED 16 KB
NurseTask_clinicDomain_patientProfileId_idx 16 KB
Objective_goalId_idx 16 KB
Objective_pkey 16 KB
OnboardingConfigurationSnapshot_checksum_idx UNUSED 16 KB
OnboardingConfigurationSnapshot_pkey 16 KB
OnboardingConfigurationSnapshot_projectId_createdAt_idx 16 KB
OnboardingEvent_pkey 16 KB
OnboardingEvent_projectId_createdAt_idx UNUSED 16 KB
OnboardingEvent_projectId_isOverride_idx 16 KB
OnboardingEvent_projectId_type_idx UNUSED 16 KB
OnboardingEvidence 16 KB
OnboardingEvidence_pkey 16 KB
OnboardingEvidence_projectId_entityType_entityId_idx 16 KB
OnboardingExperienceEvent_createdAt_idx 16 KB
OnboardingExperienceEvent_eventType_createdAt_idx UNUSED 16 KB
OnboardingExperienceEvent_pkey 16 KB
OnboardingExperienceEvent_projectId_createdAt_idx UNUSED 16 KB
OnboardingExperienceEvent_userId_createdAt_idx 16 KB
OnboardingMetricCheckpoint 16 KB
OnboardingMetricCheckpoint_pkey 16 KB
OnboardingMetricCheckpoint_projectId_kind_key 16 KB
OnboardingProject 16 KB
OnboardingProject_clinicId_key 16 KB
OnboardingProject_engineerId_idx UNUSED 16 KB
OnboardingProject_health_targetGoLiveAt_idx UNUSED 16 KB
OnboardingProject_onboardingManagerId_idx UNUSED 16 KB
OnboardingProject_pkey 16 KB
OnboardingProject_status_stage_idx 16 KB
OnboardingReadinessCheck 16 KB
OnboardingReadinessCheck_pkey 16 KB
OnboardingReadinessCheck_runId_key_key 16 KB
OnboardingReadinessRun_pkey 16 KB
OnboardingReadinessRun_projectId_createdAt_idx 16 KB
OnboardingScopeRevision 16 KB
OnboardingScopeRevision_pkey 16 KB
OnboardingScopeRevision_projectId_createdAt_idx UNUSED 16 KB
OnboardingScopeRevision_projectId_version_key 16 KB
OnboardingTask_ownerId_dueAt_idx 16 KB
OnboardingTask_pkey 16 KB
OnboardingTask_projectId_category_status_idx 16 KB
OnboardingTrainingAssignment 16 KB
OnboardingTrainingAssignment_pkey 16 KB
OnboardingTrainingAssignment_projectId_status_idx 16 KB
OnboardingTrainingAssignment_targetUserId_idx UNUSED 16 KB
OperationDetails_clinicDomain_hospitalName_idx 16 KB
OperationDetails_clinicDomain_status_idx 16 KB
OperationDetails_pkey 16 KB
OperationDetails_sessionId_key 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
PackageSubscriptionUnit_packageSubscriptionId_examinationId_key 16 KB
PackageSubscriptionUnit_pkey 16 KB
Partition_pkey 16 KB
PatientAppSettings 16 KB
PatientAppSettings_bundleId_key 16 KB
PatientAppSettings_clinicDomain_key 16 KB
PatientAppSettings_pkey 16 KB
PatientJourney_patientProfileId_status_idx 16 KB
PatientJourney_pkey 16 KB
PatientPaymentMethodConfig 16 KB
PatientPaymentMethodConfig_clinicDomain_enabled_idx UNUSED 16 KB
PatientPaymentMethodConfig_clinicDomain_method_key 16 KB
PatientPaymentMethodConfig_pkey 16 KB
PatientPaymentSubmission_clinicDomain_status_createdAt_idx UNUSED 16 KB
PatientPaymentSubmission_invoiceId_status_idx 16 KB
PatientPaymentSubmission_patientProfileId_status_idx UNUSED 16 KB
PatientPaymentSubmission_paymentTransactionId_key 16 KB
PatientPaymentSubmission_pkey 16 KB
PatientPaymentSubmission_providerPaymentId_key 16 KB
PatientPaymentSubmission_sessionId_status_idx UNUSED 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
PatientUser_deletedAt_idx UNUSED 16 KB
PatientUser_phone_phoneCode_key 16 KB
PatientUser_pkey 16 KB
PatientUser_registeredClinicDomain_idx 16 KB
PatientWallet_clinicDomain_idx 16 KB
PaymentIntent 16 KB
PaymentIntent_clinicDomain_status_createdAt_idx UNUSED 16 KB
PaymentIntent_invoiceId_idx UNUSED 16 KB
PaymentIntent_orderId_idx UNUSED 16 KB
PaymentIntent_packageId_idx UNUSED 16 KB
PaymentIntent_packageSubscriptionId_idx UNUSED 16 KB
PaymentIntent_paymentLinkId_idx UNUSED 16 KB
PaymentIntent_pkey 16 KB
PaymentIntent_providerReference_key 16 KB
PaymentIntent_sessionRequestId_idx UNUSED 16 KB
PaymentIntent_treasuryId_idx UNUSED 16 KB
PaymentLink 16 KB
PaymentLink_clinicDomain_status_createdAt_idx 16 KB
PaymentLink_code_key 16 KB
PaymentLink_invoiceId_idx UNUSED 16 KB
PaymentLink_pkey 16 KB
PaymentWebhookEvent 16 KB
PaymentWebhookEvent_clinicDomain_createdAt_idx 16 KB
PaymentWebhookEvent_pkey 16 KB
PaymentWebhookEvent_providerEventId_idx UNUSED 16 KB
PayrollPeriod_clinicDomain_startDate_endDate_key 16 KB
PayrollPeriod_pkey 16 KB
Payslip_expenseId_key 16 KB
Payslip_periodId_userId_key 16 KB
Payslip_userId_idx 16 KB
PediatricsProfile_patientProfileId_key 16 KB
PediatricsProfile_pkey 16 KB
PelvisUltraSound 16 KB
PelvisUltraSound_pkey 16 KB
PerformanceCycle 16 KB
PerformanceCycle_clinicDomain_name_key 16 KB
PerformanceCycle_clinicDomain_status_idx UNUSED 16 KB
PerformanceCycle_pkey 16 KB
PerformanceReview_bonusEarningId_key 16 KB
PerformanceReview_clinicDomain_status_idx 16 KB
PerformanceReview_cycleId_userId_key 16 KB
PerformanceReview_pkey 16 KB
PerformanceReview_userId_idx UNUSED 16 KB
PermissionRequest 16 KB
PermissionRequest_clinicDomain_status_idx 16 KB
PermissionRequest_pkey 16 KB
PermissionRequest_userId_date_idx 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
Plan 16 KB
Plan_key_key 16 KB
Plan_organizationType_isActive_idx UNUSED 16 KB
Plan_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
ProgramItem_pkey 16 KB
ProgramItem_treatmentPlanId_order_idx UNUSED 16 KB
ProgressLog 16 KB
ProgressLog_objectiveId_loggedAt_idx 16 KB
ProgressLog_pkey 16 KB
ProgressLog_treatmentPlanId_loggedAt_idx 16 KB
RecurringExpense_treasuryId_idx UNUSED 16 KB
ReferenceValue_pkey 16 KB
Retina 16 KB
Retina_pkey 16 KB
SalesDailyReport_clinicDomain_day_idx UNUSED 16 KB
SalesDailyReport_clinicDomain_day_key 16 KB
SalesDailyReport_pkey 16 KB
SalesReviewRun 16 KB
SalesReviewRun_clinicDomain_day_idx UNUSED 16 KB
SalesReviewRun_clinicDomain_day_trigger_key 16 KB
SalesReviewRun_pkey 16 KB
SalesReviewSetting 16 KB
SalesReviewSetting_clinicDomain_key 16 KB
SalesReviewSetting_enabled_idx UNUSED 16 KB
SalesReviewSetting_pkey 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
Squint 16 KB
SquintItem 16 KB
SquintItem_pkey 16 KB
Squint_pkey 16 KB
SupportTicket_onboardingProjectId_onboardingCategory_idx 16 KB
TelemedicineConsent_clinicDomain_sessionId_idx 16 KB
TelemedicineConsent_pkey 16 KB
TelemedicineConsent_sessionId_patientProfileId_textVersion_key 16 KB
TelemedicineFollowUpDraft 16 KB
TelemedicineFollowUpDraft_clinicDomain_sessionId_idx 16 KB
TelemedicineFollowUpDraft_pkey 16 KB
TelemedicineFollowUpDraft_sessionId_key 16 KB
TelemedicineMinuteBalance_clinicDomain_key 16 KB
TelemedicineMinuteBalance_pkey 16 KB
TelemedicineMinuteCostConfig_pkey 16 KB
TelemedicineRecording 16 KB
TelemedicineRecording_clinicDomain_sessionId_idx 16 KB
TelemedicineRecording_pkey 16 KB
TelemedicineRecording_providerRecordingId_idx UNUSED 16 KB
TelemedicineRecording_telemedicineRoomId_status_idx UNUSED 16 KB
TelemedicineRoom_clinicDomain_status_idx 16 KB
TelemedicineRoom_pkey 16 KB
TelemedicineRoom_provider_providerRoomName_key 16 KB
TelemedicineRoom_sessionId_key 16 KB
TelemedicineRoom_sessionId_status_idx UNUSED 16 KB
TelemedicineTranscript 16 KB
TelemedicineTranscript_clinicDomain_patientProfileId_idx UNUSED 16 KB
TelemedicineTranscript_clinicDomain_sessionId_idx UNUSED 16 KB
TelemedicineTranscript_clinicDomain_status_idx UNUSED 16 KB
TelemedicineTranscript_pkey 16 KB
TelemedicineTranscript_recordingId_key 16 KB
TelemedicineUsageLog_sessionId_idx 16 KB
TreasuryPosition_currency_idx UNUSED 16 KB
TreasuryPosition_pkey 16 KB
TreasuryPosition_treasuryId_currency_key 16 KB
TreatmentPlanSettings_clinicDomain_key 16 KB
TreatmentPlanSettings_pkey 16 KB
UniqueTextSettings_pkey 16 KB
Update_pkey 16 KB
VacationBalance_pkey 16 KB
VacationHistory 16 KB
VacationHistory_pkey 16 KB
VacationHistory_vacationId_idx UNUSED 16 KB
Vacation_clinicDomain_idx UNUSED 16 KB
Vacation_directManagerId_idx UNUSED 16 KB
Vacation_pkey 16 KB
Vacation_status_idx UNUSED 16 KB
Vacation_userId_idx UNUSED 16 KB
VaccinationStatus 16 KB
VaccinationStatus_growthVisitId_key 16 KB
VaccinationStatus_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
VisitSummary 16 KB
VisitSummary_clinicDomain_patientProfileId_status_idx 16 KB
VisitSummary_clinicDomain_sessionId_idx 16 KB
VisitSummary_pkey 16 KB
Vote_pkey 16 KB
Vote_userId_featureRequestId_key 16 KB
WorkShift 16 KB
WorkShift_clinicDomain_isActive_idx UNUSED 16 KB
WorkShift_clinicDomain_name_key 16 KB
WorkShift_clinicDomain_sectionId_isDefaultForSection_idx UNUSED 16 KB
WorkShift_pkey 16 KB
WorkShift_ramadanShiftId_key 16 KB
_BranchToTreasury_AB_pkey 16 KB
_BranchToTreasury_B_index 16 KB
_CustomRoleToUser_AB_pkey 16 KB
_CustomRoleToUser_B_index UNUSED 16 KB
_DietDayBlockToDietTag 16 KB
_DietDayBlockToDietTag_AB_pkey 16 KB
_DietDayBlockToDietTag_B_index 16 KB
_DietFoodToDietTag 16 KB
_DietFoodToDietTag_AB_pkey 16 KB
_DietFoodToDietTag_B_index 16 KB
_DietMealBlockToDietTag 16 KB
_DietMealBlockToDietTag_AB_pkey 16 KB
_DietMealBlockToDietTag_B_index 16 KB
_FileTags_B_index 16 KB
_NamedPriceListBranches_AB_pkey 16 KB
_NamedPriceListBranches_B_index 16 KB
_ShiftToUser_AB_pkey 16 KB
_ShiftToUser_B_index 16 KB
_TreasuryToUser_AB_pkey 16 KB
_TreasuryToUser_B_index 16 KB
AccommodationServiceUnit 8 KB
AnalysisResult 8 KB
BiometricPunch 8 KB
BiometricPunch_clinicDomain_punchAt_idx 8 KB
BiometricPunch_deviceId_deviceUserId_punchAt_direction_key 8 KB
BiometricPunch_pkey 8 KB
BiometricPunch_userId_punchAt_idx UNUSED 8 KB
BookingLinkEventDailyRollup 8 KB
BookingLinkEventDailyRollup_clinicDomain_day_bookingLinkId__idx 8 KB
BookingLinkEventDailyRollup_pkey 8 KB
CashDrawerSession 8 KB
CashDrawerSession_clinicDomain_branchId_status_idx UNUSED 8 KB
CashDrawerSession_pkey 8 KB
CashDrawerSession_shiftId_idx UNUSED 8 KB
CheckPropertyValue 8 KB
ClinicActivityAttachment 8 KB
ClinicActivityAttachment_activityId_idx 8 KB
ClinicActivityAttachment_pkey 8 KB
ClinicActivityMention_activityId_userId_key 8 KB
ClinicActivityMention_pkey 8 KB
ClinicActivityMention_userId_readAt_idx UNUSED 8 KB
ClinicActivityRevision 8 KB
ClinicActivityRevision_activityId_createdAt_idx UNUSED 8 KB
ClinicActivityRevision_pkey 8 KB
ClinicCurrencyConfig 8 KB
ClinicCurrencyConfig_clinicDomain_currency_key 8 KB
ClinicCurrencyConfig_clinicDomain_idx UNUSED 8 KB
ClinicCurrencyConfig_pkey 8 KB
ClinicFormularyItem 8 KB
ClinicFormularyItem_clinicDomain_drugId_key 8 KB
ClinicFormularyItem_clinicDomain_isStocked_idx UNUSED 8 KB
ClinicFormularyItem_pkey 8 KB
ClinicFormularyItem_productId_idx UNUSED 8 KB
ClinicRatingHistory 8 KB
ClinicRatingHistory_clinicDomain_kind_createdAt_idx 8 KB
ClinicRatingHistory_pkey 8 KB
ClinicSubscriptionAddon 8 KB
ClinicalCode 8 KB
ClinicalCodeSystem 8 KB
ClinicalCodeSystem_kind_key 8 KB
ClinicalCodeSystem_pkey 8 KB
ClinicalCode_code_idx UNUSED 8 KB
ClinicalCode_pkey 8 KB
ClinicalCode_systemId_code_key 8 KB
ClinicalCode_systemId_isActive_idx UNUSED 8 KB
ControlledSubstanceEntry 8 KB
ControlledSubstanceEntry_clinicDomain_branchId_drugId_creat_idx UNUSED 8 KB
ControlledSubstanceEntry_clinicDomain_branchId_registerBook_idx UNUSED 8 KB
ControlledSubstanceEntry_clinicDomain_branchId_registerBook_key 8 KB
ControlledSubstanceEntry_dispenseOrderId_idx UNUSED 8 KB
ControlledSubstanceEntry_drugId_idx UNUSED 8 KB
ControlledSubstanceEntry_hash_key 8 KB
ControlledSubstanceEntry_pkey 8 KB
ControlledSubstanceEntry_productId_idx UNUSED 8 KB
ControlledSubstanceEntry_reversesId_key 8 KB
CoverageVerification 8 KB
CoverageVerification_patientInsuranceId_purpose_serviceDate_idx UNUSED 8 KB
CoverageVerification_patientInsuranceId_verifiedAt_idx UNUSED 8 KB
CoverageVerification_pkey 8 KB
DemoRequest 8 KB
DemoRequestNote 8 KB
DemoRequestNote_demoRequestId_createdAt_idx UNUSED 8 KB
DemoRequestNote_pkey 8 KB
DemoRequestRateBucket 8 KB
DemoRequestRateBucket_expiresAt_idx UNUSED 8 KB
DemoRequestRateBucket_pkey 8 KB
DemoRequest_createdAt_id_idx 8 KB
DemoRequest_idempotencyKey_key 8 KB
DemoRequest_market_status_createdAt_idx UNUSED 8 KB
DemoRequest_pkey 8 KB
DevelopmentalExam 8 KB
DevelopmentalExam_growthVisitId_key 8 KB
DevelopmentalExam_pkey 8 KB
DietFoodSwap 8 KB
DietFoodSwap_alternativeId_idx UNUSED 8 KB
DietFoodSwap_foodId_alternativeId_key 8 KB
DietFoodSwap_foodId_order_idx UNUSED 8 KB
DietFoodSwap_pkey 8 KB
DietPlanBlock 8 KB
DietPlanBlockDay 8 KB
DietPlanBlockDay_pkey 8 KB
DietPlanBlockDay_planBlockId_dayBlockId_order_key 8 KB
DietPlanBlockDay_planBlockId_order_idx UNUSED 8 KB
DietPlanBlock_clinicDomain_avgDailyCalories_idx UNUSED 8 KB
DietPlanBlock_clinicDomain_isActive_idx UNUSED 8 KB
DietPlanBlock_clinicDomain_usageCount_idx 8 KB
DietPlanBlock_pkey 8 KB
DispenseItem 8 KB
DispenseItem_dispenseOrderId_idx UNUSED 8 KB
DispenseItem_drugId_idx UNUSED 8 KB
DispenseItem_externalPrescriptionItemId_idx UNUSED 8 KB
DispenseItem_pkey 8 KB
DispenseItem_prescriptionUnitId_idx UNUSED 8 KB
DispenseItem_productId_idx UNUSED 8 KB
DispenseOrder 8 KB
DispenseOrder_clinicDomain_createdAt_idx UNUSED 8 KB
DispenseOrder_clinicDomain_number_key 8 KB
DispenseOrder_clinicDomain_status_idx UNUSED 8 KB
DispenseOrder_externalPrescriptionId_idx UNUSED 8 KB
DispenseOrder_invoiceUnitId_key 8 KB
DispenseOrder_issueKey_key 8 KB
DispenseOrder_patientProfileId_idx 8 KB
DispenseOrder_pkey 8 KB
DispenseOrder_prescriptionId_idx 8 KB
DoctorReview 8 KB
DoctorReview_clinicDomain_status_createdAt_idx 8 KB
DoctorReview_doctorId_status_publishedAt_idx UNUSED 8 KB
DoctorReview_patientUserId_idx UNUSED 8 KB
DoctorReview_pkey 8 KB
DoctorReview_sessionId_patientUserId_key 8 KB
DrugDoseUnit 8 KB
DrugDoseUnit_code_key 8 KB
DrugDoseUnit_pkey 8 KB
DrugFrequency 8 KB
DrugFrequency_code_key 8 KB
DrugFrequency_pkey 8 KB
DrugInteraction 8 KB
DrugInteraction_ingredientA_idx UNUSED 8 KB
DrugInteraction_ingredientA_ingredientB_key 8 KB
DrugInteraction_ingredientB_idx UNUSED 8 KB
DrugInteraction_pkey 8 KB
EmailDelivery 8 KB
EmailDelivery_clinicDomain_createdAt_idx UNUSED 8 KB
EmailDelivery_pkey 8 KB
EmailDelivery_to_status_idx UNUSED 8 KB
EmailSuppression 8 KB
EmailSuppression_clinicDomain_email_key 8 KB
EmailSuppression_email_idx UNUSED 8 KB
EmailSuppression_pkey 8 KB
EmployeeInsurance 8 KB
EmployeeInsurance_clinicDomain_coverageEnd_idx 8 KB
EmployeeInsurance_clinicDomain_userId_idx UNUSED 8 KB
EmployeeInsurance_documentId_key 8 KB
EmployeeInsurance_pkey 8 KB
EmployeeStatusHistory 8 KB
EmployeeStatusHistory_clinicDomain_idx 8 KB
EmployeeStatusHistory_pkey 8 KB
EmployeeStatusHistory_userId_changedAt_idx UNUSED 8 KB
ExchangeRate 8 KB
ExchangeRate_clinicDomain_fromCurrency_toCurrency_effective_key 8 KB
ExchangeRate_clinicDomain_fromCurrency_toCurrency_purpose_e_idx UNUSED 8 KB
ExchangeRate_pkey 8 KB
ExchangeRate_supersedesId_key 8 KB
ExternalLabPrice 8 KB
ExternalLabPrice_analysisTemplateId_idx UNUSED 8 KB
ExternalLabPrice_analysisUnitId_idx UNUSED 8 KB
ExternalLabPrice_externalLabId_idx 8 KB
ExternalLabPrice_pkey 8 KB
ExternalPrescription 8 KB
ExternalPrescriptionItem 8 KB
ExternalPrescriptionItem_drugId_idx UNUSED 8 KB
ExternalPrescriptionItem_externalPrescriptionId_idx UNUSED 8 KB
ExternalPrescriptionItem_pkey 8 KB
ExternalPrescription_clinicDomain_number_key 8 KB
ExternalPrescription_clinicDomain_status_idx UNUSED 8 KB
ExternalPrescription_fileId_idx 8 KB
ExternalPrescription_patientProfileId_idx 8 KB
ExternalPrescription_pkey 8 KB
FileFavorite 8 KB
FinancialPeriodWriteFence 8 KB
FinancialPeriodWriteFence_clinicDomain_releasedAt_periodSta_idx UNUSED 8 KB
FinancialPeriodWriteFence_financialPeriodId_idx UNUSED 8 KB
FinancialPeriodWriteFence_pkey 8 KB
FinancialWriteGate 8 KB
FinancialWriteGate_pkey 8 KB
FxConversion 8 KB
FxConversion_accountingEventId_key 8 KB
FxConversion_clinicDomain_occurredAt_id_idx 8 KB
FxConversion_clinicDomain_status_occurredAt_idx 8 KB
FxConversion_destinationMovementId_key 8 KB
FxConversion_destinationTreasuryId_occurredAt_idx 8 KB
FxConversion_feeExpenseId_key 8 KB
FxConversion_feeMovementId_key 8 KB
FxConversion_pkey 8 KB
FxConversion_reversalOfId_key 8 KB
FxConversion_sourceMovementId_key 8 KB
FxConversion_sourceTreasuryId_occurredAt_idx UNUSED 8 KB
FxRevaluationLine 8 KB
FxRevaluationLine_exchangeRateId_idx UNUSED 8 KB
FxRevaluationLine_foreignCurrency_idx UNUSED 8 KB
FxRevaluationLine_itemType_sourceId_idx UNUSED 8 KB
FxRevaluationLine_pkey 8 KB
FxRevaluationLine_reversalOfId_key 8 KB
FxRevaluationLine_reversalTreasuryMovementId_key 8 KB
FxRevaluationLine_runId_itemType_sourceId_key 8 KB
FxRevaluationLine_treasuryMovementId_key 8 KB
FxRevaluationRateSnapshot 8 KB
FxRevaluationRateSnapshot_exchangeRateId_idx UNUSED 8 KB
FxRevaluationRateSnapshot_pkey 8 KB
FxRevaluationRateSnapshot_runId_foreignCurrency_key 8 KB
FxRevaluationRun 8 KB
FxRevaluationRun_accountingEventId_key 8 KB
FxRevaluationRun_clinicDomain_periodEnd_idx UNUSED 8 KB
FxRevaluationRun_clinicDomain_status_periodEnd_idx UNUSED 8 KB
FxRevaluationRun_financialPeriodId_idx UNUSED 8 KB
FxRevaluationRun_periodPostingKey_key 8 KB
FxRevaluationRun_pkey 8 KB
FxRevaluationRun_reversalOfId_key 8 KB
GiftCardTransaction_giftCardId_idx UNUSED 8 KB
GiftCardTransaction_orderId_idx UNUSED 8 KB
GiftCardTransaction_pkey 8 KB
InsuranceClaim 8 KB
InsuranceClaim_clinicDomain_claimNumber_key 8 KB
InsuranceClaim_insuranceCompanyId_claimDate_idx 8 KB
InsuranceClaim_pkey 8 KB
IntakeRedFlagRule 8 KB
IntakeRedFlagRule_clinicDomain_isActive_idx 8 KB
IntakeRedFlagRule_formFieldId_idx UNUSED 8 KB
IntakeRedFlagRule_pkey 8 KB
InvoicePaymentApplication 8 KB
InvoicePaymentApplication_applicationKey_key 8 KB
InvoicePaymentApplication_clinicDomain_occurredAt_idx UNUSED 8 KB
InvoicePaymentApplication_invoiceId_paymentTransactionId_idx 8 KB
InvoicePaymentApplication_invoiceId_positionVersionAfter_idx 8 KB
InvoicePaymentApplication_pkey 8 KB
InvoicePaymentApplication_reversalOfId_idx UNUSED 8 KB
InvoiceReceivablePosition 8 KB
InvoiceReceivablePosition_clinicDomain_currency_idx UNUSED 8 KB
InvoiceReceivablePosition_clinicDomain_lastEventAt_idx UNUSED 8 KB
InvoiceReceivablePosition_invoiceId_key 8 KB
InvoiceReceivablePosition_pkey 8 KB
InvoiceUnitOption 8 KB
InvoiceUnitOption_invoiceUnitId_idx 8 KB
InvoiceUnitOption_name_value_idx UNUSED 8 KB
InvoiceUnitOption_pkey 8 KB
LabNotificationRule 8 KB
LabNotificationRule_clinicDomain_idx UNUSED 8 KB
LabNotificationRule_clinicDomain_notificationType_key 8 KB
LabNotificationRule_pkey 8 KB
LabSettings 8 KB
LabSettings_clinicDomain_key 8 KB
LabSettings_pkey 8 KB
Like 8 KB
LoyaltyExaminationRule 8 KB
LoyaltyFormRule 8 KB
LoyaltyPackageRule 8 KB
LoyaltyRedemption 8 KB
MedicalOrderAttachment 8 KB
MedicalOrderAttachment_pkey 8 KB
MobileAppConfig 8 KB
MobileAppConfig_bundleId_key 8 KB
MobileAppConfig_clinicDomain_key 8 KB
MobileAppConfig_pkey 8 KB
MobileAppRevision 8 KB
MobileAppRevision_configId_createdAt_idx UNUSED 8 KB
MobileAppRevision_pkey 8 KB
NoShowPolicyHistory 8 KB
NoShowPolicyHistory_pkey 8 KB
NoShowPolicyHistory_sessionId_idx 8 KB
NphiesAccount 8 KB
NphiesAccount_certificateExpiresAt_idx UNUSED 8 KB
NphiesAccount_clinicDomain_isActive_idx UNUSED 8 KB
NphiesAccount_clinicDomain_provider_key 8 KB
NphiesAccount_pkey 8 KB
NphiesAuthorization 8 KB
NphiesAuthorizationLine 8 KB
NphiesAuthorizationLine_authorizationId_sequence_key 8 KB
NphiesAuthorizationLine_invoiceUnitId_idx 8 KB
NphiesAuthorizationLine_pkey 8 KB
NphiesAuthorization_clinicDomain_preAuthRef_idx UNUSED 8 KB
NphiesAuthorization_clinicDomain_sessionId_status_idx 8 KB
NphiesAuthorization_clinicDomain_status_preAuthPeriodEnd_idx 8 KB
NphiesAuthorization_eligibilityVerificationId_idx UNUSED 8 KB
NphiesAuthorization_nphiesMessageId_idx UNUSED 8 KB
NphiesAuthorization_pkey 8 KB
NphiesClaim 8 KB
NphiesClaimLine 8 KB
NphiesClaimLine_claimId_invoiceUnitId_key 8 KB
NphiesClaimLine_claimId_sequence_key 8 KB
NphiesClaimLine_invoiceUnitId_idx 8 KB
NphiesClaimLine_pkey 8 KB
NphiesClaim_appealedById_idx UNUSED 8 KB
NphiesClaim_clinicDomain_businessIdentifier_key 8 KB
NphiesClaim_clinicDomain_invoiceId_idx 8 KB
NphiesClaim_clinicDomain_receivablePostingStatus_idx UNUSED 8 KB
NphiesClaim_clinicDomain_sessionId_status_idx 8 KB
NphiesClaim_clinicDomain_status_idx UNUSED 8 KB
NphiesClaim_eligibilityVerificationId_idx UNUSED 8 KB
NphiesClaim_nphiesMessageId_idx UNUSED 8 KB
NphiesClaim_originalClaimId_idx UNUSED 8 KB
NphiesClaim_pkey 8 KB
NphiesClaim_relatedClaimId_idx UNUSED 8 KB
NphiesDisclosure 8 KB
NphiesDisclosure_actorId_idx UNUSED 8 KB
NphiesDisclosure_clinicDomain_disclosedAt_idx UNUSED 8 KB
NphiesDisclosure_infoRequestId_idx UNUSED 8 KB
NphiesDisclosure_nphiesMessageId_idx UNUSED 8 KB
NphiesDisclosure_pkey 8 KB
NphiesInfoRequest 8 KB
NphiesInfoRequestAttachment 8 KB
NphiesInfoRequestAttachment_pkey 8 KB
NphiesInfoRequestAttachment_requestId_idx UNUSED 8 KB
NphiesInfoRequest_assignedToId_idx UNUSED 8 KB
NphiesInfoRequest_clinicDomain_businessIdentifier_key 8 KB
NphiesInfoRequest_clinicDomain_patientId_status_idx 8 KB
NphiesInfoRequest_clinicDomain_status_receivedAt_idx UNUSED 8 KB
NphiesInfoRequest_inboundMessageId_idx UNUSED 8 KB
NphiesInfoRequest_nphiesAuthorizationId_idx UNUSED 8 KB
NphiesInfoRequest_nphiesClaimId_idx UNUSED 8 KB
NphiesInfoRequest_pkey 8 KB
NphiesMessage 8 KB
NphiesMessage_clinicDomain_direction_businessIdentifier_key 8 KB
NphiesMessage_clinicDomain_direction_eventCode_idx UNUSED 8 KB
NphiesMessage_clinicDomain_mode_idx UNUSED 8 KB
NphiesMessage_clinicDomain_sourceType_sourceId_idempotencyV_key 8 KB
NphiesMessage_clinicDomain_sourceType_status_idx UNUSED 8 KB
NphiesMessage_clinicDomain_status_nextAttemptAt_createdAt_idx UNUSED 8 KB
NphiesMessage_pkey 8 KB
NphiesMessage_status_nextAttemptAt_createdAt_idx UNUSED 8 KB
NphiesPayerDirectory 8 KB
NphiesPayerDirectory_isActive_idx UNUSED 8 KB
NphiesPayerDirectory_nphiesIdentifier_key 8 KB
NphiesPayerDirectory_pkey 8 KB
NphiesPayload 8 KB
NphiesPayload_clinicDomain_redactedAt_idx 8 KB
NphiesPayload_pkey 8 KB
NphiesPayload_storageKey_key 8 KB
NphiesPaymentNotice 8 KB
NphiesPaymentNotice_clinicDomain_status_idx UNUSED 8 KB
NphiesPaymentNotice_insuranceClaimId_nphiesClaimId_key 8 KB
NphiesPaymentNotice_nphiesMessageId_idx UNUSED 8 KB
NphiesPaymentNotice_pkey 8 KB
NphiesPaymentNotice_reconciliationId_idx UNUSED 8 KB
NphiesPaymentReconciliation 8 KB
NphiesPaymentReconciliationLine 8 KB
NphiesPaymentReconciliationLine_claimBusinessIdentifier_idx UNUSED 8 KB
NphiesPaymentReconciliationLine_nphiesClaimId_idx UNUSED 8 KB
NphiesPaymentReconciliationLine_pkey 8 KB
NphiesPaymentReconciliationLine_reconciliationId_sequence_key 8 KB
NphiesPaymentReconciliation_clinicDomain_businessIdentifier_key 8 KB
NphiesPaymentReconciliation_clinicDomain_paymentDate_idx UNUSED 8 KB
NphiesPaymentReconciliation_nphiesMessageId_idx UNUSED 8 KB
NphiesPaymentReconciliation_pkey 8 KB
NphiesPollLock 8 KB
NphiesPollLock_pkey 8 KB
OnboardingBlocker 8 KB
OnboardingBlocker_ownerId_dueAt_idx UNUSED 8 KB
OnboardingBlocker_pkey 8 KB
OnboardingBlocker_projectId_status_severity_idx 8 KB
OnboardingBlocker_reasonKey_category_idx UNUSED 8 KB
OnboardingBlocker_sourceTaskId_idx UNUSED 8 KB
OnboardingCalendarAttendee_eventId_userId_key 8 KB
OnboardingCalendarAttendee_pkey 8 KB
OnboardingCalendarAttendee_userId_eventId_idx UNUSED 8 KB
OnboardingCalendarEvent 8 KB
OnboardingCalendarEvent_clinicDomain_startAt_idx 8 KB
OnboardingCalendarEvent_onboardingProjectId_startAt_idx UNUSED 8 KB
OnboardingCalendarEvent_pkey 8 KB
OnboardingCalendarEvent_startAt_idx 8 KB
OnboardingCalendarEvent_status_startAt_idx UNUSED 8 KB
OnboardingCalendarReminderRule_eventId_offsetMinutes_scope_key 8 KB
OnboardingCalendarReminderRule_pkey 8 KB
OnboardingDecision 8 KB
OnboardingDecision_pkey 8 KB
OnboardingDecision_projectId_type_decidedAt_idx 8 KB
OnboardingHandoff 8 KB
OnboardingHandoffItem 8 KB
OnboardingHandoffItem_handoffId_sortOrder_idx UNUSED 8 KB
OnboardingHandoffItem_pkey 8 KB
OnboardingHandoff_incomingOwnerId_status_idx 8 KB
OnboardingHandoff_pkey 8 KB
OnboardingHandoff_projectId_role_incomingOwnerId_idx 8 KB
OnboardingHandoff_projectId_status_idx 8 KB
OnboardingMigrationReview 8 KB
OnboardingMigrationReview_importJobId_idx UNUSED 8 KB
OnboardingMigrationReview_pkey 8 KB
OnboardingMigrationReview_projectId_createdAt_idx 8 KB
OnboardingReadinessRun 8 KB
OnboardingTaskDependency_dependsOnTaskId_idx 8 KB
OnboardingTaskDependency_pkey 8 KB
OnboardingTaskDependency_projectId_idx UNUSED 8 KB
OnboardingTemplate 8 KB
OnboardingTemplate_familyKey_revision_key 8 KB
OnboardingTemplate_familyKey_status_revision_idx UNUSED 8 KB
OnboardingTemplate_key_key 8 KB
OnboardingTemplate_pkey 8 KB
OnboardingUatRun 8 KB
OnboardingUatRun_pkey 8 KB
OnboardingUatRun_projectId_attemptNumber_key 8 KB
OnboardingUatRun_projectId_executedAt_idx UNUSED 8 KB
OrderReturn 8 KB
OrderReturnItem_invoiceUnitId_idx 8 KB
OrderReturnItem_orderReturnId_idx UNUSED 8 KB
OrderReturnItem_pkey 8 KB
OrderReturn_clinicDomain_status_idx 8 KB
OrderReturn_orderId_idx 8 KB
OrderReturn_pkey 8 KB
PatientAllergy 8 KB
PatientAllergy_atcPrefix_idx UNUSED 8 KB
PatientAllergy_clinicDomain_isActive_idx UNUSED 8 KB
PatientAllergy_ingredientName_idx UNUSED 8 KB
PatientAllergy_patientProfileId_isActive_idx 8 KB
PatientAllergy_pkey 8 KB
PatientOperation 8 KB
PatientOperation_clinicDomain_hospitalName_idx 8 KB
PatientOperation_clinicDomain_patientProfileId_idx 8 KB
PatientOperation_clinicDomain_performedAt_idx 8 KB
PatientOperation_pkey 8 KB
PatientUserStorePriceList 8 KB
PatientUserStorePriceList_clinicDomain_idx UNUSED 8 KB
PatientUserStorePriceList_namedPriceListId_idx UNUSED 8 KB
PatientUserStorePriceList_patientUserId_clinicDomain_key 8 KB
PatientUserStorePriceList_pkey 8 KB
PaymentGatewayAccount 8 KB
PaymentGatewayAccount_clinicDomain_isActive_idx 8 KB
PaymentGatewayAccount_clinicDomain_provider_key 8 KB
PaymentGatewayAccount_pkey 8 KB
PaymentSettlementRecord 8 KB
PaymentSettlementRecord_clinicDomain_paymentIntentId_idx UNUSED 8 KB
PaymentSettlementRecord_clinicDomain_provider_providerRefer_key 8 KB
PaymentSettlementRecord_clinicDomain_settledAt_idx UNUSED 8 KB
PaymentSettlementRecord_feeExpenseId_key 8 KB
PaymentSettlementRecord_pkey 8 KB
PerformanceCriterion 8 KB
PerformanceCriterion_clinicDomain_name_key 8 KB
PerformanceCriterion_pkey 8 KB
PerformanceReviewScore 8 KB
PerformanceReviewScore_pkey 8 KB
PerformanceReviewScore_reviewId_criterionId_key 8 KB
PlatformCashSnapshot 8 KB
PlatformCashSnapshot_asOfDate_idx 8 KB
PlatformCashSnapshot_asOfDate_key 8 KB
PlatformCashSnapshot_pkey 8 KB
PlatformExpense 8 KB
PlatformExpense_date_costType_idx 8 KB
PlatformExpense_pkey 8 KB
PolicyHolderOrganization 8 KB
PolicyHolderOrganization_clinicDomain_idx UNUSED 8 KB
PolicyHolderOrganization_clinicDomain_name_key 8 KB
PolicyHolderOrganization_pkey 8 KB
PrescriptionSafetyCheck 8 KB
PrescriptionSafetyCheck_clinicDomain_severity_createdAt_idx 8 KB
PrescriptionSafetyCheck_pkey 8 KB
PrescriptionSafetyCheck_prescriptionId_isCurrent_idx 8 KB
RadiologyOrder 8 KB
RadiologyOrder_orderId_key 8 KB
RadiologyOrder_pkey 8 KB
SalesAgentDailyScore 8 KB
SalesAgentDailyScore_clinicDomain_day_idx 8 KB
SalesAgentDailyScore_clinicDomain_userId_day_idx UNUSED 8 KB
SalesAgentDailyScore_clinicDomain_userId_day_key 8 KB
SalesAgentDailyScore_pkey 8 KB
SessionDeviceUsage 8 KB
SessionDeviceUsage_clinicDomain_assetId_usedAt_idx UNUSED 8 KB
SessionDeviceUsage_clinicDomain_examinationId_usedAt_idx 8 KB
SessionDeviceUsage_clinicDomain_usedAt_idx UNUSED 8 KB
SessionDeviceUsage_pkey 8 KB
SessionDeviceUsage_sessionId_idx 8 KB
SessionDiagnosis 8 KB
SessionDiagnosis_pkey 8 KB
SessionDiagnosis_sessionId_idx UNUSED 8 KB
SessionDiagnosis_sessionId_sequence_key 8 KB
SessionProgramItemLog 8 KB
SessionProgramItemLog_pkey 8 KB
SessionProgramItemLog_sessionId_programItemId_key 8 KB
SessionProgramItemLog_treatmentPlanId_sessionId_idx 8 KB
SpecialtyPracticeCode 8 KB
SpecialtyPracticeCode_clinicDomain_idx UNUSED 8 KB
SpecialtyPracticeCode_clinicDomain_specialty_key 8 KB
SpecialtyPracticeCode_pkey 8 KB
StaffDevice 8 KB
StaffDevice_deviceToken_idx UNUSED 8 KB
StaffDevice_pkey 8 KB
StaffDevice_userId_deviceToken_key 8 KB
StaffDevice_userId_idx UNUSED 8 KB
Star_pkey 8 KB
Star_userId_updateId_key 8 KB
TaxBracket 8 KB
TaxBracket_clinicDomain_kind_order_idx UNUSED 8 KB
TaxBracket_pkey 8 KB
TelemedicineDailyReconciliation 8 KB
TelemedicineDailyReconciliation_clinicDomain_date_idx UNUSED 8 KB
TelemedicineDailyReconciliation_clinicDomain_date_key 8 KB
TelemedicineDailyReconciliation_pkey 8 KB
TelemedicineMeteringFailure 8 KB
TelemedicineMeteringFailure_clinicDomain_createdAt_idx UNUSED 8 KB
TelemedicineMeteringFailure_pkey 8 KB
TelemedicineMeteringFailure_resolvedAt_idx UNUSED 8 KB
TelemedicineMinuteCostConfig 8 KB
TelemedicineMinutePackage 8 KB
TelemedicineMinutePackage_pkey 8 KB
TelemedicineMinuteTransaction 8 KB
TelemedicineMinuteTransaction_clinicDomain_createdAt_idx UNUSED 8 KB
TelemedicineMinuteTransaction_clinicDomain_type_createdAt_idx UNUSED 8 KB
TelemedicineMinuteTransaction_idempotencyKey_key 8 KB
TelemedicineMinuteTransaction_pkey 8 KB
TelemedicineMinuteTransaction_sessionId_idx UNUSED 8 KB
TelemedicineMinuteUsage 8 KB
TelemedicineMinuteUsage_clinicDomain_createdAt_idx 8 KB
TelemedicineMinuteUsage_pkey 8 KB
TelemedicineMinuteUsage_sessionId_idx UNUSED 8 KB
TreasuryCashCount 8 KB
TreasuryCashCount_accountingEventId_key 8 KB
TreasuryCashCount_clinicDomain_countedAt_idx UNUSED 8 KB
TreasuryCashCount_clinicDomain_status_countedAt_idx UNUSED 8 KB
TreasuryCashCount_pkey 8 KB
TreasuryCashCount_resolutionMovementId_key 8 KB
TreasuryCashCount_treasuryId_currency_countedAt_idx UNUSED 8 KB
Vote 8 KB
WaitlistOffer 8 KB
WaitlistOffer_clinicDomain_status_expiresAt_idx 8 KB
WaitlistOffer_pkey 8 KB
WaitlistOffer_sessionRequestId_createdAt_idx UNUSED 8 KB
WaitlistOffer_slotKey_sessionRequestId_key 8 KB
WaitlistOffer_slotKey_status_idx 8 KB
WaitlistOffer_token_key 8 KB
WorkScheduleException 8 KB
WorkScheduleException_clinicDomain_date_idx UNUSED 8 KB
WorkScheduleException_pkey 8 KB
WorkScheduleException_userId_date_key 8 KB
_DietPlanBlockToDietTag 8 KB
_DietPlanBlockToDietTag_AB_pkey 8 KB
_DietPlanBlockToDietTag_B_index UNUSED 8 KB
_ExaminationAddOns_AB_pkey 8 KB
_ExaminationAddOns_B_index 8 KB
_ExaminationToPatientOperation_AB_pkey 8 KB
_ExaminationToPatientOperation_B_index UNUSED 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
ClinicActivityMention 0 Bytes
GiftCardTransaction 0 Bytes
OnboardingCalendarAttendee 0 Bytes
OnboardingCalendarReminderRule 0 Bytes
OnboardingTaskDependency 0 Bytes
OrderReturnItem 0 Bytes
Star 0 Bytes
_ExaminationAddOns 0 Bytes
_ExaminationToPatientOperation 0 Bytes
_InvoiceToTag 0 Bytes
_TagToUser 0 Bytes