Autodesk BIM 360 & Construction Cloud
Explore the interactive ERD
Table & Field Reference
iq_issues_quality_risk
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
predicted_at | Unknown | |
risk | Unknown | |
updated_at | Unknown | |
user_risk | Unknown |
markup_layer
| Column | Type | Keys |
|---|---|---|
uid | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
base_entity_uid | Unknown | |
base_entity_urn | Unknown | |
name | Unknown | |
promotable | Unknown | |
surface_type | Unknown | |
surface_uid | Unknown |
status_step_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
status_step_set_id | Unknown | FK |
bucket | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
description | Unknown | |
is_active | Unknown | |
label | Unknown | |
sort_order | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
version | Unknown |
status_step
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
description | Unknown | |
is_active | Unknown | |
is_default | Unknown | |
name | Unknown | |
updated_at | Instant | |
updated_by | Unknown | |
version | Unknown |
transmittal_recipient
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
user_id | Unknown | FK |
company_name | Unknown | |
created_at | Unknown | |
downloaded_at | Unknown | |
updated_at | Unknown | |
viewed_at | Unknown | |
workflow_transmittal_id | Unknown |
schedule_activity_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_unique_id | Unknown | FK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
schedule_id | Unknown | FK |
created_at | Unknown | |
name | Unknown | |
updated_at | Unknown | |
value | Unknown | |
value_description | Unknown |
issue_permitted_action
| Column | Type | Keys |
|---|---|---|
permitted_action | Unknown | PK |
issue_id | Unknown | PKFK |
issue_permitted_attribute
| Column | Type | Keys |
|---|---|---|
permitted_attribute | Unknown | PK |
issue_id | Unknown | PKFK |
issue_permitted_status
| Column | Type | Keys |
|---|---|---|
permitted_status | Unknown | PK |
issue_id | Unknown | PKFK |
issue_watcher
| Column | Type | Keys |
|---|---|---|
watcher | Unknown | PK |
issue_id | Unknown | PKFK |
issue_gps_coordinate
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
issue_id | Unknown | FK |
latitude | Unknown | |
longitude | Unknown |
issue_custom_attribute
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
attribute_definition_id | Unknown | FK |
issue_id | Unknown | FK |
title | Unknown | |
type | Unknown | |
value | Unknown |
issue_linked_document
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
issue_id | Unknown | FK |
closed_at | Unknown | |
closed_at_version | Unknown | |
closed_by | Unknown | |
created_at | Unknown | |
created_at_version | Unknown | |
created_by | Unknown | |
details_external_id | Unknown | |
details_is_3_d | Unknown | |
details_name | Unknown | |
details_object_id | Unknown | |
details_position_x | Unknown | |
details_position_y | Unknown | |
details_position_z | Unknown | |
details_viewable_guid | Unknown | |
details_viewable_id | Unknown | |
details_viewer_state | Unknown | |
type | Unknown | |
urn | Unknown |
issue
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
container_id | Unknown | FK |
issue_subtype_id | Unknown | FK |
issue_type_id | Unknown | FK |
project_id | Unknown | FK |
root_cause_id | Unknown | FK |
assigned_to | Unknown | |
assigned_to_type | Unknown | |
attachment_count | Unknown | |
closed_at | Unknown | |
closed_by | Unknown | |
comment_count | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
deleted | Unknown | |
description | Unknown | |
display_id | Unknown | |
due_date | Unknown | |
issue_template_id | Unknown | |
linked_documents | Json | |
links | Json | |
location_details | Unknown | |
location_id | Unknown | |
official_response | Json | |
opened_at | Unknown | |
opened_by | Unknown | |
owner_id | Unknown | |
published | Unknown | |
snapshot_urn | Unknown | |
start_date | Unknown | |
status | Unknown | |
updated_at | Instant | |
updated_by | Unknown |
meeting_minute_non_member_participant
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
meeting_id | Unknown | FK |
company | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
status | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
iq_rfis_discipline
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
discipline | Unknown | |
predicted_at | Unknown | |
updated_at | Unknown |
submittal_acc_task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
step_id | Unknown | FK |
assigned_to | Unknown | |
assigned_to_type | Unknown | |
completed_at | Unknown | |
completed_by | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
is_required | Unknown | |
responded_at | Unknown | |
responded_by | Unknown | |
response_comment | Unknown | |
response_id | Unknown | |
response_value | Unknown | |
started_at | Unknown | |
status | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
sheet_tag
| Column | Type | Keys |
|---|---|---|
value | Unknown | PK |
sheet_id | Unknown | PKFK |
meeting_minute_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
topic_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
cross_series_id | Unknown | |
deleted_at | Unknown | |
description | Unknown | |
due_date | Unknown | |
order_index | Unknown | |
status | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
schedule_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
schedule_id | Unknown | FK |
actual_duration | Unknown | |
actual_finish | Unknown | |
actual_start | Unknown | |
completion_percentage | Unknown | |
created_at | Unknown | |
duration | Unknown | |
file_activity_id | Unknown | |
finish | Unknown | |
free_slack_duration | Unknown | |
free_slack_unit | Unknown | |
is_critical_path | Unknown | |
is_wbs | Unknown | |
name | Unknown | |
parent_unique_id | Unknown | |
planned_finish | Unknown | |
planned_start | Unknown | |
remaining_duration | Unknown | |
sequential_id | Unknown | |
start | Unknown | |
total_slack_duration | Unknown | |
total_slack_unit | Unknown | |
type | Unknown | |
unique_id | Unknown | |
updated_at | Unknown | |
wbs_code | Unknown | |
wbs_path | Unknown | |
wbs_path_text | Unknown |
issue_attribute_permitted_action
| Column | Type | Keys |
|---|---|---|
permitted_action | Unknown | PK |
issue_attribute_id | Unknown | PKFK |
issue_attribute_permitted_attribute
| Column | Type | Keys |
|---|---|---|
permitted_attribute | Unknown | PK |
issue_attribute_id | Unknown | PKFK |
issue_attribute_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
issue_attribute_id | Unknown | PKFK |
value | Unknown |
issue_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
container_id | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
data_type | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
description | Unknown | |
is_required_default | Unknown | |
title | Unknown | |
updated_at | Instant | |
updated_by | Unknown |
closed_clash_group
| Column | Type | Keys |
|---|---|---|
clash_group_id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
clash_test_id | Unknown | FK |
issue_id | Unknown | FK |
created_at | Unknown | |
created_at_model_set_version | Unknown | |
created_by | Unknown | |
description | Unknown | |
model_set_id | Unknown | |
reason | Unknown | |
title | Unknown |
iq_cost_impact_issue
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
cost_impact | Unknown | |
predicted_at | Unknown | |
updated_at | Unknown |
iq_company_daily_quality_risk_change
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | |
company_id | Unknown | |
created_at | Unknown | |
daily_risk | Unknown | |
daily_risk_indicator | Unknown | |
start_time | Unknown | |
updated_at | Unknown |
issue_attribute_mapping
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attribute_definition_id | Unknown | FK |
project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
is_required | Unknown | |
mapped_item_id | Unknown | |
mapped_item_type | Unknown | |
orders | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
admin_project_user_product
| Column | Type | Keys |
|---|---|---|
product_key | Unknown | PK |
bim_360_account_id | Unknown | PKFK |
bim_360_project_id | Unknown | PKFK |
user_id | Unknown | PKFK |
created_at | Unknown |
admin_project_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
name | Unknown | |
status | Unknown |
group_permission
| Column | Type | Keys |
|---|---|---|
permission | Unknown | PK |
form_template_id | Unknown | PKFK |
template_group_permission_index | Unknown | PKFK |
template_group_permission
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
form_template_id | Unknown | PKFK |
role_key | Unknown | |
role_name | Unknown |
user_permission
| Column | Type | Keys |
|---|---|---|
permission | Unknown | PK |
form_template_id | Unknown | PKFK |
template_user_permission_user_id | Unknown | PKFK |
template_user_permission
| Column | Type | Keys |
|---|---|---|
user_id | Unknown | PK |
form_template_id | Unknown | PKFK |
form_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
created_at | Unknown | |
is_pdf | Unknown | |
name | Unknown | |
pdf_url | Unknown | |
status | Unknown | |
template_type | Unknown | |
updated_at | Unknown |
custom_attribute_enum_value
| Column | Type | Keys |
|---|---|---|
enum_value | Unknown | PK |
custom_attribute_id | Unknown | PKFK |
custom_attribute_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_attribute_id | Unknown | FK |
project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
display_name | Unknown | |
is_active | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
version | Unknown |
custom_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
data_type | Unknown | |
default_value | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
description | Unknown | |
display_name | Unknown | |
is_active | Unknown | |
max_length_on_ingress | Unknown | |
name | Unknown | |
required_on_ingress | Unknown | |
updated_at | Instant | |
updated_by | Unknown | |
version | Unknown |
asset_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
description | Unknown | |
label | Unknown | |
sort_order | Unknown | |
status_set_id | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
version | Unknown |
submittal_acc_item_revision
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
item_id | Unknown | FK |
created_at | Unknown | |
manager | Unknown | |
manager_due_date | Unknown | |
manager_type | Unknown | |
published_by | Unknown | |
published_date | Unknown | |
received_from_review | Unknown | |
received_from_submitter | Unknown | |
responded_at | Unknown | |
responded_by | Unknown | |
response_comment | Unknown | |
response_id | Unknown | |
revision | Unknown | |
sent_to_review | Unknown | |
sent_to_review_by | Unknown | |
sent_to_submitter | Unknown | |
subcontractor | Unknown | |
subcontractor_type | Unknown | |
submitted_by | Unknown | |
submitter_due_date | Unknown | |
updated_at | Unknown |
sheet_set
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
created_by_name | Unknown | |
issuance_date | Unknown | |
name | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
updated_by_name | Unknown |
submittal_acc_spec
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
identifier | Unknown | |
title | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
admin_project_user_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | PKFK |
project_id | Unknown | PKFK |
user_id | Unknown | PKFK |
created_at | Unknown |
asset
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
project_id | Unknown | FK |
status_id | Unknown | FK |
barcode | Unknown | |
client_asset_id | Unknown | |
company_id | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
description | Unknown | |
is_active | Unknown | |
location_id | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
version | Unknown | |
custom_** |
form_layout_table_column
| Column | Type | Keys |
|---|---|---|
uid | Unknown | PK |
layout_uid | Unknown | FK |
column_key | Unknown | |
column_type | Unknown | |
expression | Unknown | |
label | Unknown | |
presets | Unknown | |
section_item_uid | Unknown | |
sort_index | Unknown | |
value_name | Unknown | |
values_provider | Unknown |
submittal_acc_step
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
item_id | Unknown | FK |
completed_at | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
days_to_respond | Unknown | |
due_date | Unknown | |
started_at | Unknown | |
status | Unknown | |
step_number | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
project_scope
| Column | Type | Keys |
|---|---|---|
scope | Unknown | PK |
project_id | Unknown | PKFK |
project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hub_id | Unknown | FK |
attributes_name | Unknown | |
attributes_project_type | Unknown | |
attributes_region | Unknown | |
attributes_type | Unknown | |
attributes_version | Unknown | |
checklist_id | Unknown | |
checklist_type | Unknown | |
cost_id | Unknown | |
cost_type | Unknown | |
issue_container_id | Unknown | |
issue_type | Unknown | |
location_id | Unknown | |
location_type | Unknown | |
markup_id | Unknown | |
markup_type | Unknown | |
rfi_container_id | Unknown | |
rfi_type | Unknown | |
root_folder_id | Unknown | |
root_folder_type | Unknown | |
submittals_id | Unknown | |
submittals_type | Unknown | |
type | Unknown |
admin_project_user
| Column | Type | Keys |
|---|---|---|
bim_360_account_id | Unknown | PKFK |
bim_360_project_id | Unknown | PKFK |
user_id | Unknown | PKFK |
created_at | Unknown | |
updated_at | Unknown |
admin_project_user_company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | PKFK |
user_id | Unknown | PKFK |
bim_360_account_id | Unknown | FK |
submittal_acc_item_watcher
| Column | Type | Keys |
|---|---|---|
user_id | Unknown | PK |
item_id | Unknown | PKFK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
user_type_id | Unknown | |
user_type_value | Unknown |
submittal_acc_item_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
is_active | Unknown | |
platform_id | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
value | Unknown |
form_layout_section
| Column | Type | Keys |
|---|---|---|
uid | Unknown | PK |
assignee_id | Unknown | FK |
layout_uid | Unknown | FK |
assignee_type | Unknown | |
description | Unknown | |
display_index | Unknown | |
form_section_id | Unknown | |
label | Unknown | |
sort_index | Unknown |
assigned_clash_group
| Column | Type | Keys |
|---|---|---|
clash_group_id | Unknown | PK |
bim_360_account_id | Unknown | PKFK |
bim_360_project_id | Unknown | PKFK |
issue_id | Unknown | PKFK |
clash_test_id | Unknown | FK |
created_at | Unknown | |
created_at_model_set_version | Unknown | |
created_by | Unknown | |
description | Unknown | |
model_set_id | Unknown | |
status | Unknown | |
title | Unknown |
clash_group_to_clash_id
| Column | Type | Keys |
|---|---|---|
clash_group_id | Unknown | PK |
clash_id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
clash_test_id | Unknown | FK |
issue_id | Unknown | FK |
form_layout
| Column | Type | Keys |
|---|---|---|
uid | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
description | Unknown | |
has_section_assignee | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
user_created_at | Unknown |
iq_rfis_high_risk
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
predicted_at | Unknown | |
risk | Unknown | |
score | Unknown | |
updated_at | Unknown |
project_acc_product
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
project_id | Unknown | PKFK |
icon | Unknown | |
languages | Unknown | |
name | Unknown | |
status | Unknown |
project_acc
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hub_id | Unknown | PKFK |
account_id | Unknown | |
address_line_1 | Unknown | |
address_line_2 | Unknown | |
admin_group_id | Unknown | |
business_unit_id | Unknown | |
city | Unknown | |
classification | Unknown | |
company_count | Unknown | |
construction_type | Unknown | |
contract_type | Unknown | |
country | Unknown | |
created_at | Unknown | |
current_phase | Unknown | |
delivery_method | Unknown | |
end_date | Unknown | |
image_url | Unknown | |
job_number | Unknown | |
last_sign_in | Unknown | |
latitude | Unknown | |
longitude | Unknown | |
member_count | Unknown | |
member_group_id | Unknown | |
name | Unknown | |
platform | Unknown | |
postal_code | Unknown | |
project_currency | Unknown | |
project_value | Unknown | |
sheet_count | Unknown | |
start_date | Unknown | |
state_or_province | Unknown | |
status | Unknown | |
template_id | Unknown | |
thumbnail_image_url | Unknown | |
timezone | Unknown | |
type | Unknown | |
updated_at | Instant |
submittal_acc_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
item_id | Unknown | FK |
task_id | Unknown | FK |
category_id | Unknown | |
category_value | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
is_file_uploaded | Unknown | |
name | Unknown | |
revision | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
upload_urn | Unknown | |
urn | Unknown |
location_node
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
parent_id | Unknown | FK |
created_at | Unknown | |
name | Unknown | |
orders | Unknown | |
tree_id | Unknown | |
updated_at | Unknown |
rfi_co_reviewer
| Column | Type | Keys |
|---|---|---|
reviewer | Unknown | PK |
rfi_id | Unknown | PKFK |
rfi_distribution_list
| Column | Type | Keys |
|---|---|---|
distribution | Unknown | PK |
rfi_id | Unknown | PKFK |
rfi_discipline
| Column | Type | Keys |
|---|---|---|
discipline | Unknown | PK |
rfi_id | Unknown | PKFK |
rfi_category
| Column | Type | Keys |
|---|---|---|
category | Unknown | PK |
rfi_id | Unknown | PKFK |
rfi
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
container_id | Unknown | FK |
project_id | Unknown | FK |
answered_at | Unknown | |
answered_by | Unknown | |
architect_id | Unknown | |
assigned_to | Unknown | |
assigned_to_type | Unknown | |
attachments_count | Unknown | |
closed_at | Unknown | |
closed_by | Unknown | |
comments_count | Unknown | |
construction_manager_id | Unknown | |
cost_impact | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
custom_identifier | Unknown | |
due_date | Unknown | |
linked_document | Unknown | |
linked_document_close_version | Unknown | |
linked_document_version | Unknown | |
location_description | Unknown | |
manager_id | Unknown | |
official_response | Unknown | |
priority | Unknown | |
pushpin_attributes | Unknown | |
question | Unknown | |
reference | Unknown | |
responded_at | Unknown | |
responded_by | Unknown | |
reviewer_id | Unknown | |
schedule_impact | Unknown | |
sheet_metadata | Unknown | |
status | Unknown | |
suggested_answer | Unknown | |
title | Unknown | |
updated_at | Instant | |
updated_by | Unknown | |
virtual_folder_urn | Unknown |
rfi_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
rfi_id | Unknown | FK |
body | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
updated_at | Unknown |
iq_rfis_root_cause
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
predicted_at | Unknown | |
root_cause | Unknown | |
updated_at | Unknown |
issue_profile_permission
| Column | Type | Keys |
|---|---|---|
permission | Unknown | PK |
issue_profile_id | Unknown | PKFK |
issue_profile_permitted_action
| Column | Type | Keys |
|---|---|---|
permitted_action | Unknown | PK |
issue_profile_id | Unknown | PKFK |
issue_profile_permitted_status
| Column | Type | Keys |
|---|---|---|
permitted_status | Unknown | PK |
issue_profile_id | Unknown | PKFK |
issue_profile_permitted_attribute
| Column | Type | Keys |
|---|---|---|
permitted_attribute | Unknown | PK |
issue_profile_id | Unknown | PKFK |
issue_profile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
can_manage_templates | Unknown | |
is_project_admin | Unknown |
error_code_data_key
| Column | Type | Keys |
|---|---|---|
data_key | Unknown | PK |
error_code_name | Unknown | PKFK |
error_code
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
description | Unknown | |
http_status_code | Unknown |
meeting_minute_topic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
meeting_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
name | Unknown | |
order_index | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
admin_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
default_company_id | Unknown | FK |
access_level_account_admin | Unknown | |
access_level_executive | Unknown | |
access_level_project_admin | Unknown | |
access_level_project_member | Unknown | |
address_line_1 | Unknown | |
address_line_2 | Unknown | |
autodesk_id | Unknown | |
city | Unknown | |
country | Unknown | |
created_at | Unknown | |
default_role_id | Unknown | |
email | Unknown | |
first_name | Unknown | |
job_title | Unknown | |
last_name | Unknown | |
last_sign_in | Unknown | |
name | Unknown | |
phone | Unknown | |
postal_code | Unknown | |
state_or_province | Unknown | |
status | Unknown | |
status_reason | Unknown | |
updated_at | Unknown |
submittal_acc_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
item_id | Unknown | FK |
body | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
clash_test
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
backend_type | Unknown | |
completed_at | Unknown | |
model_set_id | Unknown | |
model_set_version | Unknown | |
root_folder_urn | Unknown | |
started_at | Unknown | |
status | Unknown |
submittal_acc_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
spec_section_id | Unknown | FK |
type_id | Unknown | FK |
ball_in_court | Unknown | |
ball_in_court_company | Unknown | |
ball_in_court_role | Unknown | |
ball_in_court_user | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
custom_identifier | Unknown | |
custom_identifier_human_readable | Unknown | |
custom_identifier_sort | Unknown | |
description | Unknown | |
due_date | Unknown | |
identifier | Unknown | |
lead_time | Unknown | |
manager | Unknown | |
manager_due_date | Unknown | |
manager_type | Unknown | |
package | Unknown | |
package_identifier | Unknown | |
package_title | Unknown | |
priority_id | Unknown | |
priority_value | Unknown | |
published_by | Unknown | |
published_date | Unknown | |
received_from_review | Unknown | |
received_from_submitter | Unknown | |
required_approval_date | Unknown | |
required_date | Unknown | |
required_on_job_date | Unknown | |
responded_at | Unknown | |
responded_by | Unknown | |
response_comment | Unknown | |
response_id | Unknown | |
response_value | Unknown | |
revision | Unknown | |
sent_to_review | Unknown | |
sent_to_review_by | Unknown | |
sent_to_submitter | Unknown | |
spec_identifier | Unknown | |
state_id | Unknown | |
status_id | Unknown | |
status_value | Unknown | |
subcontractor | Unknown | |
subcontractor_type | Unknown | |
submitted_by | Unknown | |
submitter_due_date | Unknown | |
subsection | Unknown | |
title | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
sheet_upload
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
version_set_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
created_by_name | Unknown | |
published_at | Unknown | |
published_by | Unknown | |
published_by_name | Unknown | |
published_count | Unknown | |
status | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
schedule_dependency
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
schedule_id | Unknown | FK |
created_at | Unknown | |
source_unique_id | Unknown | |
target_unique_id | Unknown | |
type | Unknown | |
updated_at | Unknown |
transmittal_document
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
last_modified_user_id | Unknown | FK |
created_at | Unknown | |
file_name | Unknown | |
last_modified_time | Unknown | |
parent_folder_urn | Unknown | |
revision_number | Unknown | |
updated_at | Unknown | |
urn | Unknown | |
version_number | Unknown | |
workflow_transmittal_id | Unknown |
sheet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
container_type | Unknown | FK |
discipline_index | Unknown | FK |
history_id | Unknown | FK |
upload_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
created_by_name | Unknown | |
deleted | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
deleted_by_name | Unknown | |
is_current | Unknown | |
name | Unknown | |
nat_sort_name | Unknown | |
original_set_name | Unknown | |
processing_state | Unknown | |
title | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
updated_by_name | Unknown | |
upload_file_name | Unknown | |
version_set_id | Unknown |
asset_stage
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | FK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
bound_id | Unknown | |
bound_type | Unknown | |
completed_at | Unknown | |
completed_by | Unknown | |
completed_work | Unknown | |
completion_status | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
is_current | Unknown | |
max_work | Unknown | |
started_at | Unknown | |
started_by | Unknown | |
unit_of_work | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
version | Unknown |
iq_inspection_risk_issue
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
inspection_risk | Unknown | |
predicted_at | Unknown | |
updated_at | Unknown | |
user_category | Unknown |
iq_design_issues_building_component
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
building_component | Unknown | |
building_component_keyword | Unknown | |
predicted_at | Unknown | |
updated_at | Unknown | |
user_building_component | Unknown |
form_native_form
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
layout_uid | Unknown | FK |
template_id | Unknown | FK |
updated_at | Unknown |
sheet_discipline
| Column | Type | Keys |
|---|---|---|
container_type | Unknown | PK |
index | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
designator | Unknown | |
name | Unknown |
iq_rfis_building_component
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
building_component | Unknown | |
building_component_keyword | Unknown | |
predicted_at | Unknown | |
updated_at | Unknown |
issue_sub_type_permitted_action
| Column | Type | Keys |
|---|---|---|
permitted_action | Unknown | PK |
issue_sub_type_id | Unknown | PKFK |
issue_sub_type_permitted_attribute
| Column | Type | Keys |
|---|---|---|
permitted_attribute | Unknown | PK |
issue_sub_type_id | Unknown | PKFK |
issue_sub_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
issue_type_id | Unknown | FK |
code | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
is_active | Unknown | |
is_read_only | Unknown | |
order_index | Unknown | |
status_set | Unknown | |
title | Unknown | |
updated_at | Unknown | |
updated_by | Unknown |
issue_type_permitted_action
| Column | Type | Keys |
|---|---|---|
permitted_action | Unknown | PK |
issue_type_id | Unknown | PKFK |
issue_type_permitted_attribute
| Column | Type | Keys |
|---|---|---|
permitted_attribute | Unknown | PK |
issue_type_id | Unknown | PKFK |
issue_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
container_id | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
is_active | Unknown | |
order_index | Unknown | |
status_set | Unknown | |
title | Unknown | |
updated_at | Instant | |
updated_by | Unknown |
schedule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
is_public | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
version_number | Unknown |
rfi_transition
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
rfi_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
from_status | Unknown | |
to_status | Unknown |
sheet_lineage
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
container_type | Unknown | |
name | Unknown |
hub
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data | Json | |
extension_type | Unknown | |
name | Unknown | |
region | Unknown | |
type | Unknown | |
version | Unknown |
form_pdf_value
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
form_id | Unknown | FK |
name | Unknown | |
value | Unknown |
form_hourly_weather
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_id | Unknown | FK |
created_at | Unknown | |
fetched_at | Unknown | |
hour | Unknown | |
humidity | Unknown | |
temp | Unknown | |
updated_at | Unknown | |
wind_bearing | Unknown | |
wind_speed | Unknown |
custom_array_value
| Column | Type | Keys |
|---|---|---|
value | Unknown | PK |
form_custom_value_id | Unknown | PKFK |
form_custom_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_id | Unknown | FK |
choice_value | Unknown | |
date_value | Unknown | |
item_label | Unknown | |
notes | Unknown | |
number_value | Unknown | |
section_label | Unknown | |
svg_value | Unknown | |
text_value | Unknown | |
toggle_value | Unknown | |
value_name | Unknown |
form
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_template_id | Unknown | FK |
project_id | Unknown | FK |
assignee_id | Unknown | |
assignee_type | Unknown | |
created_by | Unknown | |
description | Unknown | |
form_date | Unknown | |
form_num | Unknown | |
location_id | Unknown | |
notes | Unknown | |
pdf_url | Unknown | |
status | Unknown | |
updated_at | Unknown | |
weather_humidity | Unknown | |
weather_precipitation_accumulation | Unknown | |
weather_precipitation_accumulation_unit | Unknown | |
weather_speed_unit | Unknown | |
weather_summary_key | Unknown | |
weather_temperature_max | Unknown | |
weather_temperature_min | Unknown | |
weather_temperature_unit | Unknown | |
weather_wind_bearing | Unknown | |
weather_wind_gust | Unknown | |
weather_wind_speed | Unknown |
form_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_id | Unknown | PKFK |
deleted | Unknown | |
description | Unknown | |
headcount | Unknown | |
timespan | Unknown | |
trade | Unknown | |
type | Unknown |
issue_comment_permitted_action
| Column | Type | Keys |
|---|---|---|
permitted_action | Unknown | PK |
issue_comment_id | Unknown | PKFK |
issue_comment_permitted_attribute
| Column | Type | Keys |
|---|---|---|
permitted_attribute | Unknown | PK |
issue_comment_id | Unknown | PKFK |
issue_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
issue_id | Unknown | FK |
project_id | Unknown | FK |
body | Unknown | |
client_created_at | Unknown | |
client_updated_at | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
updated_at | Unknown |
asset_custom_attribute_value
| Column | Type | Keys |
|---|---|---|
asset_id | Unknown | PKFK |
custom_attribute_id | Unknown | PKFK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
value_boolean | Unknown | |
value_string | Unknown |
schedule_resource
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
schedule_id | Unknown | FK |
activity_unique_id | Unknown | |
created_at | Unknown | |
email_address | Unknown | |
name | Unknown | |
resource_unique_id | Unknown | |
type | Unknown | |
updated_at | Unknown |
meeting_minute_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
item_id | Unknown | FK |
non_member_participant_id | Unknown | FK |
created_at | Unknown | |
deleted_at | Unknown | |
participant_id | Unknown | |
updated_at | Unknown |
meeting_minute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bim_360_account_id | Unknown | FK |
bim_360_project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
description | Unknown | |
duration | Unknown | |
meeting_location | Unknown | |
num_in_series | Unknown | |
series_id | Unknown | |
starts_at | Unknown | |
status | Unknown | |
summary | Unknown | |
title | Unknown | |
updated_at | Unknown | |
updated_by | Unknown | |
video_conference_link | Unknown |
sub_category
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PKFK |
sub_category_id | Unknown | PKFK |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
description | Unknown | |
is_active | Unknown | |
is_leaf | Unknown | |
is_root | Unknown | |
name | Unknown | |
uid | Unknown | |
updated_at | Instant | |
updated_by | Unknown |
root_cause_permitted_action
| Column | Type | Keys |
|---|---|---|
permitted_action | Unknown | PK |
issue_root_cause_category_id | Unknown | PKFK |
root_cause_permitted_attribute
| Column | Type | Keys |
|---|---|---|
permitted_attribute | Unknown | PK |
issue_root_cause_category_id | Unknown | PKFK |
issue_root_cause
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
root_cause_category_id | Unknown | FK |
title | Unknown |
issue_root_cause_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
created_at | Unknown | |
created_by | Unknown | |
deleted_at | Unknown | |
deleted_by | Unknown | |
is_active | Unknown | |
title | Unknown | |
updated_at | Instant | |
updated_by | Unknown |