# Autodesk BIM 360 & Construction Cloud schema ERD

Table and field reference for the Fivetran Autodesk BIM 360 & Construction Cloud connector.

## 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 | PK, FK |

### issue_permitted_attribute

| Column | Type | Keys |
| --- | --- | --- |
| permitted_attribute | Unknown | PK |
| issue_id | Unknown | PK, FK |

### issue_permitted_status

| Column | Type | Keys |
| --- | --- | --- |
| permitted_status | Unknown | PK |
| issue_id | Unknown | PK, FK |

### issue_watcher

| Column | Type | Keys |
| --- | --- | --- |
| watcher | Unknown | PK |
| issue_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |

### issue_attribute_permitted_attribute

| Column | Type | Keys |
| --- | --- | --- |
| permitted_attribute | Unknown | PK |
| issue_attribute_id | Unknown | PK, FK |

### issue_attribute_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issue_attribute_id | Unknown | PK, FK |
| 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 | PK, FK |
| bim_360_project_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| template_group_permission_index | Unknown | PK, FK |

### template_group_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_template_id | Unknown | PK, FK |
| role_key | Unknown |  |
| role_name | Unknown |  |

### user_permission

| Column | Type | Keys |
| --- | --- | --- |
| permission | Unknown | PK |
| form_template_id | Unknown | PK, FK |
| template_user_permission_user_id | Unknown | PK, FK |

### template_user_permission

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| form_template_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| project_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| bim_360_project_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### admin_project_user_company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| bim_360_account_id | Unknown | FK |

### submittal_acc_item_watcher

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| item_id | Unknown | PK, FK |
| 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 | PK, FK |
| bim_360_project_id | Unknown | PK, FK |
| issue_id | Unknown | PK, FK |
| 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 | PK, FK |
| icon | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### project_acc

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| hub_id | Unknown | PK, FK |
| 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 | PK, FK |

### rfi_distribution_list

| Column | Type | Keys |
| --- | --- | --- |
| distribution | Unknown | PK |
| rfi_id | Unknown | PK, FK |

### rfi_discipline

| Column | Type | Keys |
| --- | --- | --- |
| discipline | Unknown | PK |
| rfi_id | Unknown | PK, FK |

### rfi_category

| Column | Type | Keys |
| --- | --- | --- |
| category | Unknown | PK |
| rfi_id | Unknown | PK, FK |

### 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 | PK, FK |

### issue_profile_permitted_action

| Column | Type | Keys |
| --- | --- | --- |
| permitted_action | Unknown | PK |
| issue_profile_id | Unknown | PK, FK |

### issue_profile_permitted_status

| Column | Type | Keys |
| --- | --- | --- |
| permitted_status | Unknown | PK |
| issue_profile_id | Unknown | PK, FK |

### issue_profile_permitted_attribute

| Column | Type | Keys |
| --- | --- | --- |
| permitted_attribute | Unknown | PK |
| issue_profile_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |

### issue_sub_type_permitted_attribute

| Column | Type | Keys |
| --- | --- | --- |
| permitted_attribute | Unknown | PK |
| issue_sub_type_id | Unknown | PK, FK |

### 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 | PK, FK |

### issue_type_permitted_attribute

| Column | Type | Keys |
| --- | --- | --- |
| permitted_attribute | Unknown | PK |
| issue_type_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |

### issue_comment_permitted_attribute

| Column | Type | Keys |
| --- | --- | --- |
| permitted_attribute | Unknown | PK |
| issue_comment_id | Unknown | PK, FK |

### 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 | PK, FK |
| custom_attribute_id | Unknown | PK, FK |
| 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 | PK, FK |
| sub_category_id | Unknown | PK, FK |

### 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 | PK, FK |

### root_cause_permitted_attribute

| Column | Type | Keys |
| --- | --- | --- |
| permitted_attribute | Unknown | PK |
| issue_root_cause_category_id | Unknown | PK, FK |

### 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 |  |

## Relationships

