# Float schema ERD

Table and field reference for the Fivetran Float connector.

## Table & Field Reference

### task_people_id

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

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| parent_task_id | Unknown | FK |
| people_id | Unknown | FK |
| phase_id | Unknown | FK |
| project_id | Unknown | FK |
| root_task_id | Unknown | FK |
| billable | Unknown |  |
| created | Unknown |  |
| end_date | Unknown |  |
| hour | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| repeat_end_date | Unknown |  |
| repeat_state | Unknown |  |
| start_date | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| task_meta_id | Unknown |  |

### project_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| tags | Unknown |  |

### project_team

| Column | Type | Keys |
| --- | --- | --- |
| people_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| hourly_rate | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| client_id | Unknown | FK |
| project_manager | Unknown | FK |
| active | Unknown |  |
| all_pms_schedule | Unknown |  |
| budget_per_phase | Unknown |  |
| budget_total | Unknown |  |
| budget_type | Unknown |  |
| color | Unknown |  |
| created | Unknown |  |
| default_hourly_rate | Unknown |  |
| locked_task_list | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| non_billable | Unknown |  |
| note | Unknown |  |
| tentative | Unknown |  |

### timeoff_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| active | Unknown |  |
| approval_required | Unknown |  |
| color | Unknown |  |
| timeoff_type_name | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| name | Unknown |  |

### milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| phase_id | Unknown | FK |
| project_id | Unknown | FK |
| created | Unknown |  |
| date | Unknown |  |
| end_date | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |

### public_holiday

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dates | Json |  |
| name | Unknown |  |
| region | Unknown |  |

### client

| Column | Type | Keys |
| --- | --- | --- |
| client_id | Unknown | PK |
| name | Unknown |  |

### team_holiday

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |

### phase_team

| Column | Type | Keys |
| --- | --- | --- |
| people_id | Unknown | PK, FK |
| phase_id | Unknown | PK, FK |
| hourly_rate | Unknown |  |

### phase

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| active | Unknown |  |
| budget_total | Unknown |  |
| color | Unknown |  |
| created | Unknown |  |
| default_hourly_rate | Unknown |  |
| end_date | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| non_billable | Unknown |  |
| note | Unknown |  |
| start_date | Unknown |  |
| tentative | Unknown |  |

### status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| people_id | Unknown | FK |
| created | Unknown |  |
| end_date | Unknown |  |
| modified | Unknown |  |
| repeat_end | Unknown |  |
| repeat_state | Unknown |  |
| start_date | Unknown |  |
| status_name | Unknown |  |
| status_type_id | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department_filter_id | Unknown | FK |
| people_id | Unknown | FK |
| access | Unknown |  |
| account_type | Unknown |  |
| active | Unknown |  |
| avatar | Unknown |  |
| budget_right | Unknown |  |
| created | Unknown |  |
| department_filter | Json |  |
| edit_right | Unknown |  |
| email | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |
| view_right | Unknown |  |

### report_people

| Column | Type | Keys |
| --- | --- | --- |
| end_date | String | PK |
| start_date | String | PK |
| people_id | Unknown | PK, FK |
| billable | Unknown |  |
| capacity | Unknown |  |
| co_hour | Unknown |  |
| co_hours_history | Unknown |  |
| my_hour | Unknown |  |
| my_hours_history | Unknown |  |
| non_billable | Unknown |  |
| overtime | Unknown |  |
| scheduled | Unknown |  |
| timeoff | Unknown |  |
| unscheduled | Unknown |  |
| wk_day_hrs_** |  |  |

### report_project

| Column | Type | Keys |
| --- | --- | --- |
| end_date | String | PK |
| start_date | String | PK |
| project_id | Unknown | PK, FK |
| billable | Unknown |  |
| scheduled | Unknown |  |

### timeoffs_people_id

| Column | Type | Keys |
| --- | --- | --- |
| people_id | Unknown | PK |
| timeoff_id | Unknown | PK, FK |
| id | Unknown | FK |

### timeoff

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| status_creator_id | Unknown | FK |
| timeoff_type_id | Unknown | FK |
| created | Unknown |  |
| end_date | Unknown |  |
| full_day | Unknown |  |
| hour | Unknown |  |
| modified | Unknown |  |
| repeat_end | Unknown |  |
| repeat_state | Unknown |  |
| start_date | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| status_note | Unknown |  |
| timeoff_note | Unknown |  |

### people_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| name | Unknown | PK |
| people_id | Unknown | PK, FK |
| type | Unknown |  |

### people_work_day_hour

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| work_days_hour | Unknown |  |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department_id | Unknown | FK |
| active | Unknown |  |
| auto_email | Unknown |  |
| avatar_file | Unknown |  |
| contractor | Unknown |  |
| created | Unknown |  |
| default_hourly_rate | Unknown |  |
| email | Unknown |  |
| employee_type | Unknown |  |
| end_date | Unknown |  |
| job_title | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| non_work_day | Unknown |  |
| note | Unknown |  |
| people_type_id | Unknown |  |
| region_id | Unknown |  |
| role_id | Unknown |  |
| start_date | Unknown |  |
| work_days_hours_history | Unknown |  |

### logged_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| people_id | Unknown | FK |
| phase_id | Unknown | FK |
| project_id | Unknown | FK |
| task_id | Unknown | FK |
| billable | Unknown |  |
| created | Unknown |  |
| date | Unknown |  |
| hour | Unknown |  |
| locked | Unknown |  |
| locked_date | Unknown |  |
| modified | Unknown |  |
| note | Unknown |  |
| task_meta_id | Unknown |  |

## Relationships

- task_people_id(people_id) → people(id)
- task_people_id(task_id) → task(id)
- task(people_id) → people(id)
- task(phase_id) → phase(id)
- task(created_by) → account(id)
- task(root_task_id) → task(id)
- task(project_id) → project(id)
- task(modified_by) → account(id)
- task(parent_task_id) → task(id)
- project_tag(project_id) → project(id)
- project_team(people_id) → people(id)
- project_team(project_id) → project(id)
- project(project_manager) → account(id)
- project(client_id) → client(client_id)
- timeoff_type(created_by) → account(id)
- department(parent_id) → department(id)
- milestone(project_id) → project(id)
- milestone(phase_id) → phase(id)
- phase_team(people_id) → people(id)
- phase_team(phase_id) → phase(id)
- phase(project_id) → project(id)
- status(people_id) → people(id)
- status(created_by) → account(id)
- status(modified_by) → account(id)
- account(people_id) → people(id)
- account(department_filter_id) → department(id)
- report_people(people_id) → people(id)
- report_project(project_id) → project(id)
- timeoffs_people_id(timeoff_id) → timeoff(id)
- timeoffs_people_id(id) → people(id)
- timeoff(timeoff_type_id) → timeoff_type(id)
- timeoff(status_creator_id) → account(id)
- timeoff(created_by) → account(id)
- timeoff(modified_by) → account(id)
- people_tag(people_id) → people(id)
- people_work_day_hour(people_id) → people(id)
- people(department_id) → department(id)
- logged_time(task_id) → task(id)
- logged_time(people_id) → people(id)
- logged_time(phase_id) → phase(id)
- logged_time(created_by) → account(id)
- logged_time(project_id) → project(id)
- logged_time(modified_by) → account(id)