Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| helper_id | int8 |
|
|
The foreign key for the associated helper. @example 1 |
| company_id | int8 |
|
|
The foreign key for the associated marketplace. @example 1 |
| membership_id | int8 |
|
|
The foreign key for the associated membership. @example 1 |
| ticket_id | int8 |
|
|
The optional foreign key for the associated ticket. @example 1 |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| auto_send_checkout_link_enabled | bool |
|
|
Whether to automatically send checkout links for this purchase order’s lines. @example true |
| auto_send_checkout_link_days_before | int4 |
|
|
Number of days before estimated_delivery_date to automatically send checkout links. Must be between 0 and 30. @example 3 |
| check_in_enabled | bool |
|
|
Whether check-in is enabled for the purchase order. @example true |
| checkout_window | int4 |
|
|
The period before and after the purchase order’s estimated delivery time that checkin/out is permitted. The number represents the number of hours. @example “48” |
| line_counter | int4 |
|
|
A counter to keep track of the number of lines added to this purchase order. Used to populate the line_number in the purchase_order_lines table. The number is not decreased if a line is removed. @example 5 |
| care_plan_summary_enabled | bool |
|
|
Indicates whether care plan summary generation is enabled for the purchase order. @example true |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_purchase_orders_pkey | Primary key | Asc | id |
| idx_edge_purchase_orders_company_id | Performance | Asc | company_id |
| idx_edge_purchase_orders_helper_id | Performance | Asc | helper_id |
| idx_edge_purchase_orders_membership_id | Performance | Asc | membership_id |
| idx_edge_purchase_orders_ticket_id | Performance | Asc | ticket_id |