# Rocketlane schema ERD

Table and field reference for the Fivetran Rocketlane connector.

## Table & Field Reference

### space_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| created_by_user_id | Unknown | FK |
| space_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| private | Unknown |  |
| template_id | Unknown |  |
| template_name | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| url | Unknown |  |

### project_partner_company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### project_team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| email_id | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### project_team_customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| email_id | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### project_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |
| value_label | Unknown |  |

### project_current_phase

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| name | Unknown |  |

### project_source

| Column | Type | Keys |
| --- | --- | --- |
| template_id | Unknown | PK |
| project_id | Unknown | PK, FK |
| prefix | Unknown |  |
| start_date | Unknown |  |
| template_name | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| customer_champion_user_id | Unknown | FK |
| customer_company_id | Unknown | FK |
| owner_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| allocated_hours | Unknown |  |
| allocated_minute | Unknown |  |
| annualized_recurring_revenue | Unknown |  |
| archived | Unknown |  |
| auto_allocation | Unknown |  |
| billable_hour | Unknown |  |
| billable_minute | Unknown |  |
| budgeted_hours | Unknown |  |
| created_at | Instant |  |
| currency_code | Unknown |  |
| currency_name | Unknown |  |
| currency_symbol | Unknown |  |
| customer_company_name | Unknown |  |
| customer_company_url | Unknown |  |
| customers_invited | Unknown |  |
| customers_joined | Unknown |  |
| due_date | Unknown |  |
| due_date_actual | Unknown |  |
| external_reference_id | Unknown |  |
| fee | Unknown |  |
| financial_contract_type | Unknown |  |
| financial_fixed_fee | Unknown |  |
| financial_metrics_actual_cost | Unknown |  |
| financial_metrics_actual_profit | Unknown |  |
| financial_metrics_actual_profit_margin | Unknown |  |
| financial_metrics_actual_revenue | Unknown |  |
| financial_metrics_estimate_at_completion | Unknown |  |
| financial_metrics_estimated_cost | Unknown |  |
| financial_metrics_estimated_profit | Unknown |  |
| financial_metrics_estimated_profit_margin | Unknown |  |
| financial_metrics_estimated_revenue | Unknown |  |
| financial_metrics_estimation_to_completion_in_hours | Unknown |  |
| financial_subscription_contract_frequency | Unknown |  |
| financial_subscription_contract_no_of_periods | Unknown |  |
| financial_subscription_contract_period_budget | Unknown |  |
| financial_subscription_contract_period_minute | Unknown |  |
| financial_subscription_contract_start_date | Unknown |  |
| financial_time_and_material_contract_project_budget | Unknown |  |
| financial_time_and_material_contract_rate_card_id | Unknown |  |
| financial_time_and_material_contract_rate_card_name | Unknown |  |
| inferred_progress | Unknown |  |
| name | Unknown |  |
| non_billable_hour | Unknown |  |
| non_billable_minute | Unknown |  |
| percentage_budget_consumed | Unknown |  |
| planned_duration_in_days | Unknown |  |
| progress_percentage | Unknown |  |
| project_age_in_days | Unknown |  |
| start_date | Unknown |  |
| start_date_actual | Unknown |  |
| status_label | Unknown |  |
| status_value | Unknown |  |
| tracked_hours | Unknown |  |
| tracked_minute | Unknown |  |
| updated_at | Instant |  |
| visibility | Unknown |  |

### space

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| created_by_user_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| private | Unknown |  |
| updated_at | Instant |  |

### timeoff_user_notification

| Column | Type | Keys |
| --- | --- | --- |
| time_off_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### time_off

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Instant |  |
| duration_in_minutes | Unknown |  |
| end_date | Unknown |  |
| note | Unknown |  |
| project_owners | Unknown |  |
| start_date | Unknown |  |
| type | Unknown |  |

### resource_allocation_task

| Column | Type | Keys |
| --- | --- | --- |
| resource_allocation_fivetran_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### resource_allocation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| created_by_user_id | Unknown | FK |
| project_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| user_id | Unknown | FK |
| allocation_for | Unknown |  |
| allocation_type | Unknown |  |
| created_at | Unknown |  |
| duration_days_consider | Unknown |  |
| duration_hours | Unknown |  |
| duration_minutes | Unknown |  |
| duration_seconds | Unknown |  |
| end_date | Unknown |  |
| hours_per_day | Unknown |  |
| minutes_per_day | Unknown |  |
| placeholder_id | Unknown |  |
| placeholder_name | Unknown |  |
| role_id | Unknown |  |
| role_name | Unknown |  |
| seconds_per_day | Unknown |  |
| start_date | Unknown |  |
| updated_at | Instant |  |

### phase

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| created_by_user_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| created_at | Unknown |  |
| due_date | Unknown |  |
| due_date_actual | Unknown |  |
| name | Unknown |  |
| private | Unknown |  |
| start_date | Unknown |  |
| start_date_actual | Unknown |  |
| status_label | Unknown |  |
| status_value | Unknown |  |
| updated_at | Instant |  |

