Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
||||||
| purchaseOrderId | uuid | 2147483647 | null |
|
|
||||||
| fileName | text | 2147483647 | null |
|
|
contains only a file name. when this file is open, it will contain the invoice of purchase order |
|||||
| status | "employer_purchases"."enum_employer_purchases_PurchaseOrderInvoices_status" | 2147483647 | null |
|
|
||||||
| failureMessage | text | 2147483647 | √ | null |
|
|
|||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| updatedAt | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PurchaseOrderInvoices_pkey | Primary key | Asc | id |
| PurchaseOrderInvoices_purchaseOrderId_status_idx | Must be unique | Asc/Asc | purchaseOrderId + status |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| PurchaseOrderInvoices_failureMessage_nullable_check | ((((status = 'FAILED'::employer_purchases."enum_employer_purchases_PurchaseOrderInvoices_status") AND ("failureMessage" IS NOT NULL)) OR ((status = ANY (ARRAY['IN_PROGRESS'::employer_purchases."enum_employer_purchases_PurchaseOrderInvoices_status", 'SUCCESS'::employer_purchases."enum_employer_purchases_PurchaseOrderInvoices_status"])) AND ("failureMessage" IS NULL)) OR (status = 'NOT_AVAILABLE'::employer_purchases."enum_employer_purchases_PurchaseOrderInvoices_status"))) |
Relationships
Close relationships within degrees of separation