- iq_issues_quality_risk(bim_360_account_id) → hub(id)
- iq_issues_quality_risk(bim_360_project_id) → project(id)
- markup_layer(bim_360_account_id) → hub(id)
- markup_layer(bim_360_project_id) → project(id)
- status_step_value(status_step_set_id) → status_step(id)
- status_step_value(project_id) → project(id)
- status_step(project_id) → project(id)
- transmittal_recipient(user_id) → admin_user(id)
- transmittal_recipient(bim_360_account_id) → hub(id)
- transmittal_recipient(bim_360_project_id) → project(id)
- schedule_activity_code(bim_360_account_id) → hub(id)
- schedule_activity_code(activity_unique_id) → schedule_activity(unique_id)
- schedule_activity_code(bim_360_project_id) → project(id)
- schedule_activity_code(schedule_id) → schedule(id)
- issue_permitted_action(issue_id) → issue(id)
- issue_permitted_attribute(issue_id) → issue(id)
- issue_permitted_status(issue_id) → issue(id)
- issue_watcher(issue_id) → issue(id)
- issue_gps_coordinate(issue_id) → issue(id)
- issue_custom_attribute(attribute_definition_id) → issue_attribute(id)
- issue_custom_attribute(issue_id) → issue(id)
- issue_linked_document(issue_id) → issue(id)
- issue(issue_type_id) → issue_type(id)
- issue(root_cause_id) → issue_root_cause(id)
- issue(issue_subtype_id) → issue_sub_type(id)
- issue(container_id) → project(issue_container_id)
- issue(project_id) → project(id)
- meeting_minute_non_member_participant(bim_360_account_id) → hub(id)
- meeting_minute_non_member_participant(bim_360_project_id) → project(id)
- meeting_minute_non_member_participant(meeting_id) → meeting_minute(id)
- iq_rfis_discipline(bim_360_account_id) → hub(id)
- iq_rfis_discipline(bim_360_project_id) → project(id)
- submittal_acc_task(bim_360_account_id) → hub(id)
- submittal_acc_task(bim_360_project_id) → project(id)
- submittal_acc_task(step_id) → submittal_acc_step(id)
- sheet_tag(sheet_id) → sheet(id)
- meeting_minute_item(bim_360_account_id) → hub(id)
- meeting_minute_item(topic_id) → meeting_minute_topic(id)
- meeting_minute_item(bim_360_project_id) → project(id)
- schedule_activity(bim_360_account_id) → hub(id)
- schedule_activity(bim_360_project_id) → project(id)
- schedule_activity(schedule_id) → schedule(id)
- issue_attribute_permitted_action(issue_attribute_id) → issue_attribute(id)
- issue_attribute_permitted_attribute(issue_attribute_id) → issue_attribute(id)
- issue_attribute_option(issue_attribute_id) → issue_attribute(id)
- issue_attribute(project_id) → project(id)
- closed_clash_group(clash_test_id) → clash_test(id)
- closed_clash_group(bim_360_account_id) → hub(id)
- closed_clash_group(bim_360_project_id) → project(id)
- closed_clash_group(issue_id) → issue(id)
- iq_cost_impact_issue(bim_360_account_id) → hub(id)
- iq_cost_impact_issue(bim_360_project_id) → project(id)
- iq_company_daily_quality_risk_change(bim_360_account_id) → hub(id)
- issue_attribute_mapping(attribute_definition_id) → issue_attribute(id)
- issue_attribute_mapping(project_id) → project(id)
- admin_project_user_product(user_id) → admin_user(id)
- admin_project_user_product(bim_360_project_id) → project(id)
- admin_project_user_product(bim_360_account_id) → hub(id)
- admin_project_role(bim_360_project_id) → project(id)
- admin_project_role(bim_360_account_id) → hub(id)
- group_permission(template_group_permission_index) → template_group_permission(index)
- group_permission(form_template_id) → template_group_permission(form_template_id)
- template_group_permission(form_template_id) → form_template(id)
- user_permission(template_user_permission_user_id) → template_user_permission(user_id)
- user_permission(form_template_id) → template_user_permission(form_template_id)
- template_user_permission(form_template_id) → form_template(id)
- form_template(project_id) → project(id)
- custom_attribute_enum_value(custom_attribute_id) → custom_attribute(id)
- custom_attribute_value(custom_attribute_id) → custom_attribute(id)
- custom_attribute_value(project_id) → project(id)
- custom_attribute(project_id) → project(id)
- asset_status(bim_360_account_id) → hub(id)
- asset_status(bim_360_project_id) → project(id)
- submittal_acc_item_revision(bim_360_account_id) → hub(id)
- submittal_acc_item_revision(item_id) → submittal_acc_item(id)
- submittal_acc_item_revision(bim_360_project_id) → project(id)
- sheet_set(bim_360_account_id) → hub(id)
- sheet_set(id) → sheet(version_set_id)
- sheet_set(bim_360_project_id) → project(id)
- submittal_acc_spec(bim_360_account_id) → hub(id)
- submittal_acc_spec(bim_360_project_id) → project(id)
- admin_project_user_role(project_id) → project(id)
- admin_project_user_role(user_id) → admin_user(id)
- admin_project_user_role(bim_360_account_id) → hub(id)
- asset(category_id) → category(id)
- asset(status_id) → asset_status(id)
- asset(project_id) → project(id)
- form_layout_table_column(layout_uid) → form_layout(uid)
- submittal_acc_step(bim_360_account_id) → hub(id)
- submittal_acc_step(item_id) → submittal_acc_item(id)
- submittal_acc_step(bim_360_project_id) → project(id)
- project_scope(project_id) → project(id)
- project(hub_id) → hub(id)
- admin_project_user(bim_360_project_id) → project(id)
- admin_project_user(bim_360_account_id) → hub(id)
- admin_project_user(user_id) → admin_user(id)
- admin_project_user_company(user_id) → admin_user(id)
- admin_project_user_company(project_id) → project(id)
- admin_project_user_company(bim_360_account_id) → hub(id)
- submittal_acc_item_watcher(item_id) → submittal_acc_item(id)
- submittal_acc_item_watcher(bim_360_account_id) → hub(id)
- submittal_acc_item_watcher(bim_360_project_id) → project(id)
- submittal_acc_item_type(bim_360_account_id) → hub(id)
- submittal_acc_item_type(bim_360_project_id) → project(id)
- form_layout_section(layout_uid) → form_layout(uid)
- form_layout_section(assignee_id) → admin_user(id)
- assigned_clash_group(clash_test_id) → clash_test(id)
- assigned_clash_group(bim_360_account_id) → hub(id)
- assigned_clash_group(issue_id) → issue(id)
- assigned_clash_group(bim_360_project_id) → project(id)
- clash_group_to_clash_id(bim_360_account_id) → hub(id)
- clash_group_to_clash_id(bim_360_project_id) → project(id)
- clash_group_to_clash_id(clash_test_id) → clash_test(id)
- clash_group_to_clash_id(issue_id) → issue(id)
- form_layout(bim_360_account_id) → hub(id)
- form_layout(bim_360_project_id) → project(id)
- iq_rfis_high_risk(bim_360_account_id) → hub(id)
- iq_rfis_high_risk(bim_360_project_id) → project(id)
- project_acc_product(project_id) → project_acc(id)
- project_acc(hub_id) → hub(id)
- submittal_acc_attachment(bim_360_account_id) → hub(id)
- submittal_acc_attachment(task_id) → submittal_acc_task(id)
- submittal_acc_attachment(item_id) → submittal_acc_item(id)
- submittal_acc_attachment(bim_360_project_id) → project(id)
- location_node(bim_360_account_id) → hub(id)
- location_node(bim_360_project_id) → project(id)
- location_node(parent_id) → location_node(id)
- rfi_co_reviewer(rfi_id) → rfi(id)
- rfi_distribution_list(rfi_id) → rfi(id)
- rfi_discipline(rfi_id) → rfi(id)
- rfi_category(rfi_id) → rfi(id)
- rfi(project_id) → project(id)
- rfi(container_id) → project(rfi_container_id)
- rfi_comment(rfi_id) → rfi(id)
- rfi_comment(bim_360_account_id) → hub(id)
- rfi_comment(bim_360_project_id) → project(id)
- iq_rfis_root_cause(bim_360_account_id) → hub(id)
- iq_rfis_root_cause(bim_360_project_id) → project(id)
- issue_profile_permission(issue_profile_id) → issue_profile(id)
- issue_profile_permitted_action(issue_profile_id) → issue_profile(id)
- issue_profile_permitted_status(issue_profile_id) → issue_profile(id)
- issue_profile_permitted_attribute(issue_profile_id) → issue_profile(id)
- issue_profile(project_id) → project(id)
- error_code_data_key(error_code_name) → error_code(name)
- meeting_minute_topic(bim_360_account_id) → hub(id)
- meeting_minute_topic(bim_360_project_id) → project(id)
- meeting_minute_topic(meeting_id) → meeting_minute(id)
- admin_user(default_company_id) → admin_project_user_company(id)
- admin_user(bim_360_account_id) → hub(id)
- submittal_acc_comment(bim_360_account_id) → hub(id)
- submittal_acc_comment(item_id) → submittal_acc_item(id)
- submittal_acc_comment(bim_360_project_id) → project(id)
- clash_test(bim_360_account_id) → hub(id)
- clash_test(bim_360_project_id) → project(id)
- submittal_acc_item(bim_360_account_id) → hub(id)
- submittal_acc_item(bim_360_project_id) → project(id)
- submittal_acc_item(spec_section_id) → submittal_acc_spec(id)
- submittal_acc_item(type_id) → submittal_acc_item_type(id)
- sheet_upload(version_set_id) → sheet_set(id)
- sheet_upload(project_id) → project(id)
- schedule_dependency(bim_360_account_id) → hub(id)
- schedule_dependency(bim_360_project_id) → project(id)
- schedule_dependency(schedule_id) → schedule(id)
- transmittal_document(bim_360_account_id) → hub(id)
- transmittal_document(bim_360_project_id) → project(id)
- transmittal_document(last_modified_user_id) → admin_user(autodesk_id)
- sheet(upload_id) → sheet_upload(id)
- sheet(bim_360_account_id) → hub(id)
- sheet(discipline_index) → sheet_discipline(index)
- sheet(history_id) → sheet_lineage(id)
- sheet(bim_360_project_id) → project(id)
- sheet(container_type) → sheet_discipline(container_type)
- asset_stage(bim_360_account_id) → hub(id)
- asset_stage(asset_id) → asset(id)
- asset_stage(bim_360_project_id) → project(id)
- iq_inspection_risk_issue(bim_360_account_id) → hub(id)
- iq_inspection_risk_issue(bim_360_project_id) → project(id)
- iq_design_issues_building_component(bim_360_account_id) → hub(id)
- iq_design_issues_building_component(bim_360_project_id) → project(id)
- form_native_form(bim_360_account_id) → hub(id)
- form_native_form(bim_360_project_id) → project(id)
- form_native_form(template_id) → form_template(id)
- form_native_form(layout_uid) → form_layout(uid)
- sheet_discipline(bim_360_account_id) → hub(id)
- sheet_discipline(bim_360_project_id) → project(id)
- iq_rfis_building_component(bim_360_account_id) → hub(id)
- iq_rfis_building_component(bim_360_project_id) → project(id)
- issue_sub_type_permitted_action(issue_sub_type_id) → issue_sub_type(id)
- issue_sub_type_permitted_attribute(issue_sub_type_id) → issue_sub_type(id)
- issue_sub_type(issue_type_id) → issue_type(id)
- issue_type_permitted_action(issue_type_id) → issue_type(id)
- issue_type_permitted_attribute(issue_type_id) → issue_type(id)
- issue_type(project_id) → project(id)
- schedule(bim_360_account_id) → hub(id)
- schedule(bim_360_project_id) → project(id)
- rfi_transition(bim_360_account_id) → hub(id)
- rfi_transition(bim_360_project_id) → project(id)
- rfi_transition(rfi_id) → rfi(id)
- sheet_lineage(bim_360_account_id) → hub(id)
- sheet_lineage(bim_360_project_id) → project(id)
- form_pdf_value(form_id) → form(id)
- form_hourly_weather(form_id) → form(id)
- custom_array_value(form_custom_value_id) → form_custom_value(id)
- form_custom_value(form_id) → form(id)
- form(form_template_id) → form_template(id)
- form(project_id) → project(id)
- form_entry(form_id) → form(id)
- issue_comment_permitted_action(issue_comment_id) → issue_comment(id)
- issue_comment_permitted_attribute(issue_comment_id) → issue_comment(id)
- issue_comment(project_id) → project(id)
- issue_comment(issue_id) → issue(id)
- asset_custom_attribute_value(asset_id) → asset(id)
- asset_custom_attribute_value(custom_attribute_id) → custom_attribute(id)
- asset_custom_attribute_value(bim_360_account_id) → hub(id)
- asset_custom_attribute_value(bim_360_project_id) → project(id)
- schedule_resource(bim_360_account_id) → hub(id)
- schedule_resource(bim_360_project_id) → project(id)
- schedule_resource(schedule_id) → schedule(id)
- meeting_minute_assignee(bim_360_account_id) → hub(id)
- meeting_minute_assignee(item_id) → meeting_minute_item(id)
- meeting_minute_assignee(non_member_participant_id) → meeting_minute_non_member_participant(id)
- meeting_minute_assignee(bim_360_project_id) → project(id)
- meeting_minute(bim_360_account_id) → hub(id)
- meeting_minute(bim_360_project_id) → project(id)
- sub_category(sub_category_id) → category(id)
- sub_category(category_id) → category(id)
- category(parent_id) → category(id)
- category(project_id) → project(id)
- root_cause_permitted_action(issue_root_cause_category_id) → issue_root_cause_category(id)
- root_cause_permitted_attribute(issue_root_cause_category_id) → issue_root_cause_category(id)
- issue_root_cause(root_cause_category_id) → issue_root_cause_category(id)
- issue_root_cause_category(project_id) → project(id)