Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| source_type | varchar |
|
|
The type of the source of the invoice. @example: ‘Visit’ |
| source_id | int8 |
|
|
The foreign key of the source of the invoice. The associated table can vary by row and depends on the value of source_type. @example: 1 |
| helper_viewer_id | int8 |
|
|
Foreign key to the helper viewer. @example: 1 |
| membership_viewer_id | int8 |
|
|
Foreign key to the membership viewer. @example: 1 |
| issuer_id | int8 |
|
|
Foreign key to the recipient profile. @example: 1 |
| recipient_id | int8 |
|
|
Foreign key to the recipient profile. @example: 1 |
| billing_run_id | int8 |
|
|
Foreign key to the billing run. @example: 1 |
| standard_invoice_id | int8 |
|
|
Foreign key to the corresponding invoice. @example 1 |
| company_id | int8 |
|
|
Foreign key to the tenant company. @example 1 |
| created_at | timestamp |
|
|
|
| updated_at | 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_independent_contractor_invoices_pkey | Primary key | Asc | id |
| idx_00823ec725eab21b752b2ef01348140f | Performance | Asc | standard_invoice_id |
| idx_aa8917e513395d6306fb9e9520cd70ba | Performance | Asc | membership_viewer_id |
| idx_edge_independent_contractor_invoices_billing_run_id | Performance | Asc | billing_run_id |
| idx_edge_independent_contractor_invoices_company_id | Performance | Asc | company_id |
| idx_edge_independent_contractor_invoices_helper_viewer_id | Performance | Asc | helper_viewer_id |
| idx_edge_independent_contractor_invoices_issuer_id | Performance | Asc | issuer_id |
| idx_edge_independent_contractor_invoices_recipient_id | Performance | Asc | recipient_id |
| idx_edge_independent_contractor_invoices_source_id | Performance | Asc | source_id |