microting/eform-sdk-dotnet

View on GitHub
eFormCore/Migrations/20190509074123_RefactoringidtoId.Designer.cs

Summary

Maintainability
F
1 wk
Test Coverage
/*
The MIT License (MIT)

Copyright (c) 2007 - 2020 Microting A/S

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.
*/

// <auto-generated />

using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;
using Microting.eForm.Infrastructure;

namespace Microting.eForm.Migrations
{
    [DbContext(typeof(MicrotingDbContext))]
    [Migration("20190509074123_RefactoringidtoId")]
    partial class RefactoringidtoId
    {
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            string autoIDGenStrategy = "SqlServer:ValueGenerationStrategy";
            object autoIDGenStrategyValue = MySqlValueGenerationStrategy.IdentityColumn;
            if (DbConfig.IsMySQL)
            {
                autoIDGenStrategy = "MySql:ValueGenerationStrategy";
                autoIDGenStrategyValue = MySqlValueGenerationStrategy.IdentityColumn;
            }
            modelBuilder
                .HasAnnotation("ProductVersion", "2.2.4-servicing-10062")
                .HasAnnotation("Relational:MaxIdentifierLength", 128)
                .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

            modelBuilder.Entity("eFormSqlController.answer_value_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int>("answerId");

                    b.Property<int>("answerValueId");

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("optionsId");

                    b.Property<int>("questionId");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int>("value");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("answerValueId");

                    b.ToTable("answer_value_versions");
                });

