# Procore schema ERD

Table and field reference for the Fivetran Procore connector.

## Table & Field Reference

### project_vendor

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| vendor_id | Unknown | PK, FK |

### project_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |

### checklist_item_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| category | Unknown |  |
| name | Unknown |  |

### company_office

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country_code | Unknown |  |
| division | Unknown |  |
| fax | Unknown |  |
| logo_filename | Unknown |  |
| logo_id | Unknown |  |
| logo_name | Unknown |  |
| logo_url | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| state_code | Unknown |  |
| zip | Unknown |  |

### budget_view_summary_row_line_item

| Column | Type | Keys |
| --- | --- | --- |
| budget_line_item_id | Unknown | PK |
| budget_view_summary_row_id | Unknown | PK, FK |

### budget_view_summary_row

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget_view_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| biller_type | Unknown |  |
| budget_forecast_amount | Unknown |  |
| budget_modifications | Unknown |  |
| currency_configuration_iso_code | Unknown |  |
| name | Unknown |  |
| original_budget_amount | Unknown |  |
| custom_** |  |  |

### project_user

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| company_permission_template_id | Unknown |  |
| company_permission_template_name | Unknown |  |
| company_permission_template_project_specific | Unknown |  |
| company_permission_template_type | Unknown |  |
| created_at | Unknown |  |
| email_signature | Unknown |  |
| last_login_at | Unknown |  |
| notes | Unknown |  |
| origin_data | Unknown |  |
| permission_template_id | Unknown |  |
| permission_template_name | Unknown |  |
| permission_template_project_specific | Unknown |  |
| permission_template_type | Unknown |  |
| updated_at | Unknown |  |
| welcome_email_sent_at | Unknown |  |

### company_checklist_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| inspection_type_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| trade_active | Unknown |  |
| trade_id | Unknown |  |
| trade_name | Unknown |  |
| trade_updated_at | Unknown |  |
| updated_at | Unknown |  |

### project_injury_body_part

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_injury_id | Unknown | PK, FK |
| created_at | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| selectable | Unknown |  |
| updated_at | Unknown |  |

### project_injury_affliction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_injury_id | Unknown | PK, FK |
| affected_body_part | Unknown |  |
| affliction_type_active | Unknown |  |
| affliction_type_created_at | Unknown |  |
| affliction_type_global | Unknown |  |
| affliction_type_id | Unknown |  |
| affliction_type_name | Unknown |  |
| affliction_type_updated_at | Unknown |  |

### project_injury_affected_body_part

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_injury_id | Unknown | PK, FK |
| affected_body_part | Unknown |  |

### project_injury

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| affected_body_part | Unknown |  |
| affected_company_id | Unknown |  |
| affected_company_name | Unknown |  |
| affected_party_id | Unknown |  |
| affected_party_name | Unknown |  |
| affected_person_id | Unknown |  |
| affected_person_login | Unknown |  |
| affected_person_name | Unknown |  |
| affliction_type_active | Unknown |  |
| affliction_type_created_at | Unknown |  |
| affliction_type_global | Unknown |  |
| affliction_type_id | Unknown |  |
| affliction_type_name | Unknown |  |
| affliction_type_updated_at | Unknown |  |
| body_diagram_type | Unknown |  |
| created_at | Unknown |  |
| custom_fields | Json |  |
| date_of_death | Unknown |  |
| date_returned_to_work | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| description_plain_text | Unknown |  |
| filing_type | Unknown |  |
| full_number | Unknown |  |
| harm_source_active | Unknown |  |
| harm_source_created_at | Unknown |  |
| harm_source_global | Unknown |  |
| harm_source_id | Unknown |  |
| harm_source_name | Unknown |  |
| harm_source_updated_at | Unknown |  |
| hospitalized_overnight | Unknown |  |
| incident_created_by_id | Unknown |  |
| incident_created_by_login | Unknown |  |
| incident_created_by_name | Unknown |  |
| incident_id | Unknown |  |
| incident_private | Unknown |  |
| incident_title | Unknown |  |
| managed_equipment_id | Unknown |  |
| managed_equipment_name | Unknown |  |
| number | Unknown |  |
| recordable | Unknown |  |
| summary | Unknown |  |
| treated_in_er | Unknown |  |
| treatment_facility | Unknown |  |
| treatment_facility_address | Unknown |  |
| treatment_provider | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| work_activity_active | Unknown |  |
| work_activity_created_at | Unknown |  |
| work_activity_global | Unknown |  |
| work_activity_id | Unknown |  |
| work_activity_name | Unknown |  |
| work_activity_updated_at | Unknown |  |
| work_days_absent | Unknown |  |
| work_days_restricted | Unknown |  |
| work_days_transferred | Unknown |  |

### checklist_item_response_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| checklist_item_id | Unknown | PK, FK |
| item_status_id | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### checklist_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| item_responder_id | Unknown | FK |
| type_id | Unknown | FK |
| company_template_item_details | Unknown |  |
| details | Unknown |  |
| item_response_item_id | Unknown |  |
| item_response_item_type_category | Unknown |  |
| item_response_item_type_id | Unknown |  |
| item_response_item_type_name | Unknown |  |
| item_response_payload_date_value | Unknown |  |
| item_response_payload_number_value | Unknown |  |
| item_response_payload_response_option_id | Unknown |  |
| item_response_payload_response_option_name | Unknown |  |
| item_response_payload_text_value | Unknown |  |
| item_response_responded_at | Unknown |  |
| item_response_status | Unknown |  |
| list_id | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| responded_with | Unknown |  |
| response_corresponding_status | Unknown |  |
| response_id | Unknown |  |
| response_name | Unknown |  |
| response_set_active | Unknown |  |
| response_set_created_at | Unknown |  |
| response_set_deletable | Unknown |  |
| response_set_id | Unknown |  |
| response_set_name | Unknown |  |
| response_set_procore_standard | Unknown |  |
| response_set_updated_at | Unknown |  |
| response_type_id | Unknown |  |
| section_id | Unknown |  |
| status | Unknown |  |
| template_item_id | Unknown |  |
| updated_at | Unknown |  |

### company_vendor_trade

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_vendor_id | Unknown | PK, FK |
| active | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### company_vendor_standard_cost_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_vendor_id | Unknown | PK, FK |
| code | Unknown |  |
| full_code | Unknown |  |
| name | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| parent_id | Unknown |  |
| standard_cost_code_list_id | Unknown |  |

### company_vendor_bidding_distribution

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_vendor_id | Unknown | PK, FK |
| company_name | Unknown |  |
| login | Unknown |  |
| name | Unknown |  |

### company_vendor_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_vendor_id | Unknown | PK, FK |
| filename | Unknown |  |
| url | Unknown |  |

### company_vendor_project

| Column | Type | Keys |
| --- | --- | --- |
| company_vendor_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |

### company_vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| abbreviated_name | Unknown |  |
| address | Unknown |  |
| authorized_bidder | Unknown |  |
| bidding_affirmative_action | Unknown |  |
| bidding_african_american_business | Unknown |  |
| bidding_asian_american_business | Unknown |  |
| bidding_certified_business_enterprise | Unknown |  |
| bidding_disadvantaged_business | Unknown |  |
| bidding_eight_a_business | Unknown |  |
| bidding_hispanic_business | Unknown |  |
| bidding_historically_underutilized_business | Unknown |  |
| bidding_minority_business_enterprise | Unknown |  |
| bidding_native_american_business | Unknown |  |
| bidding_sdvo_business | Unknown |  |
| bidding_small_business | Unknown |  |
| bidding_womens_business | Unknown |  |
| business_id | Unknown |  |
| business_phone | Unknown |  |
| business_register_id | Unknown |  |
| business_register_identifier | Unknown |  |
| business_register_type | Unknown |  |
| business_register_verification_status | Unknown |  |
| business_register_verified_at | Unknown |  |
| children_count | Unknown |  |
| city | Unknown |  |
| company_vendor | Unknown |  |
| contact_count | Unknown |  |
| country_code | Unknown |  |
| created_at | Unknown |  |
| email_address | Unknown |  |
| fax_number | Unknown |  |
| is_active | Unknown |  |
| is_connected | Unknown |  |
| labor_union | Unknown |  |
| legal_name | Unknown |  |
| logo | Unknown |  |
| mobile_phone | Unknown |  |
| name | Unknown |  |
| non_union_prevailing_wage | Unknown |  |
| notes | Unknown |  |
| origin_code | Unknown |  |
| origin_id | Unknown |  |
| parent_id | Unknown |  |
| parent_name | Unknown |  |
| prequalified | Unknown |  |
| primary_contact_business_phone | Unknown |  |
| primary_contact_business_phone_extension | Unknown |  |
| primary_contact_created_at | Unknown |  |
| primary_contact_email_address | Unknown |  |
| primary_contact_fax_number | Unknown |  |
| primary_contact_first_name | Unknown |  |
| primary_contact_id | Unknown |  |
| primary_contact_last_name | Unknown |  |
| primary_contact_mobile_phone | Unknown |  |
| primary_contact_updated_at | Unknown |  |
| state_code | Unknown |  |
| synced_to_erp | Unknown |  |
| trade_name | Unknown |  |
| union_member | Unknown |  |
| updated_at | Unknown |  |
| vendor_group_id | Unknown |  |
| vendor_group_name | Unknown |  |
| website | Unknown |  |
| zip | Unknown |  |

### work_order_contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| vendor_id | Unknown | FK |
| accounting_method | Unknown |  |
| actual_completion_date | Unknown |  |
| approval_letter_date | Unknown |  |
| approved_change_order | Unknown |  |
| base_currency_iso_code | Unknown |  |
| contract_date | Unknown |  |
| contract_estimated_completion_date | Unknown |  |
| contract_start_date | Unknown |  |
| created_at | Unknown |  |
| currency_exchange_rate | Unknown |  |
| currency_iso_code | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| draft_change_orders_amount | Unknown |  |
| exclusion | Unknown |  |
| executed | Unknown |  |
| execution_date | Unknown |  |
| grand_total | Unknown |  |
| inclusion | Unknown |  |
| issued_on_date | Unknown |  |
| letter_of_intent_date | Unknown |  |
| number | Unknown |  |
| origin_code | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| pending_change_order | Unknown |  |
| pending_revised_contract | Unknown |  |
| percentage_paid | Unknown |  |
| private | Unknown |  |
| remaining_balance_outstanding | Unknown |  |
| requisitions_are_enabled | Unknown |  |
| retainage_percent | Unknown |  |
| returned_date | Unknown |  |
| revised_contract | Unknown |  |
| show_line_items_to_non_admin | Unknown |  |
| signed_contract_received_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| total_draw_requests_amount | Unknown |  |
| total_payment | Unknown |  |
| total_requisitions_amount | Unknown |  |
| updated_at | Unknown |  |

### dailylog_manpower_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| dailylog_manpower_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| filename | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### dailylog_manpower

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| cost_code_id | Unknown | FK |
| created_by_id | Unknown | FK |
| location_id | Unknown | FK |
| vendor_id | Unknown | FK |
| can_delete | Unknown |  |
| can_update | Unknown |  |
| contact_business_phone | Unknown |  |
| contact_business_phone_extension | Unknown |  |
| contact_email | Unknown |  |
| contact_fax_number | Unknown |  |
| contact_id | Unknown |  |
| contact_job_title | Unknown |  |
| contact_login_information_id | Unknown |  |
| contact_mobile_phone | Unknown |  |
| contact_name | Unknown |  |
| contact_vendor_name | Unknown |  |
| created_at | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| date | Unknown |  |
| datetime | Unknown |  |
| man_hours | Unknown |  |
| notes | Unknown |  |
| num_hours | Unknown |  |
| num_workers | Unknown |  |
| position | Unknown |  |
| status | Unknown |  |
| trade_active | Unknown |  |
| trade_id | Unknown |  |
| trade_name | Unknown |  |
| trade_updated_at | Unknown |  |
| updated_at | Unknown |  |
| user_id | Unknown |  |
| user_login | Unknown |  |
| user_name | Unknown |  |

