Skip to main content

Data Model

107 entities, 91 of them tenant-scoped. Each page lists the table, its columns, its relationships, the repository declared over it, and the endpoints that can reach it.

For the hand-drawn overview of how the core tables relate, see the ERD. This section is the exhaustive version, and unlike the ERD it is regenerated on every build.

Entities​

EntityTableColumnsRelationsTenant-scopedModule
Announcementannouncement61YesHR
BillingSubscriptionbilling_subscription260—Billing & Platform
BillingWebhookEventbilling_webhook_event90—Billing & Platform
Bir2316Inputsbir_2316_inputs170YesPH Statutory
Bonusbonus81YesPayroll
CertificateTemplatecertificate_template150YesHR
ChatMessagemessages43YesPlatform Misc
CompanyProfilecompany_profile220YesBilling & Platform
Conversationconversation42YesPlatform Misc
CrmActivitycrm_activity105YesCRM
CrmContactcrm_contact103YesCRM
CrmDealcrm_deal115YesCRM
CrmLeadcrm_lead141YesCRM
CrmNotecrm_note35YesCRM
CrmOrganizationcrm_organization122YesCRM
CrmPicklistItemcrm_picklist_item110YesCRM
CrmSettingscrm_settings120YesCRM
CrmSettingsChangecrm_settings_changes61YesCRM
CustomerOrdercustomer_order106YesInventory & Portal
CustomerOrderItemcustomer_order_item42Yes—
DeductionTypededuction_types100YesPayroll
DeMinimisBenefitTypede_minimis_benefit_types120YesPayroll
Departmentdepartment41YesHR
Employeeemployee392YesHR
EmployeeDeductionemployee_deductions122YesPayroll
EmployeePayoutHistoryemployee_payout_history80YesHR
EmployeeRestDayemployee_rest_day21Yes—
EwtPayeeewt_payees120YesPH Statutory
EwtTransactionewt_transactions141YesPH Statutory
FringeBenefitfringe_benefit101YesPH Statutory
GovernmentFilinggovernment_filing191YesPH Statutory
InterviewFeedbackinterview_feedback62YesRecruitment
InterviewScheduleinterview_schedule62YesRecruitment
InventoryIteminventory_item163YesInventory & Portal
InventoryLotinventory_lot82YesInventory & Portal
InventoryOrderinventory_order72YesInventory & Portal
InventoryStockinventory_stock22YesInventory & Portal
ItemCategoryitem_category30YesInventory & Portal
ItemPriceitem_price112YesInventory & Portal
ItemPriceHistoryitem_price_history53YesInventory & Portal
ItemSerialitem_serial52YesInventory & Portal
JobApplicantjob_applicant122YesRecruitment
JobApplicantResumejob_applicant_resume61YesRecruitment
JobOfferjob_offer243YesRecruitment
JobOpeningjob_opening111YesRecruitment
JobRequisitionjob_requisition73YesRecruitment
LeaveBalanceleave_balance22YesHR
LeaveRequestleave_request83YesHR
LeaveRequestTypeleave_request_type30YesBilling & Platform
LegalDocumentAcceptancelegal_document_acceptance50YesBilling & Platform
Notificationnotifications51YesPlatform Misc
OrderStageorder_stage62Yes—
OvertimeRequestovertime_request61YesPayroll
PagibigContributionRatepagibig_contribution_rates70—Payroll
PasswordResetTokenpassword_reset_tokens70—Auth & Identity
Payrollpayroll140YesPayroll
PayrollApprovalpayroll_approval32YesPayroll
PayrollChangepayroll_changes61YesPayroll
PayrollGlAccountpayroll_gl_account41Yes—
PayrollPayoutBatchpayroll_payout_batch143YesPayroll
PayrollPayoutBatchLinepayroll_payout_batch_line32YesPayroll
PayrollReportArchivepayroll_report_archive120Yes—
PayrollSettingspayroll_settings760YesPayroll
PayrollSettingsChangepayroll_settings_changes61YesPayroll
PayrollSettingsSnapshotpayroll_settings_snapshot40Yes—
PayrollTransactionpayroll_transactions52YesPayroll
Payslippayslip602YesPayroll
PayslipDayLinepayslip_day_line190Yes—
PayslipDeductionItempayslip_deduction_items42YesPayroll
PayslipHistorypayslip_history81YesPayroll
PayslipTemplatepayslip_template90YesPayroll
PayslipTemplateSettingspayslip_template_settings70YesPayroll
Permissionpermission40—Auth & Identity
PhHolidayph_holidays100YesPayroll
PhilhealthContributionRatephilhealth_contribution_rates70—Payroll
PortalEmailVerificationTokenportal_email_verification_tokens80—Inventory & Portal
PortalPasswordResetTokenportal_password_reset_tokens70—Inventory & Portal
PortalUserportal_user101—Inventory & Portal
Positionposition51YesHR
PurchaseReceivingpurchase_receiving74YesInventory & Portal
PurchaseReceivingItempurchase_receiving_item34Yes—
RecognitionAwardrecognition_award82YesPayroll
RefreshTokenrefresh_tokens81——
ReimbursementRequestreimbursement_requests73YesPayroll
ReimbursementTransactionreimbursement_transactions61YesPayroll
Rolerole62—Auth & Identity
SavedViewsaved_view81YesPlatform Misc
ShipmentTrackingshipment_tracking62YesInventory & Portal
SssContributionRatesss_contribution_rates120—Payroll
StaffingPlanstaffing_plan63YesRecruitment
StaffingPlanItemstaffing_plan_item42YesRecruitment
StockTransactionstock_transaction184YesInventory & Portal
Storestore91YesInventory & Portal
StoreInventorystore_inventory52YesInventory & Portal
Suppliersupplier102YesInventory & Portal
Tenanttenant150—Billing & Platform
Timesheettimesheet82YesHR
TinCompliancetin_compliance31YesPH Statutory
Userusers112—Inventory & Portal
UserLoguser_log51—Auth & Identity
UserNavPreferenceuser_nav_preference31YesPlatform Misc
UserOnboardingProgressuser_onboarding_progress70YesPlatform Misc
Warehousewarehouse50YesInventory & Portal
WarehouseLocationwarehouse_location72YesInventory & Portal
WarehouseTransferwarehouse_transfer54YesInventory & Portal
WithholdingTaxBracketwithholding_tax_brackets80—Payroll
WorkSuspensionwork_suspensions50YesPayroll

