Tempo

Explore the interactive ERD

Table & Field Reference

timesheet_approval

Column	Type	Keys
`_fivetran_id`	String	PK
`team_id`	Long	FK
`period_from`	String
`period_to`	String
`required_seconds`	Long
`reviewer_account_id`	String
`status_account_id`	String
`status_comment`	String
`status_key`	String
`status_required_seconds_at_submit`	Long
`status_time_spent_seconds_at_submit`	Long
`status_updated_at`	Instant
`time_spent_seconds`	Long
`user_account_id`	String

role

Column	Type	Keys
`id`	Long	PK
`is_default`	Boolean
`name`	String

holiday_member

Column	Type	Keys
`_fivetran_id`	String	PK
`holiday_scheme_id`	Long	FK
`account_id`	String

global_configuration

Column	Type	Keys
`_fivetran_id`	String	PK
`allow_logging_on_closed_account`	Boolean
`approval_period`	String
`approval_week_start`	Long
`max_hours_per_day_per_user`	Long
`number_of_days_allowed_into_future`	Long
`remaining_estimate_optional`	Boolean
`week_start`	Long
`worklog_description_optional`	Boolean

timesheet_reviewer

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Long	FK
`reviewer_account_id`	String

workload_member

Column	Type	Keys
`_fivetran_id`	String	PK
`workload_scheme_id`	Long	FK
`account_id`	String

team_membership

Column	Type	Keys
`id`	Long	PK
`role_id`	Long	FK
`team_id`	Long	FK
`commitment_percent`	Long
`from_date`	Unknown
`member_account_id`	String
`to_date`	Unknown

program_team_value

Column	Type	Keys
`program_id`	Long	PKFK
`team_id`	Long	PKFK

program

Column	Type	Keys
`id`	Long	PK
`manager_account_id`	String
`name`	String

work_attribute

Column	Type	Keys
`key`	String	PK
`name`	String
`required`	Boolean
`some_value`	String
`type`	String
`values`	Json

holiday

Column	Type	Keys
`id`	Long	PK
`scheme_id`	Long	FK
`date`	LocalDate
`description`	String
`duration_seconds`	Long
`name`	String
`type`	String

generic_resource

Column	Type	Keys
`id`	Long	PK
`team_id`	Long	FK
`name`	String

plan_period_value

Column	Type	Keys
`_fivetran_id`	String	PK
`plan_id`	Long	FK
`from_date`	Unknown
`planned_seconds`	Long
`to_date`	Unknown

planned_time_day_value

Column	Type	Keys
`_fivetran_id`	String	PK
`plan_id`	Long	FK
`date`	LocalDate
`planned_seconds`	Long

plan

Column	Type	Keys
`id`	Long	PK
`assignee_id`	String
`assignee_type`	String
`created_at`	Instant
`description`	String
`effort_persistence_type`	String
`end_date`	LocalDate
`include_non_working_days`	Boolean
`period_count`	Long
`plan_approval_account_id`	String
`plan_approval_status`	String
`plan_creator_id`	String
`plan_item_id`	Int
`plan_item_type`	String
`planned_seconds_per_day`	Long
`planned_time_day_count`	Long
`recurrence_end_date`	LocalDate
`rule`	String
`start_date`	LocalDate
`start_time`	String
`total_planned_seconds`	Long
`total_planned_seconds_in_scope`	Long
`updated_at`	Instant

user_schedule

Column	Type	Keys
`_fivetran_id`	String	PK
`holiday_id`	Long	FK
`scheme_id`	Long	FK
`date`	LocalDate
`required_seconds`	Long
`type`	String

workload_scheme_day

Column	Type	Keys
`_fivetran_id`	String	PK
`workload_scheme_id`	Long	FK
`day`	String
`required_seconds`	Long

workload_scheme

Column	Type	Keys
`id`	Long	PK
`default_scheme`	Boolean
`description`	String
`member_count`	Long
`name`	String

holiday_scheme

Column	Type	Keys
`id`	Long	PK
`default_scheme`	Boolean
`description`	String
`member_count`	Long
`name`	String

worklog_audit_description

Column	Type	Keys
`index`	Unknown	PK
`worklog_audit_entity_id`	Unknown	FK
`worklog_audit_worklog_timestamp`	Unknown	FK
`change_field`	String
`new_value`	String
`previous_value`	String

worklog_audit

Column	Type	Keys
`entity_id`	Unknown	PK
`worklog_timestamp`	Unknown	PK
`action`	Unknown
`author`	Unknown
`parent_id`	Unknown
`worker`	Unknown

team

Column	Type	Keys
`id`	Long	PK
`program_id`	Long	FK
`lead_account_id`	String
`name`	String
`summary`	String

global_permission_access_entity

Column	Type	Keys
`id`	Long	PK
`global_permission_role_id`	Long	PKFK

global_permission

Column	Type	Keys
`key`	String	PK
`global_permission_role_id`	Long	PKFK

global_permitted_user

Column	Type	Keys
`account_id`	String	PK
`global_permission_role_id`	Long	PKFK

global_permission_role

Column	Type	Keys
`id`	Long	PK
`access_type`	String
`editable`	Boolean
`name`	String

worklog_attribute_value

Column	Type	Keys
`_fivetran_id`	String	PK
`key`	String	FK
`worklog_worklog_id`	Long	FK
`value`	String

worklog

Column	Type	Keys
`worklog_id`	Long	PK
`author_account_id`	String
`billable_seconds`	Long
`created_at`	Instant
`description`	String
`issue_id`	Long
`issue_key`	String
`jira_worklog_id`	Long
`start_date`	LocalDate
`start_time`	String
`time_spent_seconds`	Long
`updated_at`	Instant

permission_access_entity

Column	Type	Keys
`id`	Long	PK
`permission_role_id`	Long	FK

permission

Column	Type	Keys
`key`	String	PK
`permission_role_id`	Long	FK

permission_role

Column	Type	Keys
`id`	Long	PK
`access_type`	String
`editable`	Boolean
`name`	String
`permitted_account_id`	String

account

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	FK
`category_id`	Long
`category_key`	String
`category_name`	String
`category_type_name`	String
`contact_account_id`	String
`contact_type`	String
`global`	Boolean
`key`	String
`lead_account_id`	String
`monthly_budget`	Long
`name`	String
`status`	String

customer

Column	Type	Keys
`id`	Long	PK
`key`	String
`name`	String