# Uptempo schema ERD

Table and field reference for the Fivetran Uptempo connector.

## Table & Field Reference

### finance_cell

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| finance_fivetran_id | Unknown | PK, FK |
| column_name | Unknown |  |
| value | Unknown |  |

### finance_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| finance_fivetran_id | Unknown | PK, FK |
| amortization | Json |  |
| budget_id | Unknown |  |
| budget_item_id | Unknown |  |
| percentage | Unknown |  |
| roll_over | Unknown |  |
| roll_under | Unknown |  |
| split_id | Unknown |  |

### finance

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| amount | Unknown |  |
| conflicted | Unknown |  |
| end_date | Unknown |  |
| id | Unknown |  |
| imported | Unknown |  |
| po_number | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### line_item_cell

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| line_item_id | Unknown | PK, FK |
| approval_status | Unknown |  |
| column_name | Unknown |  |
| comment | Unknown |  |
| lock_enabled | Unknown |  |
| locked | Unknown |  |
| tag_id | Unknown |  |
| value | Unknown |  |

### line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown |  |
| budget_id | Unknown |  |
| carryover | Unknown |  |
| created_date | Unknown |  |
| has_manually_allocated_investment | Unknown |  |
| locked | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| persistent_id | Unknown |  |
| scenario_id | Unknown |  |
| type | Unknown |  |
| updated_date | Unknown |  |

## Relationships

- finance_cell(finance_fivetran_id) → finance(_fivetran_id)
- finance_allocation(finance_fivetran_id) → finance(_fivetran_id)
- line_item_cell(line_item_id) → line_item(id)