Database Properties
Database Type: PostgreSQL - 14.15 (Ubuntu 14.15-1.pgdg22.04+1)
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| PointsTopUpOrderAfterPaymentActions | 2 | 1 | 6 | Table | |
| AutomatedCSVExportLogs | 0 | 1 | 8 | Table | |
| XenditInvoiceReconciliationCronTaskLogs | 0 | 0 | 4 | Table | Table to store all cron job tasks record |
| PointsTopUpOrderRelatedJobs | 0 | 2 | 2 | Table | |
| PointsJournalEntries | 4 | 2 | 8 | Table | |
| TalentChatPointsAccounts | 0 | 2 | 2 | Table | Table to link talent chat points account to company |
| FreeSubscriptionPlanGroups | 1 | 0 | 5 | Table | |
| PointsCurrencyConversionRates | 0 | 0 | 5 | Table | |
| JobPostExtensionPointsUsageAccounts | 0 | 2 | 2 | Table | Table to link job post extension points account to company |
| Orders | 2 | 3 | 5 | Table | |
| PointsTopUpOrderPricings | 0 | 1 | 5 | Table | |
| SubscriptionCsvDownloads | 0 | 1 | 5 | Table | Table to associate CSV download functionality with CompanyJobSlotsSubscriptions |
| PointsExpiryDatetimes | 0 | 1 | 2 | Table | Table to store expiry of each points transaction |
| CompanyBalanceExpiryDates | 0 | 1 | 4 | Table | |
| CompanyJobSlotsSubscriptions | 6 | 2 | 13 | Table | |
| ExpiryPointsAccounts | 0 | 2 | 2 | Table | Table to link job post points expiry account to company |
| JobPostPointsUsageAccounts | 0 | 2 | 2 | Table | Table to link points usage account to company |
| PointsTopUpOrders | 8 | 3 | 7 | Table | |
| EmployerBonusPointsAccounts | 0 | 2 | 2 | Table | Table to link bonus points account to company |
| MissingXenditInvoicesForPointsTopUpOrders | 0 | 1 | 4 | Table | Table to store points top up order for which Xendit Invoice is missing |
| PointsAccounts | 7 | 0 | 6 | Table | |
| PointsTopUpOrderPayments | 0 | 1 | 3 | Table | |
| TalentChatAllocations | 0 | 1 | 4 | Table | |
| PointsTopUpOrderXenditInvoiceMismatches | 0 | 1 | 8 | Table | Table to store points top up order that has different status or amount between DB and Xendit |
| PointsJournalEntryDebitCredits | 0 | 2 | 5 | Table | |
| SubscriptionTalentChatQuotas | 0 | 1 | 5 | Table | |
| CompanyJobSlotSubscriptionAdditionalFeatures | 0 | 1 | 3 | Table | |
| JobPostOrderItems | 0 | 2 | 2 | Table | |
| PointsTopUpJournalEntries | 0 | 2 | 2 | Table | Table to link Points Journal Entry to Points Top Up Order |
| JobExtensionOrderItems | 0 | 2 | 3 | Table | |
| PointsTopUpOrderRelatedJobDrafts | 0 | 3 | 3 | Table | |
| Products | 1 | 0 | 5 | Table | |
| PointsTopUpOrderPointDetails | 0 | 1 | 3 | Table | |
| SubscriptionPlanAssistanceRequests | 0 | 2 | 13 | Table | |
| PointsTopUpOrderXenditPayments | 0 | 1 | 6 | Table | |
| ProductPurchaseAssistanceRequests | 0 | 2 | 13 | Table | |
| EmployerPaidPointsAccounts | 0 | 2 | 2 | Table | Table to link paid points account to company |
| OrderItems | 2 | 2 | 4 | Table | |
| XenditInvoicesWithoutPointsTopUpOrders | 0 | 0 | 4 | Table | Table to store missing Xendit invoice that is not available on database |
| PointsUsageJournalEntries | 0 | 2 | 2 | Table | Table to link Points Usage Journal Entry to Points Top Up Order |
| SubscriptionPlans | 0 | 0 | 11 | Table |