//
using System;
using IoTSharp.Data;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
#nullable disable
namespace IoTSharp.Data.Sqlite.Migrations
{
[DbContext(typeof(ApplicationDbContext))]
[Migration("20221006071746_remove_online_status")]
partial class remove_online_status
{
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.UseCollation("NOCASE")
.HasAnnotation("ProductVersion", "6.0.9");
modelBuilder.Entity("IoTSharp.Data.Alarm", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("AckDateTime")
.HasColumnType("TEXT");
b.Property("AlarmDetail")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("AlarmStatus")
.HasColumnType("INTEGER");
b.Property("AlarmType")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ClearDateTime")
.HasColumnType("TEXT");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("EndDateTime")
.HasColumnType("TEXT");
b.Property("OriginatorId")
.HasColumnType("TEXT");
b.Property("OriginatorType")
.HasColumnType("INTEGER");
b.Property("Propagate")
.HasColumnType("INTEGER");
b.Property("Serverity")
.HasColumnType("INTEGER");
b.Property("StartDateTime")
.HasColumnType("TEXT");
b.Property("TenantId")
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("CustomerId");
b.HasIndex("TenantId");
b.ToTable("Alarms");
});
modelBuilder.Entity("IoTSharp.Data.Asset", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("AssetType")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("Description")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Name")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("TenantId")
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("CustomerId");
b.HasIndex("TenantId");
b.ToTable("Assets");
});
modelBuilder.Entity("IoTSharp.Data.AssetRelation", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("AssetId")
.HasColumnType("TEXT");
b.Property("DataCatalog")
.HasColumnType("INTEGER");
b.Property("Description")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DeviceId")
.HasColumnType("TEXT");
b.Property("KeyName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Name")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("Id");
b.HasIndex("AssetId");
b.ToTable("AssetRelations");
});
modelBuilder.Entity("IoTSharp.Data.AuditLog", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("ActionData")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ActionName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ActionResult")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ActiveDateTime")
.HasColumnType("TEXT");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("ObjectID")
.HasColumnType("TEXT");
b.Property("ObjectName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ObjectType")
.HasColumnType("INTEGER");
b.Property("TenantId")
.HasColumnType("TEXT");
b.Property("UserId")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("UserName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("Id");
b.HasIndex("CustomerId");
b.HasIndex("TenantId");
b.ToTable("AuditLog");
});
modelBuilder.Entity("IoTSharp.Data.AuthorizedKey", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("AuthToken")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("Name")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("TenantId")
.HasColumnType("TEXT");
b.HasKey("Id");
b.HasIndex("CustomerId");
b.HasIndex("TenantId");
b.ToTable("AuthorizedKeys");
});
modelBuilder.Entity("IoTSharp.Data.BaseDictionary", b =>
{
b.Property("DictionaryId")
.ValueGeneratedOnAdd()
.HasColumnType("INTEGER");
b.Property("Dictionary18NKeyName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryColor")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryDesc")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryGroupId")
.HasColumnType("INTEGER");
b.Property("DictionaryIcon")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryPattern")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryStatus")
.HasColumnType("INTEGER");
b.Property("DictionaryTag")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryValue")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryValueType")
.HasColumnType("INTEGER");
b.Property("DictionaryValueTypeName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("DictionaryId");
b.ToTable("BaseDictionaries");
});
modelBuilder.Entity("IoTSharp.Data.BaseDictionaryGroup", b =>
{
b.Property("DictionaryGroupId")
.ValueGeneratedOnAdd()
.HasColumnType("INTEGER");
b.Property("DictionaryGroup18NKeyName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryGroupDesc")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryGroupKey")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryGroupName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DictionaryGroupStatus")
.HasColumnType("INTEGER");
b.Property("DictionaryGroupValueType")
.HasColumnType("INTEGER");
b.Property("DictionaryGroupValueTypeName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("DictionaryGroupId");
b.ToTable("BaseDictionaryGroups");
});
modelBuilder.Entity("IoTSharp.Data.BaseEvent", b =>
{
b.Property("EventId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("BizData")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Bizid")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CreaterDateTime")
.HasColumnType("TEXT");
b.Property("Creator")
.HasColumnType("TEXT");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("EventDesc")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("EventName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("EventStaus")
.HasColumnType("INTEGER");
b.Property("FlowRuleRuleId")
.HasColumnType("TEXT");
b.Property("MataData")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("TenantId")
.HasColumnType("TEXT");
b.Property("Type")
.HasColumnType("INTEGER");
b.HasKey("EventId");
b.HasIndex("CustomerId");
b.HasIndex("FlowRuleRuleId");
b.HasIndex("TenantId");
b.ToTable("BaseEvents");
});
modelBuilder.Entity("IoTSharp.Data.BaseI18N", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("INTEGER");
b.Property("AddDate")
.HasColumnType("TEXT");
b.Property("KeyName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ResouceDesc")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ResouceGroupId")
.HasColumnType("INTEGER");
b.Property("ResourceId")
.HasColumnType("INTEGER");
b.Property("ResourceKey")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ResourceTag")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ResourceType")
.HasColumnType("INTEGER");
b.Property("Status")
.HasColumnType("INTEGER");
b.Property("UserId")
.HasColumnType("TEXT");
b.Property("ValueBG")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueCS")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueDA")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueDEDE")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueELGR")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueENGR")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueENUS")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueESES")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueFI")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueFRFR")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueHE")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueHRHR")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueHU")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueITIT")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueJAJP")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueKOKR")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueNL")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValuePLPL")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValuePT")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueSLSL")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueSR")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueSV")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueTRTR")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueUK")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueVI")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueZHCN")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ValueZHTW")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("Id");
b.ToTable("BaseI18Ns");
});
modelBuilder.Entity("IoTSharp.Data.Customer", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("Address")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("City")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Country")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Email")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Name")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Phone")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Province")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Street")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("TenantId")
.HasColumnType("TEXT");
b.Property("ZipCode")
.HasColumnType("INTEGER");
b.HasKey("Id");
b.HasIndex("TenantId");
b.ToTable("Customer");
});
modelBuilder.Entity("IoTSharp.Data.DataStorage", b =>
{
b.Property("Catalog")
.HasColumnType("INTEGER")
.HasColumnOrder(0);
b.Property("DeviceId")
.HasColumnType("TEXT")
.HasColumnOrder(1);
b.Property("KeyName")
.HasColumnType("TEXT")
.HasColumnOrder(2)
.UseCollation("NOCASE");
b.Property("DataSide")
.HasColumnType("INTEGER")
.HasColumnOrder(4);
b.Property("DateTime")
.HasColumnType("TEXT")
.HasColumnOrder(3);
b.Property("Type")
.HasColumnType("INTEGER")
.HasColumnOrder(5);
b.Property("Value_Binary")
.HasColumnType("BLOB");
b.Property("Value_Boolean")
.HasColumnType("INTEGER");
b.Property("Value_DateTime")
.HasColumnType("TEXT");
b.Property("Value_Double")
.HasColumnType("REAL");
b.Property("Value_Json")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Value_Long")
.HasColumnType("INTEGER");
b.Property("Value_String")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("Value_XML")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("Catalog", "DeviceId", "KeyName");
b.HasIndex("Catalog");
b.HasIndex("Catalog", "DeviceId");
b.ToTable("DataStorage");
b.HasDiscriminator("Catalog").HasValue(0);
});
modelBuilder.Entity("IoTSharp.Data.Device", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("AuthorizedKeyId")
.HasColumnType("TEXT");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("Deleted")
.HasColumnType("INTEGER");
b.Property("DeviceModelId")
.HasColumnType("TEXT");
b.Property("DeviceType")
.HasColumnType("INTEGER");
b.Property("Name")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("OwnerId")
.HasColumnType("TEXT");
b.Property("ProduceId")
.HasColumnType("TEXT");
b.Property("TenantId")
.HasColumnType("TEXT");
b.Property("Timeout")
.HasColumnType("INTEGER");
b.HasKey("Id");
b.HasIndex("AuthorizedKeyId");
b.HasIndex("CustomerId");
b.HasIndex("OwnerId");
b.HasIndex("ProduceId");
b.HasIndex("TenantId");
b.ToTable("Device");
b.HasDiscriminator("DeviceType").HasValue(0);
});
modelBuilder.Entity("IoTSharp.Data.DeviceDiagram", b =>
{
b.Property("DiagramId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("CreateDate")
.HasColumnType("TEXT");
b.Property("Creator")
.HasColumnType("TEXT");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("DiagramDesc")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DiagramImage")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DiagramName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("DiagramStatus")
.HasColumnType("INTEGER");
b.Property("IsDefault")
.HasColumnType("INTEGER");
b.Property("TenantId")
.HasColumnType("TEXT");
b.HasKey("DiagramId");
b.HasIndex("CustomerId");
b.HasIndex("TenantId");
b.ToTable("DeviceDiagrams");
});
modelBuilder.Entity("IoTSharp.Data.DeviceGraph", b =>
{
b.Property("GraphId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("CreateDate")
.HasColumnType("TEXT");
b.Property("Creator")
.HasColumnType("TEXT");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("DeviceDiagramDiagramId")
.HasColumnType("TEXT");
b.Property("DeviceId")
.HasColumnType("TEXT");
b.Property("GraphElementId")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("GraphFill")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("GraphHeight")
.HasColumnType("INTEGER");
b.Property("GraphPostionX")
.HasColumnType("INTEGER");
b.Property("GraphPostionY")
.HasColumnType("INTEGER");
b.Property("GraphShape")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("GraphStroke")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("GraphStrokeWidth")
.HasColumnType("INTEGER");
b.Property("GraphTextAnchor")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("GraphTextFill")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("GraphTextFontFamily")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("GraphTextFontSize")
.HasColumnType("INTEGER");
b.Property("GraphTextRefX")
.HasColumnType("INTEGER");
b.Property("GraphTextRefY")
.HasColumnType("INTEGER");
b.Property("GraphTextVerticalAnchor")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("GraphWidth")
.HasColumnType("INTEGER");
b.Property("TenantId")
.HasColumnType("TEXT");
b.HasKey("GraphId");
b.HasIndex("CustomerId");
b.HasIndex("DeviceDiagramDiagramId");
b.HasIndex("TenantId");
b.ToTable("DeviceGraphs");
});
modelBuilder.Entity("IoTSharp.Data.DeviceGraphToolBox", b =>
{
b.Property("ToolBoxId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("CommondParam")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CommondType")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CreateDate")
.HasColumnType("TEXT");
b.Property("Creator")
.HasColumnType("TEXT");
b.Property("CustomerId")
.HasColumnType("TEXT");
b.Property("DeviceId")
.HasColumnType("INTEGER");
b.Property("TenantId")
.HasColumnType("TEXT");
b.Property("ToolBoxIcon")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ToolBoxName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ToolBoxOffsetLeftPer")
.HasColumnType("INTEGER");
b.Property("ToolBoxOffsetTopPer")
.HasColumnType("INTEGER");
b.Property("ToolBoxOffsetX")
.HasColumnType("INTEGER");
b.Property("ToolBoxOffsetY")
.HasColumnType("INTEGER");
b.Property("ToolBoxRequestUri")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ToolBoxStatus")
.HasColumnType("INTEGER");
b.Property("ToolBoxType")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("ToolBoxId");
b.HasIndex("CustomerId");
b.HasIndex("TenantId");
b.ToTable("DeviceGraphToolBoxes");
});
modelBuilder.Entity("IoTSharp.Data.DeviceIdentity", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("DeviceId")
.HasColumnType("TEXT");
b.Property("IdentityId")
.IsRequired()
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("IdentityType")
.HasColumnType("INTEGER");
b.Property("IdentityValue")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("Id");
b.HasIndex("DeviceId")
.IsUnique();
b.ToTable("DeviceIdentities");
});
modelBuilder.Entity("IoTSharp.Data.DeviceModel", b =>
{
b.Property("DeviceModelId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("CreateDateTime")
.HasColumnType("TEXT");
b.Property("Creator")
.HasColumnType("TEXT");
b.Property("ModelDesc")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ModelName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("ModelStatus")
.HasColumnType("INTEGER");
b.HasKey("DeviceModelId");
b.ToTable("DeviceModels");
});
modelBuilder.Entity("IoTSharp.Data.DeviceModelCommand", b =>
{
b.Property("CommandId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("CommandI18N")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CommandName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CommandParams")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CommandStatus")
.HasColumnType("INTEGER");
b.Property("CommandTemplate")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CommandTitle")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("CommandType")
.HasColumnType("INTEGER");
b.Property("CreateDateTime")
.HasColumnType("TEXT");
b.Property("Creator")
.HasColumnType("TEXT");
b.Property("DeviceModelId")
.HasColumnType("TEXT");
b.HasKey("CommandId");
b.HasIndex("DeviceModelId");
b.ToTable("DeviceModelCommands");
});
modelBuilder.Entity("IoTSharp.Data.DevicePort", b =>
{
b.Property("PortId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("CreateDate")
.HasColumnType("TEXT");
b.Property("Creator")
.HasColumnType("INTEGER");
b.Property("DeviceId")
.HasColumnType("TEXT");
b.Property("PortDesc")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("PortElementId")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("PortName")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("PortPhyType")
.HasColumnType("INTEGER");
b.Property("PortPic")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("PortStatus")
.HasColumnType("INTEGER");
b.Property("PortType")
.HasColumnType("INTEGER");
b.HasKey("PortId");
b.ToTable("DevicePorts");
});
modelBuilder.Entity("IoTSharp.Data.DevicePortMapping", b =>
{
b.Property("MappingId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("CreateDate")
.HasColumnType("TEXT");
b.Property("Creator")
.HasColumnType("TEXT");
b.Property("MappingIndex")
.HasColumnType("INTEGER");
b.Property("MappingStatus")
.HasColumnType("INTEGER");
b.Property("SourceDeviceId")
.HasColumnType("TEXT");
b.Property("SourceElementId")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("SourceId")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("TargeId")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.Property("TargetDeviceId")
.HasColumnType("TEXT");
b.Property("TargetElementId")
.HasColumnType("TEXT")
.UseCollation("NOCASE");
b.HasKey("MappingId");
b.ToTable("DevicePortMappings");
});
modelBuilder.Entity("IoTSharp.Data.DeviceRule", b =>
{
b.Property("DeviceRuleId")
.ValueGeneratedOnAdd()
.HasColumnType("TEXT");
b.Property("ConfigDateTime")
.HasColumnType("TEXT");
b.Property("ConfigUser")
.HasColumnType("TEXT");
b.Property("DeviceId")
.HasColumnType("TEXT");
b.Property("EnableTrace")
.HasColumnType("INTEGER");
b.Property("FlowRuleRuleId")
.HasColumnType("TEXT");
b.HasKey("DeviceRuleId");
b.HasIndex("DeviceId");
b.HasIndex("FlowRuleRuleId");
b.ToTable("DeviceRules");
});
modelBuilder.Entity("IoTSharp.Data.DynamicFormFieldInfo", b =>
{
b.Property