# myosh schema ERD

Table and field reference for the Fivetran myosh connector.

## Table & Field Reference

### record_read_access_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| record_id | Unknown | PK, FK |
| role | Unknown |  |

### record_schedule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| record_id | Unknown | PK, FK |
| day_of_month | Unknown |  |
| hour_of_day | Unknown |  |
| schedule_type | Unknown |  |

### record_field_trigger

| Column | Type | Keys |
| --- | --- | --- |
| field_id | Unknown | PK |
| record_id | Unknown | PK, FK |
| first_occurence | Unknown |  |
| repeat_every | Unknown |  |

### record_fields_to_question_with_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| record_id | Unknown | PK, FK |
| answer_id | Unknown |  |
| file | Unknown |  |
| image | Unknown |  |
| int_value | Unknown |  |
| linked_record_id | Unknown |  |
| observation | Unknown |  |
| question_id | Unknown |  |

### record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | FK |
| module_id | Unknown | FK |
| archived_step | Unknown |  |
| complete | Unknown |  |
| creation_date | Unknown |  |
| deleted | Unknown |  |
| display_text | Unknown |  |
| fields_to_additional_values | Json |  |
| fields_to_values | Json |  |
| form_version | Unknown |  |
| has_normal_reverse_record | Unknown |  |
| important | Unknown |  |
| important_doc_no | Unknown |  |
| invitation | Json |  |
| last_modified | Instant |  |
| link_url | Unknown |  |
| location_lat | Unknown |  |
| location_lon | Unknown |  |
| persisted_since_last_edit | Unknown |  |
| record | Json |  |
| scheduled_record_default_setting | Unknown |  |
| scheduled_record_name | Unknown |  |
| scheduled_record_work_flow_step | Unknown |  |
| source_id | Unknown |  |
| version_state | Unknown |  |
| workflow_step_histories | Unknown |  |
| workflow_step_history | Json |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager_locale_id | Unknown | FK |
| admin | Unknown |  |
| layout_admin | Unknown |  |
| manager_email | Unknown |  |
| manager_locale_date_format | Unknown |  |
| manager_locale_language_tag | Unknown |  |
| restrict_create_individual_tab | Unknown |  |
| visible_in_ui | Unknown |  |

### risk_matrix

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| consequence_description | Unknown |  |
| consequence_descriptions_en_au | Unknown |  |
| consequence_id | Unknown |  |
| consequence_name | Unknown |  |
| consequence_names_en_au | Unknown |  |
| consequence_position | Unknown |  |
| likelihood_description | Unknown |  |
| likelihood_id | Unknown |  |
| likelihood_name | Unknown |  |
| likelihood_names_en_au | Unknown |  |
| likelihood_position | Unknown |  |
| rating | Unknown |  |
| risk_level_background_color | Unknown |  |
| risk_level_category | Unknown |  |
| risk_level_color | Unknown |  |
| risk_level_descripations_en_au | Unknown |  |
| risk_level_id | Unknown |  |
| risk_level_name | Unknown |  |
| risk_level_names_en_au | Unknown |  |

### competency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived | Unknown |  |
| author | Unknown |  |
| cost | Unknown |  |
| name | Unknown |  |
| proficiency | Unknown |  |
| training_time | Unknown |  |

### site_area

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| site_id | Unknown | PK, FK |
| area | Unknown |  |

### site_supervisor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| site_id | Unknown | PK, FK |
| supervisor | Unknown |  |

### site_accountable

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| site_id | Unknown | PK, FK |
| accountable | Unknown |  |

### site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived | Unknown |  |
| country | Unknown |  |
| last_modified | Unknown |  |
| site | Unknown |  |
| soft_deleted | Unknown |  |
| unid | Unknown |  |

### form_field_group_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_field_group_index | Unknown | PK, FK |
| form_id | Unknown | PK, FK |
| allow_new_value | Unknown |  |
| default_value | Unknown |  |
| field_label | Unknown |  |
| field_name | Unknown |  |
| field_type | Unknown |  |
| help | Unknown |  |
| hint | Unknown |  |
| metadata | Unknown |  |
| position | Unknown |  |
| required | Unknown |  |
| search_full | Unknown |  |
| source | Json |  |
| summary_field | Unknown |  |
| target_form_id | Unknown |  |
| target_module_id | Unknown |  |
| validation | Json |  |
| visibility_conditions | Json |  |
| custom_field_label_names_** |  |  |

### form_field_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| field_group_name | Unknown |  |
| parent_key | Unknown |  |
| visibility_condition | Unknown |  |
| custom_field_group_name_** |  |  |

### form_next_step

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| form_workflow_step_id | Unknown | PK, FK |
| button_label | Unknown |  |
| close_on_save | Unknown |  |
| condition | Json |  |
| next_step | Unknown |  |
| prompt_before_advance | Unknown |  |
| skip_mandatory_field_validation | Unknown |  |
| custom_button_label_name_** |  |  |

### form_field_group_read

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| form_workflow_step_id | Unknown | PK, FK |
| field_groups_read | Unknown |  |

### form_field_group_edit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| form_workflow_step_id | Unknown | PK, FK |
| field_groups_edit | Unknown |  |

