# Hilti On!Track schema ERD

Table and field reference for the Fivetran Hilti On!Track connector.

## Table & Field Reference

### usage_history_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| usage_history_asset_id | Unknown | PK, FK |
| date_on | Unknown |  |
| is_used | Unknown |  |

### usage_history

| Column | Type | Keys |
| --- | --- | --- |
| asset_id | Unknown | PK, FK |
| last_updated_timestamp | Unknown |  |

### location_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| label | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager_id | Unknown | FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| cost_center | Unknown |  |
| country | Unknown |  |
| custom_location_id | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| is_locker_enabled | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| phone_number_country_code | Unknown |  |
| postal_code | Unknown |  |
| scan_code | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### asset_history_service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| attachment_count | Unknown |  |
| completion_date | LocalDate |  |
| cost | Unknown |  |
| cost_currency | Unknown |  |
| notes | Unknown |  |
| schedule_date | Unknown |  |
| service_name | Unknown |  |
| service_provider | Unknown |  |
| service_result | Unknown |  |
| service_state | Unknown |  |
| service_template_id | Unknown |  |

### group_associated

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| group_id | Unknown | PK, FK |
| group_associated | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| parent_group_id | Unknown |  |

### asset_service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| frequency | Unknown |  |
| is_associated | Unknown |  |
| service_description | Unknown |  |
| service_interval | Unknown |  |
| service_name | Unknown |  |
| service_period | Unknown |  |
| service_type | Unknown |  |

### runtime_data

| Column | Type | Keys |
| --- | --- | --- |
| asset_id | Unknown | PK, FK |
| application_count | Unknown |  |
| last_seen_timestamp | Unknown |  |
| last_used_timestamp | Unknown |  |
| run_time_total | Unknown |  |

### asset_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | PK, FK |
| display_name | Unknown |  |
| file_name | Unknown |  |

### asset_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| label | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| current_location_id | Unknown | FK |
| default_location_id | Unknown | FK |
| default_parent_on_track_id | Unknown | FK |
| default_worker_id | Unknown | FK |
| group_id | Unknown | FK |
| inventory_employee_id | Unknown | FK |
| parent_on_track_id | Unknown | FK |
| responsible_employee_id | Unknown | FK |
| category_code | Unknown |  |
| child_asset_count | Unknown |  |
| child_quantity_item_count | Unknown |  |
| completed_services_count | Unknown |  |
| cost_code | Unknown |  |
| current_location_type | Unknown |  |
| default_location_type | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| fleet_cost_center | Unknown |  |
| fleet_currency_code | Unknown |  |
| fleet_delivery_date | Unknown |  |
| fleet_exchange_or_warranty_date | Unknown |  |
| fleet_inventory_number | Unknown |  |
| fleet_is_loan_tool_claim | Unknown |  |
| fleet_is_theft_insurance | Unknown |  |
| fleet_monthly_rate | Unknown |  |
| fleet_organization_reference_number | Unknown |  |
| fleet_purchase_order_number | Unknown |  |
| image_id | Unknown |  |
| inventory_number | Unknown |  |
| is_hilti_tool | Unknown |  |
| manufacturer_id | Unknown |  |
| manufacturer_name | Unknown |  |
| model | Unknown |  |
| name | Unknown |  |
| next_service_date | Unknown |  |
| notes | Unknown |  |
| ownership_detail_purchase_currency_code | Unknown |  |
| ownership_detail_purchase_date | Unknown |  |
| ownership_detail_purchase_order_number | Unknown |  |
| ownership_detail_purchase_price | Unknown |  |
| ownership_detail_vendor | Unknown |  |
| ownership_detail_warranty_expiration_date | Unknown |  |
| ownership_type | Unknown |  |
| replacement_cost | Unknown |  |
| scan_code | Unknown |  |
| scan_code_type | Unknown |  |
| serial_number | Unknown |  |
| status_code | Unknown |  |
| storage_location | Unknown |  |
| sub_type_code | Unknown |  |
| type_code | Unknown |  |
| upcoming_services_count | Unknown |  |
| usage_condition_date | Unknown |  |
| usage_condition_state_code | Unknown |  |

### asset_cost

| Column | Type | Keys |
| --- | --- | --- |
| asset_id | Unknown | PK, FK |
| source_type | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### worker_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| worker_id | Unknown | PK, FK |
| label | Unknown |  |

