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) |
|---|---|---|---|
| 3d0c2f2a15a6d4b064c1d84fc9fa55b6 | Performance | Asc | projected_visit_id |
| 42c5efd71462ff6d4d9dc476c76f7539 | Performance | Asc | company_id |
| 4b4a21e0c7995e179d39b6b0c9db7510 | Performance | Asc | projected_time_tracking_log_id |
| 594ed6e0898aba28a2233041d6112b20 | Performance | Asc | actual_invoice_line_id |
| 5de9e59ba9da10033eb3a726c0a53577 | Performance | Asc | membership_id |
| 78a2d0365d13c0c5646f1d6923f40293 | Performance | Asc | projected_purchase_order_line_id |
| c1ebb907f87f46bd47ff5dd3f98bad4d | Performance | Asc | projected_event_time_attendee_id |