eFormCore/Migrations/20190318122928_FixingNamingOfSurveyConfigurationSites.Designer.cs
/*
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("20190318122928_FixingNamingOfSurveyConfigurationSites")]
partial class FixingNamingOfSurveyConfigurationSites
{
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618 //Setup for SQL Server Provider
string autoIDGenStrategy = "SqlServer:ValueGenerationStrategy";
object autoIDGenStrategyValue = MySqlValueGenerationStrategy.IdentityColumn;
if (DbConfig.IsMySQL)
{
autoIDGenStrategy = "MySql:ValueGenerationStrategy";
autoIDGenStrategyValue = MySqlValueGenerationStrategy.IdentityColumn;
}
modelBuilder
.HasAnnotation("ProductVersion", "2.2.2-servicing-10034")
.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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
}
}
}