Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pointsTopUpOrderId | uuid | 2147483647 | null |
|
|
||||||
| actualStatus | "employer_commerce"."enum_EmployerCommerce_PointsTopUpOrderStatus" | 2147483647 | √ | null |
|
|
the actual status of the points top up order |
||||
| expectedStatus | "employer_commerce"."enum_EmployerCommerce_PointsTopUpOrderStatus" | 2147483647 | √ | null |
|
|
the expected status of the points top up order |
||||
| actualTotalAmount | numeric | 0 | √ | null |
|
|
the actual total amount of the points top up order |
||||
| expectedTotalAmount | numeric | 0 | √ | null |
|
|
the expected total amount of the points top up order |
||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| updatedAt | timestamptz | 35,6 | now() |
|
|
||||||
| deletedAt | timestamptz | 35,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PointsTopUpOrderXenditInvoiceMismatches_pkey | Primary key | Asc | pointsTopUpOrderId |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| PointsTopUpOrderXenditInvoiceMismatches_check | (((("actualStatus" IS NULL) = ("expectedStatus" IS NULL)) AND ((("actualTotalAmount" IS NULL) AND ("expectedTotalAmount" IS NULL)) OR (("actualTotalAmount" IS NOT NULL) AND ("actualTotalAmount" >= (0)::numeric) AND ("expectedTotalAmount" IS NOT NULL) AND ("expectedTotalAmount" >= (0)::numeric))))) |
Relationships
Close relationships within degrees of separation
