Resource Management by Smartsheet

Explore the interactive ERD

Table & Field Reference

user_project

Column	Type	Keys
`project_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

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

placeholder_resource_custom_field_value

Column	Type	Keys
`id`	Unknown	PK
`placeholder_resource_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`custom_field_id`	Unknown	FK
`created_at`	Unknown
`updated_at`	Unknown
`value`	Unknown

user_availability

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