# NetSuite SuiteProjects Pro schema ERD

Table and field reference for the Fivetran NetSuite SuiteProjects Pro connector.

## Table & Field Reference

### project_phase_attachment_id

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| project_phase_id | Unknown | PK, FK |

### project_phase

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| project_id | Unknown | FK |
| calculated_finish | Unknown |  |
| calculated_start | Unknown |  |
| created | LocalDateTime |  |
| currency | Unknown |  |
| default_category_on_phase | Unknown |  |
| default_category_on_phase_1 | Unknown |  |
| default_category_on_phase_2 | Unknown |  |
| default_category_on_phase_3 | Unknown |  |
| default_category_on_phase_4 | Unknown |  |
| default_category_on_phase_5 | Unknown |  |
| external_id | Unknown |  |
| id_number | Unknown |  |
| is_closed | Unknown |  |
| is_ready_for_recognition | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| originating_id | Unknown |  |
| parent_id | Unknown |  |
| percent_complete | Unknown |  |
| planned_hour | Unknown |  |
| predecessor | Unknown |  |
| predecessor_lag | Unknown |  |
| predecessors_type | Unknown |  |
| priority | Unknown |  |
| seq | Unknown |  |
| updated | LocalDateTime |  |

### project_phase_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| uploaded_by | Unknown | FK |
| attachment_category_id | Unknown |  |
| created | LocalDateTime |  |
| file_name | Unknown |  |
| file_type | Unknown |  |
| has_thumbnail | Unknown |  |
| is_excluded_from_alert | Unknown |  |
| is_folder | Unknown |  |
| is_locked | Unknown |  |
| is_viewable | Unknown |  |
| locked_by | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| size | Unknown |  |
| updated | LocalDateTime |  |
| workspace_id | Unknown |  |

### project_milestone_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| uploaded_by | Unknown | FK |
| attachment_category_id | Unknown |  |
| created | LocalDateTime |  |
| file_name | Unknown |  |
| file_type | Unknown |  |
| has_thumbnail | Unknown |  |
| is_excluded_from_alert | Unknown |  |
| is_folder | Unknown |  |
| is_locked | Unknown |  |
| is_viewable | Unknown |  |
| locked_by | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| size | Unknown |  |
| updated | LocalDateTime |  |
| workspace_id | Unknown |  |

### project_milestone_attachment_id

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| project_milestone_id | Unknown | PK, FK |

### project_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| project_id | Unknown | FK |
| calculated_starts | Unknown |  |
| created | LocalDateTime |  |
| currency | Unknown |  |
| default_category | Unknown |  |
| default_category_1 | Unknown |  |
| default_category_2 | Unknown |  |
| default_category_3 | Unknown |  |
| default_category_4 | Unknown |  |
| default_category_5 | Unknown |  |
| external_id | Unknown |  |
| id_number | Unknown |  |
| is_closed | Unknown |  |
| is_non_billable | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| originating_id | Unknown |  |
| parent_id | Unknown |  |
| predecessor | Unknown |  |
| predecessor_lag | Unknown |  |
| predecessor_type | Unknown |  |
| priority | Unknown |  |
| project_task_type_id | Unknown |  |
| seq | Unknown |  |
| start_date | Unknown |  |
| updated | LocalDateTime |  |
| use_all_can_assign | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| accounting_code | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| address_3 | Unknown |  |
| address_4 | Unknown |  |
| can_bill | Unknown |  |
| can_sell | Unknown |  |
| can_ship | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created | LocalDateTime |  |
| email | Unknown |  |
| external_id | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| is_active | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| mobile | Unknown |  |
| nickname | Unknown |  |
| note | Unknown |  |
| phone | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |
| updated | LocalDateTime |  |
| zip | Unknown |  |

### job_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounting_code | Unknown |  |
| created | LocalDateTime |  |
| currency | Unknown |  |
| external_id | Unknown |  |
| generic_resource_id | Unknown |  |
| is_active | Unknown |  |
| loaded_cost | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| updated | LocalDateTime |  |

### project_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| uploaded_by | Unknown | FK |
| attachment_category_id | Unknown |  |
| created | LocalDateTime |  |
| file_name | Unknown |  |
| file_type | Unknown |  |
| has_thumbnail | Unknown |  |
| is_excluded_from_alert | Unknown |  |
| is_folder | Unknown |  |
| is_locked | Unknown |  |
| is_viewable | Unknown |  |
| locked_by | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| size | Unknown |  |
| updated | LocalDateTime |  |
| workspace_id | Unknown |  |

