Rocketlane

Explore the interactive ERD

Table & Field Reference

space_document

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`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	PKFK
`name`	Unknown
`url`	Unknown

project_team_member

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`email_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown

project_team_customer

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`email_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown

project_field

Column	Type	Keys
`id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`label`	Unknown
`value`	Unknown
`value_label`	Unknown

project_current_phase

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`name`	Unknown

project_source

Column	Type	Keys
`template_id`	Unknown	PK
`project_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`user_id`	Unknown	PKFK

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

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	PKFK
`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	PKFK
`task_id`	Unknown	PKFK
`label`	Unknown
`value`	Unknown
`value_label`	Unknown

task_assignee_member

Column	Type	Keys
`id`	Unknown	PKFK
`task_id`	Unknown	PKFK

task_assignee_placeholder

Column	Type	Keys
`id`	Unknown	PKFK
`task_id`	Unknown	PKFK
`name`	Unknown
`role_id`	Unknown
`role_name`	Unknown

task_follower_member

Column	Type	Keys
`id`	Unknown	PKFK
`task_id`	Unknown	PKFK

task_follower_placeholder

Column	Type	Keys
`id`	Unknown	PKFK
`task_id`	Unknown	PKFK
`name`	Unknown
`role_id`	Unknown
`role_name`	Unknown

task_dependency

Column	Type	Keys
`index`	Unknown	PK
`task_dependency_id`	Unknown	PK
`task_id`	Unknown	PKFK

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