### rfi_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| rfi_id | Unknown | PK, FK |
| filename | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### rfi_question_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| rfi_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| answer_date | Unknown |  |
| created_by | Unknown |  |
| official | Unknown |  |
| plain_text_body | Unknown |  |
| rich_text_body | Unknown |  |

### direct_cost

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| vendor_id | Unknown | FK |
| amount | Unknown |  |
| base_currency_iso_code | Unknown |  |
| created_at | Unknown |  |
| currency_exchange_rate | Unknown |  |
| currency_iso_code | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| direct_cost_date | Unknown |  |
| direct_cost_type | Unknown |  |
| employee_id | Unknown |  |
| employee_name | Unknown |  |
| grand_total | Unknown |  |
| invoice_number | Unknown |  |
| payment_date | Unknown |  |
| received_date | Unknown |  |
| status | Unknown |  |
| terms | Unknown |  |
| updated_at | Unknown |  |

### task_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| assignee_id | Unknown | FK |
| created_at | Unknown |  |
| date_notified | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| number | Unknown |  |
| private | Unknown |  |
| status | Unknown |  |
| task_item_category_id | Unknown |  |
| task_item_category_name | Unknown |  |
| title | Unknown |  |

### submittal_current_step_approver

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| submittal_id | Unknown | PK, FK |
| response_required | Unknown |  |
| user_id | Unknown |  |
| user_name | Unknown |  |

### submittal_distribution_member_id

| Column | Type | Keys |
| --- | --- | --- |
| distribution_member_id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| submittal_id | Unknown | PK, FK |

### submittal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| cost_code_id | Unknown | FK |
| sub_job_id | Unknown | FK |
| actual_delivery_date | Unknown |  |
| bic_due_date | Unknown |  |
| confirmed_delivery_date | Unknown |  |
| current_step_returned_date | Unknown |  |
| current_step_sent_date | Unknown |  |
| custom_textarea_1 | Unknown |  |
| custom_textfield_1 | Unknown |  |
| description | Unknown |  |
| design_team_review_time | Unknown |  |
| due_date | Unknown |  |
| internal_review_time | Unknown |  |
| issue_date | Unknown |  |
| lead_time | Unknown |  |
| location_id | Unknown |  |
| number | Unknown |  |
| private | Unknown |  |
| received_date | Unknown |  |
| received_from_id | Unknown |  |
| required_on_site_date | Unknown |  |
| responsible_contractor_id | Unknown |  |
| revision | Unknown |  |
| scheduled_task_id | Unknown |  |
| scheduled_task_key | Unknown |  |
| specification_section_id | Unknown |  |
| status_id | Unknown |  |
| submit_by | Unknown |  |
| submittal_manager_id | Unknown |  |
| submittal_package_id | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| workflow_current_step | Unknown |  |
| workflow_days_late | Unknown |  |
| workflow_total_step | Unknown |  |

### budget_view_snapshot_detail_segment_item_path

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_view_snapshot_detail_row_fivetran_id | Unknown | PK, FK |
| budget_view_snapshot_detail_segment_item_index | Unknown | PK, FK |
| path_id | Unknown |  |

### budget_view_snapshot_detail_segment_item_path_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_view_snapshot_detail_row_fivetran_id | Unknown | PK, FK |
| budget_view_snapshot_detail_segment_item_index | Unknown | PK, FK |
| path_code | Unknown |  |

### budget_view_snapshot_detail_segment_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_view_snapshot_detail_row_fivetran_id | Unknown | PK, FK |
| code | Unknown |  |
| id | Unknown |  |
| is_parent | Unknown |  |
| name | Unknown |  |
| segment_id | Unknown |  |
| segment_name | Unknown |  |
| segment_structure | Unknown |  |
| segment_type | Unknown |  |

### budget_view_snapshot_detail_row

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| biller_id | Unknown | FK |
| budget_view_snapshot_id | Unknown | FK |
| company_id | Unknown | FK |
| project_id | Unknown | FK |
| budget_modifications | Unknown |  |
| budget_row_id | Unknown |  |
| category | Unknown |  |
| category_id | Unknown |  |
| cost_code | Unknown |  |
| cost_code_id | Unknown |  |
| cost_code_origin_id | Unknown |  |
| currency_configuration_iso_code | Unknown |  |
| deletable | Unknown |  |
| id | Unknown |  |
| original_budget_amount | Unknown |  |
| quantity | Unknown |  |
| root_cost_code | Unknown |  |
| root_cost_code_id | Unknown |  |
| unbudgeted_reason | Unknown |  |
| unit_cost | Unknown |  |
| wbs_code_id | Unknown |  |
| custom_** |  |  |

### project_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| category | Unknown |  |
| is_bidding_stage | Unknown |  |
| name | Unknown |  |
| read_only | Unknown |  |

### direct_cost_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| cost_code_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| extended_amount | Unknown |  |
| extended_type | Unknown |  |
| holder_id | Unknown |  |
| holder_type | Unknown |  |
| line_item_type_base_type | Unknown |  |
| line_item_type_code | Unknown |  |
| line_item_type_id | Unknown |  |
| line_item_type_name | Unknown |  |
| line_item_type_origin_data | Unknown |  |
| line_item_type_origin_id | Unknown |  |
| origin_id | Unknown |  |
| position | Unknown |  |
| quantity | Unknown |  |
| total_amount | Unknown |  |
| unit_cost | Unknown |  |
| uom | Unknown |  |
| updated_at | Unknown |  |
| wbs_code_description | Unknown |  |
| wbs_code_flat_code | Unknown |  |
| wbs_code_id | Unknown |  |

### purchase_order_contract_potential_change_order

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| purchase_order_contract_id | Unknown | PK, FK |

### purchase_order_contract_change_order_package

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| purchase_order_contract_id | Unknown | PK, FK |

### purchase_order_contract_change_order_request

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| purchase_order_contract_id | Unknown | PK, FK |
| currency_exchange_rate | Unknown |  |

### purchase_order_contract_invoice_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| purchase_order_contract_id | Unknown | PK, FK |
| base_currency_iso_code | Unknown |  |
| business_phone | Unknown |  |
| business_phone_extension | Unknown |  |
| currency_exchange_rate | Unknown |  |
| currency_iso_code | Unknown |  |
| email | Unknown |  |
| fax_number | Unknown |  |
| job_title | Unknown |  |
| login_information_id | Unknown |  |
| mobile_phone | Unknown |  |
| name | Unknown |  |
| vendor_name | Unknown |  |

### purchase_order_contract_payments_issued_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| purchase_order_contract_id | Unknown | PK, FK |
| purchase_order_contract_payments_issued_id | Unknown | PK, FK |
| filename | Unknown |  |
| url | Unknown |  |

### purchase_order_contract_payments_issued

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| purchase_order_contract_id | Unknown | PK, FK |
| amount | Unknown |  |
| base_currency_iso_code | Unknown |  |
| check_number | Unknown |  |
| created_at | Unknown |  |
| currency_exchange_rate | Unknown |  |
| currency_iso_code | Unknown |  |
| date | Unknown |  |
| draw_request_number | Unknown |  |
| invoice_number | Unknown |  |
| notes | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| payment_number | Unknown |  |

### purchase_order_contract

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK |
| id | Unknown | PK |
| project_id | Unknown | PK |
| assignee_id | Unknown | FK |
| created_by_id | Unknown | FK |
| vendor_id | Unknown | FK |
| accounting_method | Unknown |  |
| approval_letter_date | Unknown |  |
| approved_change_order | Unknown |  |
| attachments_filename | Unknown |  |
| attachments_id | Unknown |  |
| attachments_url | Unknown |  |
| base_currency_iso_code | Unknown |  |
| bill_to_address | Unknown |  |
| contract_date | Unknown |  |
| created_at | Unknown |  |
| currency_exchange_rate | Unknown |  |
| currency_iso_code | Unknown |  |
| deleted_at | Unknown |  |
| delivery_date | Unknown |  |
| description | Unknown |  |
| draft_change_orders_amount | Unknown |  |
| executed | Unknown |  |
| execution_date | Unknown |  |
| grand_total | Unknown |  |
| issued_on_date | Unknown |  |
| letter_of_intent_date | Unknown |  |
| number | Unknown |  |
| origin_code | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| payment_term | Unknown |  |
| pending_change_order | Unknown |  |
| pending_revised_contract | Unknown |  |
| percentage_paid | Unknown |  |
| private | Unknown |  |
| remaining_balance_outstanding | Unknown |  |
| requisitions_are_enabled | Unknown |  |
| retainage_percent | Unknown |  |
| returned_date | Unknown |  |
| revised_contract | Unknown |  |
| ship_to_address | Unknown |  |
| ship_via | Unknown |  |
| show_line_items_to_non_admin | Unknown |  |
| signed_contract_received_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| total_draw_requests_amount | Unknown |  |
| total_payment | Unknown |  |
| total_requisitions_amount | Unknown |  |
| updated_at | Unknown |  |

### task_item_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| task_item_id | Unknown | FK |
| attachment_filename | Unknown |  |
| attachment_id | Unknown |  |
| attachment_url | Unknown |  |
| comment | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### change_order_change_event_line_item

| Column | Type | Keys |
| --- | --- | --- |
| change_event_line_item_id | Unknown | PK |
| budget_change_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |

### budget_change

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| prime_contract_id | Unknown | FK |
| amount | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| currency_iso_code | Unknown |  |
| description | Unknown |  |
| erp_status | Unknown |  |
| number | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |

