PointsTopUpOrders


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
MissingXenditInvoicesForPointsTopUpOrders.pointsTopUpOrderId MissingXenditInvoicesForPointsTopUpOrde_pointsTopUpOrderId_fkey C
PointsTopUpJournalEntries.pointsTopUpOrderId PointsTopUpJournalEntries_pointsTopUpOrderId_fkey C
PointsTopUpOrderAfterPaymentActions.pointsTopUpOrderId PointsTopUpOrderAfterPaymentActions_pointsTopUpOrderId_fkey C
PointsTopUpOrderPayments.pointsTopUpOrderId PointsTopUpOrderPayments_pointsTopUpOrderId_fkey C
PointsTopUpOrderPointDetails.pointsTopUpOrderId PointsTopUpOrderPointDetails_pointsTopUpOrderId_fkey C
PointsTopUpOrderPricings.pointsTopUpOrderId PointsTopUpOrderPricings_pointsTopUpOrderId_fkey C
PointsTopUpOrderXenditInvoiceMismatches.pointsTopUpOrderId PointsTopUpOrderXenditInvoiceMismatches_pointsTopUpOrderId_fkey C
PointsTopUpOrderXenditPayments.pointsTopUpOrderId PointsTopUpOrderXenditPayments_pointsTopUpOrderId_fkey C
userCompanyId uuid 2147483647 √ null
UserCompanies.id PointsTopUpOrders_userCompanyId_fkey N
status "employer_commerce"."enum_EmployerCommerce_PointsTopUpOrderStatus" 2147483647 null
createdAt timestamptz 35,6 null
updatedAt timestamptz 35,6 null
userId uuid 2147483647 √ null
Users.id PointsTopUpOrders_userId_fkey R
companyId uuid 2147483647 √ null
Companies.id PointsTopUpOrders_companyId_fkey N

Indexes

Constraint Name Type Sort Column(s)
PointsTopUpOrders_pkey Primary key Asc id
employer_commerce_PointsTopUpOrders_companyId_idx Performance Asc companyId
employer_commerce_PointsTopUpOrders_status_idx Performance Asc status
employer_commerce_PointsTopUpOrders_userCompanyId_idx Performance Asc userCompanyId
employer_commerce_PointsTopUpOrders_userId_idx Performance Asc userId

Relationships

Close relationships within degrees of separation