### project_hierarchy_node

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

### project_attachment_id

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

### project_filter_set

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

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_contact_id | Unknown | FK |
| contact_id | Unknown | FK |
| customer_id | Unknown | FK |
| project_approver_1 | Unknown | FK |
| project_approver_2 | Unknown | FK |
| project_approver_3 | Unknown | FK |
| shipping_contact_id | Unknown | FK |
| sold_to_contact_id | Unknown | FK |
| user_id | Unknown | FK |
| accounting_code | Unknown |  |
| auto_bill_cap_value | Unknown |  |
| billing_code | Unknown |  |
| booking_approval_process | Unknown |  |
| booking_approver | Unknown |  |
| booking_request_approval_process | Unknown |  |
| booking_request_approver | Unknown |  |
| budget | Unknown |  |
| budget_approval_process | Unknown |  |
| budget_approver | Unknown |  |
| budget_cost | Unknown |  |
| budget_time | Unknown |  |
| category_filter | Unknown |  |
| copy_approver | Unknown |  |
| copy_booking | Unknown |  |
| copy_cp_exclude_filter | Unknown |  |
| copy_custom_field | Unknown |  |
| copy_dashboard_setting | Unknown |  |
| copy_expense_policy | Unknown |  |
| copy_invoice_layout_setting | Unknown |  |
| copy_issue | Unknown |  |
| copy_loaded_cost | Unknown |  |
| copy_notification_setting | Unknown |  |
| copy_project_assignment_profile | Unknown |  |
| copy_project_billing_auto_setting | Unknown |  |
| copy_project_billing_rule | Unknown |  |
| copy_project_budget_group | Unknown |  |
| copy_project_pricing | Unknown |  |
| copy_revenue_recognition_auto_setting | Unknown |  |
| copy_revenue_recognition_rule | Unknown |  |
| cost_center_id | Unknown |  |
| created | LocalDateTime |  |
| credit_invoice_layout_id | Unknown |  |
| currency | Unknown |  |
| dashboard_from | Unknown |  |
| dashboard_message | Unknown |  |
| discussion_message_count | Unknown |  |
| expense_allowance_approval_process | Unknown |  |
| expense_allowance_approver | Unknown |  |
| expense_approval_process | Unknown |  |
| expense_approver | Unknown |  |
| expense_authorization_approval_process | Unknown |  |
| expense_authorization_approver | Unknown |  |
| external_id | Unknown |  |
| finish_date | Unknown |  |
| invoice_approval_process | Unknown |  |
| invoice_approver | Unknown |  |
| invoice_layout_id | Unknown |  |
| invoice_text | Unknown |  |
| is_active | Unknown |  |
| is_auto_bill | Unknown |  |
| is_auto_bill_cap | Unknown |  |
| is_auto_bill_overriden | Unknown |  |
| is_dashboard_enabled | Unknown |  |
| is_portfolio_project | Unknown |  |
| msp_link_type | Unknown |  |
| name | Unknown |  |
| news_feed_id | Unknown |  |
| note | Unknown |  |
| notify_assignees | Unknown |  |
| notify_assignment_cc | Unknown |  |
| notify_issue_assigned_to | Unknown |  |
| notify_issue_closed_assigned_to | Unknown |  |
| notify_issue_closed_customer_owner | Unknown |  |
| notify_issue_closed_project_owner | Unknown |  |
| notify_issue_created_customer_owner | Unknown |  |
| notify_issue_created_project_owner | Unknown |  |
| notify_owner | Unknown |  |
| notify_sr_submitted_project_owner | Unknown |  |
| only_owner_can_edit | Unknown |  |
| originating_id | Unknown |  |
| payroll_type_filter | Unknown |  |
| portfolio_project_id | Unknown |  |
| project_location_id | Unknown |  |
| project_stage_id | Unknown |  |
| purchase_order_approval_process | Unknown |  |
| purchase_order_approver | Unknown |  |
| purchase_request_approval_process | Unknown |  |
| purchase_request_approver | Unknown |  |
| rate | Unknown |  |
| rate_card_id | Unknown |  |
| revenue_approval_process | Unknown |  |
| revenue_approver | Unknown |  |
| sga_labor | Unknown |  |
| start_date | Unknown |  |
| sync_workspace | Unknown |  |
| task_budget_cost | Unknown |  |
| task_budget_revenue | Unknown |  |
| tax_location_id | Unknown |  |
| tax_rate_federal | Unknown |  |
| tax_rate_state | Unknown |  |
| template_project_id | Unknown |  |
| timesheet_approval_process | Unknown |  |
| timesheet_approver | Unknown |  |
| timetype_filter | Unknown |  |
| updated | LocalDateTime |  |
| user_filter | Unknown |  |