### change_event_line_item_budget_code_segment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| change_event_line_item_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Unknown |  |
| in_use | Unknown |  |
| is_parent | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| path_code | Json |  |
| path_id | Json |  |
| path_name | Json |  |
| segment_created_at | Unknown |  |
| segment_delimiter | Unknown |  |
| segment_id | Unknown |  |
| segment_name | Unknown |  |
| segment_position | Unknown |  |
| segment_project_can_delete_origin_company | Unknown |  |
| segment_project_can_modify_origin_project | Unknown |  |
| segment_required | Unknown |  |
| segment_segment_items_count | Unknown |  |
| segment_structure | Unknown |  |
| segment_type | Unknown |  |
| segment_updated_at | Unknown |  |
| segment_wbs_pattern_id | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### change_event_line_item_budget_impact_estimate_transfer_from_wbs_code_segment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| change_event_line_item_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Unknown |  |
| in_use | Unknown |  |
| is_parent | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| path_code | Json |  |
| path_id | Json |  |
| path_name | Json |  |
| segment_created_at | Unknown |  |
| segment_delimiter | Unknown |  |
| segment_id | Unknown |  |
| segment_name | Unknown |  |
| segment_position | Unknown |  |
| segment_project_can_delete_origin_company | Unknown |  |
| segment_project_can_modify_origin_project | Unknown |  |
| segment_required | Unknown |  |
| segment_segment_items_count | Unknown |  |
| segment_structure | Unknown |  |
| segment_type | Unknown |  |
| segment_updated_at | Unknown |  |
| segment_wbs_pattern_id | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### change_event_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| budget_impact_budget_change_id | Unknown | FK |
| budget_impact_budget_modification_id | Unknown | FK |
| cost_impact_change_order_package_id | Unknown | FK |
| revenue_impact_change_order_package_id | Unknown | FK |
| budget_code_description | Unknown |  |
| budget_code_flat_code | Unknown |  |
| budget_code_id | Unknown |  |
| budget_impact_budget_change_adjustment_line_item_amount | Unknown |  |
| budget_impact_budget_change_adjustment_line_item_id | Unknown |  |
| budget_impact_budget_change_adjustment_line_item_number | Unknown |  |
| budget_impact_budget_change_days_in_stage | Unknown |  |
| budget_impact_budget_change_in_status_since | Unknown |  |
| budget_impact_budget_change_number | Unknown |  |
| budget_impact_budget_change_status | Unknown |  |
| budget_impact_budget_change_title | Unknown |  |
| budget_impact_budget_modification_amount | Unknown |  |
| budget_impact_budget_modification_notes | Unknown |  |
| budget_impact_budget_modification_transfer_from_id | Unknown |  |
| budget_impact_budget_modification_transfer_from_name | Unknown |  |
| budget_impact_budget_modification_transfer_to_id | Unknown |  |
| budget_impact_budget_modification_transfer_to_name | Unknown |  |
| budget_impact_estimate_amount | Unknown |  |
| budget_impact_estimate_amount_project_currency | Unknown |  |
| budget_impact_estimate_auto_balance | Unknown |  |
| budget_impact_estimate_calculation_strategy | Unknown |  |
| budget_impact_estimate_from_wbs_code_description | Unknown |  |
| budget_impact_estimate_from_wbs_code_flat_code | Unknown |  |
| budget_impact_estimate_from_wbs_code_id | Unknown |  |
| budget_impact_estimate_quantity | Unknown |  |
| budget_impact_estimate_transfer_amount | Unknown |  |
| budget_impact_estimate_unit_cost | Unknown |  |
| budget_impact_estimate_unit_cost_project_currency | Unknown |  |
| budget_impact_source_of_budget_rom | Unknown |  |
| budget_impact_source_of_latest_budget_impact | Unknown |  |
| budget_impact_source_of_stage | Unknown |  |
| cost_impact_change_order_package_contract_type | Unknown |  |
| cost_impact_change_order_package_days_in_stage | Unknown |  |
| cost_impact_change_order_package_in_status_since | Unknown |  |
| cost_impact_change_order_package_line_item_amount | Unknown |  |
| cost_impact_change_order_package_line_item_amount_project_currency | Unknown |  |
| cost_impact_change_order_package_line_item_id | Unknown |  |
| cost_impact_change_order_package_number | Unknown |  |
| cost_impact_change_order_package_status | Unknown |  |
| cost_impact_change_order_package_title | Unknown |  |
| cost_impact_change_order_package_type | Unknown |  |
| cost_impact_commitment_base_currency_iso_code | Unknown |  |
| cost_impact_commitment_contract_type | Unknown |  |
| cost_impact_commitment_currency_exchange_rate | Unknown |  |
| cost_impact_commitment_currency_iso_code | Unknown |  |
| cost_impact_commitment_days_in_stage | Unknown |  |
| cost_impact_commitment_id | Unknown |  |
| cost_impact_commitment_in_status_since | Unknown |  |
| cost_impact_commitment_line_item_amount | Unknown |  |
| cost_impact_commitment_line_item_amount_project_currency | Unknown |  |
| cost_impact_commitment_line_item_id | Unknown |  |
| cost_impact_commitment_number | Unknown |  |
| cost_impact_commitment_status | Unknown |  |
| cost_impact_commitment_title | Unknown |  |
| cost_impact_commitment_type | Unknown |  |
| cost_impact_contract_confirmed_contract_type | Unknown |  |
| cost_impact_contract_confirmed_id | Unknown |  |
| cost_impact_contract_confirmed_number | Unknown |  |
| cost_impact_contract_confirmed_status | Unknown |  |
| cost_impact_contract_confirmed_title | Unknown |  |
| cost_impact_contract_proposed_contract_type | Unknown |  |
| cost_impact_contract_proposed_id | Unknown |  |
| cost_impact_contract_proposed_number | Unknown |  |
| cost_impact_contract_proposed_status | Unknown |  |
| cost_impact_contract_proposed_title | Unknown |  |
| cost_impact_estimate_amount | Unknown |  |
| cost_impact_estimate_calculation_strategy | Unknown |  |
| cost_impact_estimate_quantity | Unknown |  |
| cost_impact_estimate_unit_cost | Unknown |  |
| cost_impact_estimate_unit_of_measure | Unknown |  |
| cost_impact_non_commitment_amount | Unknown |  |
| cost_impact_request_for_quote_days_in_stage | Unknown |  |
| cost_impact_request_for_quote_id | Unknown |  |
| cost_impact_request_for_quote_in_status_since | Unknown |  |
| cost_impact_request_for_quote_latest_quote_amount | Unknown |  |
| cost_impact_request_for_quote_number | Unknown |  |
| cost_impact_request_for_quote_status | Unknown |  |
| cost_impact_request_for_quote_title | Unknown |  |
| cost_impact_source_of_latest_cost | Unknown |  |
| cost_impact_source_of_stage | Unknown |  |
| cost_impact_vendor_confirmed_id | Unknown |  |
| cost_impact_vendor_confirmed_name | Unknown |  |
| cost_impact_vendor_proposed_id | Unknown |  |
| cost_impact_vendor_proposed_name | Unknown |  |
| currency_iso_code | Unknown |  |
| deletable | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| editable | Unknown |  |
| event_id | Unknown |  |
| event_number | Unknown |  |
| event_title | Unknown |  |
| item_type | Unknown |  |
| latest_cost_values_amount | Unknown |  |
| latest_cost_values_amount_project_currency | Unknown |  |
| latest_cost_values_calculation_strategy | Unknown |  |
| latest_cost_values_quantity | Unknown |  |
| latest_cost_values_unit_cost | Unknown |  |
| latest_cost_values_unit_cost_project_currency | Unknown |  |
| latest_cost_values_unit_of_measure | Unknown |  |
| latest_revenue_valuesamount | Unknown |  |
| latest_revenue_valuesamount_project_currency | Unknown |  |
| latest_revenue_valuescalculation_strategy | Unknown |  |
| latest_revenue_valuesquantity | Unknown |  |
| latest_revenue_valuesunit_cost | Unknown |  |
| latest_revenue_valuesunit_cost_project_currency | Unknown |  |
| line_aging | Unknown |  |
| notes | Json |  |
| revenue_impact_change_order_base_currency_iso_code | Unknown |  |
| revenue_impact_change_order_contract_id | Unknown |  |
| revenue_impact_change_order_currency_exchange_rate | Unknown |  |
| revenue_impact_change_order_currency_iso_code | Unknown |  |
| revenue_impact_change_order_days_in_stage | Unknown |  |
| revenue_impact_change_order_id | Unknown |  |
| revenue_impact_change_order_in_status_since | Unknown |  |
| revenue_impact_change_order_line_item_amount | Unknown |  |
| revenue_impact_change_order_line_item_amount_project_currency | Unknown |  |
| revenue_impact_change_order_line_item_id | Unknown |  |
| revenue_impact_change_order_number | Unknown |  |
| revenue_impact_change_order_package_contract_id | Unknown |  |
| revenue_impact_change_order_package_days_in_stage | Unknown |  |
| revenue_impact_change_order_package_in_status_since | Unknown |  |
| revenue_impact_change_order_package_line_item_amount | Unknown |  |
| revenue_impact_change_order_package_line_item_id | Unknown |  |
| revenue_impact_change_order_package_number | Unknown |  |
| revenue_impact_change_order_package_status | Unknown |  |
| revenue_impact_change_order_package_title | Unknown |  |
| revenue_impact_change_order_package_type | Unknown |  |
| revenue_impact_change_order_status | Unknown |  |
| revenue_impact_change_order_title | Unknown |  |
| revenue_impact_change_order_type | Unknown |  |
| revenue_impact_estimate_amount | Unknown |  |
| revenue_impact_estimate_amount_project_currency | Unknown |  |
| revenue_impact_estimate_calculation_strategy | Unknown |  |
| revenue_impact_estimate_quantity | Unknown |  |
| revenue_impact_estimate_unit_cost | Unknown |  |
| revenue_impact_estimate_unit_cost_project_currency | Unknown |  |
| revenue_impact_source_of_latest_price | Unknown |  |
| revenue_impact_source_of_revenue_rom | Unknown |  |
| revenue_impact_source_of_stage | Unknown |  |
| source | Unknown |  |
| updated_at | Unknown |  |

### change_event_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| filename | Unknown |  |
| url | Unknown |  |

### change_event_markup_item_wbs_code_segment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| change_event_markup_item_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Unknown |  |
| in_use | Unknown |  |
| is_parent | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| path_code | Json |  |
| path_id | Json |  |
| path_name | Json |  |
| segment_created_at | Unknown |  |
| segment_delimiter | Unknown |  |
| segment_id | Unknown |  |
| segment_name | Unknown |  |
| segment_position | Unknown |  |
| segment_project_can_delete_origin_company | Unknown |  |
| segment_project_can_modify_origin_project | Unknown |  |
| segment_required | Unknown |  |
| segment_segment_items_count | Unknown |  |
| segment_structure | Unknown |  |
| segment_type | Unknown |  |
| segment_updated_at | Unknown |  |
| segment_wbs_pattern_id | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### change_event_markup_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| event_id | Unknown |  |
| item_type | Unknown |  |
| revenue_change_order_amount | Unknown |  |
| revenue_estimate_amount | Unknown |  |
| revenue_latest_price_amount | Unknown |  |
| wbs_code_description | Unknown |  |
| wbs_code_flat_code | Unknown |  |
| wbs_code_id | Unknown |  |

### change_event_production_wbs_segment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| change_event_production_quantity_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Unknown |  |
| in_use | Unknown |  |
| is_parent | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| path_code | Json |  |
| path_id | Json |  |
| path_name | Json |  |
| segment_created_at | Unknown |  |
| segment_delimiter | Unknown |  |
| segment_id | Unknown |  |
| segment_name | Unknown |  |
| segment_position | Unknown |  |
| segment_project_can_delete_origin_company | Unknown |  |
| segment_project_can_modify_origin_project | Unknown |  |
| segment_required | Unknown |  |
| segment_segment_items_count | Unknown |  |
| segment_structure | Unknown |  |
| segment_type | Unknown |  |
| segment_updated_at | Unknown |  |
| segment_wbs_pattern_id | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### change_event_production_disabled_field

| Column | Type | Keys |
| --- | --- | --- |
| disabled_field | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| change_event_production_quantity_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |

### change_event_production_quantity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_event_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| budget_change_id | Unknown | FK |
| production_code_cost_code_id | Unknown | FK |
| production_code_sub_job_id | Unknown | FK |
| budget_change_description | Unknown |  |
| budget_change_number | Unknown |  |
| budget_change_production_quantity | Unknown |  |
| budget_change_production_quantity_id | Unknown |  |
| budget_change_production_quantity_unit_of_measure | Unknown |  |
| budget_change_status | Unknown |  |
| budget_change_title | Unknown |  |
| estimate_quantity | Unknown |  |
| estimate_unit_of_measure | Unknown |  |
| event_id | Unknown |  |
| item_type | Unknown |  |
| prime_change_order_contract_id | Unknown |  |
| prime_change_order_description | Unknown |  |
| prime_change_order_id | Unknown |  |
| prime_change_order_number | Unknown |  |
| prime_change_order_production_quantity | Unknown |  |
| prime_change_order_production_quantity_id | Unknown |  |
| prime_change_order_production_quantity_unit_of_measure | Unknown |  |
| prime_change_order_status | Unknown |  |
| prime_change_order_title | Unknown |  |
| prime_change_order_type | Unknown |  |
| production_code_cost_code_description | Unknown |  |
| production_code_wbs_code_description | Unknown |  |
| production_code_wbs_code_flat_code | Unknown |  |
| production_code_wbs_code_id | Unknown |  |

