// using System; using DW5S.Repostory; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; using Oracle.EntityFrameworkCore.Metadata; #nullable disable namespace DW5S.Repostory.Migrations { [DbContext(typeof(OracleContext))] [Migration("20250218024518_init")] partial class init { /// protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "7.0.20") .HasAnnotation("Relational:MaxIdentifierLength", 128); OracleModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("DW5S.Entity.AdRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Ch") .HasColumnType("NUMBER(10)") .HasColumnName("CH"); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("FileErrorMsg") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("FILEERRORMSG"); b.Property("FileSeconds") .HasColumnType("BINARY_DOUBLE") .HasColumnName("FILESECONDS"); b.Property("FileSize") .HasColumnType("NUMBER(19)") .HasColumnName("FILESIZE"); b.Property("FileTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("FILETIME"); b.Property("FreqCenter") .HasColumnType("NUMBER(19)") .HasColumnName("FREQCENTER"); b.Property("FreqdownHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQDOWNHZ"); b.Property("FrequpHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQUPHZ"); b.Property("FsHz") .HasColumnType("NUMBER(10)") .HasColumnName("FSHZ"); b.Property("HttpFile") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("HTTPFILE"); b.Property("RealFileCreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("REALFILECREATETIME"); b.Property("RealFileSize") .HasColumnType("NUMBER(19)") .HasColumnName("REALFILESIZE"); b.Property("RealFileUpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("REALFILEUPDATETIME"); b.Property("RecStationName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("RECSTATIONNAME"); b.Property("RecTxInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("RECTXINFOID"); b.Property("SatCode") .HasColumnType("NUMBER(10)") .HasColumnName("SATCODE"); b.Property("SigTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("SIGTIME"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_ADRES"); b.HasIndex("RecTxInfoID") .HasDatabaseName("IX_ADRES_RECTXINFOID"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_ADRES_UPDATETIME"); b.ToTable("ADRES", (string)null); }); modelBuilder.Entity("DW5S.Entity.CgRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AdResId1") .HasColumnType("NUMBER(19)") .HasColumnName("ADRESID1"); b.Property("AdResId2") .HasColumnType("NUMBER(19)") .HasColumnName("ADRESID2"); b.Property("AdResId3") .HasColumnType("NUMBER(19)") .HasColumnName("ADRESID3"); b.Property("Adja1Code") .HasColumnType("NUMBER(10)") .HasColumnName("ADJA1CODE"); b.Property("Adja1X") .HasColumnType("BINARY_DOUBLE") .HasColumnName("ADJA1X"); b.Property("Adja1XlTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("ADJA1XLTIME"); b.Property("Adja1Y") .HasColumnType("BINARY_DOUBLE") .HasColumnName("ADJA1Y"); b.Property("Adja1Z") .HasColumnType("BINARY_DOUBLE") .HasColumnName("ADJA1Z"); b.Property("Adja2Code") .HasColumnType("NUMBER(10)") .HasColumnName("ADJA2CODE"); b.Property("CheckResID") .HasColumnType("NUMBER(19)") .HasColumnName("CHECKRESID"); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("Dfo1") .HasColumnType("BINARY_DOUBLE") .HasColumnName("DFO1"); b.Property("Dfo2") .HasColumnType("BINARY_DOUBLE") .HasColumnName("DFO2"); b.Property("Dto1") .HasColumnType("BINARY_DOUBLE") .HasColumnName("DTO1"); b.Property("Dto2") .HasColumnType("BINARY_DOUBLE") .HasColumnName("DTO2"); b.Property("FreqdownHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQDOWNHZ"); b.Property("FrequpHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQUPHZ"); b.Property("MainCode") .HasColumnType("NUMBER(10)") .HasColumnName("MAINCODE"); b.Property("MainX") .HasColumnType("BINARY_DOUBLE") .HasColumnName("MAINX"); b.Property("MainXlTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("MAINXLTIME"); b.Property("MainY") .HasColumnType("BINARY_DOUBLE") .HasColumnName("MAINY"); b.Property("MainZ") .HasColumnType("BINARY_DOUBLE") .HasColumnName("MAINZ"); b.Property("RefYbDto1") .HasColumnType("BINARY_DOUBLE") .HasColumnName("REFYBDTO1"); b.Property("RefYbDto2") .HasColumnType("BINARY_DOUBLE") .HasColumnName("REFYBDTO2"); b.Property("SigInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("SIGINFOID"); b.Property("SigTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("SIGTIME"); b.Property("Snr1") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SNR1"); b.Property("Snr2") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SNR2"); b.Property("StationResID") .HasColumnType("NUMBER(19)") .HasColumnName("STATIONRESID"); b.Property("TaskID") .HasColumnType("NUMBER(10)") .HasColumnName("TASKID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_CGRES"); b.HasIndex("CheckResID") .HasDatabaseName("IX_CGRES_CHECKRESID"); b.HasIndex("SigInfoID") .HasDatabaseName("IX_CGRES_SIGINFOID"); b.HasIndex("StationResID") .HasDatabaseName("IX_CGRES_STATIONRESID"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_CGRES_UPDATETIME"); b.HasIndex("TaskID", "SigTime", "FrequpHz") .IsDescending(true, true, false) .HasDatabaseName("IX_CGRES_TASKID_TIME_FREQ"); b.ToTable("CGRES", (string)null); }); modelBuilder.Entity("DW5S.Entity.CgXgfRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CgResID") .HasColumnType("NUMBER(19)") .HasColumnName("CGRESID"); b.Property("CgType") .HasColumnType("NUMBER(10)") .HasColumnName("CGTYPE"); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("Dfo") .HasColumnType("BINARY_DOUBLE") .HasColumnName("DFO"); b.Property("Dto") .HasColumnType("BINARY_DOUBLE") .HasColumnName("DTO"); b.Property("SigTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("SIGTIME"); b.Property("Snr") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SNR"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_CGXGFRES"); b.HasIndex("CgResID") .HasDatabaseName("IX_CGXGFRES_CGRESID"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_CGXGFRES_UPDATETIME"); b.ToTable("CGXGFRES", (string)null); }); modelBuilder.Entity("DW5S.Entity.CheckRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("FfcHz") .HasColumnType("BINARY_DOUBLE") .HasColumnName("FFCHZ"); b.Property("HttpFile") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("HTTPFILE"); b.Property("ModRate") .HasColumnType("BINARY_DOUBLE") .HasColumnName("MODRATE"); b.Property("ModType") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("MODTYPE"); b.Property("PosCheckType") .HasColumnType("NUMBER(10)") .HasColumnName("POSCHECKTYPE"); b.Property("SigTime") .HasColumnType("NUMBER(10)") .HasColumnName("SIGTIME"); b.Property("SmpCount") .HasColumnType("NUMBER(19)") .HasColumnName("SMPCOUNT"); b.Property("SmpStart") .HasColumnType("NUMBER(19)") .HasColumnName("SMPSTART"); b.Property("Snr") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SNR"); b.Property("TaskID") .HasColumnType("NUMBER(10)") .HasColumnName("TASKID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.Property("UserName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("USERNAME"); b.HasKey("Id") .HasName("PK_CHECKRES"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_CHECKRES_UPDATETIME"); b.HasIndex("TaskID", "SigTime") .IsDescending() .HasDatabaseName("IX_CHECKRES_TASKID_SIGTIME"); b.ToTable("CHECKRES", (string)null); }); modelBuilder.Entity("DW5S.Entity.CxRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("Fx") .HasColumnType("BINARY_DOUBLE") .HasColumnName("FX"); b.Property("SigTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("SIGTIME"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_CXRES"); b.HasIndex("SigTime") .IsDescending() .HasDatabaseName("IX_CXRES_SIGTIME"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_CXRES_UPDATETIME"); b.ToTable("CXRES", (string)null); }); modelBuilder.Entity("DW5S.Entity.FixedStation", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("Enable") .HasColumnType("NUMBER(1)") .HasColumnName("ENABLE"); b.Property("FreqUpHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQUPHZ"); b.Property("Lat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("LAT"); b.Property("Lon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("LON"); b.Property("SpareField") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SPAREFIELD"); b.Property("StationName") .IsRequired() .HasMaxLength(50) .HasColumnType("NVARCHAR2(50)") .HasColumnName("STATIONNAME"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.Property("Value") .HasColumnType("BINARY_DOUBLE") .HasColumnName("VALUE"); b.HasKey("Id") .HasName("PK_FIXEDSTATION"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_FIXEDSTATION_UPDATETIME"); b.ToTable("FIXEDSTATION", (string)null); }); modelBuilder.Entity("DW5S.Entity.LogRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("LogTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("LOGTIME"); b.Property("LogType") .HasColumnType("NUMBER(10)") .HasColumnName("LOGTYPE"); b.Property("Module") .HasColumnType("NVARCHAR2(450)") .HasColumnName("MODULE"); b.Property("Msg") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("MSG"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_LOGRES"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_LOGRES_UPDATETIME"); b.HasIndex("Module", "LogTime", "LogType") .HasDatabaseName("IX_LOGRES_MODULE_TIME_TYPE"); b.ToTable("LOGRES", (string)null); }); modelBuilder.Entity("DW5S.Entity.PosRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CgResID") .HasColumnType("NUMBER(19)") .HasColumnName("CGRESID"); b.Property("CheckResID") .HasColumnType("NUMBER(19)") .HasColumnName("CHECKRESID"); b.Property("Confidence") .HasColumnType("NUMBER(10)") .HasColumnName("CONFIDENCE"); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("CxResID") .HasColumnType("NUMBER(19)") .HasColumnName("CXRESID"); b.Property("FreqdownHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQDOWNHZ"); b.Property("FrequpHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQUPHZ"); b.Property("MirrLat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("MIRRLAT"); b.Property("MirrLon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("MIRRLON"); b.Property("PosLat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("POSLAT"); b.Property("PosLon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("POSLON"); b.Property("PosResType") .HasColumnType("NUMBER(10)") .HasColumnName("POSRESTYPE"); b.Property("SigInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("SIGINFOID"); b.Property("SigTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("SIGTIME"); b.Property("StationResID") .HasColumnType("NUMBER(19)") .HasColumnName("STATIONRESID"); b.Property("TargetInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("TARGETINFOID"); b.Property("TaskID") .HasColumnType("NUMBER(10)") .HasColumnName("TASKID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_POSRES"); b.HasIndex("CgResID") .HasDatabaseName("IX_POSRES_CGRESID"); b.HasIndex("CheckResID") .HasDatabaseName("IX_POSRES_CHECKRESID"); b.HasIndex("CxResID") .HasDatabaseName("IX_POSRES_CXRESID"); b.HasIndex("SigInfoID") .HasDatabaseName("IX_POSRES_SIGINFOID"); b.HasIndex("StationResID") .IsUnique() .HasDatabaseName("IX_POSRES_STATIONRESID"); b.HasIndex("TargetInfoID") .IsUnique() .HasDatabaseName("IX_POSRES_TARGETINFOID") .HasFilter("\"TARGETINFOID\" IS NOT NULL"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_POSRES_UPDATETIME"); b.HasIndex("TaskID", "SigTime", "FrequpHz") .IsDescending(true, true, false) .HasDatabaseName("IX_POSRES_TASKID_TIME_FREQ"); b.ToTable("POSRES", (string)null); }); modelBuilder.Entity("DW5S.Entity.RefCgRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("FileTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("FILETIME"); b.Property("FreqdownHz") .HasColumnType("BINARY_DOUBLE") .HasColumnName("FREQDOWNHZ"); b.Property("FrequpHz") .HasColumnType("BINARY_DOUBLE") .HasColumnName("FREQUPHZ"); b.Property("RefTxInfoID") .HasColumnType("NUMBER(19)") .HasColumnName("REFTXINFOID"); b.Property("RefTxInfoId") .HasColumnType("NUMBER(10)") .HasColumnName("REFTXINFOID"); b.Property("SatInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("SATINFOID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.Property("YbDfo") .HasColumnType("BINARY_DOUBLE") .HasColumnName("YBDFO"); b.Property("YbDto") .HasColumnType("BINARY_DOUBLE") .HasColumnName("YBDTO"); b.Property("YbSnr") .HasColumnType("BINARY_DOUBLE") .HasColumnName("YBSNR"); b.HasKey("Id") .HasName("PK_REFCGRES"); b.HasIndex("RefTxInfoId") .HasDatabaseName("IX_REFCGRES_REFTXINFOID"); b.HasIndex("SatInfoID") .HasDatabaseName("IX_REFCGRES_SATINFOID"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_REFCGRES_UPDATETIME"); b.HasIndex("FileTime", "FrequpHz", "YbSnr") .IsDescending(true, false, true) .HasDatabaseName("IX_REFCGRES_TIME_FREQ_SNR"); b.ToTable("REFCGRES", null, t => { t.Property("RefTxInfoId") .HasColumnName("REFTXINFOID1"); }); }); modelBuilder.Entity("DW5S.Entity.RefTaskFreq", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CalcCycle") .HasColumnType("NUMBER(10)") .HasColumnName("CALCCYCLE"); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("DfoRange") .HasColumnType("NUMBER(10)") .HasColumnName("DFORANGE"); b.Property("DtoCenterus") .HasColumnType("NUMBER(10)") .HasColumnName("DTOCENTERUS"); b.Property("DtoRangeus") .HasColumnType("NUMBER(10)") .HasColumnName("DTORANGEUS"); b.Property("Enable") .HasColumnType("NUMBER(1)") .HasColumnName("ENABLE"); b.Property("SampleInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("SAMPLEINFOID"); b.Property("SampleLen") .HasColumnType("NUMBER(10)") .HasColumnName("SAMPLELEN"); b.Property("SatInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("SATINFOID"); b.Property("Snr0") .HasColumnType("NUMBER(10)") .HasColumnName("SNR0"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_REFTASKFREQ"); b.HasIndex("SampleInfoID") .IsUnique() .HasDatabaseName("IX_REFTASKFREQ_SAMPLEINFOID"); b.HasIndex("SatInfoID") .IsUnique() .HasDatabaseName("IX_REFTASKFREQ_SATINFOID"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_REFTASKFREQ_UPDATETIME"); b.ToTable("REFTASKFREQ", (string)null); }); modelBuilder.Entity("DW5S.Entity.SampleInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("EndSec") .HasColumnType("NUMBER(10)") .HasColumnName("ENDSEC"); b.Property("Fs") .HasColumnType("BINARY_DOUBLE") .HasColumnName("FS"); b.Property("Remark") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("REMARK"); b.Property("SampleFileName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("SAMPLEFILENAME"); b.Property("SampleName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("SAMPLENAME"); b.Property("SamplePath") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("SAMPLEPATH"); b.Property("SigInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("SIGINFOID"); b.Property("StartSec") .HasColumnType("NUMBER(10)") .HasColumnName("STARTSEC"); b.Property("TxInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("TXINFOID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_SAMPLEINFO"); b.HasIndex("SigInfoID") .IsUnique() .HasDatabaseName("IX_SAMPLEINFO_SIGINFOID"); b.HasIndex("TxInfoID") .HasDatabaseName("IX_SAMPLEINFO_TXINFOID"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_SAMPLEINFO_UPDATETIME"); b.ToTable("SAMPLEINFO", (string)null); }); modelBuilder.Entity("DW5S.Entity.SatInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("SatCode") .HasColumnType("NUMBER(10)") .HasColumnName("SATCODE"); b.Property("SatLon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SATLON"); b.Property("SatName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("SATNAME"); b.Property("SatTrans") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SATTRANS"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_SATINFO"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_SATINFO_UPDATETIME"); b.ToTable("SATINFO", (string)null); }); modelBuilder.Entity("DW5S.Entity.SigDelay", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("Delay") .HasColumnType("BINARY_DOUBLE") .HasColumnName("DELAY"); b.Property("Sat") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("SAT"); b.Property("SatInfoSatCode") .HasColumnType("NUMBER(10)") .HasColumnName("SATINFOSATCODE"); b.Property("SigInfoId") .HasColumnType("NUMBER(10)") .HasColumnName("SIGINFOID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_SIGDELAY"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_SIGDELAY_UPDATETIME"); b.ToTable("SIGDELAY", (string)null); }); modelBuilder.Entity("DW5S.Entity.SigInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Band") .HasColumnType("NUMBER(10)") .HasColumnName("BAND"); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("FreqDownHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQDOWNHZ"); b.Property("FreqUpHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQUPHZ"); b.Property("FsHz") .HasColumnType("NUMBER(10)") .HasColumnName("FSHZ"); b.Property("SigCheckType") .HasColumnType("NUMBER(10)") .HasColumnName("SIGCHECKTYPE"); b.Property("SigType") .HasColumnType("NUMBER(10)") .HasColumnName("SIGTYPE"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_SIGINFO"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_SIGINFO_UPDATETIME"); b.ToTable("SIGINFO", (string)null); }); modelBuilder.Entity("DW5S.Entity.StationRes", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(19)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CdbTxLat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("CDBTXLAT"); b.Property("CdbTxLon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("CDBTXLON"); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("CxLat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("CXLAT"); b.Property("CxLon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("CXLON"); b.Property("FixedLat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("FIXEDLAT"); b.Property("FixedLon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("FIXEDLON"); b.Property("FixedName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("FIXEDNAME"); b.Property("RefLat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("REFLAT"); b.Property("RefLon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("REFLON"); b.Property("RefName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("REFNAME"); b.Property("SatTxLat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SATTXLAT"); b.Property("SatTxLon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("SATTXLON"); b.Property("TaskID") .HasColumnType("NUMBER(10)") .HasColumnName("TASKID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_STATIONRES"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_STATIONRES_UPDATETIME"); b.ToTable("STATIONRES", (string)null); }); modelBuilder.Entity("DW5S.Entity.SysSetings", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("HttpPort") .HasColumnType("NUMBER(10)") .HasColumnName("HTTPPORT"); b.Property("MapLayerType") .HasColumnType("NUMBER(10)") .HasColumnName("MAPLAYERTYPE"); b.Property("MapType") .HasColumnType("NUMBER(10)") .HasColumnName("MAPTYPE"); b.Property("SampleDirectory") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("SAMPLEDIRECTORY"); b.Property("TimeZoneID") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("TIMEZONEID"); b.Property("TimeZoneName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("TIMEZONENAME"); b.Property("TimeZoneUTC") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("TIMEZONEUTC"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.Property("WmtsSource") .HasColumnType("NUMBER(10)") .HasColumnName("WMTSSOURCE"); b.Property("XLDirectory") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("XLDIRECTORY"); b.Property("ZoneHours") .HasColumnType("BINARY_DOUBLE") .HasColumnName("ZONEHOURS"); b.HasKey("Id") .HasName("PK_SYSSETINGS"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_SYSSETINGS_UPDATETIME"); b.ToTable("SYSSETINGS", (string)null); }); modelBuilder.Entity("DW5S.Entity.TargetInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("TargeColor") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("TARGECOLOR"); b.Property("TargetName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("TARGETNAME"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_TARGETINFO"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_TARGETINFO_UPDATETIME"); b.ToTable("TARGETINFO", (string)null); }); modelBuilder.Entity("DW5S.Entity.TaskInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Adja1Sat") .HasColumnType("NUMBER(10)") .HasColumnName("ADJA1SAT"); b.Property("Adja2Sat") .HasColumnType("NUMBER(10)") .HasColumnName("ADJA2SAT"); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("MainSat") .HasColumnType("NUMBER(10)") .HasColumnName("MAINSAT"); b.Property("PosType") .HasColumnType("NUMBER(10)") .HasColumnName("POSTYPE"); b.Property("TaskName") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("TASKNAME"); b.Property("TaskSourceType") .HasColumnType("NUMBER(10)") .HasColumnName("TASKSOURCETYPE"); b.Property("TaskState") .HasColumnType("NUMBER(10)") .HasColumnName("TASKSTATE"); b.Property("TaskType") .HasColumnType("NUMBER(10)") .HasColumnName("TASKTYPE"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_TASKINFO"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_TASKINFO_UPDATETIME"); b.ToTable("TASKINFO", (string)null); }); modelBuilder.Entity("DW5S.Entity.TaskRunnningInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("FreqUp") .HasColumnType("NUMBER(19)") .HasColumnName("FREQUP"); b.Property("LastDoneAdFileTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("LASTDONEADFILETIME"); b.Property("TaskID") .HasColumnType("NUMBER(10)") .HasColumnName("TASKID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_TASKRUNNNINGINFO"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_TASKRUNNNINGINFO_UPDATETIME"); b.ToTable("TASKRUNNNINGINFO", (string)null); }); modelBuilder.Entity("DW5S.Entity.TaskSig", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("DtoCenterus") .HasColumnType("BINARY_FLOAT") .HasColumnName("DTOCENTERUS"); b.Property("DtoRangeus") .HasColumnType("NUMBER(10)") .HasColumnName("DTORANGEUS"); b.Property("FreqDownHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQDOWNHZ"); b.Property("FreqUpHz") .HasColumnType("NUMBER(19)") .HasColumnName("FREQUPHZ"); b.Property("FsHz") .HasColumnType("NUMBER(19)") .HasColumnName("FSHZ"); b.Property("SigInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("SIGINFOID"); b.Property("Snr") .HasColumnType("NUMBER(10)") .HasColumnName("SNR"); b.Property("TaskInfoID") .HasColumnType("NUMBER(10)") .HasColumnName("TASKINFOID"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_TASKSIG"); b.HasIndex("SigInfoID") .HasDatabaseName("IX_TASKSIG_SIGINFOID"); b.HasIndex("TaskInfoID") .HasDatabaseName("IX_TASKSIG_TASKINFOID"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_TASKSIG_UPDATETIME"); b.ToTable("TASKSIG", (string)null); }); modelBuilder.Entity("DW5S.Entity.TxInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("Enable") .HasColumnType("NUMBER(1)") .HasColumnName("ENABLE"); b.Property("Lat") .HasColumnType("BINARY_DOUBLE") .HasColumnName("LAT"); b.Property("Lon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("LON"); b.Property("Name") .IsRequired() .HasMaxLength(50) .HasColumnType("NVARCHAR2(50)") .HasColumnName("NAME"); b.Property("Remark") .HasMaxLength(200) .HasColumnType("NVARCHAR2(200)") .HasColumnName("REMARK"); b.Property("TxType") .HasColumnType("NUMBER(10)") .HasColumnName("TXTYPE"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_TXINFO"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_TXINFO_UPDATETIME"); b.ToTable("TXINFO", (string)null); }); modelBuilder.Entity("DW5S.Entity.XlInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("NUMBER(10)") .HasColumnName("ID"); OraclePropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("CREATETIME"); b.Property("Line1") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("LINE1"); b.Property("Line2") .HasColumnType("NVARCHAR2(2000)") .HasColumnName("LINE2"); b.Property("Lon") .HasColumnType("BINARY_DOUBLE") .HasColumnName("LON"); b.Property("SatCode") .HasColumnType("NUMBER(10)") .HasColumnName("SATCODE"); b.Property("SatName") .HasColumnType("NVARCHAR2(450)") .HasColumnName("SATNAME"); b.Property("TimeUTC") .HasColumnType("TIMESTAMP(7)") .HasColumnName("TIMEUTC"); b.Property("UpdateTime") .HasColumnType("TIMESTAMP(7)") .HasColumnName("UPDATETIME"); b.HasKey("Id") .HasName("PK_XLINFO"); b.HasIndex("UpdateTime") .HasDatabaseName("IX_XLINFO_UPDATETIME"); b.HasIndex("SatName", "TimeUTC", "Lon") .IsDescending(false, true, false) .HasDatabaseName("IX_XLINFO_SATNAME_TIMEUTC_LON"); b.ToTable("XLINFO", (string)null); }); modelBuilder.Entity("DW5S.Entity.AdRes", b => { b.HasOne("DW5S.Entity.TxInfo", "RecTxInfo") .WithMany() .HasForeignKey("RecTxInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_ADRES_TXINFO_RECTXINFOID"); b.Navigation("RecTxInfo"); }); modelBuilder.Entity("DW5S.Entity.CgRes", b => { b.HasOne("DW5S.Entity.CheckRes", "CheckRes") .WithMany() .HasForeignKey("CheckResID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_CGRES_CHECKRES_CHECKRESID"); b.HasOne("DW5S.Entity.SigInfo", "SigInfo") .WithMany() .HasForeignKey("SigInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_CGRES_SIGINFO_SIGINFOID"); b.HasOne("DW5S.Entity.StationRes", "StationRes") .WithMany() .HasForeignKey("StationResID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_CGRES_STATIONRESID"); b.Navigation("CheckRes"); b.Navigation("SigInfo"); b.Navigation("StationRes"); }); modelBuilder.Entity("DW5S.Entity.CgXgfRes", b => { b.HasOne("DW5S.Entity.CgRes", "CgRes") .WithMany() .HasForeignKey("CgResID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_CGXGFRES_CGRES_CGRESID"); b.Navigation("CgRes"); }); modelBuilder.Entity("DW5S.Entity.PosRes", b => { b.HasOne("DW5S.Entity.CgRes", "CgRes") .WithMany() .HasForeignKey("CgResID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_POSRES_CGRES_CGRESID"); b.HasOne("DW5S.Entity.CheckRes", "CheckRes") .WithMany() .HasForeignKey("CheckResID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_POSRES_CHECKRES_CHECKRESID"); b.HasOne("DW5S.Entity.CxRes", "CxRes") .WithMany() .HasForeignKey("CxResID") .HasConstraintName("FK_POSRES_CXRES_CXRESID"); b.HasOne("DW5S.Entity.SigInfo", "SigInfo") .WithMany() .HasForeignKey("SigInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_POSRES_SIGINFO_SIGINFOID"); b.HasOne("DW5S.Entity.StationRes", "StationRes") .WithOne() .HasForeignKey("DW5S.Entity.PosRes", "StationResID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_POSRES_STATIONRESID"); b.HasOne("DW5S.Entity.TargetInfo", "TargetInfo") .WithOne() .HasForeignKey("DW5S.Entity.PosRes", "TargetInfoID") .HasConstraintName("FK_POSRES_TARGETINFOID"); b.Navigation("CgRes"); b.Navigation("CheckRes"); b.Navigation("CxRes"); b.Navigation("SigInfo"); b.Navigation("StationRes"); b.Navigation("TargetInfo"); }); modelBuilder.Entity("DW5S.Entity.RefCgRes", b => { b.HasOne("DW5S.Entity.TxInfo", "RefTxInfo") .WithMany() .HasForeignKey("RefTxInfoId") .HasConstraintName("FK_REFCGRES_TXINFO_REFTXINFOID"); b.HasOne("DW5S.Entity.SatInfo", "SatInfo") .WithMany() .HasForeignKey("SatInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_REFCGRES_SATINFO_SATINFOID"); b.Navigation("RefTxInfo"); b.Navigation("SatInfo"); }); modelBuilder.Entity("DW5S.Entity.RefTaskFreq", b => { b.HasOne("DW5S.Entity.SampleInfo", "SampleInfo") .WithOne() .HasForeignKey("DW5S.Entity.RefTaskFreq", "SampleInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_REFTASKFREQ_SAMPLEINFOID"); b.HasOne("DW5S.Entity.SatInfo", "SatInfo") .WithOne() .HasForeignKey("DW5S.Entity.RefTaskFreq", "SatInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_REFTASKFREQ_SATINFOID"); b.Navigation("SampleInfo"); b.Navigation("SatInfo"); }); modelBuilder.Entity("DW5S.Entity.SampleInfo", b => { b.HasOne("DW5S.Entity.SigInfo", "SigInfo") .WithOne() .HasForeignKey("DW5S.Entity.SampleInfo", "SigInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_SAMPLEINFO_SIGINFOID"); b.HasOne("DW5S.Entity.TxInfo", "RefTxInfo") .WithMany() .HasForeignKey("TxInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_SAMPLEINFO_TXINFO_TXINFOID"); b.Navigation("RefTxInfo"); b.Navigation("SigInfo"); }); modelBuilder.Entity("DW5S.Entity.TaskSig", b => { b.HasOne("DW5S.Entity.SigInfo", "SigInfo") .WithMany() .HasForeignKey("SigInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_TASKSIG_SIGINFO_SIGINFOID"); b.HasOne("DW5S.Entity.TaskInfo", "TaskInfo") .WithMany() .HasForeignKey("TaskInfoID") .OnDelete(DeleteBehavior.Cascade) .IsRequired() .HasConstraintName("FK_TASKSIG_TASKINFO_TASKINFOID"); b.Navigation("SigInfo"); b.Navigation("TaskInfo"); }); #pragma warning restore 612, 618 } } }