### time_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| job_code_id | Unknown | FK |
| project_id | Unknown | FK |
| project_task_id | Unknown | FK |
| user_id | Unknown | FK |
| accounting_date | Unknown |  |
| category_1_id | Unknown |  |
| category_2_id | Unknown |  |
| category_3_id | Unknown |  |
| category_4_id | Unknown |  |
| category_5_id | Unknown |  |
| category_id | Unknown |  |
| cost_center_id | Unknown |  |
| created | LocalDateTime |  |
| date | LocalDate |  |
| decimal_hour | Unknown |  |
| description | Unknown |  |
| end_time | Unknown |  |
| exported | Unknown |  |
| hour | Unknown |  |
| hours_remaining | Unknown |  |
| minute | Unknown |  |
| note | Unknown |  |
| payroll_type_id | Unknown |  |
| project_task_type_id | Unknown |  |
| schedule_request_item_id | Unknown |  |
| slip_id | Unknown |  |
| start_time | Unknown |  |
| thin_client_id | Unknown |  |
| time_type_id | Unknown |  |
| timesheet_id | Unknown |  |
| updated | LocalDateTime |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| job_code_id | Unknown | FK |
| line_manager_id | Unknown | FK |
| accounting_code | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| address_3 | Unknown |  |
| address_4 | Unknown |  |
| attachments | Json |  |
| bcc_self | Unknown |  |
| booking_approval_process | Unknown |  |
| booking_approver | Unknown |  |
| booking_request_approval_process | Unknown |  |
| booking_request_approver | Unknown |  |
| budget_approval_process | Unknown |  |
| budget_approver | Unknown |  |
| city | Unknown |  |
| cost_center_id | Unknown |  |
| country | Unknown |  |
| created | LocalDateTime |  |
| currency | Unknown |  |
| deal_booking_request_approval_process | Unknown |  |
| deal_booking_request_approver | Unknown |  |
| default_saml_settings_name | Unknown |  |
| department_id | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| expense_allowance_approval_process | Unknown |  |
| expense_allowance_approver | Unknown |  |
| expense_approval_process | Unknown |  |
| expense_approver | Unknown |  |
| expense_authorization_approval_process | Unknown |  |
| expense_authorization_approver | Unknown |  |
| expenses_filter_set | Unknown |  |
| external_id | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| generic | Unknown |  |
| invoice_filter_set | Unknown |  |
| is_active | Unknown |  |
| is_guest | Unknown |  |
| is_locked | Unknown |  |
| is_password_forced_change | Unknown |  |
| last_name | Unknown |  |
| mfa_setup_date | Unknown |  |
| mfa_status | Unknown |  |
| middle_name | Unknown |  |
| mobile | Unknown |  |
| my_account_filter_set | Unknown |  |
| name | Unknown |  |
| nickname | Unknown |  |
| opportunties_filter_set | Unknown |  |
| payroll_code | Unknown |  |
| phone | Unknown |  |
| primary_filter_set | Unknown |  |
| project_access_node | Unknown |  |
| project_filter_set | Unknown |  |
| proposal_approval_process | Unknown |  |
| proposal_approver | Unknown |  |
| purchase_filter_set | Unknown |  |
| purchase_order_approval_process | Unknown |  |
| purchase_order_approver | Unknown |  |
| purchase_request_approval_process | Unknown |  |
| purchase_request_approver | Unknown |  |
| rate | Unknown |  |
| report_filter_set | Unknown |  |
| resource_filter_set | Unknown |  |
| resource_profile_approval_process | Unknown |  |
| resource_profile_approver | Unknown |  |
| role_id | Unknown |  |
| rpc_api_updated | Unknown |  |
| rpc_updated_by | Unknown |  |
| rpc_user_updated | Unknown |  |
| salutation | Unknown |  |
| schedule_request_approval_process | Unknown |  |
| schedule_request_approver | Unknown |  |
| ssn | Unknown |  |
| state | Unknown |  |
| territory_id | Unknown |  |
| timesheet_approval_process | Unknown |  |
| timesheet_approver | Unknown |  |
| timesheets_filter_set | Unknown |  |
| timezone | Unknown |  |
| updated | LocalDateTime |  |
| user_location_id | Unknown |  |
| week_start | Unknown |  |
| work_schedule_id | Unknown |  |
| workspace_filter_set | Unknown |  |
| zip | Unknown |  |

