myosh

Explore the interactive ERD

Table & Field Reference

record_read_access_role

Column	Type	Keys
`index`	Unknown	PK
`record_id`	Unknown	PKFK
`role`	Unknown

record_schedule

Column	Type	Keys
`index`	Unknown	PK
`record_id`	Unknown	PKFK
`day_of_month`	Unknown
`hour_of_day`	Unknown
`schedule_type`	Unknown

record_field_trigger

Column	Type	Keys
`field_id`	Unknown	PK
`record_id`	Unknown	PKFK
`first_occurence`	Unknown
`repeat_every`	Unknown

record_fields_to_question_with_answer

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

site_supervisor

Column	Type	Keys
`index`	Unknown	PK
`site_id`	Unknown	PKFK
`supervisor`	Unknown

site_accountable

Column	Type	Keys
`index`	Unknown	PK
`site_id`	Unknown	PKFK
`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	PKFK
`form_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`form_workflow_step_id`	Unknown	PKFK
`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	PKFK
`form_workflow_step_id`	Unknown	PKFK
`field_groups_read`	Unknown

form_field_group_edit

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

occupation_hierarchy_field_access

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