### worker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| badge_id | Unknown |  |
| contract_type | Unknown |  |
| cost_center | Unknown |  |
| description | Unknown |  |
| designation | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| is_locker_admin | Unknown |  |
| language_code | Unknown |  |
| last_name | Unknown |  |
| locker_rfid | Unknown |  |
| mobile_country_code | Unknown |  |
| mobile_phone_number | Unknown |  |
| notification_email | Unknown |  |
| office_country_code | Unknown |  |
| office_phone_number | Unknown |  |
| primary_emergency_country_code | Unknown |  |
| primary_emergency_phone_number | Unknown |  |
| private_home_country_code | Unknown |  |
| private_home_phone_number | Unknown |  |
| responsibility_type | Unknown |  |
| scan_code | Unknown |  |

### asset_open_service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| service_description | Unknown |  |
| service_name | Unknown |  |
| service_schedule_date | LocalDate |  |

### quantity_item_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quantity_item_id | Unknown | PK, FK |
| label | Unknown |  |

### quantity_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| can_consume | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| inventory_number | Unknown |  |
| last_purchase_date | Unknown |  |
| last_purchase_price | Unknown |  |
| manufacturer_id | Unknown |  |
| manufacturer_name | Unknown |  |
| model | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| one_time_cost | Unknown |  |
| scan_code | Unknown |  |
| scan_code_type | Unknown |  |
| stock_unit_id | Unknown |  |

### quantity_item_allocation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quantity_item_id | Unknown | FK |
| responsible_employee_id | Unknown | FK |
| allocation_status | Unknown |  |
| allocation_type | Unknown |  |
| allocation_type_id | Unknown |  |
| main_allocation_flag | Unknown |  |
| stock_alert_enabled | Unknown |  |
| stock_max | Unknown |  |
| stock_min | Unknown |  |
| stock_quantity | Unknown |  |
| storage_location | Unknown |  |

### transfer_asset_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transfer_id | Unknown | PK, FK |
| from_location_id | Unknown | FK |
| from_storage_asset_id | Unknown | FK |
| from_worker_id | Unknown | FK |
| quantity_item_id | Unknown | FK |
| to_location_id | Unknown | FK |
| to_storage_asset_id | Unknown | FK |
| to_worker_id | Unknown | FK |
| to_allocation_status | Unknown |  |
| transfer_asset_type | Unknown |  |
| transfer_quantity | Unknown |  |
| transfer_status | Unknown |  |

### transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| notes | Unknown |  |
| origin | Unknown |  |
| submitted_timestamp | Unknown |  |
| task_code | Unknown |  |
| transfer_timestamp | Unknown |  |

## Relationships

- usage_history_detail(usage_history_asset_id) → usage_history(asset_id)
- usage_history(asset_id) → asset(id)
- location_label(location_id) → location(id)
- location(manager_id) → worker(id)
- asset_history_service(asset_id) → asset(id)
- group_associated(group_id) → groups(id)
- runtime_data(asset_id) → asset(id)
- asset_attachment(asset_id) → asset(id)
- asset_label(asset_id) → asset(id)
- asset(default_location_id) → location(id)
- asset(responsible_employee_id) → worker(id)
- asset(default_parent_on_track_id) → asset(id)
- asset(default_worker_id) → worker(id)
- asset(group_id) → groups(id)
- asset(parent_on_track_id) → asset(id)
- asset(current_location_id) → location(id)
- asset(inventory_employee_id) → worker(id)
- asset_cost(asset_id) → asset(id)
- worker_label(worker_id) → worker(id)
- asset_open_service(asset_id) → asset(id)
- quantity_item_label(quantity_item_id) → quantity_item(id)
- quantity_item(group_id) → groups(id)
- quantity_item_allocation(responsible_employee_id) → worker(id)
- quantity_item_allocation(quantity_item_id) → quantity_item(id)
- transfer_asset_detail(to_worker_id) → worker(id)
- transfer_asset_detail(from_location_id) → location(id)
- transfer_asset_detail(quantity_item_id) → quantity_item(id)
- transfer_asset_detail(from_worker_id) → worker(id)
- transfer_asset_detail(from_storage_asset_id) → asset(id)
- transfer_asset_detail(to_storage_asset_id) → asset(id)
- transfer_asset_detail(to_location_id) → location(id)
- transfer_asset_detail(transfer_id) → transfer(id)
- transfer(creator_id) → worker(id)