### project_task_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| uploaded_by | Unknown | FK |
| attachment_category_id | Unknown |  |
| created | LocalDateTime |  |
| file_name | Unknown |  |
| file_type | Unknown |  |
| has_thumbnail | Unknown |  |
| is_excluded_from_alert | Unknown |  |
| is_folder | Unknown |  |
| is_locked | Unknown |  |
| is_viewable | Unknown |  |
| locked_by | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| size | Unknown |  |
| updated | LocalDateTime |  |
| workspace_id | Unknown |  |

### project_task_time_type_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_task_id | Unknown | PK, FK |

### project_task_assigned_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| project_task_id | Unknown | PK, FK |

### project_task_assigned_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_task_id | Unknown | PK, FK |

### project_task_attachment_id

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| project_task_id | Unknown | PK, FK |

### project_task_task_split

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_task_id | Unknown | PK, FK |

### project_task_user_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_task_id | Unknown | PK, FK |

### project_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| parent_id | Unknown | FK |
| project_id | Unknown | FK |
| assignment_cc | Unknown |  |
| assignment_cc_email | Unknown |  |
| calculated_finish | LocalDate |  |
| calculated_start | LocalDate |  |
| cost_center_id | Unknown |  |
| created | LocalDateTime |  |
| currency | Unknown |  |
| default_category | Unknown |  |
| default_category_1 | Unknown |  |
| default_category_2 | Unknown |  |
| default_category_3 | Unknown |  |
| default_category_4 | Unknown |  |
| default_category_5 | Unknown |  |
| external_id | Unknown |  |
| fn_lt_date | Unknown |  |
| hours_remaining_estimate | Json |  |
| id_number | Unknown |  |
| is_closed | Unknown |  |
| is_non_billable | Unknown |  |
| is_ready_for_recognition | Unknown |  |
| is_sign_off_required | Unknown |  |
| is_using_project_assignment | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| originating_id | Unknown |  |
| percent_complete | Unknown |  |
| planned_hour | Unknown |  |
| predecessor | Unknown |  |
| predecessor_lag | Unknown |  |
| predecessor_type | Unknown |  |
| priority | Unknown |  |
| project_task_type_id | Unknown |  |
| seq | Unknown |  |
| start_date | Unknown |  |
| task_budget_cost | Unknown |  |
| task_budget_revenue | Unknown |  |
| updated | LocalDateTime |  |
| use_all_can_assign | Unknown |  |
| use_manual_task_budget | Unknown |  |

### booking_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| uploaded_by | Unknown | FK |
| attachment_category_id | Unknown |  |
| created | LocalDateTime |  |
| file_name | Unknown |  |
| file_type | Unknown |  |
| has_thumbnail | Unknown |  |
| is_excluded_from_alert | Unknown |  |
| is_folder | Unknown |  |
| is_locked | Unknown |  |
| is_viewable | Unknown |  |
| locked_by | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| size | Unknown |  |
| updated | LocalDateTime |  |
| workspace_id | Unknown |  |

### booking_attachment_id

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### booking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| job_code_id | Unknown | FK |
| project_id | Unknown | FK |
| project_task_id | Unknown | FK |
| user_id | Unknown | FK |
| approval_status | Unknown |  |
| as_percentage | Unknown |  |
| booking_request_id | Unknown |  |
| booking_type_id | Unknown |  |
| created | LocalDateTime |  |
| date_approved | Unknown |  |
| date_rejected | Unknown |  |
| date_submitted | Unknown |  |
| end_date | LocalDate |  |
| end_time | Unknown |  |
| external_id | Unknown |  |
| hour | Unknown |  |
| location_id | Unknown |  |
| match_score | Unknown |  |
| note | Unknown |  |
| notify_owner | Unknown |  |
| owner_id | Unknown |  |
| percentage | Unknown |  |
| preferred | Unknown |  |
| priority | Unknown |  |
| project_assignment_profile_id | Unknown |  |
| repeat_id | Unknown |  |
| resource_request_queue_id | Unknown |  |
| rm_approver_1 | Unknown |  |
| rm_approver_2 | Unknown |  |
| rm_approver_3 | Unknown |  |
| schedule_request_item_id | Unknown |  |
| source_booking_id | Unknown |  |
| start_date | LocalDate |  |
| start_time | Unknown |  |
| updated | LocalDateTime |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_contact_id | Unknown | FK |
| primary_contact_id | Unknown | FK |
| shipping_contact_id | Unknown | FK |
| sold_to_contact_id | Unknown | FK |
| user_id | Unknown | FK |
| accounting_code | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| address_3 | Unknown |  |
| address_4 | Unknown |  |
| billing_code | Unknown |  |
| business_type_id | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| company_size_id | Unknown |  |
| cost_center_id | Unknown |  |
| country | Unknown |  |
| created | LocalDateTime |  |
| credit_invoice_layout_id | Unknown |  |
| currency | Unknown |  |
| customer_location_id | Unknown |  |
| customer_source_id | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| fax | Unknown |  |
| invoice_approval_process | Unknown |  |
| invoice_approver | Unknown |  |
| invoice_email_text | Unknown |  |
| invoice_layout_id | Unknown |  |
| invoice_prefix | Unknown |  |
| invoice_text | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| phone | Unknown |  |
| rate | Unknown |  |
| state | Unknown |  |
| statement | Unknown |  |
| sync_workspace | Unknown |  |
| term | Unknown |  |
| territory_id | Unknown |  |
| type | Unknown |  |
| updated | LocalDateTime |  |
| web | Unknown |  |
| zip | Unknown |  |

