# Factbird schema ERD

Table and field reference for the Fivetran Factbird connector.

## 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 | PK, FK |
| sensor_id | Unknown | PK, FK |
| sensor_stop_cause_id | Unknown | PK, FK |
| stop_cause_category_id | Unknown | PK, FK |
| description | Unknown |  |
| language_code | Unknown |  |
| name | Unknown |  |

### sensor_stop_cause

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| sensor_id | Unknown | PK, FK |
| stop_cause_category_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| batch_stop_cause_index | Unknown | PK, FK |
| line_id | Unknown | PK, FK |
| description | Unknown |  |
| language_code | Unknown |  |
| name | Unknown |  |

### batch_stop_cause

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| batch_id | Unknown | PK, FK |
| line_id | Unknown | PK, FK |
| 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 | PK, FK |
| sensor_id | Unknown | PK, FK |
| 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 | PK, FK |
| sensor_group_id | Unknown | PK, FK |
| sensor_id | Unknown | PK, FK |

### sensor_group_line

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Unknown | PK, FK |
| sensor_group_device_id | Unknown | PK, FK |
| sensor_group_id | Unknown | PK, FK |
| sensor_id | Unknown | PK, FK |

### sensor_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sensor_device_id | Unknown | PK, FK |
| sensor_id | Unknown | PK, FK |
| default_group | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| node_id | Unknown |  |

### sensor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- line(company_id) → company(id)
- oee(line_id) → line(id)
- sensor_stop_cause_meta(device_id) → sensor_stop_cause(device_id)
- sensor_stop_cause_meta(sensor_id) → sensor_stop_cause(sensor_id)
- sensor_stop_cause_meta(sensor_stop_cause_id) → sensor_stop_cause(id)
- sensor_stop_cause_meta(stop_cause_category_id) → sensor_stop_cause(stop_cause_category_id)
- sensor_stop_cause(stop_cause_category_id) → sensor_stop_cause_category(id)
- sensor_stop_cause(device_id) → device(id)
- sensor_stop_cause(sensor_id) → sensor(id)
- product(line_id) → line(id)
- product(attached_control_receipt_entry_field_sensor_id) → sensor(id)
- andon_call_tag(line_id) → line(id)
- andon_call_tag(andon_call_id) → andon_call(id)
- andon_call(line_id) → line(id)
- stop(batch_id) → batch(id)
- stop_cause_stats(id) → sensor_stop_cause(id)
- stop_cause_stats(batch_id) → batch(id)
- batch(product_id) → product(product_id)
- batch(line_id) → line(id)
- changeover_stop(target_shift_target_line_id) → line(id)
- changeover_stop(target_next_batch_batch_id) → batch(id)
- changeover_stop(target_previous_batch_batch_id) → batch(id)
- line_stop(line_id) → line(id)
- batch_stop_cause_meta(batch_id) → batch_stop_cause(batch_id)
- batch_stop_cause_meta(line_id) → batch_stop_cause(line_id)
- batch_stop_cause_meta(batch_stop_cause_index) → batch_stop_cause(index)
- batch_stop_cause(stop_id) → stop(id)
- batch_stop_cause(batch_id) → batch(id)
- batch_stop_cause(line_id) → line(id)
- sensor_stop_cause_category(sensor_id) → sensor(id)
- sensor_stop_cause_category(sensor_device_id) → sensor(device_id)
- sensor_group_peripheral(sensor_id) → sensor_group(sensor_id)
- sensor_group_peripheral(sensor_group_id) → sensor_group(id)
- sensor_group_peripheral(sensor_group_device_id) → sensor_group(sensor_device_id)
- sensor_group_line(line_id) → line(id)
- sensor_group_line(sensor_id) → sensor_group(sensor_id)
- sensor_group_line(sensor_group_id) → sensor_group(id)
- sensor_group_line(sensor_group_device_id) → sensor_group(sensor_device_id)
- sensor_group(sensor_id) → sensor(id)
- sensor_group(sensor_device_id) → sensor(device_id)
- sensor(peripheral_line_id) → line(id)
- sensor(device_id) → device(id)