### change_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| change_reason | Unknown |  |
| change_reason_id | Unknown |  |
| change_type_abbreviation | Unknown |  |
| change_type_id | Unknown |  |
| change_type_name | Unknown |  |
| comments_enabled | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| currency_iso_code | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| event_origin_display_name | Unknown |  |
| event_origin_id | Unknown |  |
| event_origin_type | Unknown |  |
| event_origin_web_page_url | Unknown |  |
| external_data_origin_data | Unknown |  |
| external_data_origin_id | Unknown |  |
| in_recycle_bin | Unknown |  |
| notes | Json |  |
| number | Unknown |  |
| prime_contract_for_estimates_id | Unknown |  |
| prime_contract_for_estimates_name | Unknown |  |
| prime_contract_for_estimates_number | Unknown |  |
| scope | Unknown |  |
| source | Unknown |  |
| status_id | Unknown |  |
| status_mapped_to_status | Unknown |  |
| status_name | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### observation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| assignee_id | Unknown | FK |
| checklist_item_id | Unknown | FK |
| location_id | Unknown | FK |
| vendor_id | Unknown | FK |
| closed_at | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| custom_fields | Json |  |
| date_notified | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| description_rich_text | Unknown |  |
| due_date | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| observation_type_active | Unknown |  |
| observation_type_category | Unknown |  |
| observation_type_category_id | Unknown |  |
| observation_type_category_key | Unknown |  |
| observation_type_company_active | Unknown |  |
| observation_type_id | Unknown |  |
| observation_type_in_use | Unknown |  |
| observation_type_kind | Unknown |  |
| observation_type_localized_name | Unknown |  |
| observation_type_name | Unknown |  |
| observation_type_name_translations | Json |  |
| observation_type_parent_inactive | Unknown |  |
| origin_bim_model_id | Unknown |  |
| origin_bim_model_name | Unknown |  |
| origin_checklist_item_id | Unknown |  |
| origin_coordination_issue_id | Unknown |  |
| origin_coordination_issue_number | Unknown |  |
| origin_incident_action_id | Unknown |  |
| origin_incident_id | Unknown |  |
| origin_type | Unknown |  |
| personal | Unknown |  |
| priority | Unknown |  |
| specification_section_description | Unknown |  |
| specification_section_id | Unknown |  |
| specification_section_latest_revision_url | Unknown |  |
| specification_section_number | Unknown |  |
| status | Unknown |  |
| trade_active | Unknown |  |
| trade_id | Unknown |  |
| trade_name | Unknown |  |
| trade_updated_at | Unknown |  |
| updated_at | Unknown |  |

### checklist_schedule_assignee

| Column | Type | Keys |
| --- | --- | --- |
| assignee_id | Unknown | PK |
| checklist_schedule_id | Unknown | PK, FK |

### checklist_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_at | Unknown |  |
| ends_at | Unknown |  |
| first_inspection_due_at | Unknown |  |
| frequency | Unknown |  |
| inspection_template_description | Unknown |  |
| inspection_template_id | Unknown |  |
| inspection_template_name | Unknown |  |
| inspection_template_trade_id | Unknown |  |
| inspection_template_type_id | Unknown |  |
| inspection_template_type_name | Unknown |  |
| inspections_created | Unknown |  |
| location_id | Unknown |  |
| name | Unknown |  |
| next_due_at | Unknown |  |
| point_of_contact_id | Unknown |  |
| responsible_contractor_id | Unknown |  |
| total_inspections_scheduled | Unknown |  |
| updated_at | Unknown |  |

### project_incident

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| actions_count | Unknown |  |
| attachments_count | Unknown |  |
| closed_observations_count | Unknown |  |
| contributing_behavior_active | Unknown |  |
| contributing_behavior_created_at | Unknown |  |
| contributing_behavior_global | Unknown |  |
| contributing_behavior_id | Unknown |  |
| contributing_behavior_name | Unknown |  |
| contributing_behavior_updated_at | Unknown |  |
| contributing_condition_active | Unknown |  |
| contributing_condition_created_at | Unknown |  |
| contributing_condition_global | Unknown |  |
| contributing_condition_id | Unknown |  |
| contributing_condition_name | Unknown |  |
| contributing_condition_updated_at | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| custom_fields | Json |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| event_date | Unknown |  |
| hazard_active | Unknown |  |
| hazard_created_at | Unknown |  |
| hazard_global | Unknown |  |
| hazard_id | Unknown |  |
| hazard_name | Unknown |  |
| hazard_updated_at | Unknown |  |
| open_observations_count | Unknown |  |
| private | Unknown |  |
| recordable | Unknown |  |
| records_count | Unknown |  |
| status | Unknown |  |
| time_unknown | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| witness_statements_count | Unknown |  |

### company_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| vendor_id | Unknown | FK |
| work_classification_id | Unknown | FK |
| address | Unknown |  |
| avatar | Unknown |  |
| bid_contact | Unknown |  |
| business_id | Unknown |  |
| business_phone | Unknown |  |
| business_phone_extension | Unknown |  |
| city | Unknown |  |
| contact_id | Unknown |  |
| country_code | Unknown |  |
| email_address | Unknown |  |
| employee_id | Unknown |  |
| erp_integrated_accountant | Unknown |  |
| fax_number | Unknown |  |
| first_name | Unknown |  |
| initials | Unknown |  |
| is_active | Unknown |  |
| is_employee | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| mobile_phone | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |
| role | Unknown |  |
| state_code | Unknown |  |
| verified_employee | Unknown |  |
| zip | Unknown |  |

### work_classification_project

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK, FK |
| project_level_work_classification_id | Unknown | PK, FK |

### project_level_work_classification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| abbreviation | Unknown |  |
| company_visible | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### change_order_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| prime_contract_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| change_order_package_id | Unknown | FK |
| created_by_id | Unknown | FK |
| base_currency_iso_code | Unknown |  |
| created_at | Unknown |  |
| currency_iso_code | Unknown |  |
| deleted_at | Unknown |  |
| due_date | Unknown |  |
| grand_total | Unknown |  |
| invoiced_date | Unknown |  |
| number | Unknown |  |
| paid_date | Unknown |  |
| revision | Unknown |  |
| schedule_impact_amount | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### company_schedule_project

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| company_schedule_date | Unknown | PK, FK |
| id | Unknown | PK, FK |
| tasks_count | Unknown |  |

### company_schedule

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| company_id | Unknown | PK, FK |

### budget_modification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_at | Unknown |  |
| from_budget_line_item_id | Unknown |  |
| notes | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| to_budget_line_item_id | Unknown |  |
| transfer_amount | Unknown |  |
| updated_at | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| owners_project_id | Unknown | FK |
| project_stage_id | Unknown | FK |
| accounting_project_number | Unknown |  |
| active | Unknown |  |
| address_street | Unknown |  |
| city | Unknown |  |
| completion_date | Unknown |  |
| country_code | Unknown |  |
| county | Unknown |  |
| created_at | Unknown |  |
| custom_fields | Json |  |
| designated_market_area | Unknown |  |
| display_name | Unknown |  |
| estimated_value | Unknown |  |
| is_demo | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| name | Unknown |  |
| origin_code | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| parent_job_id | Unknown |  |
| phone | Unknown |  |
| photo_id | Unknown |  |
| project_bid_type_id | Unknown |  |
| project_number | Unknown |  |
| project_owner_type_id | Unknown |  |
| project_region_id | Unknown |  |
| project_template_id | Unknown |  |
| project_template_name | Unknown |  |
| stage | Unknown |  |
| start_date | Unknown |  |
| state_code | Unknown |  |
| store_number | Unknown |  |
| time_zone | Unknown |  |
| total_value | Unknown |  |
| updated_at | Instant |  |
| zip | Unknown |  |

### project_membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| party_id | Unknown |  |

### project_people

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

### punch_item_assignment_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| punch_item_assignment_id | Unknown | PK, FK |
| punch_item_id | Unknown | PK, FK |
| filename | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### punch_item_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| punch_item_id | Unknown | PK, FK |
| vendor_id | Unknown | FK |
| approved | Unknown |  |
| comment | Unknown |  |
| login_information_id | Unknown |  |
| login_information_login | Unknown |  |
| login_information_name | Unknown |  |
| manager_accepted_at | Unknown |  |
| notified_at | Unknown |  |
| responded_at | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| user_name | Unknown |  |

### punch_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| assignee_id | Unknown | FK |
| cost_code_id | Unknown | FK |
| created_by_id | Unknown | FK |
| location_id | Unknown | FK |
| assignee_login | Unknown |  |
| assignee_name | Unknown |  |
| ball_in_court_id | Unknown |  |
| ball_in_court_login | Unknown |  |
| ball_in_court_name | Unknown |  |
| closed_at | Unknown |  |
| cost_impact | Unknown |  |
| cost_impact_amount | Unknown |  |
| created_at | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| final_approver_id | Unknown |  |
| final_approver_locale | Unknown |  |
| final_approver_name | Unknown |  |
| has_resolved_response | Unknown |  |
| has_unresolved_response | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| priority | Unknown |  |
| private | Unknown |  |
| punch_item_manager_id | Unknown |  |
| punch_item_manager_locale | Unknown |  |
| punch_item_manager_name | Unknown |  |
| punch_item_type_id | Unknown |  |
| punch_item_type_name | Unknown |  |
| reference | Unknown |  |
| schedule_impact | Unknown |  |
| schedule_impact_days | Unknown |  |
| schedule_risk | Unknown |  |
| schedule_risk_confidence | Unknown |  |
| schedule_risk_probability | Unknown |  |
| schedule_risk_reason | Unknown |  |
| status | Unknown |  |
| trade_active | Unknown |  |
| trade_id | Unknown |  |
| trade_name | Unknown |  |
| trade_updated_at | Unknown |  |
| updated_at | Unknown |  |
| workflow_status | Unknown |  |

### timecard_entry_crew_employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| timecard_entry_id | Unknown | PK, FK |
| login | Unknown |  |
| name | Unknown |  |

### timecard_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| cost_code_id | Unknown | FK |
| location_id | Unknown | FK |
| approval_status | Unknown |  |
| billable | Unknown |  |
| created_at | Unknown |  |
| crew_company_id | Unknown |  |
| crew_created_at | Unknown |  |
| crew_created_by_id | Unknown |  |
| crew_created_by_login | Unknown |  |
| crew_created_by_name | Unknown |  |
| crew_id | Unknown |  |
| crew_lead_id | Unknown |  |
| crew_lead_login | Unknown |  |
| crew_lead_name | Unknown |  |
| crew_name | Unknown |  |
| crew_project_id | Unknown |  |
| crew_updated_at | Unknown |  |
| custom_fields | Json |  |
| date | Unknown |  |
| datetime | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| hours | Unknown |  |
| injured | Unknown |  |
| line_item_type_id | Unknown |  |
| login_information_id | Unknown |  |
| login_information_login | Unknown |  |
| login_information_name | Unknown |  |
| lunch_time | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| party_id | Unknown |  |
| party_name | Unknown |  |
| procore_signature_created_by | Unknown |  |
| procore_signature_created_by_id | Unknown |  |
| procore_signature_created_by_login | Unknown |  |
| procore_signature_created_by_name | Unknown |  |
| procore_signature_file_name | Unknown |  |
| procore_signature_id | Unknown |  |
| procore_signature_large_thumbnail_url | Unknown |  |
| procore_signature_medium_thumbnail_url | Unknown |  |
| procore_signature_signature_text | Unknown |  |
| procore_signature_url | Unknown |  |
| signed | Unknown |  |
| sub_job_code | Unknown |  |
| sub_job_id | Unknown |  |
| sub_job_name | Unknown |  |
| time_in | Unknown |  |
| time_out | Unknown |  |
| timecard_time_type_abbreviated_time_type | Unknown |  |
| timecard_time_type_company_id | Unknown |  |
| timecard_time_type_global | Unknown |  |
| timecard_time_type_id | Unknown |  |
| timecard_time_type_time_type | Unknown |  |
| timesheet_created_at | Unknown |  |
| timesheet_created_by_id | Unknown |  |
| timesheet_created_by_login | Unknown |  |
| timesheet_created_by_name | Unknown |  |
| timesheet_date | Unknown |  |
| timesheet_id | Unknown |  |
| timesheet_name | Unknown |  |
| timesheet_number | Unknown |  |
| timesheet_status | Unknown |  |
| timesheet_updated_at | Unknown |  |
| updated_at | Unknown |  |

