Factbird

Explore the interactive ERD

Table & Field Reference

line

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`description`	Unknown
`language_code`	Unknown
`main_peripheral_id`	Unknown
`name`	Unknown
`owner`	Unknown
`time`	Json
`time_zone`	Unknown

oee

Column	Type	Keys
`_fivetran_id`	String	PK
`line_id`	Unknown	FK
`consolidated_time_from`	LocalDate
`consolidated_time_to`	LocalDate
`manned_time`	Unknown
`oee_1`	Unknown
`oee_2`	Unknown
`oee_3`	Unknown
`operating_time`	Unknown
`production_time`	Unknown
`scrap_loss`	Unknown
`speed_loss`	Unknown
`tcu`	Unknown
`total_equipment_time`	Unknown
`valued_operating_time`	Unknown

sensor_stop_cause_meta

Column	Type	Keys
`index`	Unknown	PK
`device_id`	Unknown	PKFK
`sensor_id`	Unknown	PKFK
`sensor_stop_cause_id`	Unknown	PKFK
`stop_cause_category_id`	Unknown	PKFK
`description`	Unknown
`language_code`	Unknown
`name`	Unknown

sensor_stop_cause

Column	Type	Keys
`id`	Unknown	PK
`device_id`	Unknown	PKFK
`sensor_id`	Unknown	PKFK
`stop_cause_category_id`	Unknown	PKFK
`deleted`	Unknown
`description`	Unknown
`enable_counter_measure`	Unknown
`legacy_stop_cause_id`	Unknown
`name`	Unknown
`orders`	Unknown
`require_comment`	Unknown
`require_initial`	Unknown
`stop_type`	Unknown

company

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

product

Column	Type	Keys
`product_id`	Unknown	PK
`attached_control_receipt_entry_field_sensor_id`	Unknown	FK
`line_id`	Unknown	FK
`attached_control_receipt_attached_product_id`	Unknown
`attached_control_receipt_control_receipt_id`	Unknown
`attached_control_receipt_deleted`	Unknown
`attached_control_receipt_description`	Unknown
`attached_control_receipt_entry_entry_id`	Unknown
`attached_control_receipt_entry_field_derivation_setting_fields`	Unknown
`attached_control_receipt_entry_field_derivation_setting_formula`	Unknown
`attached_control_receipt_entry_field_description`	Unknown
`attached_control_receipt_entry_field_field_id`	Unknown
`attached_control_receipt_entry_field_label`	Unknown
`attached_control_receipt_entry_field_lower_limit`	Unknown
`attached_control_receipt_entry_field_type`	Unknown
`attached_control_receipt_entry_field_upper_limit`	Unknown
`attached_control_receipt_entry_follow_up_delay_ms`	Unknown
`attached_control_receipt_entry_follow_up_enabled`	Unknown
`attached_control_receipt_entry_initial_setting`	Unknown
`attached_control_receipt_entry_title`	Unknown
`attached_control_receipt_entry_trigger_delay_when_stopped`	Unknown
`attached_control_receipt_entry_trigger_payload_millis`	Unknown
`attached_control_receipt_entry_trigger_type`	Unknown
`attached_control_receipt_name`	Unknown
`attached_control_receipt_user_pool_id`	Unknown
`comment`	Unknown
`data_multiplier`	Unknown
`expected_average_speed`	Unknown
`item_number`	Unknown
`name`	Unknown
`overwritten_by_batch`	Unknown
`packaging_comment`	Unknown
`packaging_line_id`	Unknown
`packaging_name`	Unknown
`packaging_packaging_id`	Unknown
`packaging_packaging_number`	Unknown
`packaging_unit`	Unknown
`parameters_alarm_id`	Unknown
`parameters_key`	Unknown
`parameters_setpoint_peripheral_id`	Unknown
`parameters_setpoint_value`	Unknown
`parameters_value`	Unknown
`validated_line_speed`	Unknown

andon_call_tag

Column	Type	Keys
`id`	Unknown	PK
`andon_call_id`	Unknown	PKFK
`line_id`	Unknown	FK
`value`	Unknown

andon_call

Column	Type	Keys
`id`	Unknown	PK
`line_id`	Unknown	FK
`action_make_author`	Unknown
`action_make_details`	Unknown
`action_make_time`	Instant
`action_pending_author`	Unknown
`action_pending_details`	Unknown
`action_pending_time`	Instant
`action_resolve_author`	Unknown
`action_resolve_details`	Unknown
`action_resolve_time`	Instant
`action_take_author`	Unknown
`action_take_details`	Unknown
`action_take_time`	Instant
`last_message`	Instant
`role_escalation_configuration_delay`	Unknown
`role_escalation_configuration_taken_delay`	Unknown
`role_escalation_configuration_type`	Unknown
`role_id`	Unknown
`role_name`	Unknown
`urgency`	Unknown
`work_order_id`	Unknown

