fct_purchase_orders


Description

A purchase order is created for third-party providers to order goods or services. Once a purchase order is generated for a third party, a PDF is sent to the relevant party and the order is placed. The associated fulfilment of this order is given in the fct_purchase_order_items model.

Columns

Column Type Children Parents Comments
purchase_order_id int8
fct_purchase_order_items.purchase_order_id Implied Constraint R

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
fct_tickets.ticket_id Implied Constraint R

The ID of the ticket associated with the purchase order. E.g. 123.
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
dim_companies.company_id Implied Constraint R

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

Relationships

Close relationships within degrees of separation