PurchaseOrderProductAfterPaymentActionLogs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
purchaseOrderProductId uuid 2147483647 null
PurchaseOrderProducts.id PurchaseOrderProductAfterPaymentAct_purchaseOrderProductId_fkey R
relatedJobId uuid 2147483647 √ null
Jobs.id PurchaseOrderProductAfterPaymentActionLogs_relatedJobId_fkey N
status "employer_purchases"."enum_PurchaseOrderProductAfterPaymentActionLogs_status" 2147483647 null
failureType "employer_purchases"."enum_PurchaseOrderProductAfterPaymentActionLogs_failureType" 2147483647 √ null

Contains type of failure if the status is failed
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
PurchaseOrderProductAfterPaymentActionLogs_pkey Primary key Asc purchaseOrderProductId

Check Constraints

Constraint Name Constraint
PurchaseOrderProductAfterPaymentActionLogs_failureType_nullable ((((status = 'FAILED'::employer_purchases."enum_PurchaseOrderProductAfterPaymentActionLogs_status") AND ("failureType" IS NOT NULL)) OR ((status <> 'FAILED'::employer_purchases."enum_PurchaseOrderProductAfterPaymentActionLogs_status") AND ("failureType" IS NULL))))

Relationships

Close relationships within degrees of separation