## Relationships

- project_phase_attachment_id(id) → project_phase_attachment(id)
- project_phase_attachment_id(project_phase_id) → project_phase(id)
- project_phase(customer_id) → customer(id)
- project_phase(project_id) → project(id)
- project_phase_attachment(parent_id) → project_phase_attachment(id)
- project_phase_attachment(uploaded_by) → users(id)
- project_milestone_attachment(parent_id) → project_milestone_attachment(id)
- project_milestone_attachment(uploaded_by) → users(id)
- project_milestone_attachment_id(id) → project_milestone_attachment(id)
- project_milestone_attachment_id(project_milestone_id) → project_milestone(id)
- project_milestone(customer_id) → customer(id)
- project_milestone(project_id) → project(id)
- contact(customer_id) → customer(id)
- project_attachment(parent_id) → project_attachment(id)
- project_attachment(uploaded_by) → users(id)
- project_hierarchy_node(project_id) → project(id)
- project_attachment_id(id) → project_attachment(id)
- project_attachment_id(project_id) → project(id)
- project_filter_set(project_id) → project(id)
- project(user_id) → users(id)
- project(billing_contact_id) → contact(id)
- project(project_approver_3) → users(id)
- project(project_approver_2) → users(id)
- project(shipping_contact_id) → contact(id)
- project(sold_to_contact_id) → contact(id)
- project(customer_id) → customer(id)
- project(project_approver_1) → users(id)
- project(contact_id) → contact(id)
- time_entry(user_id) → users(id)
- time_entry(project_task_id) → project_task(id)
- time_entry(job_code_id) → job_code(id)
- time_entry(customer_id) → customer(id)
- time_entry(project_id) → project(id)
- users(line_manager_id) → users(id)
- users(job_code_id) → job_code(id)
- users(customer_id) → customer(id)
- project_task_attachment(parent_id) → project_task_attachment(id)
- project_task_attachment(uploaded_by) → users(id)
- project_task_time_type_filter(project_task_id) → project_task(id)
- project_task_assigned_user(id) → users(id)
- project_task_assigned_user(project_task_id) → project_task(id)
- project_task_assigned_group(project_task_id) → project_task(id)
- project_task_attachment_id(id) → project_task_attachment(id)
- project_task_attachment_id(project_task_id) → project_task(id)
- project_task_task_split(project_task_id) → project_task(id)
- project_task_user_assignment(project_task_id) → project_task(id)
- project_task(customer_id) → customer(id)
- project_task(project_id) → project(id)
- project_task(parent_id) → project_task(id)
- booking_attachment(parent_id) → booking_attachment(id)
- booking_attachment(uploaded_by) → users(id)
- booking_attachment_id(id) → booking_attachment(id)
- booking_attachment_id(booking_id) → booking(id)
- booking(user_id) → users(id)
- booking(project_task_id) → project_task(id)
- booking(job_code_id) → job_code(id)
- booking(customer_id) → customer(id)
- booking(project_id) → project(id)
- customer(user_id) → users(id)
- customer(billing_contact_id) → contact(id)
- customer(shipping_contact_id) → contact(id)
- customer(sold_to_contact_id) → contact(id)
- customer(primary_contact_id) → contact(id)