### budget_segment_item_path_name

| Column | Type | Keys |
| --- | --- | --- |
| path_name | Unknown | PK |
| budget_detail_id | Unknown | PK, FK |
| budget_detail_segment_item_id | Unknown | PK, FK |

### budget_segment_item_path_code

| Column | Type | Keys |
| --- | --- | --- |
| path_code | Unknown | PK |
| budget_detail_id | Unknown | PK, FK |
| budget_detail_segment_item_id | Unknown | PK, FK |

### budget_segment_item_path

| Column | Type | Keys |
| --- | --- | --- |
| path_id | Unknown | PK |
| budget_detail_id | Unknown | PK, FK |
| budget_detail_segment_item_id | Unknown | PK, FK |

### budget_detail_segment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget_detail_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Unknown |  |
| is_parent | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| path_code | Unknown |  |
| segment_created_at | Unknown |  |
| segment_delimiter | Unknown |  |
| segment_id | Unknown |  |
| segment_name | Unknown |  |
| segment_position | Unknown |  |
| segment_project_can_delete_origin_company | Unknown |  |
| segment_project_can_modify_origin_project | Unknown |  |
| segment_required | Unknown |  |
| segment_segment_items_count | Unknown |  |
| segment_structure | Unknown |  |
| segment_type | Unknown |  |
| segment_updated_at | Unknown |  |
| segment_wbs_pattern_id | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### budget_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget_view_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| cost_code_id | Unknown | FK |
| root_cost_code_id | Unknown | FK |
| vendor_id | Unknown | FK |
| contract_id | Unknown |  |
| contract_name | Unknown |  |
| cost_type_id | Unknown |  |
| cost_type_name | Unknown |  |
| detail_type_id | Unknown |  |
| detail_type_name | Unknown |  |
| item | Unknown |  |
| link | Unknown |  |
| root_cost_code_name | Unknown |  |
| wbs_code_description | Unknown |  |
| wbs_code_flat_code | Unknown |  |
| wbs_code_flat_name | Unknown |  |
| wbs_code_id | Unknown |  |
| custom_** |  |  |

### sub_job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| updated_at | Unknown |  |

### project_date

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| schedule_date_fivetran_id | Unknown | PK, FK |
| date | Unknown |  |
| name | Unknown |  |
| project_membership_id | Unknown |  |

### schedule_date

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| company_id | Unknown | FK |
| project_id | Unknown | FK |
| finish_variance | Unknown |  |
| percentage_complete | Unknown |  |
| substantial_completion_date | Unknown |  |

### prime_contract_pay_app

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| prime_contract_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| billing_date | Unknown |  |
| billing_period_end_date | Unknown |  |
| billing_period_start_date | Unknown |  |
| contract_id | Unknown |  |
| contract_title | Unknown |  |
| contract_type | Unknown |  |
| created_at | Unknown |  |
| currency_configuration_base_currency_iso_code | Unknown |  |
| currency_configuration_currency_exchange_rate | Unknown |  |
| currency_configuration_currency_iso_code | Unknown |  |
| formatted_contract_company | Unknown |  |
| g_702_balance_to_finish_including_retainage | Unknown |  |
| g_702_completed_work_retainage_amount | Unknown |  |
| g_702_completed_work_retainage_percent | Unknown |  |
| g_702_contract_sum_to_date | Unknown |  |
| g_702_current_payment_due | Unknown |  |
| g_702_formatted_period | Unknown |  |
| g_702_less_previous_certificates_for_payment | Unknown |  |
| g_702_negative_change_order_item_total | Unknown |  |
| g_702_negative_new_change_order_item_total | Unknown |  |
| g_702_negative_previous_change_order_item_total | Unknown |  |
| g_702_net_change_by_change_orders | Unknown |  |
| g_702_original_contract_sum | Unknown |  |
| g_702_positive_change_order_item_total | Unknown |  |
| g_702_positive_new_change_order_item_total | Unknown |  |
| g_702_positive_previous_change_order_item_total | Unknown |  |
| g_702_stored_materials_retainage_amount | Unknown |  |
| g_702_stored_materials_retainage_percent | Unknown |  |
| g_702_tax_applicable_to_this_payment | Unknown |  |
| g_702_total_completed_and_stored_to_date | Unknown |  |
| g_702_total_earned_less_retainage | Unknown |  |
| g_702_total_retainage | Unknown |  |
| invoice_number | Unknown |  |
| number | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| percent_complete | Unknown |  |
| period_end | Unknown |  |
| period_id | Unknown |  |
| period_start | Unknown |  |
| status | Unknown |  |
| total_amount_accrued_this_period | Unknown |  |
| total_amount_paid | Unknown |  |
| updated_at | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| parent_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| activity_id | Unknown |  |
| actual_finish | Unknown |  |
| actual_start | Unknown |  |
| baseline_finish | Unknown |  |
| baseline_start | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| critical_path | Unknown |  |
| finish_datetime | Unknown |  |
| finish_variance | Unknown |  |
| full_outline_path | Unknown |  |
| has_children | Unknown |  |
| key | Unknown |  |
| manually_edited | Unknown |  |
| milestone | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| pending | Unknown |  |
| percentage | Unknown |  |
| resource_ids | Json |  |
| resource_name | Unknown |  |
| row_number | Unknown |  |
| schedule_activity_id | Unknown |  |
| schedule_duration | Unknown |  |
| source_uid | Unknown |  |
| start_datetime | Unknown |  |
| start_variance | Unknown |  |
| updated_at | Unknown |  |
| wbs | Unknown |  |

### rfi_error

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| rfi_id | Unknown | PK, FK |
| rfi_question_id | Unknown | PK, FK |
| error | Unknown |  |

### rfi_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| rfi_id | Unknown | PK, FK |
| body | Unknown |  |

### rfi_assignee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| rfi_id | Unknown | PK, FK |
| locale | Unknown |  |
| login | Unknown |  |
| name | Unknown |  |
| response_required | Unknown |  |

### rfi

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| cost_code_id | Unknown | FK |
| created_by_id | Unknown | FK |
| location_id | Unknown | FK |
| project_stage_id | Unknown | FK |
| sub_job_id | Unknown | FK |
| ball_in_court_id | Unknown |  |
| ball_in_court_login | Unknown |  |
| ball_in_court_name | Unknown |  |
| cost_impact_status | Unknown |  |
| cost_impact_value | Unknown |  |
| created_at | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| current_revision | Unknown |  |
| deleted | Unknown |  |
| deleted_at | Unknown |  |
| due_date | Unknown |  |
| full_number | Unknown |  |
| has_revision | Unknown |  |
| initiated_at | Unknown |  |
| link | Unknown |  |
| number | Unknown |  |
| prefix | Unknown |  |
| private | Unknown |  |
| project_stage_default_stage | Unknown |  |
| project_stage_dependent_projects | Unknown |  |
| project_stage_formatted_name | Unknown |  |
| project_stage_formatted_parent_name | Unknown |  |
| project_stage_name | Unknown |  |
| project_stage_parent_id | Unknown |  |
| project_stage_procore_category | Unknown |  |
| received_from_id | Unknown |  |
| received_from_login | Unknown |  |
| received_from_name | Unknown |  |
| reference | Unknown |  |
| responsible_contractor_id | Unknown |  |
| responsible_contractor_name | Unknown |  |
| revision | Unknown |  |
| rfi_manager_id | Unknown |  |
| rfi_manager_login | Unknown |  |
| rfi_manager_name | Unknown |  |
| schedule_impact_status | Unknown |  |
| schedule_impact_value | Unknown |  |
| source_rfi_header_id | Unknown |  |
| specification_section_id | Unknown |  |
| status | Unknown |  |
| sub_job_code | Unknown |  |
| sub_job_name | Unknown |  |
| subject | Unknown |  |
| time_resolved | Unknown |  |
| translated_status | Unknown |  |
| updated_at | Unknown |  |

### prime_contract_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| prime_contract_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| amount | Unknown |  |
| description | Unknown |  |
| extended_type | Unknown |  |
| position | Unknown |  |
| prime_line_item_id | Unknown |  |
| quantity | Unknown |  |
| tax_code_id | Unknown |  |
| unit_cost | Unknown |  |
| uom | Unknown |  |
| wbs_code_description | Unknown |  |
| wbs_code_flat_code | Unknown |  |
| wbs_code_id | Unknown |  |
| work_breakdown_structure | Json |  |

### production_quantity_actual_crew_employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| production_quantity_actual_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| login | Unknown |  |
| name | Unknown |  |

### production_quantity_actual

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| cost_code_id | Unknown | FK |
| created_by_id | Unknown | FK |
| location_id | Unknown | FK |
| sub_job_id | Unknown | FK |
| cost_code_biller_id | Unknown |  |
| cost_code_biller_type | Unknown |  |
| created_at | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| crew_company_id | Unknown |  |
| crew_created_at | Unknown |  |
| crew_created_by_id | Unknown |  |
| crew_created_by_login | Unknown |  |
| crew_created_by_name | Unknown |  |
| crew_id | Unknown |  |
| crew_lead_id | Unknown |  |
| crew_lead_login | Unknown |  |
| crew_lead_name | Unknown |  |
| crew_name | Unknown |  |
| crew_project_id | Unknown |  |
| crew_updated_at | Unknown |  |
| date | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| quantity | Unknown |  |
| sub_job_code | Unknown |  |
| sub_job_created_at | Unknown |  |
| sub_job_name | Unknown |  |
| sub_job_origin_data | Unknown |  |
| sub_job_origin_id | Unknown |  |
| sub_job_updated_at | Unknown |  |
| timesheet_id | Unknown |  |
| unit_of_measure | Unknown |  |
| updated_at | Unknown |  |

### submittal_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| name | Unknown |  |
| status | Unknown |  |

### checklist_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| item_id | Unknown | FK |
| body | Unknown |  |
| created_at | Unknown |  |
| created_by_login | Unknown |  |
| updated_at | Unknown |  |

### budget_view_snapshot

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| budget_view_id | Unknown | FK |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### budget_view_detail_row

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget_view_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| cost_code_id | Unknown | FK |
| wbs_code_id | Unknown | FK |
| budget_forecast_amount | Unknown |  |
| budget_forecast_automatic_amount | Unknown |  |
| budget_forecast_automatically_calculated | Unknown |  |
| budget_forecast_calculation_strategy | Unknown |  |
| budget_forecast_id | Unknown |  |
| budget_forecast_manual_amount | Unknown |  |
| budget_forecast_notes | Unknown |  |
| budget_modifications | Unknown |  |
| budget_row_id | Unknown |  |
| category | Unknown |  |
| category_id | Unknown |  |
| cost_code | Unknown |  |
| cost_code_origin_id | Unknown |  |
| currency_configuration_iso_code | Unknown |  |
| deletable | Unknown |  |
| original_budget_amount | Unknown |  |
| root_cost_code_id | Unknown |  |
| unbudgeted_reason | Unknown |  |
| uom | Unknown |  |
| custom_** |  |  |

