PurchaseOrders


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
PurchaseOrderInvoices.purchaseOrderId PurchaseOrderInvoices_purchaseOrderId_fkey C
PurchaseOrderPaymentRequests.purchaseOrderId PurchaseOrderPaymentRequests_purchaseOrderId_fkey R
PurchaseOrderPricingDetails.purchaseOrderId PurchaseOrderPricingDetails_purchaseOrderId_fkey R
PurchaseOrderProducts.purchaseOrderId PurchaseOrderProducts_purchaseOrderId_fkey C
PurchaseOrderXenditPaymentRequests.purchaseOrderId PurchaseOrderXenditPaymentRequests_purchaseOrderId_fkey R
companyId uuid 2147483647 √ null
Companies.id PurchaseOrders_companyId_fkey N
userId uuid 2147483647 √ null
Users.id PurchaseOrders_userId_fkey N
status "employer_purchases"."enum_employer_purchases_PurchaseOrders_status" 2147483647 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
redirectPathAfterPayment text 2147483647 √ null

redirect path for frontend after successful payment and after payment action

Indexes

Constraint Name Type Sort Column(s)
PurchaseOrders_pkey Primary key Asc id
employer_purchases_PurchaseOrders_companyId_idx Performance Asc companyId
employer_purchases_PurchaseOrders_status_idx Performance Asc status
employer_purchases_PurchaseOrders_userId_idx Performance Asc userId
PurchaseOrders_companyId_status_idx Performance Asc/Asc companyId + status

Relationships

Close relationships within degrees of separation