Fivetran documentation

Search the docs

/

Float

Explore the interactive ERD

Table & Field Reference

task_people_id

Column	Type	Keys
`people_id`	Unknown	PKFK
`task_id`	Unknown	PKFK

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	PKFK
`tags`	Unknown

project_team

Column	Type	Keys
`people_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`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	PKFK
`phase_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`billable`	Unknown
`scheduled`	Unknown

timeoffs_people_id

Column	Type	Keys
`people_id`	Unknown	PK
`timeoff_id`	Unknown	PKFK
`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	PKFK
`type`	Unknown

people_work_day_hour

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`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