Procore
Explore the interactive ERD
Table & Field Reference
project_vendor
| Column | Type | Keys |
|---|---|---|
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
project_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
category | Unknown | |
name | Unknown |
company_office
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
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 | PKFK |
budget_view_summary_row
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
budget_view_id | Unknown | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
affected_body_part | Unknown |
project_injury
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
item_status_id | Unknown | |
name | Unknown | |
status | Unknown |
checklist_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
active | Unknown | |
name | Unknown | |
updated_at | Unknown |
company_vendor_standard_cost_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_vendor_id | Unknown | PKFK |
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 | PKFK |
company_name | Unknown | |
login | Unknown | |
name | Unknown |
company_vendor_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_vendor_id | Unknown | PKFK |
filename | Unknown | |
url | Unknown |
company_vendor_project
| Column | Type | Keys |
|---|---|---|
company_vendor_id | Unknown | PKFK |
project_id | Unknown | PKFK |
company_vendor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
dailylog_manpower_id | Unknown | PKFK |
project_id | Unknown | PKFK |
filename | Unknown | |
name | Unknown | |
url | Unknown |
dailylog_manpower
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
rfi_id | Unknown | PKFK |
filename | Unknown | |
name | Unknown | |
url | Unknown |
rfi_question_answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
rfi_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
submittal_id | Unknown | PKFK |
response_required | Unknown | |
user_id | Unknown | |
user_name | Unknown |
submittal_distribution_member_id
| Column | Type | Keys |
|---|---|---|
distribution_member_id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
submittal_id | Unknown | PKFK |
submittal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
budget_view_snapshot_detail_segment_item_index | Unknown | PKFK |
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 | PKFK |
budget_view_snapshot_detail_segment_item_index | Unknown | PKFK |
path_code | Unknown |
budget_view_snapshot_detail_segment_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
budget_view_snapshot_detail_row_fivetran_id | Unknown | PKFK |
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 | PKFK |
category | Unknown | |
is_bidding_stage | Unknown | |
name | Unknown | |
read_only | Unknown |
direct_cost_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
project_id | Unknown | PKFK |
purchase_order_contract_id | Unknown | PKFK |
purchase_order_contract_change_order_package
| Column | Type | Keys |
|---|---|---|
company_id | Unknown | PKFK |
id | Unknown | PKFK |
project_id | Unknown | PKFK |
purchase_order_contract_id | Unknown | PKFK |
purchase_order_contract_change_order_request
| Column | Type | Keys |
|---|---|---|
company_id | Unknown | PKFK |
id | Unknown | PKFK |
project_id | Unknown | PKFK |
purchase_order_contract_id | Unknown | PKFK |
currency_exchange_rate | Unknown |
purchase_order_contract_invoice_contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
purchase_order_contract_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
purchase_order_contract_id | Unknown | PKFK |
purchase_order_contract_payments_issued_id | Unknown | PKFK |
filename | Unknown | |
url | Unknown |
purchase_order_contract_payments_issued
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
purchase_order_contract_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
budget_change
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
change_event_line_item_id | Unknown | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
change_event_line_item_id | Unknown | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
filename | Unknown | |
url | Unknown |
change_event_markup_item_wbs_code_segment_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
change_event_id | Unknown | PKFK |
change_event_markup_item_id | Unknown | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
change_event_production_quantity_id | Unknown | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
change_event_production_quantity_id | Unknown | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
change_event_production_quantity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
change_event_id | Unknown | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
checklist_schedule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
project_level_work_classification_id | Unknown | PKFK |
project_level_work_classification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
prime_contract_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
company_schedule_date | Unknown | PKFK |
id | Unknown | PKFK |
tasks_count | Unknown |
company_schedule
| Column | Type | Keys |
|---|---|---|
date | Unknown | PK |
company_id | Unknown | PKFK |
budget_modification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
party_id | Unknown |
project_people
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
user_uuid | Unknown | FK |
user_id | Unknown |
punch_item_assignment_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
punch_item_assignment_id | Unknown | PKFK |
punch_item_id | Unknown | PKFK |
filename | Unknown | |
name | Unknown | |
url | Unknown |
punch_item_assignment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
punch_item_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
login | Unknown | |
name | Unknown |
timecard_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
budget_detail_segment_item_id | Unknown | PKFK |
budget_segment_item_path_code
| Column | Type | Keys |
|---|---|---|
path_code | Unknown | PK |
budget_detail_id | Unknown | PKFK |
budget_detail_segment_item_id | Unknown | PKFK |
budget_segment_item_path
| Column | Type | Keys |
|---|---|---|
path_id | Unknown | PK |
budget_detail_id | Unknown | PKFK |
budget_detail_segment_item_id | Unknown | PKFK |
budget_detail_segment_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
budget_detail_id | Unknown | PKFK |
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 | PKFK |
company_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
prime_contract_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
rfi_id | Unknown | PKFK |
rfi_question_id | Unknown | PKFK |
error | Unknown |
rfi_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
rfi_id | Unknown | PKFK |
body | Unknown |
rfi_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
rfi_id | Unknown | PKFK |
locale | Unknown | |
login | Unknown | |
name | Unknown | |
response_required | Unknown |
rfi
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
prime_contract_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
production_quantity_actual_id | Unknown | PKFK |
project_id | Unknown | PKFK |
login | Unknown | |
name | Unknown |
production_quantity_actual
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
name | Unknown | |
status | Unknown |
checklist_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
work_order_contract_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
dailylog_work_id | Unknown | PKFK |
project_id | Unknown | PKFK |
filename | Unknown | |
name | Unknown | |
url | Unknown |
dailylog_work_scheduled_task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
dailylog_work_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
prime_contract_id | Unknown | PKFK |
project_id | Unknown | PKFK |
filename | Unknown | |
url | Unknown |
prime_contract_contractor_trade
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
prime_contract_id | Unknown | PKFK |
project_id | Unknown | PKFK |
active | Unknown | |
name | Unknown | |
updated_at | Unknown |
prime_contract_contractor_bidding_distribution
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
prime_contract_id | Unknown | PKFK |
project_id | Unknown | PKFK |
login | Unknown | |
name | Unknown |
prime_contract_contractor_standard_cost_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
prime_contract_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
prime_contract_contractor_project_id | Unknown | PKFK |
prime_contract_id | Unknown | PKFK |
prime_contract
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
purchase_order_contract_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
name | Unknown | |
translated_name | Unknown |
inspection_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
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 | PKFK |
project_id | Unknown | PKFK |
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 | PKFK |
base_type | Unknown | |
code | Unknown | |
name | Unknown | |
origin_id | Unknown |
cost_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
project_id | Unknown | PKFK |
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 |