# Resource Management by Smartsheet schema ERD

Table and field reference for the Fivetran Resource Management by Smartsheet connector.

## Table & Field Reference

### user_project

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

### assignable

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| parent_id | Unknown | FK |
| project_state_id | Unknown | FK |
| client | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Instant |  |
| description | Unknown |  |
| ends_at | Unknown |  |
| guid | Unknown |  |
| name | Unknown |  |
| phase_name | Unknown |  |
| secure_url | Unknown |  |
| secure_url_expiration | Unknown |  |
| settings | Unknown |  |
| starts_at | Unknown |  |
| thumbnail | Unknown |  |
| time_entry_lockout | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| data_type | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| is_editable_only_by_admins | Unknown |  |
| is_visible_as_filter | Unknown |  |
| is_visible_on_info_page | Unknown |  |
| name | Unknown |  |
| namespace | Unknown |  |
| updated_at | Unknown |  |

### custom_field_option

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| custom_field_id | Unknown | FK |
| option | Unknown |  |

### approval

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approvable_id | Unknown | FK |
| approvee_user_id | Unknown | FK |
| approver_user_id | Unknown | FK |
| approvable_type | Unknown |  |
| approved_at | Unknown |  |
| created_at | Unknown |  |
| status | Unknown |  |
| submitted_at | Unknown |  |
| updated_at | Instant |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| value | Unknown |  |

### phase

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| project_id | Unknown | FK |
| archived | Unknown |  |
| archived_at | Unknown |  |
| client | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| ends_at | Unknown |  |
| guid | Unknown |  |
| has_pending_updates | Unknown |  |
| name | Unknown |  |
| phase_name | Unknown |  |
| secure_url | Unknown |  |
| secure_url_expiration | Unknown |  |
| settings | Unknown |  |
| starts_at | Unknown |  |
| thumbnail | Unknown |  |
| time_entry_lockout | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| use_parent_bill_rates | Unknown |  |

### status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignable_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| current_task | Unknown |  |
| ends | Unknown |  |
| message | Unknown |  |
| start | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### time_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignable_id | Unknown | FK |
| bill_rate_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| date | Unknown |  |
| hours | Unknown |  |
| is_suggestion | Unknown |  |
| note | Unknown |  |
| scheduled_hours | Unknown |  |
| task | Unknown |  |
| updated_at | Instant |  |

### discipline

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| value | Unknown |  |

### status_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Instant |  |
| label | Unknown |  |
| orders | Unknown |  |
| stage | Unknown |  |
| updated_at | Unknown |  |

### assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignable_id | Unknown | FK |
| bill_rate_id | Unknown | FK |
| status_option_id | Unknown | FK |
| user_id | Unknown | FK |
| all_day_assignment | Unknown |  |
| allocation_mode | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| ends_at | Unknown |  |
| hours_per_day | Unknown |  |
| note | Unknown |  |
| repetition_id | Unknown |  |
| resource_request_id | Unknown |  |
| starts_at | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |

### bill_rate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignable_id | Unknown | FK |
| discipline_id | Unknown | FK |
| role_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| ends_at | Unknown |  |
| rate | Unknown |  |
| starts_at | Unknown |  |
| updated_at | Unknown |  |

### project_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| custom_field_id | Unknown | FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |
| value | Json |  |

### project_budget_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| assignable_id | Unknown | FK |
| assignable_parent_id | Unknown | FK |
| amount | Unknown |  |
| category | Unknown |  |
| created_at | Unknown |  |
| per_item_amount | Unknown |  |
| per_item_label | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### project_tag

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

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| parent_id | Unknown | FK |
| approved_dollars | Unknown |  |
| approved_hours | Unknown |  |
| archived | Unknown |  |
| archived_at | Unknown |  |
| bounding_end_date | Unknown |  |
| bounding_end_date_assignables | Unknown |  |
| bounding_end_date_assignments | Unknown |  |
| bounding_end_date_expense_items | Unknown |  |
| bounding_end_date_time_entries | Unknown |  |
| bounding_start_date | Unknown |  |
| bounding_start_date_assignables | Unknown |  |
| bounding_start_date_assignments | Unknown |  |
| bounding_start_date_expense_items | Unknown |  |
| bounding_start_date_time_entries | Unknown |  |
| client | Unknown |  |
| code | Unknown |  |
| confirmed_dollars | Unknown |  |
| confirmed_hours | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Instant |  |
| description | Unknown |  |
| employee_number | Unknown |  |
| ends_at | Unknown |  |
| future_dollars | Unknown |  |
| future_hours | Unknown |  |
| guid | Unknown |  |
| has_pending_updates | Unknown |  |
| name | Unknown |  |
| scheduled_dollars | Unknown |  |
| scheduled_hours | Unknown |  |
| secure_url | Unknown |  |
| secure_url_expiration | Unknown |  |
| settings | Unknown |  |
| starts_at | Unknown |  |
| state | Unknown |  |
| state_id | Unknown |  |
| thumbnail | Unknown |  |
| time_entry_lockout | Unknown |  |
| type | Unknown |  |
| unconfirmed_dollars | Unknown |  |
| unconfirmed_hours | Unknown |  |
| updated_at | Instant |  |
| use_parent_bill_rates | Unknown |  |

