Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| membership_id | int8 |
|
|
The foreign key to the membership record. @example 1 |
| actual_invoice_line_id | int8 |
|
|
The foreign key to an optional invoice line record. @example 1 |
| projected_visit_id | int8 |
|
|
The foreign key to an optional visit record. @example 1 |
| projected_event_time_attendee_id | int8 |
|
|
The foreign key to an optional attendee record. @example 1 |
| projected_purchase_order_line_id | int8 |
|
|
The foreign key to an optional purchase order line record. @example 1 |
| occurs_at | timestamp |
|
|
The date and time at which the expense occurs. For projected expenses, this may be in the future. @example ‘2025-01-01T00:00:00Z’ |
| amount_cents | int4 |
|
|
The amount price in cents. @example 1500 |
| amount_currency | varchar |
|
|
The amount currency code. @example ‘AUD’ |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| label | varchar |
|
|
Indicates the type of expense when otherwise unrepresentable. @example: provider_travel |
| projected_time_tracking_log_id | int8 |
|
|
The foreign key to an optional time tracking log record. @example 1 |
| occurs_at_in_company_tz | timestamp |
|
|
|
| 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_budget_tracking_expenses_pkey | Primary key | Asc | id |
| idx_5e92a0930e7f6562e9db01eb370c5940 | Performance | Asc | projected_event_time_attendee_id |
| idx_7858c5e9055a2bb5e20a97e7848b4c19 | Performance | Asc | projected_purchase_order_line_id |
| idx_bbaba3b03e6f7f88a66ec8b1445a5bfa | Performance | Asc | projected_time_tracking_log_id |
| idx_edge_budget_tracking_expenses_actual_invoice_line_id | Performance | Asc | actual_invoice_line_id |
| idx_edge_budget_tracking_expenses_company_id | Performance | Asc | company_id |
| idx_edge_budget_tracking_expenses_membership_id | Performance | Asc | membership_id |
| idx_edge_budget_tracking_expenses_projected_visit_id | Performance | Asc | projected_visit_id |