### work_order_contract_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| work_order_contract_id | Unknown | PK, FK |
| change_event_line_item_id | Unknown | FK |
| cost_code_id | Unknown | FK |
| amount | Unknown |  |
| change_event_line_item_cost_code_full_code | Unknown |  |
| change_event_line_item_cost_code_id | Unknown |  |
| change_event_line_item_cost_code_name | Unknown |  |
| change_event_line_item_cost_rom | Unknown |  |
| change_event_line_item_currency_iso_code | Unknown |  |
| change_event_line_item_event_id | Unknown |  |
| change_event_line_item_revenue_rom | Unknown |  |
| change_event_line_item_type_base_type | Unknown |  |
| change_event_line_item_type_code | Unknown |  |
| change_event_line_item_type_id | Unknown |  |
| change_event_line_item_type_name | Unknown |  |
| change_event_line_item_type_origin_data | Unknown |  |
| change_event_line_item_type_origin_id | Unknown |  |
| cost_code_biller | Unknown |  |
| cost_code_biller_id | Unknown |  |
| cost_code_biller_type | Unknown |  |
| cost_code_standard_cost_code_list_id | Unknown |  |
| created_at | Unknown |  |
| currency_iso_code | Unknown |  |
| description | Unknown |  |
| extended_amount | Unknown |  |
| extended_type | Unknown |  |
| holder_id | Unknown |  |
| holder_type | Unknown |  |
| line_item_type_base_type | Unknown |  |
| line_item_type_code | Unknown |  |
| line_item_type_id | Unknown |  |
| line_item_type_name | Unknown |  |
| line_item_type_origin_data | Unknown |  |
| line_item_type_origin_id | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| position | Unknown |  |
| quantity | Unknown |  |
| tax_code_id | Unknown |  |
| total_amount | Unknown |  |
| unit_cost | Unknown |  |
| uom | Unknown |  |
| updated_at | Unknown |  |
| wbs_code_description | Unknown |  |
| wbs_code_flat_code | Unknown |  |
| wbs_code_id | Unknown |  |

### change_order_package

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| contract_id | Unknown |  |
| created_at | Unknown |  |
| currency_configuration_base_currency_iso_code | Unknown |  |
| currency_configuration_currency_iso_code | Unknown |  |
| deleted_at | Unknown |  |
| designated_reviewer_id | Unknown |  |
| designated_reviewer_login | Unknown |  |
| designated_reviewer_name | Unknown |  |
| due_date | Unknown |  |
| executed | Unknown |  |
| grand_total | Unknown |  |
| invoiced_date | Unknown |  |
| number | Unknown |  |
| origin_code | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| paid_date | Unknown |  |
| reviewed_at | Unknown |  |
| revision | Unknown |  |
| signed_change_order_received_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_home_url | Unknown |  |
| is_active | Unknown |  |
| logo_url | Unknown |  |
| my_company | Unknown |  |
| name | Unknown |  |
| pcn_business_experience | Unknown |  |

### change_order_potential

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| base_currency_iso_code | Unknown |  |
| change_order_package_acronym_number | Unknown |  |
| change_order_package_title | Unknown |  |
| change_order_request_acronym_number | Unknown |  |
| change_order_request_id | Unknown |  |
| change_order_request_title | Unknown |  |
| change_order_tier | Unknown |  |
| change_reason | Unknown |  |
| contract_id | Unknown |  |
| created_at | Unknown |  |
| currency_exchange_rate | Unknown |  |
| currency_iso_code | Unknown |  |
| deleted_at | Unknown |  |
| due_date | Unknown |  |
| executed | Unknown |  |
| grand_total | Unknown |  |
| invoiced_date | Unknown |  |
| number | Unknown |  |
| paid_date | Unknown |  |
| potential_change_order_acronym_number | Unknown |  |
| reviewed_at | Unknown |  |
| revision | Unknown |  |
| schedule_impact_amount | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### dailylog_work_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| dailylog_work_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| filename | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### dailylog_work_scheduled_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dailylog_work_id | Unknown | PK, FK |
| task_id | Unknown | FK |
| task_name | Unknown |  |
| task_percentage | Unknown |  |
| task_row_number | Unknown |  |
| work_log_id | Unknown |  |

### dailylog_work

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| location_id | Unknown | FK |
| vendor_id | Unknown | FK |
| comment | Unknown |  |
| created_at | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| daily_log_segment_id | Unknown |  |
| date | Unknown |  |
| datetime | Unknown |  |
| hourly_rate | Unknown |  |
| hours | Unknown |  |
| position | Unknown |  |
| reimbursable | Unknown |  |
| resource_name | Unknown |  |
| showed | Unknown |  |
| updated_at | Unknown |  |
| worker | Unknown |  |

### prime_contract_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| prime_contract_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| filename | Unknown |  |
| url | Unknown |  |

### prime_contract_contractor_trade

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| prime_contract_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| active | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### prime_contract_contractor_bidding_distribution

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| prime_contract_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| login | Unknown |  |
| name | Unknown |  |

### prime_contract_contractor_standard_cost_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| prime_contract_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| code | Unknown |  |
| full_code | Unknown |  |
| name | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| parent_id | Unknown |  |
| standard_cost_code_list_id | Unknown |  |

### prime_contract_contractor_project_id

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| prime_contract_contractor_project_id | Unknown | PK, FK |
| prime_contract_id | Unknown | PK, FK |

### prime_contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| vendor_id | Unknown | FK |
| accounting_method | Unknown |  |
| actual_completion_date | Unknown |  |
| approval_letter_date | Unknown |  |
| approved_change_order | Unknown |  |
| architect_id | Unknown |  |
| architect_login | Unknown |  |
| architect_name | Unknown |  |
| base_currency_iso_code | Unknown |  |
| contract_date | Unknown |  |
| contract_estimated_completion_date | Unknown |  |
| contract_start_date | Unknown |  |
| contract_termination_date | Unknown |  |
| contractor_abbreviated_name | Unknown |  |
| contractor_address | Unknown |  |
| contractor_authorized_bidder | Unknown |  |
| contractor_bidding_affirmative_action | Unknown |  |
| contractor_bidding_african_american_business | Unknown |  |
| contractor_bidding_asian_american_business | Unknown |  |
| contractor_bidding_certified_business_enterprise | Unknown |  |
| contractor_bidding_disadvantaged_business | Unknown |  |
| contractor_bidding_eight_a_business | Unknown |  |
| contractor_bidding_hispanic_business | Unknown |  |
| contractor_bidding_historically_underutilized_business | Unknown |  |
| contractor_bidding_minority_business_enterprise | Unknown |  |
| contractor_bidding_native_american_business | Unknown |  |
| contractor_bidding_sdvo_business | Unknown |  |
| contractor_bidding_small_business | Unknown |  |
| contractor_bidding_womens_business | Unknown |  |
| contractor_business_phone | Unknown |  |
| contractor_business_register_id | Unknown |  |
| contractor_business_register_identifier | Unknown |  |
| contractor_business_register_parent_id | Unknown |  |
| contractor_business_register_type | Unknown |  |
| contractor_business_register_verification_status | Unknown |  |
| contractor_business_register_verified_at | Unknown |  |
| contractor_children_count | Unknown |  |
| contractor_city | Unknown |  |
| contractor_company | Unknown |  |
| contractor_contact_count | Unknown |  |
| contractor_country_code | Unknown |  |
| contractor_created_at | Unknown |  |
| contractor_email_address | Unknown |  |
| contractor_fax_number | Unknown |  |
| contractor_id | Unknown |  |
| contractor_is_active | Unknown |  |
| contractor_labor_union | Unknown |  |
| contractor_legal_name | Unknown |  |
| contractor_license_number | Unknown |  |
| contractor_logo | Unknown |  |
| contractor_mobile_phone | Unknown |  |
| contractor_name | Unknown |  |
| contractor_non_union_prevailing_wage | Unknown |  |
| contractor_notes | Unknown |  |
| contractor_origin_code | Unknown |  |
| contractor_origin_data | Unknown |  |
| contractor_origin_id | Unknown |  |
| contractor_parent_id | Unknown |  |
| contractor_parent_name | Unknown |  |
| contractor_prequalified | Unknown |  |
| contractor_primary_contact_business_phone | Unknown |  |
| contractor_primary_contact_business_phone_extension | Unknown |  |
| contractor_primary_contact_created_at | Unknown |  |
| contractor_primary_contact_email_address | Unknown |  |
| contractor_primary_contact_fax_number | Unknown |  |
| contractor_primary_contact_first_name | Unknown |  |
| contractor_primary_contact_id | Unknown |  |
| contractor_primary_contact_last_name | Unknown |  |
| contractor_primary_contact_mobile_phone | Unknown |  |
| contractor_primary_contact_updated_at | Unknown |  |
| contractor_state_code | Unknown |  |
| contractor_synced_to_erp | Unknown |  |
| contractor_trade_name | Unknown |  |
| contractor_union_member | Unknown |  |
| contractor_updated_at | Unknown |  |
| contractor_vendor_group_id | Unknown |  |
| contractor_vendor_group_name | Unknown |  |
| contractor_website | Unknown |  |
| contractor_zip | Unknown |  |
| created_at | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| currency_exchange_rate | Unknown |  |
| currency_iso_code | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| exclusion | Unknown |  |
| executed | Unknown |  |
| execution_date | Unknown |  |
| grand_total | Unknown |  |
| inclusion | Unknown |  |
| issued_on_date | Unknown |  |
| letter_of_intent_date | Unknown |  |
| number | Unknown |  |
| origin_code | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| private | Unknown |  |
| retainage_percent | Unknown |  |
| returned_date | Unknown |  |
| show_line_items_to_non_admin | Unknown |  |
| signed_contract_received_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### checklist_schedule_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| checklist_schedule_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| attachment_file_name | Unknown |  |
| attachment_name | Unknown |  |
| attachment_url | Unknown |  |
| content_type | Unknown |  |
| created_at | Unknown |  |
| file_id | Unknown |  |
| schedule_id | Unknown |  |
| thumbnail_url | Unknown |  |
| viewable_document_id | Unknown |  |

### budget_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| created_by_login | Unknown |  |
| created_by_name | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |
| updated_at | Unknown |  |

### purchase_order_contract_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| purchase_order_contract_id | Unknown | PK, FK |
| change_event_line_item_id | Unknown | FK |
| cost_code_id | Unknown | FK |
| amount | Unknown |  |
| change_event_line_item_cost_rom | Unknown |  |
| change_event_line_item_revenue_rom | Unknown |  |
| cost_code_biller | Unknown |  |
| cost_code_biller_id | Unknown |  |
| cost_code_biller_type | Unknown |  |
| cost_code_standard_cost_code_list_id | Unknown |  |
| created_at | Unknown |  |
| currency_iso_code | Unknown |  |
| description | Unknown |  |
| extended_amount | Unknown |  |
| extended_type | Unknown |  |
| holder_id | Unknown |  |
| holder_type | Unknown |  |
| line_item_type_base_type | Unknown |  |
| line_item_type_code | Unknown |  |
| line_item_type_id | Unknown |  |
| line_item_type_name | Unknown |  |
| line_item_type_origin_data | Unknown |  |
| line_item_type_origin_id | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| position | Unknown |  |
| quantity | Unknown |  |
| tax_code_id | Unknown |  |
| total_amount | Unknown |  |
| unit_cost | Unknown |  |
| uom | Unknown |  |
| updated_at | Unknown |  |
| wbs_code_description | Unknown |  |
| wbs_code_flat_code | Unknown |  |
| wbs_code_id | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| parent_id | Unknown | FK |
| code | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| node_name | Unknown |  |
| updated_at | Unknown |  |