Global tables​

Entities that do not extend TenantOwned. Their rows are shared by every tenant, which is correct for reference data and for the tenant registry itself, and a bug for anything else — TenantCoverageTest walks the JPA metamodel and fails the build on an entity that is neither tenant-owned nor declared global.

EntityTableColumns
BillingSubscriptionbilling_subscription26
BillingWebhookEventbilling_webhook_event9
PagibigContributionRatepagibig_contribution_rates7
PasswordResetTokenpassword_reset_tokens7
Permissionpermission4
PhilhealthContributionRatephilhealth_contribution_rates7
PortalEmailVerificationTokenportal_email_verification_tokens8
PortalPasswordResetTokenportal_password_reset_tokens7
PortalUserportal_user10
RefreshTokenrefresh_tokens8
Rolerole6
SssContributionRatesss_contribution_rates12
Tenanttenant15
Userusers11
UserLoguser_log5
WithholdingTaxBracketwithholding_tax_brackets8

Enums​

EnumValues
AbsentDeductionPolicy—
BreakDeductionPolicy—
CertificateDesign—
ContributionSchedule—
DeductionAmountBasis—
HolidayEligibilityPolicy—
HolidayLeaveInteractionPolicy—
LateDeductionPolicy—
LegalDocumentType—
LockoutReason—
OnboardingTourStatus—
PayFrequency—
PayrollRoundingMode—
RecognitionCategory—
SeatSyncFailure—
SubscriptionStatus—
SuspensionReason—
TaxPayPeriod—
TenantStatus—
TimesheetPayPolicy—
TimesheetStatus—

Generated page

This page is rebuilt from the source on every docs build by docs-site/scripts/gen-code-wiki.mjs. Editing it has no effect — change the code, or, if what you want to say is prose, write it in docs/.