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) |
|---|---|---|---|
| 0b3e41caf6bdfe5073263289ad44b47d | Performance | Asc | membership_id |
| 14b9ff393c644f4a6acd80dd513ca64b | Performance | Asc | projected_visit_id |
| 1f14479372ca014a7e00905a1c947f60 | Performance | Asc | actual_invoice_line_id |
| 4dc0e4a56147411cf36c8de11179d369 | Performance | Asc | company_id |
| 7e7bfbb39653c8ff7d4e6ae1a588e8bf | Performance | Asc | projected_time_tracking_log_id |
| be856768cf24ab6c4d1d9a12909d9129 | Performance | Asc | projected_purchase_order_line_id |
| e9488261279859f62e01c1a439f900a8 | Performance | Asc | projected_event_time_attendee_id |