### submittal_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| name | Unknown |  |
| translated_name | Unknown |  |

### inspection_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| name | Unknown |  |
| source_id | Unknown |  |
| updated_at | Unknown |  |

### project_tool

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| engine_name | Unknown |  |
| is_active | Unknown |  |
| position | Unknown |  |
| required | Unknown |  |
| title | Unknown |  |

### cost_code_line_item_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cost_code_id | Unknown | PK, FK |
| base_type | Unknown |  |
| code | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |

### cost_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| parent_id | Unknown | FK |
| budgeted | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| full_code | Unknown |  |
| name | Unknown |  |
| origin_data | Unknown |  |
| origin_id | Unknown |  |
| position | Unknown |  |
| sortable_code | Unknown |  |
| standard_cost_code_id | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- project_vendor(vendor_id) → company_vendor(id)
- project_vendor(project_id) → project(id)
- project_vendor(company_id) → project(company_id)
- project_role(user_id) → project_user(id)
- project_role(project_id) → project(id)
- project_role(company_id) → project(company_id)
- checklist_item_type(project_id) → project(id)
- checklist_item_type(company_id) → project(company_id)
- company_office(company_id) → company(id)
- budget_view_summary_row_line_item(budget_view_summary_row_id) → budget_view_summary_row(id)
- budget_view_summary_row(project_id) → budget_view(project_id)
- budget_view_summary_row(company_id) → budget_view(company_id)
- budget_view_summary_row(budget_view_id) → budget_view(id)
- project_user(id) → company_user(id)
- project_user(project_id) → project(id)
- project_user(company_id) → project(company_id)
- company_checklist_template(inspection_type_id) → inspection_type(id)
- company_checklist_template(company_id) → company(id)
- project_injury_body_part(project_injury_id) → project_injury(id)
- project_injury_affliction(project_injury_id) → project_injury(id)
- project_injury_affected_body_part(project_injury_id) → project_injury(id)
- project_injury(company_id) → project(company_id)
- project_injury(project_id) → project(id)
- checklist_item_response_set(checklist_item_id) → checklist_item(id)
- checklist_item(type_id) → checklist_item_type(id)
- checklist_item(item_responder_id) → project_user(id)
- checklist_item(company_id) → project(company_id)
- checklist_item(project_id) → project(id)
- company_vendor_trade(company_vendor_id) → company_vendor(id)
- company_vendor_standard_cost_code(company_vendor_id) → company_vendor(id)
- company_vendor_bidding_distribution(company_vendor_id) → company_vendor(id)
- company_vendor_attachment(company_vendor_id) → company_vendor(id)
- company_vendor_project(project_id) → project(id)
- company_vendor_project(company_vendor_id) → company_vendor(id)
- company_vendor(company_id) → company(id)
- work_order_contract(vendor_id) → company_vendor(id)
- work_order_contract(project_id) → project(id)
- work_order_contract(company_id) → project(company_id)
- dailylog_manpower_attachment(dailylog_manpower_id) → dailylog_manpower(id)
- dailylog_manpower_attachment(project_id) → dailylog_manpower(project_id)
- dailylog_manpower_attachment(company_id) → dailylog_manpower(company_id)
- dailylog_manpower(vendor_id) → company_vendor(id)
- dailylog_manpower(cost_code_id) → cost_code(id)
- dailylog_manpower(created_by_id) → project_user(id)
- dailylog_manpower(location_id) → location(id)
- dailylog_manpower(project_id) → project(id)
- dailylog_manpower(company_id) → project(company_id)
- rfi_attachment(rfi_id) → rfi(id)
- rfi_attachment(project_id) → rfi(project_id)
- rfi_attachment(company_id) → rfi(company_id)
- rfi_question_answer(created_by_id) → project_user(id)
- rfi_question_answer(rfi_id) → rfi(id)
- rfi_question_answer(project_id) → rfi(project_id)
- rfi_question_answer(company_id) → rfi(company_id)
- direct_cost(vendor_id) → company_vendor(id)
- direct_cost(project_id) → project(id)
- direct_cost(company_id) → project(company_id)
- task_item(assignee_id) → project_user(id)
- task_item(company_id) → project(company_id)
- task_item(project_id) → project(id)
- submittal_current_step_approver(submittal_id) → submittal(id)
- submittal_current_step_approver(project_id) → submittal(project_id)
- submittal_current_step_approver(company_id) → submittal(company_id)
- submittal_distribution_member_id(submittal_id) → submittal(id)
- submittal_distribution_member_id(project_id) → submittal(project_id)
- submittal_distribution_member_id(company_id) → submittal(company_id)
- submittal(sub_job_id) → sub_job(id)
- submittal(cost_code_id) → cost_code(id)
- submittal(project_id) → project(id)
- submittal(company_id) → project(company_id)
- budget_view_snapshot_detail_segment_item_path(budget_view_snapshot_detail_segment_item_index) → budget_view_snapshot_detail_segment_item(index)
- budget_view_snapshot_detail_segment_item_path(budget_view_snapshot_detail_row_fivetran_id) → budget_view_snapshot_detail_segment_item(budget_view_snapshot_detail_row_fivetran_id)
- budget_view_snapshot_detail_segment_item_path_code(budget_view_snapshot_detail_segment_item_index) → budget_view_snapshot_detail_segment_item(index)
- budget_view_snapshot_detail_segment_item_path_code(budget_view_snapshot_detail_row_fivetran_id) → budget_view_snapshot_detail_segment_item(budget_view_snapshot_detail_row_fivetran_id)
- budget_view_snapshot_detail_segment_item(budget_view_snapshot_detail_row_fivetran_id) → budget_view_snapshot_detail_row(_fivetran_id)
- budget_view_snapshot_detail_row(biller_id) → project(id)
- budget_view_snapshot_detail_row(company_id) → budget_view_snapshot(company_id)
- budget_view_snapshot_detail_row(project_id) → budget_view_snapshot(project_id)
- budget_view_snapshot_detail_row(budget_view_snapshot_id) → budget_view_snapshot(id)
- project_stage(company_id) → company(id)
- direct_cost_line_item(cost_code_id) → cost_code(id)
- direct_cost_line_item(project_id) → project(id)
- direct_cost_line_item(company_id) → project(company_id)
- purchase_order_contract_potential_change_order(id) → change_order_potential(id)
- purchase_order_contract_potential_change_order(purchase_order_contract_id) → purchase_order_contract(id)
- purchase_order_contract_potential_change_order(project_id) → purchase_order_contract(project_id)
- purchase_order_contract_potential_change_order(company_id) → purchase_order_contract(company_id)
- purchase_order_contract_change_order_package(id) → change_order_package(id)
- purchase_order_contract_change_order_package(purchase_order_contract_id) → purchase_order_contract(id)
- purchase_order_contract_change_order_package(project_id) → purchase_order_contract(project_id)
- purchase_order_contract_change_order_package(company_id) → purchase_order_contract(company_id)
- purchase_order_contract_change_order_request(id) → change_order_request(id)
- purchase_order_contract_change_order_request(purchase_order_contract_id) → purchase_order_contract(id)
- purchase_order_contract_change_order_request(project_id) → purchase_order_contract(project_id)
- purchase_order_contract_change_order_request(company_id) → purchase_order_contract(company_id)
- purchase_order_contract_invoice_contact(purchase_order_contract_id) → purchase_order_contract(id)
- purchase_order_contract_invoice_contact(project_id) → purchase_order_contract(project_id)
- purchase_order_contract_invoice_contact(company_id) → purchase_order_contract(company_id)
- purchase_order_contract_payments_issued_attachment(purchase_order_contract_payments_issued_id) → purchase_order_contract_payments_issued(id)
- purchase_order_contract_payments_issued_attachment(purchase_order_contract_id) → purchase_order_contract_payments_issued(purchase_order_contract_id)
- purchase_order_contract_payments_issued_attachment(project_id) → purchase_order_contract_payments_issued(project_id)
- purchase_order_contract_payments_issued_attachment(company_id) → purchase_order_contract_payments_issued(company_id)
- purchase_order_contract_payments_issued(purchase_order_contract_id) → purchase_order_contract(id)
- purchase_order_contract_payments_issued(project_id) → purchase_order_contract(project_id)
- purchase_order_contract_payments_issued(company_id) → purchase_order_contract(company_id)
- purchase_order_contract(vendor_id) → company_vendor(id)
- purchase_order_contract(created_by_id) → project_user(id)
- purchase_order_contract(assignee_id) → project_user(id)
- task_item_comment(task_item_id) → task_item(id)
- task_item_comment(company_id) → project(company_id)
- task_item_comment(project_id) → project(id)
- change_order_change_event_line_item(budget_change_id) → budget_change(id)
- change_order_change_event_line_item(project_id) → budget_change(project_id)
- change_order_change_event_line_item(company_id) → budget_change(company_id)
- budget_change(created_by_id) → project_user(id)
- budget_change(prime_contract_id) → prime_contract(id)
- budget_change(project_id) → project(id)
- budget_change(company_id) → project(company_id)
- change_event_line_item_budget_code_segment_item(change_event_line_item_id) → change_event_line_item(id)
- change_event_line_item_budget_code_segment_item(change_event_id) → change_event_line_item(change_event_id)
- change_event_line_item_budget_code_segment_item(project_id) → change_event_line_item(project_id)
- change_event_line_item_budget_code_segment_item(company_id) → change_event_line_item(company_id)
- change_event_line_item_budget_impact_estimate_transfer_from_wbs_code_segment_item(change_event_line_item_id) → change_event_line_item(id)
- change_event_line_item_budget_impact_estimate_transfer_from_wbs_code_segment_item(change_event_id) → change_event_line_item(change_event_id)
- change_event_line_item_budget_impact_estimate_transfer_from_wbs_code_segment_item(project_id) → change_event_line_item(project_id)
- change_event_line_item_budget_impact_estimate_transfer_from_wbs_code_segment_item(company_id) → change_event_line_item(company_id)
- change_event_line_item(budget_impact_budget_change_id) → budget_change(id)
- change_event_line_item(budget_impact_budget_modification_id) → budget_modification(id)
- change_event_line_item(cost_impact_change_order_package_id) → change_order_package(id)
- change_event_line_item(revenue_impact_change_order_package_id) → change_order_package(id)
- change_event_line_item(change_event_id) → change_event(id)
- change_event_line_item(project_id) → change_event(project_id)
- change_event_line_item(company_id) → change_event(company_id)
- change_event_attachment(change_event_id) → change_event(id)
- change_event_attachment(project_id) → change_event(project_id)
- change_event_attachment(company_id) → change_event(company_id)
- change_event_markup_item_wbs_code_segment_item(change_event_markup_item_id) → change_event_markup_item(id)
- change_event_markup_item_wbs_code_segment_item(change_event_id) → change_event_markup_item(change_event_id)
- change_event_markup_item_wbs_code_segment_item(project_id) → change_event_markup_item(project_id)
- change_event_markup_item_wbs_code_segment_item(company_id) → change_event_markup_item(company_id)
- change_event_markup_item(change_event_id) → change_event(id)
- change_event_markup_item(project_id) → change_event(project_id)
- change_event_markup_item(company_id) → change_event(company_id)
- change_event_production_wbs_segment_item(change_event_production_quantity_id) → change_event_production_quantity(id)
- change_event_production_wbs_segment_item(change_event_id) → change_event_production_quantity(change_event_id)
- change_event_production_wbs_segment_item(project_id) → change_event_production_quantity(project_id)
- change_event_production_wbs_segment_item(company_id) → change_event_production_quantity(company_id)
- change_event_production_disabled_field(change_event_production_quantity_id) → change_event_production_quantity(id)
- change_event_production_disabled_field(change_event_id) → change_event_production_quantity(change_event_id)
- change_event_production_disabled_field(project_id) → change_event_production_quantity(project_id)
- change_event_production_disabled_field(company_id) → change_event_production_quantity(company_id)
- change_event_production_quantity(production_code_cost_code_id) → cost_code(id)
- change_event_production_quantity(production_code_sub_job_id) → sub_job(id)
- change_event_production_quantity(budget_change_id) → budget_change(id)
- change_event_production_quantity(change_event_id) → change_event(id)
- change_event_production_quantity(project_id) → change_event(project_id)
- change_event_production_quantity(company_id) → change_event(company_id)
- change_event(project_id) → project(id)
- change_event(company_id) → project(company_id)
- observation(assignee_id) → company_user(id)
- observation(vendor_id) → company_vendor(id)
- observation(location_id) → location(id)
- observation(checklist_item_id) → checklist_item(id)
- observation(project_id) → project(id)
- observation(company_id) → project(company_id)
- checklist_schedule_assignee(checklist_schedule_id) → checklist_schedule(id)
- checklist_schedule(project_id) → project(id)
- checklist_schedule(company_id) → project(company_id)
- project_incident(location_id) → location(id)
- project_incident(company_id) → project(company_id)
- project_incident(project_id) → project(id)
- company_user(vendor_id) → project_vendor(vendor_id)
- company_user(work_classification_id) → project_level_work_classification(id)
- company_user(company_id) → company(id)
- work_classification_project(project_id) → project(id)
- work_classification_project(project_level_work_classification_id) → project_level_work_classification(id)
- project_level_work_classification(company_id) → project(company_id)
- project_level_work_classification(project_id) → project(id)
- change_order_request(change_order_package_id) → change_order_package(id)
- change_order_request(created_by_id) → project_user(id)
- change_order_request(prime_contract_id) → prime_contract(id)
- change_order_request(project_id) → prime_contract(project_id)
- change_order_request(company_id) → prime_contract(company_id)
- company_schedule_project(id) → project(id)
- company_schedule_project(company_schedule_date) → company_schedule(date)
- company_schedule_project(company_id) → company_schedule(company_id)
- company_schedule(company_id) → company(id)
- budget_modification(project_id) → project(id)
- budget_modification(company_id) → project(company_id)
- project(project_stage_id) → project_stage(id)
- project(owners_project_id) → project(id)
- project(company_id) → company(id)
- project_membership(project_id) → project(id)
- project_membership(company_id) → project(company_id)
- project_people(user_uuid) → project_user(id)
- project_people(project_id) → project(id)
- project_people(company_id) → project(company_id)
- punch_item_assignment_attachment(punch_item_assignment_id) → punch_item_assignment(id)
- punch_item_assignment_attachment(punch_item_id) → punch_item_assignment(punch_item_id)
- punch_item_assignment_attachment(project_id) → punch_item_assignment(project_id)
- punch_item_assignment_attachment(company_id) → punch_item_assignment(company_id)
- punch_item_assignment(vendor_id) → company_vendor(id)
- punch_item_assignment(punch_item_id) → punch_item(id)
- punch_item_assignment(project_id) → punch_item(project_id)
- punch_item_assignment(company_id) → punch_item(company_id)
- punch_item(cost_code_id) → cost_code(id)
- punch_item(created_by_id) → project_user(id)
- punch_item(location_id) → location(id)
- punch_item(assignee_id) → project_user(id)
- punch_item(project_id) → project(id)
- punch_item(company_id) → project(company_id)
- timecard_entry_crew_employee(timecard_entry_id) → timecard_entry(id)
- timecard_entry(cost_code_id) → cost_code(id)
- timecard_entry(location_id) → location(id)
- timecard_entry(project_id) → project(id)
- timecard_entry(company_id) → project(company_id)
- budget_segment_item_path_name(budget_detail_segment_item_id) → budget_detail_segment_item(id)
- budget_segment_item_path_name(budget_detail_id) → budget_detail_segment_item(budget_detail_id)
- budget_segment_item_path_code(budget_detail_segment_item_id) → budget_detail_segment_item(id)
- budget_segment_item_path_code(budget_detail_id) → budget_detail_segment_item(budget_detail_id)
- budget_segment_item_path(budget_detail_segment_item_id) → budget_detail_segment_item(id)
- budget_segment_item_path(budget_detail_id) → budget_detail_segment_item(budget_detail_id)
- budget_detail_segment_item(budget_detail_id) → budget_detail(id)
- budget_detail(vendor_id) → company_vendor(id)
- budget_detail(root_cost_code_id) → cost_code(parent_id)
- budget_detail(cost_code_id) → cost_code(id)
- budget_detail(budget_view_id) → budget_view(id)
- budget_detail(company_id) → budget_view(company_id)
- sub_job(project_id) → project(id)
- sub_job(company_id) → project(company_id)
- project_date(schedule_date_fivetran_id) → schedule_date(_fivetran_id)
- schedule_date(project_id) → project(id)
- schedule_date(company_id) → project(company_id)
- prime_contract_pay_app(prime_contract_id) → prime_contract(id)
- prime_contract_pay_app(project_id) → prime_contract(project_id)
- prime_contract_pay_app(company_id) → prime_contract(company_id)
- task(updated_by_id) → project_user(id)
- task(created_by_id) → project_user(id)
- task(parent_id) → task(id)
- task(company_id) → project(company_id)
- task(project_id) → project(id)
- rfi_error(rfi_question_id) → rfi_question(id)
- rfi_error(rfi_id) → rfi_question(rfi_id)
- rfi_error(project_id) → rfi_question(project_id)
- rfi_error(company_id) → rfi_question(company_id)
- rfi_question(rfi_id) → rfi(id)
- rfi_question(project_id) → rfi(project_id)
- rfi_question(company_id) → rfi(company_id)
- rfi_assignee(rfi_id) → rfi(id)
- rfi_assignee(project_id) → rfi(project_id)
- rfi_assignee(company_id) → rfi(company_id)
- rfi(cost_code_id) → cost_code(id)
- rfi(created_by_id) → project_user(id)
- rfi(location_id) → location(id)
- rfi(project_stage_id) → project_stage(id)
- rfi(sub_job_id) → sub_job(id)
- rfi(project_id) → project(id)
- rfi(company_id) → project(company_id)
- prime_contract_line_item(prime_contract_id) → prime_contract(id)
- prime_contract_line_item(project_id) → prime_contract(project_id)
- prime_contract_line_item(company_id) → prime_contract(company_id)
- production_quantity_actual_crew_employee(production_quantity_actual_id) → production_quantity_actual(id)
- production_quantity_actual_crew_employee(project_id) → production_quantity_actual(project_id)
- production_quantity_actual_crew_employee(company_id) → production_quantity_actual(company_id)
- production_quantity_actual(location_id) → location(id)
- production_quantity_actual(sub_job_id) → sub_job(id)
- production_quantity_actual(cost_code_id) → cost_code(id)
- production_quantity_actual(created_by_id) → project_user(id)
- production_quantity_actual(project_id) → project(id)
- production_quantity_actual(company_id) → project(company_id)
- submittal_status(company_id) → company(id)
- checklist_comment(item_id) → checklist_item(id)
- checklist_comment(created_by_id) → project_user(id)
- checklist_comment(company_id) → project(company_id)
- checklist_comment(project_id) → project(id)
- budget_view_snapshot(budget_view_id) → budget_view(id)
- budget_view_snapshot(project_id) → project(id)
- budget_view_snapshot(company_id) → project(company_id)
- budget_view_detail_row(wbs_code_id) → budget_detail(wbs_code_id)
- budget_view_detail_row(cost_code_id) → cost_code(id)
- budget_view_detail_row(company_id) → budget_view(company_id)
- budget_view_detail_row(project_id) → budget_view(project_id)
- budget_view_detail_row(budget_view_id) → budget_view(id)
- work_order_contract_line_item(cost_code_id) → cost_code(id)
- work_order_contract_line_item(change_event_line_item_id) → change_event_line_item(id)
- work_order_contract_line_item(work_order_contract_id) → work_order_contract(id)
- work_order_contract_line_item(project_id) → work_order_contract(project_id)
- work_order_contract_line_item(company_id) → work_order_contract(company_id)
- change_order_package(created_by_id) → project_user(id)
- change_order_package(project_id) → project(id)
- change_order_package(company_id) → project(company_id)
- change_order_potential(created_by_id) → project_user(id)
- change_order_potential(project_id) → project(id)
- change_order_potential(company_id) → project(company_id)
- dailylog_work_attachment(dailylog_work_id) → dailylog_work(id)
- dailylog_work_attachment(project_id) → dailylog_work(project_id)
- dailylog_work_attachment(company_id) → dailylog_work(company_id)
- dailylog_work_scheduled_task(task_id) → task(id)
- dailylog_work_scheduled_task(dailylog_work_id) → dailylog_work(id)
- dailylog_work(created_by_id) → project_user(id)
- dailylog_work(vendor_id) → company_vendor(id)
- dailylog_work(location_id) → location(id)
- dailylog_work(project_id) → project(id)
- dailylog_work(company_id) → project(company_id)
- prime_contract_attachment(prime_contract_id) → prime_contract(id)
- prime_contract_attachment(project_id) → prime_contract(project_id)
- prime_contract_attachment(company_id) → prime_contract(company_id)
- prime_contract_contractor_trade(prime_contract_id) → prime_contract(id)
- prime_contract_contractor_trade(project_id) → prime_contract(project_id)
- prime_contract_contractor_trade(company_id) → prime_contract(company_id)
- prime_contract_contractor_bidding_distribution(prime_contract_id) → prime_contract(id)
- prime_contract_contractor_bidding_distribution(project_id) → prime_contract(project_id)
- prime_contract_contractor_bidding_distribution(company_id) → prime_contract(company_id)
- prime_contract_contractor_standard_cost_code(prime_contract_id) → prime_contract(id)
- prime_contract_contractor_standard_cost_code(project_id) → prime_contract(project_id)
- prime_contract_contractor_standard_cost_code(company_id) → prime_contract(company_id)
- prime_contract_contractor_project_id(prime_contract_contractor_project_id) → prime_contract(project_id)
- prime_contract_contractor_project_id(prime_contract_id) → prime_contract(id)
- prime_contract_contractor_project_id(company_id) → prime_contract(company_id)
- prime_contract(vendor_id) → company_vendor(id)
- prime_contract(created_by_id) → project_user(id)
- prime_contract(project_id) → project(id)
- prime_contract(company_id) → project(company_id)
- checklist_schedule_attachment(project_id) → checklist_schedule(project_id)
- checklist_schedule_attachment(checklist_schedule_id) → checklist_schedule(id)
- budget_view(company_id) → project(company_id)
- budget_view(project_id) → project(id)
- purchase_order_contract_line_item(cost_code_id) → cost_code(id)
- purchase_order_contract_line_item(change_event_line_item_id) → change_event_line_item(id)
- purchase_order_contract_line_item(purchase_order_contract_id) → purchase_order_contract(id)
- purchase_order_contract_line_item(project_id) → purchase_order_contract(project_id)
- purchase_order_contract_line_item(company_id) → purchase_order_contract(company_id)
- location(parent_id) → location(id)
- location(project_id) → project(id)
- location(company_id) → project(company_id)
- submittal_type(company_id) → company(id)
- inspection_type(company_id) → company(id)
- project_tool(project_id) → project(id)
- project_tool(company_id) → project(company_id)
- cost_code_line_item_type(cost_code_id) → cost_code(id)
- cost_code(parent_id) → cost_code(id)
- cost_code(company_id) → project(company_id)
- cost_code(project_id) → project(id)