stop

Column	Type	Keys
`id`	Unknown	PK
`batch_id`	Unknown	PKFK
`comment`	Unknown
`counter_measure`	Unknown
`counter_measure_initial`	Unknown
`duration`	Unknown
`initials`	Unknown
`is_automatic_registration`	Unknown
`is_micro_stop`	Unknown
`ongoing`	Unknown
`original_start`	Unknown
`registered_time`	Unknown
`standalone_exclude_production`	Unknown
`target`	Unknown
`target_current_shift`	Unknown
`target_next_batch`	Unknown
`target_previous_batch`	Unknown
`time_range_from`	Unknown
`time_range_to`	Unknown

stop_cause_stats

Column	Type	Keys
`batch_id`	Unknown	PKFK
`id`	Unknown	PKFK
`acc_duration`	Unknown
`acc_target`	Unknown
`is_micro_stop`	Unknown
`number_of_stops`	Unknown
`stop_category_name`	Unknown
`stop_cause_description`	Unknown
`stop_cause_name`	Unknown
`type`	Unknown

batch

Column	Type	Keys
`id`	Unknown	PK
`line_id`	Unknown	FK
`product_id`	Unknown	FK
`actual_etc`	Unknown
`actual_start`	Unknown
`actual_stop`	Unknown
`amount`	Unknown
`batch_number`	Unknown
`comment`	Unknown
`last_stop_comment`	Unknown
`last_stop_counter_measure`	Unknown
`last_stop_counter_measure_initial`	Unknown
`last_stop_duration`	Unknown
`last_stop_id`	Unknown
`last_stop_initials`	Unknown
`last_stop_is_automatic_registration`	Unknown
`last_stop_is_micro_stop`	Unknown
`last_stop_ongoing`	Unknown
`last_stop_registered_time`	Unknown
`longest_non_stop`	Unknown
`manual_scrap`	Unknown
`planned_etc`	Unknown
`planned_start`	Unknown
`produced`	Unknown
`sorting`	Unknown
`state`	Unknown
`tags`	Json

changeover_stop

Column	Type	Keys
`id`	Unknown	PK
`target_next_batch_batch_id`	Unknown	FK
`target_previous_batch_batch_id`	Unknown	FK
`target_shift_target_line_id`	Unknown	FK
`comment`	Unknown
`counter_measur_initials`	Unknown
`counter_measure`	Unknown
`duration`	Unknown
`initials`	Unknown
`is_automatic_registration`	Unknown
`is_micro_stop`	Unknown
`ongoing`	Unknown
`registered_time`	Unknown
`standalone_exclude_production`	Unknown
`stop_cause_category_name`	Unknown
`stop_cause_deleted`	Unknown
`stop_cause_description`	Unknown
`stop_cause_enable_counter_measure`	Unknown
`stop_cause_id`	Unknown
`stop_cause_language_code`	Unknown
`stop_cause_legacy_stop_cause_id`	Unknown
`stop_cause_name`	Unknown
`stop_cause_order`	Unknown
`stop_cause_require_comment`	Unknown
`stop_cause_require_initials`	Unknown
`stop_cause_stop_type`	Unknown
`target`	Unknown
`target_next_batch_actual_start`	Unknown
`target_next_batch_actual_stop`	Unknown
`target_next_batch_batch_number`	Unknown
`target_next_batch_name`	Unknown
`target_next_batch_planned_start`	Unknown
`target_next_batch_product_id`	Unknown
`target_previous_batch_actual_start`	Unknown
`target_previous_batch_actual_stop`	Unknown
`target_previous_batch_batch_number`	Unknown
`target_previous_batch_name`	Unknown
`target_previous_batch_planned_start`	Unknown
`target_previous_batch_product_id`	Unknown
`target_shift_description`	Unknown
`target_shift_from_day`	Unknown
`target_shift_from_hour`	Unknown
`target_shift_from_minute`	Unknown
`target_shift_id`	Unknown
`target_shift_name`	Unknown
`target_shift_target_id`	Unknown
`target_shift_target_main_oee_type`	Unknown
`target_shift_target_number_of_batches`	Unknown
`target_shift_target_oee`	Unknown
`target_shift_target_oee_2`	Unknown
`target_shift_target_oee_3`	Unknown
`target_shift_target_produced`	Unknown
`target_shift_target_tcu`	Unknown
`target_shift_target_valid_from_week`	Unknown
`target_shift_target_valid_from_year`	Unknown
`target_shift_to_day`	Unknown
`target_shift_to_hour`	Unknown
`target_shift_to_minute`	Unknown
`time_range_from`	Unknown
`time_range_to`	Unknown