            modelBuilder.Entity("eFormSqlController.answer_values", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int>("answerId");

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("optionsId");

                    b.Property<int>("questionId");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int>("value");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("answerId");

                    b.HasIndex("optionsId");

                    b.HasIndex("questionId");

                    b.ToTable("answer_values");
                });

            modelBuilder.Entity("eFormSqlController.answer_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<bool>("UTCAdjusted");

                    b.Property<int>("answerDuration");

                    b.Property<int>("answerId");

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("finishedAt");

                    b.Property<int>("languageId");

                    b.Property<int>("questionSetId");

                    b.Property<int>("siteId");

                    b.Property<int>("surveyConfigurationId");

                    b.Property<string>("timeZone");

                    b.Property<int>("unitId");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("answer_versions");
                });

            modelBuilder.Entity("eFormSqlController.answers", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<bool>("UTCAdjusted");

                    b.Property<int>("answerDuration");

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("finishedAt");

                    b.Property<int>("languageId");

                    b.Property<int>("questionSetId");

                    b.Property<int>("siteId");

                    b.Property<int>("surveyConfigurationId");

                    b.Property<string>("timeZone");

                    b.Property<int>("unitId");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("languageId");

                    b.HasIndex("questionSetId");

                    b.HasIndex("siteId");

                    b.HasIndex("surveyConfigurationId");

                    b.HasIndex("unitId");

                    b.ToTable("answers");
                });

            modelBuilder.Entity("eFormSqlController.case_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int?>("case_id");

                    b.Property<string>("case_uid")
                        .HasMaxLength(255);

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("custom");

                    b.Property<DateTime?>("done_at");

                    b.Property<int?>("done_by_user_id");

                    b.Property<string>("field_value_1");

                    b.Property<string>("field_value_10");

                    b.Property<string>("field_value_2");

                    b.Property<string>("field_value_3");

                    b.Property<string>("field_value_4");

                    b.Property<string>("field_value_5");

                    b.Property<string>("field_value_6");

                    b.Property<string>("field_value_7");

                    b.Property<string>("field_value_8");

                    b.Property<string>("field_value_9");

                    b.Property<string>("microting_check_uid")
                        .HasMaxLength(255);

                    b.Property<string>("microting_uid")
                        .HasMaxLength(255);

                    b.Property<int?>("site_id");

                    b.Property<int?>("status");

                    b.Property<string>("type")
                        .HasMaxLength(255);

                    b.Property<int?>("unit_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("case_versions");
                });

            modelBuilder.Entity("eFormSqlController.cases", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<string>("case_uid")
                        .HasMaxLength(255);

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("custom");

                    b.Property<DateTime?>("done_at");

                    b.Property<int?>("done_by_user_id");

                    b.Property<string>("field_value_1");

                    b.Property<string>("field_value_10");

                    b.Property<string>("field_value_2");

                    b.Property<string>("field_value_3");

                    b.Property<string>("field_value_4");

                    b.Property<string>("field_value_5");

                    b.Property<string>("field_value_6");

                    b.Property<string>("field_value_7");

                    b.Property<string>("field_value_8");

                    b.Property<string>("field_value_9");

                    b.Property<string>("microting_check_uid")
                        .HasMaxLength(255);

                    b.Property<string>("microting_uid")
                        .HasMaxLength(255);

                    b.Property<int?>("site_id");

                    b.Property<int?>("status");

                    b.Property<string>("type")
                        .HasMaxLength(255);

                    b.Property<int?>("unit_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("check_list_id");

                    b.HasIndex("done_by_user_id");

                    b.HasIndex("site_id");

                    b.HasIndex("unit_id");

                    b.ToTable("cases");
                });

            modelBuilder.Entity("eFormSqlController.check_list_site_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int?>("check_list_id");

                    b.Property<int?>("check_list_site_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("last_check_id")
                        .HasMaxLength(255);

                    b.Property<string>("microting_uid")
                        .HasMaxLength(255);

                    b.Property<int?>("site_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("check_list_site_versions");
                });

            modelBuilder.Entity("eFormSqlController.check_list_sites", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("last_check_id")
                        .HasMaxLength(255);

                    b.Property<string>("microting_uid")
                        .HasMaxLength(255);

                    b.Property<int?>("site_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("check_list_id");

                    b.HasIndex("site_id");

                    b.ToTable("check_list_sites");
                });

            modelBuilder.Entity("eFormSqlController.check_list_value_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int?>("case_id");

                    b.Property<int?>("check_list_duplicate_id");

                    b.Property<int?>("check_list_id");

                    b.Property<int?>("check_list_value_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("status")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("user_id");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("check_list_value_versions");
                });

            modelBuilder.Entity("eFormSqlController.check_list_values", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int?>("case_id");

                    b.Property<int?>("check_list_duplicate_id");

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("status")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("user_id");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("check_list_values");
                });

            modelBuilder.Entity("eFormSqlController.check_list_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<short?>("approval_enabled");

                    b.Property<string>("case_type")
                        .HasMaxLength(255);

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("custom");

                    b.Property<string>("description");

                    b.Property<int?>("display_index");

                    b.Property<short?>("done_button_enabled");

                    b.Property<short?>("download_entities");

                    b.Property<short?>("extra_fields_enabled");

                    b.Property<short?>("fast_navigation");

                    b.Property<int?>("field_1");

                    b.Property<int?>("field_10");

                    b.Property<int?>("field_2");

                    b.Property<int?>("field_3");

                    b.Property<int?>("field_4");

                    b.Property<int?>("field_5");

                    b.Property<int?>("field_6");

                    b.Property<int?>("field_7");

                    b.Property<int?>("field_8");

                    b.Property<int?>("field_9");

                    b.Property<string>("folder_name")
                        .HasMaxLength(255);

                    b.Property<string>("label");

                    b.Property<short?>("manual_sync");

                    b.Property<short?>("multi_approval");

                    b.Property<string>("original_id");

                    b.Property<int?>("parent_id");

                    b.Property<short?>("quick_sync_enabled");

                    b.Property<int?>("repeated");

                    b.Property<short?>("review_enabled");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("check_list_versions");
                });

            modelBuilder.Entity("eFormSqlController.check_lists", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<short?>("approval_enabled");

                    b.Property<string>("case_type")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("custom");

                    b.Property<string>("description");

                    b.Property<int?>("display_index");

                    b.Property<short?>("done_button_enabled");

                    b.Property<short?>("download_entities");

                    b.Property<short?>("extra_fields_enabled");

                    b.Property<short?>("fast_navigation");

                    b.Property<int?>("field_1");

                    b.Property<int?>("field_10");

                    b.Property<int?>("field_2");

                    b.Property<int?>("field_3");

                    b.Property<int?>("field_4");

                    b.Property<int?>("field_5");

                    b.Property<int?>("field_6");

                    b.Property<int?>("field_7");

                    b.Property<int?>("field_8");

                    b.Property<int?>("field_9");

                    b.Property<string>("folder_name")
                        .HasMaxLength(255);

                    b.Property<string>("label");

                    b.Property<short?>("manual_sync");

                    b.Property<short?>("multi_approval");

                    b.Property<string>("original_id");

                    b.Property<int?>("parent_id");

                    b.Property<short?>("quick_sync_enabled");

                    b.Property<int?>("repeated");

                    b.Property<short?>("review_enabled");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("parent_id");

                    b.ToTable("check_lists");
                });

            modelBuilder.Entity("eFormSqlController.entity_group_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("entity_group_id");

                    b.Property<string>("microting_uid");

                    b.Property<string>("name");

                    b.Property<string>("type")
                        .HasMaxLength(50);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("entity_group_versions");
                });

            modelBuilder.Entity("eFormSqlController.entity_groups", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("microting_uid");

                    b.Property<string>("name");

                    b.Property<string>("type")
                        .HasMaxLength(50);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("entity_groups");
                });

            modelBuilder.Entity("eFormSqlController.entity_item_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("description");

                    b.Property<int>("display_index");

                    b.Property<int?>("entity_group_id");

                    b.Property<string>("entity_item_uid")
                        .HasMaxLength(50);

                    b.Property<int>("entity_items_id");

                    b.Property<string>("microting_uid");

                    b.Property<string>("name");

                    b.Property<short?>("synced");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("entity_item_versions");
                });

            modelBuilder.Entity("eFormSqlController.entity_items", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("description");

                    b.Property<int>("display_index");

                    b.Property<int>("entity_group_id");

                    b.Property<string>("entity_item_uid")
                        .HasMaxLength(50);

                    b.Property<string>("microting_uid");

                    b.Property<string>("name");

                    b.Property<short?>("synced");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("entity_items");
                });

            modelBuilder.Entity("eFormSqlController.field_types", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<string>("description")
                        .HasMaxLength(255);

                    b.Property<string>("field_type")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("field_types");
                });

            modelBuilder.Entity("eFormSqlController.field_value_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<string>("accuracy")
                        .HasMaxLength(255);

                    b.Property<string>("altitude")
                        .HasMaxLength(255);

                    b.Property<int?>("case_id");

                    b.Property<int?>("check_list_duplicate_id");

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<DateTime?>("date");

                    b.Property<DateTime?>("done_at");

                    b.Property<int?>("field_id");

                    b.Property<int?>("field_value_id");

                    b.Property<string>("heading")
                        .HasMaxLength(255);

                    b.Property<string>("latitude")
                        .HasMaxLength(255);

                    b.Property<string>("longitude")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("uploaded_data_id");

                    b.Property<int?>("user_id");

                    b.Property<string>("value");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("field_value_versions");
                });

            modelBuilder.Entity("eFormSqlController.field_values", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<string>("accuracy")
                        .HasMaxLength(255);

                    b.Property<string>("altitude")
                        .HasMaxLength(255);

                    b.Property<int?>("case_id");

                    b.Property<int?>("check_list_duplicate_id");

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<DateTime?>("date");

                    b.Property<DateTime?>("done_at");

                    b.Property<int?>("field_id");

                    b.Property<string>("heading")
                        .HasMaxLength(255);

                    b.Property<string>("latitude")
                        .HasMaxLength(255);

                    b.Property<string>("longitude")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("uploaded_data_id");

                    b.Property<int?>("user_id");

                    b.Property<string>("value");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("check_list_id");

                    b.HasIndex("field_id");

                    b.HasIndex("uploaded_data_id");

                    b.HasIndex("user_id");

                    b.ToTable("field_values");
                });

            modelBuilder.Entity("eFormSqlController.field_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<short?>("barcode_enabled");

                    b.Property<string>("barcode_type")
                        .HasMaxLength(255);

                    b.Property<int?>("check_list_id");

                    b.Property<string>("color")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("custom");

                    b.Property<int?>("decimal_count");

                    b.Property<string>("default_value");

                    b.Property<string>("description");

                    b.Property<int?>("display_index");

                    b.Property<short?>("dummy");

                    b.Property<int?>("entity_group_id");

                    b.Property<int?>("field_id");

                    b.Property<int?>("field_type_id");

                    b.Property<short?>("geolocation_enabled");

                    b.Property<short?>("geolocation_forced");

                    b.Property<short?>("geolocation_hidden");

                    b.Property<short?>("is_num");

                    b.Property<string>("key_value_pair_list");

                    b.Property<string>("label");

                    b.Property<short?>("mandatory");

                    b.Property<int?>("max_length");

                    b.Property<string>("max_value")
                        .HasMaxLength(255);

                    b.Property<string>("min_value")
                        .HasMaxLength(255);

                    b.Property<int?>("multi");

                    b.Property<short?>("optional");

                    b.Property<string>("original_id");

                    b.Property<int?>("parent_field_id");

                    b.Property<string>("query_type")
                        .HasMaxLength(255);

                    b.Property<short?>("read_only");

                    b.Property<short?>("selected");

                    b.Property<short?>("split_screen");

                    b.Property<short?>("stop_on_save");

                    b.Property<string>("unit_name")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("field_versions");
                });

            modelBuilder.Entity("eFormSqlController.fields", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<short?>("barcode_enabled");

                    b.Property<string>("barcode_type")
                        .HasMaxLength(255);

                    b.Property<int?>("check_list_id");

                    b.Property<string>("color")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("custom");

                    b.Property<int?>("decimal_count");

                    b.Property<string>("default_value");

                    b.Property<string>("description");

                    b.Property<int?>("display_index");

                    b.Property<short?>("dummy");

                    b.Property<int?>("entity_group_id");

                    b.Property<int?>("field_type_id");

                    b.Property<short?>("geolocation_enabled");

                    b.Property<short?>("geolocation_forced");

                    b.Property<short?>("geolocation_hidden");

                    b.Property<short?>("is_num");

                    b.Property<string>("key_value_pair_list");

                    b.Property<string>("label");

                    b.Property<short?>("mandatory");

                    b.Property<int?>("max_length");

                    b.Property<string>("max_value")
                        .HasMaxLength(255);

                    b.Property<string>("min_value")
                        .HasMaxLength(255);

                    b.Property<int?>("multi");

                    b.Property<short?>("optional");

                    b.Property<string>("original_id");

                    b.Property<int?>("parent_field_id");

                    b.Property<string>("query_type")
                        .HasMaxLength(255);

                    b.Property<short?>("read_only");

                    b.Property<short?>("selected");

                    b.Property<short?>("split_screen");

                    b.Property<short?>("stop_on_save");

                    b.Property<string>("unit_name")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("check_list_id");

                    b.HasIndex("field_type_id");

                    b.HasIndex("parent_field_id");

                    b.ToTable("fields");
                });

            modelBuilder.Entity("eFormSqlController.folder_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("description");

                    b.Property<int?>("folder_id");

                    b.Property<int?>("microting_uid");

                    b.Property<string>("name");

                    b.Property<int?>("parent_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("folder_versions");
                });

            modelBuilder.Entity("eFormSqlController.folders", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("description");

                    b.Property<int?>("microting_uid");

                    b.Property<string>("name");

                    b.Property<int?>("parentId");

                    b.Property<int?>("parent_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("parentId");

                    b.ToTable("folders");
                });

            modelBuilder.Entity("eFormSqlController.language_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("description");

                    b.Property<int>("languageId");

                    b.Property<string>("name");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("languageId");

                    b.ToTable("language_versions");
                });

            modelBuilder.Entity("eFormSqlController.languages", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("description");

                    b.Property<string>("name");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("languages");
                });

            modelBuilder.Entity("eFormSqlController.log_exceptions", b =>
                {
                    b.Property<int>("id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime>("created_at");

                    b.Property<int>("level");

                    b.Property<string>("message");

                    b.Property<string>("type");

                    b.HasKey("id");

                    b.ToTable("log_exceptions");
                });

            modelBuilder.Entity("eFormSqlController.logs", b =>
                {
                    b.Property<int>("id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime>("created_at");

                    b.Property<int>("level");

                    b.Property<string>("message");

                    b.Property<string>("type");

                    b.HasKey("id");

                    b.ToTable("logs");
                });

            modelBuilder.Entity("eFormSqlController.notifications", b =>
                {
                    b.Property<int>("id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<string>("activity");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("exception");

                    b.Property<string>("microting_uid")
                        .HasMaxLength(255);

                    b.Property<string>("notification_uid")
                        .HasMaxLength(255);

                    b.Property<string>("stacktrace");

                    b.Property<string>("transmission");

                    b.Property<DateTime?>("updated_at");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("id");

                    b.ToTable("notifications");
                });

            modelBuilder.Entity("eFormSqlController.option_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int>("continuousOptionId");

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("nextQuestionId");

                    b.Property<int>("optionId");

                    b.Property<int>("optionsIndex");

                    b.Property<int>("questionId");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<int>("weight");

                    b.Property<int>("weightValue");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("optionId");

                    b.ToTable("option_versions");
                });

            modelBuilder.Entity("eFormSqlController.options", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int>("continuousOptionId");

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("nextQuestionId");

                    b.Property<int>("optionsIndex");

                    b.Property<int>("questionId");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<int>("weight");

                    b.Property<int>("weightValue");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("questionId");

                    b.ToTable("options");
                });

            modelBuilder.Entity("eFormSqlController.question_set_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<bool>("hasChild");

                    b.Property<string>("name");

                    b.Property<int>("parentId");

                    b.Property<bool>("posiblyDeployed");

                    b.Property<int>("questionSetId");

                    b.Property<bool>("share");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("questionSetId");

                    b.ToTable("question_set_versions");
                });

            modelBuilder.Entity("eFormSqlController.question_sets", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<bool>("hasChild");

                    b.Property<string>("name");

                    b.Property<int>("parentId");

                    b.Property<bool>("posiblyDeployed");

                    b.Property<bool>("share");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("question_sets");
                });

            modelBuilder.Entity("eFormSqlController.question_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<bool>("backButtonEnabled");

                    b.Property<int>("continuousQuestionId");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("fontSize");

                    b.Property<bool>("image");

                    b.Property<string>("imagePostion");

                    b.Property<int>("maxDuration");

                    b.Property<int>("maximum");

                    b.Property<int>("minDuration");

                    b.Property<int>("minimum");

                    b.Property<bool>("prioritised");

                    b.Property<int>("questionId");

                    b.Property<int>("questionIndex");

                    b.Property<int>("questionSetId");

                    b.Property<string>("questionType");

                    b.Property<int>("refId");

                    b.Property<string>("type");

                    b.Property<DateTime?>("updated_at");

                    b.Property<bool>("validDisplay");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("questionId");

                    b.ToTable("question_versions");
                });

            modelBuilder.Entity("eFormSqlController.questions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<bool>("backButtonEnabled");

                    b.Property<int>("continuousQuestionId");

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("fontSize");

                    b.Property<bool>("image");

                    b.Property<string>("imagePostion");

                    b.Property<int>("maxDuration");

                    b.Property<int>("maximum");

                    b.Property<int>("minDuration");

                    b.Property<int>("minimum");

                    b.Property<bool>("prioritised");

                    b.Property<int>("questionIndex");

                    b.Property<int>("questionSetId");

                    b.Property<string>("questionType");

                    b.Property<int>("refId");

                    b.Property<string>("type");

                    b.Property<DateTime?>("updated_at");

                    b.Property<bool>("validDisplay");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("questionSetId");

                    b.ToTable("questions");
                });

            modelBuilder.Entity("eFormSqlController.settings", b =>
                {
                    b.Property<int>("id");

                    b.Property<string>("name")
                        .IsRequired()
                        .HasMaxLength(50);

                    b.Property<string>("value");

                    b.HasKey("id");

                    b.ToTable("settings");
                });

            modelBuilder.Entity("eFormSqlController.site_survey_configuration_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("siteId");

                    b.Property<int>("siteSurveyConfigurationId");

                    b.Property<int>("surveyConfigurationId");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("siteSurveyConfigurationId");

                    b.ToTable("site_survey_configuration_versions");
                });

            modelBuilder.Entity("eFormSqlController.site_survey_configurations", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int>("siteId");

                    b.Property<int>("surveyConfigurationId");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("siteId");

                    b.HasIndex("surveyConfigurationId");

                    b.ToTable("site_survey_configurations");
                });

            modelBuilder.Entity("eFormSqlController.site_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int?>("microting_uid");

                    b.Property<string>("name")
                        .HasMaxLength(255);

                    b.Property<int?>("site_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("site_versions");
                });

            modelBuilder.Entity("eFormSqlController.site_worker_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int?>("microting_uid");

                    b.Property<int?>("site_id");

                    b.Property<int?>("site_worker_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<int?>("worker_id");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("site_worker_versions");
                });

            modelBuilder.Entity("eFormSqlController.site_workers", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int?>("microting_uid");

                    b.Property<int?>("site_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<int?>("worker_id");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("site_id");

                    b.HasIndex("worker_id");

                    b.ToTable("site_workers");
                });

            modelBuilder.Entity("eFormSqlController.sites", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int?>("microting_uid");

                    b.Property<string>("name")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("sites");
                });

            modelBuilder.Entity("eFormSqlController.survey_configuration_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("name");

                    b.Property<DateTime>("start");

                    b.Property<DateTime>("stop");

                    b.Property<int>("surveyConfigurationId");

                    b.Property<int>("timeOut");

                    b.Property<int>("timeToLive");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("surveyConfigurationId");

                    b.ToTable("survey_configuration_versions");
                });

            modelBuilder.Entity("eFormSqlController.survey_configurations", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("name");

                    b.Property<DateTime>("start");

                    b.Property<DateTime>("stop");

                    b.Property<int>("timeOut");

                    b.Property<int>("timeToLive");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("survey_configurations");
                });

            modelBuilder.Entity("eFormSqlController.tag_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("name")
                        .HasMaxLength(255);

                    b.Property<int?>("tag_id");

                    b.Property<int?>("taggings_count");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("tag_versions");
                });

            modelBuilder.Entity("eFormSqlController.tagging_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<int?>("tag_id");

                    b.Property<int?>("tagger_id");

                    b.Property<int?>("tagging_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("tagging_versions");
                });

            modelBuilder.Entity("eFormSqlController.taggings", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<int?>("check_list_id");

                    b.Property<DateTime?>("created_at");

                    b.Property<int?>("tag_id");

                    b.Property<int?>("tagger_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("check_list_id");

                    b.HasIndex("tag_id");

                    b.ToTable("taggings");
                });

            modelBuilder.Entity("eFormSqlController.tags", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("name")
                        .HasMaxLength(255);

                    b.Property<int?>("taggings_count");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("tags");
                });

            modelBuilder.Entity("eFormSqlController.unit_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int?>("customer_no");

                    b.Property<int?>("microting_uid");

                    b.Property<int?>("otp_code");

                    b.Property<int?>("site_id");

                    b.Property<int?>("unit_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("unit_versions");
                });

            modelBuilder.Entity("eFormSqlController.units", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<int?>("customer_no");

                    b.Property<int?>("microting_uid");

                    b.Property<int?>("otp_code");

                    b.Property<int?>("site_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.HasIndex("site_id");

                    b.ToTable("units");
                });

            modelBuilder.Entity("eFormSqlController.uploaded_data", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<string>("checksum")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("current_file")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("expiration_date");

                    b.Property<string>("extension")
                        .HasMaxLength(255);

                    b.Property<string>("file_location")
                        .HasMaxLength(255);

                    b.Property<string>("file_name")
                        .HasMaxLength(255);

                    b.Property<short?>("local");

                    b.Property<int?>("transcription_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("uploader_id");

                    b.Property<string>("uploader_type")
                        .HasMaxLength(255);

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("uploaded_data");
                });

            modelBuilder.Entity("eFormSqlController.uploaded_data_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<string>("checksum")
                        .HasMaxLength(255);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("current_file")
                        .HasMaxLength(255);

                    b.Property<int?>("data_uploaded_id");

                    b.Property<DateTime?>("expiration_date");

                    b.Property<string>("extension")
                        .HasMaxLength(255);

                    b.Property<string>("file_location")
                        .HasMaxLength(255);

                    b.Property<string>("file_name")
                        .HasMaxLength(255);

                    b.Property<short?>("local");

                    b.Property<int?>("transcription_id");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("uploader_id");

                    b.Property<string>("uploader_type")
                        .HasMaxLength(255);

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("uploaded_data_versions");
                });

            modelBuilder.Entity("eFormSqlController.worker_versions", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("email")
                        .HasMaxLength(255);

                    b.Property<string>("first_name")
                        .HasMaxLength(255);

                    b.Property<string>("last_name")
                        .HasMaxLength(255);

                    b.Property<int>("microting_uid");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<int?>("worker_id");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("worker_versions");
                });

            modelBuilder.Entity("eFormSqlController.workers", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation(autoIDGenStrategy, autoIDGenStrategyValue);

                    b.Property<DateTime?>("created_at");

                    b.Property<string>("email")
                        .HasMaxLength(255);

                    b.Property<string>("first_name")
                        .HasMaxLength(255);

                    b.Property<string>("last_name")
                        .HasMaxLength(255);

                    b.Property<int>("microting_uid");

                    b.Property<DateTime?>("updated_at");

                    b.Property<int?>("version");

                    b.Property<string>("workflow_state")
                        .HasMaxLength(255);

                    b.HasKey("Id");

                    b.ToTable("workers");
                });

            modelBuilder.Entity("eFormSqlController.answer_value_versions", b =>
                {
                    b.HasOne("eFormSqlController.answer_values", "AnswerValue")
                        .WithMany()
                        .HasForeignKey("answerValueId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.answer_values", b =>
                {
                    b.HasOne("eFormSqlController.answers", "Answer")
                        .WithMany()
                        .HasForeignKey("answerId")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.HasOne("eFormSqlController.options", "Option")
                        .WithMany()
                        .HasForeignKey("optionsId")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.HasOne("eFormSqlController.questions", "Question")
                        .WithMany()
                        .HasForeignKey("questionId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.answers", b =>
                {
                    b.HasOne("eFormSqlController.languages", "language")
                        .WithMany()
                        .HasForeignKey("languageId")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.HasOne("eFormSqlController.question_sets", "question_set")
                        .WithMany()
                        .HasForeignKey("questionSetId")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.HasOne("eFormSqlController.sites", "site")
                        .WithMany()
                        .HasForeignKey("siteId")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.HasOne("eFormSqlController.survey_configurations", "survey_configuration")
                        .WithMany()
                        .HasForeignKey("surveyConfigurationId")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.HasOne("eFormSqlController.units", "unit")
                        .WithMany()
                        .HasForeignKey("unitId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.cases", b =>
                {
                    b.HasOne("eFormSqlController.check_lists", "check_list")
                        .WithMany("cases")
                        .HasForeignKey("check_list_id");

                    b.HasOne("eFormSqlController.workers", "worker")
                        .WithMany()
                        .HasForeignKey("done_by_user_id");

                    b.HasOne("eFormSqlController.sites", "site")
                        .WithMany("cases")
                        .HasForeignKey("site_id");

                    b.HasOne("eFormSqlController.units", "unit")
                        .WithMany()
                        .HasForeignKey("unit_id");
                });

            modelBuilder.Entity("eFormSqlController.check_list_sites", b =>
                {
                    b.HasOne("eFormSqlController.check_lists", "check_list")
                        .WithMany("check_list_sites")
                        .HasForeignKey("check_list_id");

                    b.HasOne("eFormSqlController.sites", "site")
                        .WithMany("check_list_sites")
                        .HasForeignKey("site_id");
                });

            modelBuilder.Entity("eFormSqlController.check_lists", b =>
                {
                    b.HasOne("eFormSqlController.check_lists", "parent")
                        .WithMany("children")
                        .HasForeignKey("parent_id");
                });

            modelBuilder.Entity("eFormSqlController.field_values", b =>
                {
                    b.HasOne("eFormSqlController.check_lists", "check_list")
                        .WithMany()
                        .HasForeignKey("check_list_id");

                    b.HasOne("eFormSqlController.fields", "field")
                        .WithMany("field_values")
                        .HasForeignKey("field_id");

                    b.HasOne("eFormSqlController.uploaded_data", "uploaded_data")
                        .WithMany()
                        .HasForeignKey("uploaded_data_id");

                    b.HasOne("eFormSqlController.workers", "worker")
                        .WithMany()
                        .HasForeignKey("user_id");
                });

            modelBuilder.Entity("eFormSqlController.fields", b =>
                {
                    b.HasOne("eFormSqlController.check_lists", "check_list")
                        .WithMany("fields")
                        .HasForeignKey("check_list_id");

                    b.HasOne("eFormSqlController.field_types", "field_type")
                        .WithMany()
                        .HasForeignKey("field_type_id");

                    b.HasOne("eFormSqlController.fields", "parent")
                        .WithMany("children")
                        .HasForeignKey("parent_field_id");
                });

            modelBuilder.Entity("eFormSqlController.folders", b =>
                {
                    b.HasOne("eFormSqlController.folders", "parent")
                        .WithMany("children")
                        .HasForeignKey("parentId");
                });

            modelBuilder.Entity("eFormSqlController.language_versions", b =>
                {
                    b.HasOne("eFormSqlController.languages", "Language")
                        .WithMany()
                        .HasForeignKey("languageId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.option_versions", b =>
                {
                    b.HasOne("eFormSqlController.options", "Option")
                        .WithMany()
                        .HasForeignKey("optionId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.options", b =>
                {
                    b.HasOne("eFormSqlController.questions", "Question")
                        .WithMany()
                        .HasForeignKey("questionId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.question_set_versions", b =>
                {
                    b.HasOne("eFormSqlController.question_sets", "QuestionSet")
                        .WithMany()
                        .HasForeignKey("questionSetId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.question_versions", b =>
                {
                    b.HasOne("eFormSqlController.questions", "Question")
                        .WithMany()
                        .HasForeignKey("questionId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.questions", b =>
                {
                    b.HasOne("eFormSqlController.question_sets", "QuestionSet")
                        .WithMany()
                        .HasForeignKey("questionSetId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.site_survey_configuration_versions", b =>
                {
                    b.HasOne("eFormSqlController.site_survey_configurations", "SiteSurveyConfiguration")
                        .WithMany()
                        .HasForeignKey("siteSurveyConfigurationId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.site_survey_configurations", b =>
                {
                    b.HasOne("eFormSqlController.sites", "Site")
                        .WithMany()
                        .HasForeignKey("siteId")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.HasOne("eFormSqlController.survey_configurations", "SurveyConfiguration")
                        .WithMany()
                        .HasForeignKey("surveyConfigurationId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.site_workers", b =>
                {
                    b.HasOne("eFormSqlController.sites", "site")
                        .WithMany("site_workers")
                        .HasForeignKey("site_id");

                    b.HasOne("eFormSqlController.workers", "worker")
                        .WithMany("site_workers")
                        .HasForeignKey("worker_id");
                });

            modelBuilder.Entity("eFormSqlController.survey_configuration_versions", b =>
                {
                    b.HasOne("eFormSqlController.survey_configurations", "SurveyConfiguration")
                        .WithMany()
                        .HasForeignKey("surveyConfigurationId")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("eFormSqlController.taggings", b =>
                {
                    b.HasOne("eFormSqlController.check_lists", "check_list")
                        .WithMany("taggings")
                        .HasForeignKey("check_list_id");

                    b.HasOne("eFormSqlController.tags", "tag")
                        .WithMany("taggings")
                        .HasForeignKey("tag_id");
                });

            modelBuilder.Entity("eFormSqlController.units", b =>
                {
                    b.HasOne("eFormSqlController.sites", "site")
                        .WithMany("units")
                        .HasForeignKey("site_id");
                });
#pragma warning restore 612, 618
        }
    }
}