PointsTopUpOrderAfterPaymentActions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pointsTopUpOrderId uuid 2147483647 null
PointsTopUpOrderRelatedJobDrafts.pointsTopUpOrderAfterPaymentActionId PointsTopUpOrderRelatedJobDra_pointsTopUpOrderAfterPayment_fkey C
PointsTopUpOrderRelatedJobs.pointsTopUpOrderAfterPaymentActionId PointsTopUpOrderRelatedJob_pointsTopUpOrderAfterPaymentAct_fkey C
PointsTopUpOrders.id PointsTopUpOrderAfterPaymentActions_pointsTopUpOrderId_fkey C
status "employer_commerce"."enum_EmployerCommerce_PointsTopUpOrderAfterPaymentActionStatus" 2147483647 null
actionType "employer_commerce"."enum_EmployerCommerce_PointsTopUpOrderAfterPaymentActionType" 2147483647 null
failureJson jsonb 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
PointsTopUpOrderAfterPaymentActions_pkey Primary key Asc pointsTopUpOrderId

Check Constraints

Constraint Name Constraint
PointsTopUpOrderAfterPaymentActions_check ((((status <> 'FAILED'::employer_commerce."enum_EmployerCommerce_PointsTopUpOrderAfterPaymentActionStatus") AND ("failureJson" IS NULL)) OR ((status = 'FAILED'::employer_commerce."enum_EmployerCommerce_PointsTopUpOrderAfterPaymentActionStatus") AND ("failureJson" IS NOT NULL))))

Relationships

Close relationships within degrees of separation