### project_expense_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| assignable_id | Unknown | FK |
| amount | Unknown |  |
| category | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| note | Unknown |  |
| updated_at | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_id | Unknown | FK |
| user_id | Unknown | FK |
| date | Unknown |  |
| difference_from_past_scheduled_hours | Unknown |  |
| future_scheduled_hours | Unknown |  |
| incurred_hours | Unknown |  |
| leave_type | Unknown |  |
| scheduled_hours | Unknown |  |
| total_hours | Unknown |  |

### placeholder_resource_assignment

| Column | Type | Keys |
| --- | --- | --- |
| assignment_id | Unknown | PK, FK |
| placeholder_resource_id | Unknown | PK, FK |

### placeholder_resource_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| placeholder_resource_id | Unknown | PK, FK |
| custom_field_id | Unknown | FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### placeholder_resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_type_id | Unknown | FK |
| abbreviation | Unknown |  |
| bill_rate | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| discipline | Unknown |  |
| display_name | Unknown |  |
| guid | Unknown |  |
| location | Unknown |  |
| role | Unknown |  |
| thumbnail | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### user_expense_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| assignable_id | Unknown | FK |
| amount | Unknown |  |
| category | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| note | Unknown |  |
| updated_at | Unknown |  |

### user_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| custom_field_id | Unknown | FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### user_availability

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |
| day_0 | Unknown |  |
| day_1 | Unknown |  |
| day_2 | Unknown |  |
| day_3 | Unknown |  |
| day_4 | Unknown |  |
| day_5 | Unknown |  |
| day_6 | Unknown |  |
| ends_at | Unknown |  |
| starts_at | Unknown |  |
| updated_at | Unknown |  |

### user_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| value | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_owner | Unknown |  |
| archived | Unknown |  |
| archived_at | Unknown |  |
| bill_rate | Unknown |  |
| billability_target | Unknown |  |
| billable | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| deleted_at | Unknown |  |
| discipline | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| guid | Unknown |  |
| has_login | Unknown |  |
| hire_date | Unknown |  |
| invitation_pending | Unknown |  |
| last_login_time | Unknown |  |
| last_name | Unknown |  |
| license_type | Unknown |  |
| location | Unknown |  |
| location_id | Unknown |  |
| login_type | Unknown |  |
| mobile_phone | Unknown |  |
| office_phone | Unknown |  |
| role | Unknown |  |
| settings | Unknown |  |
| termination_date | Unknown |  |
| thumbnail | Unknown |  |
| type | Unknown |  |
| type_id | Unknown |  |
| updated_at | Instant |  |

## Relationships

- user_project(project_id) → project(id)
- user_project(user_id) → users(id)
- assignable(project_state_id) → project(state_id)
- assignable(owner_id) → users(id)
- assignable(parent_id) → assignable(id)
- custom_field_option(custom_field_id) → custom_field(id)
- approval(approvable_id) → project_expense_item(id)
- approval(approvee_user_id) → users(id)
- approval(approver_user_id) → users(id)
- phase(owner_id) → users(id)
- phase(project_id) → project(id)
- status(user_id) → users(id)
- status(assignable_id) → assignable(id)
- time_entry(user_id) → users(id)
- time_entry(assignable_id) → assignable(id)
- time_entry(bill_rate_id) → bill_rate(id)
- assignment(user_id) → users(id)
- assignment(status_option_id) → status_option(id)
- assignment(assignable_id) → assignable(id)
- assignment(bill_rate_id) → bill_rate(id)
- bill_rate(user_id) → users(id)
- bill_rate(discipline_id) → discipline(id)
- bill_rate(assignable_id) → assignable(id)
- bill_rate(role_id) → role(id)
- project_custom_field_value(custom_field_id) → custom_field(id)
- project_custom_field_value(project_id) → project(id)
- project_budget_item(assignable_parent_id) → assignable(id)
- project_budget_item(assignable_id) → assignable(id)
- project_budget_item(project_id) → project(id)
- project_tag(project_id) → project(id)
- project(owner_id) → users(id)
- project(parent_id) → project(id)
- project_expense_item(assignable_id) → assignable(id)
- project_expense_item(project_id) → project(id)
- report(user_id) → users(id)
- report(project_id) → project(id)
- placeholder_resource_assignment(assignment_id) → assignment(id)
- placeholder_resource_assignment(placeholder_resource_id) → placeholder_resource(id)
- placeholder_resource_custom_field_value(custom_field_id) → custom_field(id)
- placeholder_resource_custom_field_value(placeholder_resource_id) → placeholder_resource(id)
- placeholder_resource(user_type_id) → users(type_id)
- user_expense_item(assignable_id) → assignable(id)
- user_expense_item(user_id) → users(id)
- user_custom_field_value(custom_field_id) → custom_field(id)
- user_custom_field_value(user_id) → users(id)
- user_availability(user_id) → users(id)
- user_tag(user_id) → users(id)