### form_workflow_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | FK |
| background_color | Unknown |  |
| edit_role | Json |  |
| is_archived_step | Unknown |  |
| is_draft | Unknown |  |
| is_progress | Unknown |  |
| is_record_read | Unknown |  |
| progress_user_field | Unknown |  |
| read_role | Json |  |
| record_readable_field | Unknown |  |
| record_readable_field_by_manager | Unknown |  |
| record_readable_keyword | Unknown |  |
| record_readable_keyword_by_manager | Unknown |  |
| status_label | Unknown |  |
| custom_status_label_name_** |  |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| module_id | Unknown | FK |
| autopopulate_from_user_hierarchy | Unknown |  |
| autopopulate_hierarchy_person_field | Unknown |  |
| create_record | Unknown |  |
| default_display_option | Unknown |  |
| default_form | Unknown |  |
| delete_record | Unknown |  |
| edit_record | Unknown |  |
| enabled_for_mobile | Unknown |  |
| form_name | Unknown |  |
| full_name_field | Unknown |  |
| hierarchy_access_restriction_ignore_mode | Unknown |  |
| hierarchy_hidden_in_read_mode | Unknown |  |
| ignore_hierarchy_access | Unknown |  |
| important_conditions_enabled | Unknown |  |
| initial_form_type | Unknown |  |
| last_modified | Unknown |  |
| module_icon | Unknown |  |
| module_name | Unknown |  |
| module_visibility | Unknown |  |
| new_record_button_visible | Unknown |  |
| not_display_in_forms | Unknown |  |
| not_display_in_home_page | Unknown |  |
| read_record | Unknown |  |
| removed | Unknown |  |
| show_records_for | Unknown |  |
| sign_in_step | Unknown |  |
| sign_in_type | Unknown |  |
| sign_out_step | Unknown |  |
| sync_all_records | Unknown |  |
| version | Unknown |  |
| version_type | Unknown |  |
| visitor_form | Unknown |  |
| workflow_initialstep | Unknown |  |
| custom_form_name_** |  |  |

### module

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| display_in_mobile | Unknown |  |
| icon | Unknown |  |
| module_name | Unknown |  |
| source_url | Unknown |  |
| type | Unknown |  |
| view_id | Unknown |  |
| custom_module_names_** |  |  |

### locale

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_format | Unknown |  |
| language_tag | Unknown |  |

### occupation_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| occupation_id | Unknown | PK, FK |
| role | Unknown |  |

### occupation_hierarchy_field_access

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| occupation_id | Unknown | PK, FK |
| hierarchy_field | Unknown | FK |
| value | Unknown |  |

### occupation

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

### users_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| role | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| locale_id | Unknown | FK |
| doc_number | Unknown |  |
| email | Unknown |  |
| fields_to_values_affiliation | Unknown |  |
| fields_to_values_archived | Unknown |  |
| fields_to_values_email | Unknown |  |
| fields_to_values_employee_id | Unknown |  |
| fields_to_values_external_user | Unknown |  |
| fields_to_values_external_user_active | Unknown |  |
| fields_to_values_first_name | Unknown |  |
| fields_to_values_last_name | Unknown |  |
| fields_to_values_ldap_super_user | Unknown |  |
| fields_to_values_login_required | Unknown |  |
| fields_to_values_manager | Unknown |  |
| fields_to_values_manager_id | Unknown |  |
| fields_to_values_occupation | Unknown |  |
| fields_to_values_password | Unknown |  |
| fields_to_values_phone | Unknown |  |
| fields_to_values_retype_password | Unknown |  |
| fields_to_values_secondary_occupation | Unknown |  |
| fields_to_values_super_user | Unknown |  |
| fields_to_values_unid_domino_key | Unknown |  |
| fields_to_values_username | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| last_modified | Instant |  |
| last_name | Unknown |  |
| pref_name | Unknown |  |
| preferred_language | Unknown |  |
| read_access_roles | Json |  |
| start_date | Unknown |  |
| unid | Unknown |  |
| virtual_super_user | Unknown |  |

### users_hierarchy

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| hierarchy_field | Unknown | FK |
| users_id | Unknown | FK |
| type | String |  |
| value | Unknown |  |

### hierarchy

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

### hierarchy_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| hierarchy_id | Unknown | PK, FK |
| archived | Unknown |  |
| geofence_enabled | Unknown |  |
| geofence_radius | Unknown |  |
| is_geofence_enabled | Unknown |  |
| last_modified | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| name | Unknown |  |
| names_en_au | Unknown |  |
| parent_value_id | Unknown |  |
| type | String |  |

## Relationships

- record_read_access_role(record_id) → record(id)
- record_schedule(record_id) → record(id)
- record_field_trigger(record_id) → record(id)
- record_fields_to_question_with_answer(record_id) → record(id)
- record(module_id) → module(id)
- record(form_id) → form(id)
- role(manager_locale_id) → locale(id)
- site_area(site_id) → site(id)
- site_supervisor(site_id) → site(id)
- site_accountable(site_id) → site(id)
- form_field_group_field(form_id) → form_field_group(form_id)
- form_field_group_field(form_field_group_index) → form_field_group(index)
- form_field_group(form_id) → form(id)
- form_next_step(form_id) → form_workflow_step(form_id)
- form_next_step(form_workflow_step_id) → form_workflow_step(id)
- form_field_group_read(form_id) → form_workflow_step(form_id)
- form_field_group_read(form_workflow_step_id) → form_workflow_step(id)
- form_field_group_edit(form_id) → form_workflow_step(form_id)
- form_field_group_edit(form_workflow_step_id) → form_workflow_step(id)
- form_workflow_step(form_id) → form(id)
- form(module_id) → module(id)
- occupation_role(occupation_id) → occupation(id)
- occupation_hierarchy_field_access(hierarchy_field) → hierarchy(name)
- occupation_hierarchy_field_access(occupation_id) → occupation(id)
- users_role(users_id) → users(id)
- users(locale_id) → locale(id)
- users_hierarchy(hierarchy_field) → hierarchy(name)
- users_hierarchy(users_id) → users(id)
- hierarchy_entity(hierarchy_id) → hierarchy(id)