Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| purchase_order_id | int8 |
|
|
The unique purchase order ID. E.g. 49. |
| ticket_link | text |
|
|
A link to the Ticket. E.g. https://app.carecompany.com.au/admin/tickets/101. |
| helper_id | int8 |
|
|
The helper ID associated with the purchase order. E.g.: 57. |
| membership_id | int8 |
|
|
The ID of the membership associated with the purchase order. E.g. 1989. |
| ticket_id | int8 |
|
|
The ID of the ticket associated with the purchase order. E.g. 123. |
| delivery_address | text |
|
|
The address where the purchase order will be delivered. The format is |
| delivery_instructions | text |
|
|
Instructions for the purchase order provider. E.g. |
| created_at | timestamp |
|
|
The date and time created in UTC. E.g.: 2021-03-02 00:12:59. |
| updated_at | timestamp |
|
|
The date and time last updated in UTC. E.g.: 2021-03-17 22:59:01. |
| created_at_in_company_tz | timestamp |
|
|
The date and time created in the company timezone. E.g.: 2021-03-02 00:12:59. |
| updated_at_in_company_tz | timestamp |
|
|
The date and time last updated in the company timezone. E.g.: 2021-03-17 22:59:01. |
| company_id | int8 |
|
|
The company ID. E.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_purchase_orders_pkey | Primary key | Asc | purchase_order_id |
| fct_purchase_orders_company_id_idx | Performance | Asc | company_id |
| fct_purchase_orders_helper_id_idx | Performance | Asc | helper_id |
| fct_purchase_orders_membership_id_idx | Performance | Asc | membership_id |
| fct_purchase_orders_ticket_id_idx | Performance | Asc | ticket_id |