line_stop

Column	Type	Keys
`id`	Unknown	PK
`line_id`	Unknown	PKFK
`comment`	Unknown
`counter_measure`	Unknown
`counter_measure_initial`	Unknown
`duration`	Unknown
`initials`	Json
`is_automatic_registration`	Unknown
`is_micro_stop`	Unknown
`ongoing`	Unknown
`original_start`	Unknown
`registered_time`	Unknown
`time_range_from`	Unknown
`time_range_to`	Unknown

batch_stop_cause_meta

Column	Type	Keys
`index`	Unknown	PK
`batch_id`	Unknown	PKFK
`batch_stop_cause_index`	Unknown	PKFK
`line_id`	Unknown	PKFK
`description`	Unknown
`language_code`	Unknown
`name`	Unknown

batch_stop_cause

Column	Type	Keys
`index`	Unknown	PK
`batch_id`	Unknown	PKFK
`line_id`	Unknown	PKFK
`stop_id`	Unknown	FK
`category_id`	Unknown
`category_name`	Unknown
`deleted`	Unknown
`description`	Unknown
`enable_counter_measure`	Unknown
`language_code`	Unknown
`legacy_stop_cause_id`	Unknown
`name`	Unknown
`orders`	Unknown
`require_comment`	Unknown
`require_initial`	Unknown
`stop_cause_id`	Unknown
`stop_type`	Unknown
`target_setup_constant_time`	Unknown

sensor_stop_cause_category

Column	Type	Keys
`id`	Unknown	PK
`sensor_device_id`	Unknown	PKFK
`sensor_id`	Unknown	PKFK
`deleted`	Unknown
`language_code`	Unknown
`legacy_category_id`	Unknown
`name`	Unknown
`orders`	Unknown
`owner_type`	Unknown

sensor_group_peripheral

Column	Type	Keys
`peripheral_id`	Unknown	PK
`sensor_group_device_id`	Unknown	PKFK
`sensor_group_id`	Unknown	PKFK
`sensor_id`	Unknown	PKFK

sensor_group_line

Column	Type	Keys
`line_id`	Unknown	PKFK
`sensor_group_device_id`	Unknown	PKFK
`sensor_group_id`	Unknown	PKFK
`sensor_id`	Unknown	PKFK

sensor_group

Column	Type	Keys
`id`	Unknown	PK
`sensor_device_id`	Unknown	PKFK
`sensor_id`	Unknown	PKFK
`default_group`	Unknown
`description`	Unknown
`name`	Unknown
`node_id`	Unknown

sensor

Column	Type	Keys
`id`	Unknown	PK
`device_id`	Unknown	PKFK
`peripheral_line_id`	Unknown	FK
`alarms`	Json
`camera`	Json
`config_analog_input_range`	Unknown
`config_analog_offset`	Unknown
`config_chart_time_scale`	Unknown
`config_data_multiplier`	Unknown
`config_energy_meter`	Unknown
`config_expected_speed`	Unknown
`config_extra_multiplier_for_frontend`	Unknown
`config_find_stops`	Unknown
`config_publish_rate`	Unknown
`config_sample_rate`	Unknown
`config_stop_register_threshold`	Unknown
`config_stop_threshold`	Unknown
`config_stop_value_threshold`	Unknown
`config_subtract_cycle_time`	Unknown
`config_trigger_index`	Unknown
`config_type`	Unknown
`config_validated_speed`	Unknown
`custom_kpi`	Json
`description`	Unknown
`hardware_id`	Unknown
`horizontal_annotation`	Json
`index`	Unknown
`name`	Unknown
`offline_status_expiration`	Unknown
`offline_status_last_received`	Unknown
`owner`	Unknown
`peripheral_type`	Unknown
`scheduled_report`	Json
`stop_cause_mapping`	Json

device

Column	Type	Keys
`id`	Unknown	PK
`hardware_id`	Unknown
`name`	Unknown
`num_input_port`	Unknown
`owner`	Unknown
`type`	Unknown
`uuid`	Unknown