Hilti On!Track

Explore the interactive ERD

Table & Field Reference

usage_history_detail

Column	Type	Keys
`index`	Unknown	PK
`usage_history_asset_id`	Unknown	PKFK
`date_on`	Unknown
`is_used`	Unknown

usage_history

Column	Type	Keys
`asset_id`	Unknown	PKFK
`last_updated_timestamp`	Unknown

location_label

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`display_name`	Unknown
`file_name`	Unknown

asset_label

Column	Type	Keys
`index`	Unknown	PK
`asset_id`	Unknown	PKFK
`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	PKFK
`source_type`	Unknown
`type`	Unknown
`value`	Unknown

worker_label

Column	Type	Keys
`index`	Unknown	PK
`worker_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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