### time_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| project_phase_id | Unknown | FK |
| task_id | Unknown | FK |
| user_id | Unknown | FK |
| activity_name | Unknown |  |
| bill_rate | Unknown |  |
| bill_rate_currency | Unknown |  |
| billable | Unknown |  |
| category_id | Unknown |  |
| category_name | Unknown |  |
| cost_rate | Unknown |  |
| cost_rate_currency | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| deleted | Boolean |  |
| minutes | Unknown |  |
| notes | Unknown |  |
| source_type | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |

### task_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |
| value_label | Unknown |  |

### task_assignee_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task_assignee_placeholder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |
| name | Unknown |  |
| role_id | Unknown |  |
| role_name | Unknown |  |

### task_follower_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task_follower_placeholder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |
| name | Unknown |  |
| role_id | Unknown |  |
| role_name | Unknown |  |

### task_dependency

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| task_dependency_id | Unknown | PK |
| task_id | Unknown | PK, FK |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| project_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| archived | Unknown |  |
| at_risk | Unknown |  |
| billable | Unknown |  |
| created_at | Instant |  |
| csat_enabled | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| due_date_actual | Unknown |  |
| effort_in_minutes | Unknown |  |
| external_reference_id | Unknown |  |
| name | Unknown |  |
| parent_task_id | Unknown |  |
| parent_task_name | Unknown |  |
| phase_id | Unknown |  |
| phase_name | Unknown |  |
| priority_label | Unknown |  |
| priority_value | Unknown |  |
| progress | Unknown |  |
| start_date | Unknown |  |
| start_date_actual | Unknown |  |
| status_label | Unknown |  |
| status_value | Unknown |  |
| task_private_note | Unknown |  |
| time_entry_category_id | Unknown |  |
| time_entry_category_name | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### field_option

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| field_id | Unknown | PK, FK |
| color | Unknown |  |
| value | Unknown |  |

### field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| enabled | Unknown |  |
| label | Unknown |  |
| object_type | Unknown |  |
| private | Unknown |  |
| rating_scale | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### user_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |
| field_value | Unknown |  |
| field_value_label | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_user_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| calender_id | Unknown |  |
| calender_name | Unknown |  |
| capacity_in_minute | Unknown |  |
| company_id | Unknown |  |
| company_name | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| permission_id | Unknown |  |
| permission_name | Unknown |  |
| profile_picture_url | Unknown |  |
| role_id | Unknown |  |
| role_name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

## Relationships

- space_document(space_id) → space(id)
- space_document(created_by_user_id) → users(id)
- space_document(updated_by_user_id) → users(id)
- space_document(project_id) → project(id)
- project_partner_company(project_id) → project(id)
- project_team_member(project_id) → project(id)
- project_team_customer(project_id) → project(id)
- project_field(id) → field(id)
- project_field(project_id) → project(id)
- project_current_phase(project_id) → project(id)
- project_source(project_id) → project(id)
- project(customer_company_id) → project_partner_company(id)
- project(owner_id) → project_team_member(id)
- project(customer_champion_user_id) → project_team_customer(id)
- project(updated_by_id) → project_team_member(id)
- project(created_by_id) → project_team_member(id)
- space(created_by_user_id) → users(id)
- space(updated_by_user_id) → users(id)
- space(project_id) → project(id)
- timeoff_user_notification(user_id) → users(id)
- timeoff_user_notification(time_off_id) → time_off(id)
- time_off(user_id) → users(id)
- resource_allocation_task(task_id) → task(id)
- resource_allocation_task(resource_allocation_fivetran_id) → resource_allocation(_fivetran_id)
- resource_allocation(user_id) → users(id)
- resource_allocation(updated_by_user_id) → users(id)
- resource_allocation(created_by_user_id) → users(id)
- resource_allocation(project_id) → project(id)
- phase(updated_by_user_id) → users(id)
- phase(created_by_user_id) → users(id)
- phase(project_id) → project(id)
- time_entry(user_id) → project_team_member(id)
- time_entry(task_id) → task(id)
- time_entry(project_phase_id) → project_current_phase(id)
- time_entry(project_id) → project(id)
- task_field(id) → field(id)
- task_field(task_id) → task(id)
- task_assignee_member(id) → project_team_member(id)
- task_assignee_member(task_id) → task(id)
- task_assignee_placeholder(id) → project_team_member(id)
- task_assignee_placeholder(task_id) → task(id)
- task_follower_member(id) → project_team_member(id)
- task_follower_member(task_id) → task(id)
- task_follower_placeholder(id) → project_team_member(id)
- task_follower_placeholder(task_id) → task(id)
- task_dependency(task_id) → task(id)
- task(updated_by_id) → project_team_member(id)
- task(created_by_id) → project_team_member(id)
- task(project_id) → project(id)
- field_option(field_id) → field(id)
- field(updated_by_id) → project_team_member(id)
- field(created_by_id) → project_team_member(id)
- user_field(id) → field(id)
- user_field(users_id) → users(id)
- users(updated_by_user_id) → users(id)
- users(created_by_user_id) → users(id)