DW5S/DW5S.Repostory/Migrations/20250212085549_Init.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace DW5S.Repostory.Migrations
{
    /// <inheritdoc />
    public partial class Init : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "CheckRes",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    FILENAME = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    POSCHECKTYPE = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    SMPSTART = table.Column<long>(type: "NUMBER(19)", nullable: true),
                    SMPCOUNT = table.Column<long>(type: "NUMBER(19)", nullable: true),
                    USERNAME = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    MODTYPE = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    MODRATE = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    FFCHZ = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    SNR = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CHECKRES", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "CxRes",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    SIGTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    FX = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CXRES", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "FIXEDSTATION",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    STATIONNAME = table.Column<string>(type: "NVARCHAR2(50)", maxLength: 50, nullable: false),
                    LON = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    LAT = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    FREQUPHZ = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    VALUE = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SPAREFIELD = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    ENABLE = table.Column<bool>(type: "NUMBER(1)", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_FIXEDSTATION", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "LOGRES",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    MODULE = table.Column<string>(type: "NVARCHAR2(450)", nullable: true),
                    LOGTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    LOGTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    MSG = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_LOGRES", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "SATINFO",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    SATCODE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SATNAME = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    SATLON = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    SATTRANS = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SATINFO", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "SigInfo",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    FREQUP = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    FREQDOWN = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    SIGTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SIGCHECKTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SNR = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    BAND = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SIGINFO", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "StationRes",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    TASKID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SATTXLON = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATTXLAT = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    CDBTXLON = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    CDBTXLAT = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    CXLON = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    CXLAT = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    REFLON = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    REFLAT = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_STATIONRES", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "SysSetings",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    TIMEZONEID = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    TIMEZONEUTC = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    TIMEZONENAME = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    ZONEHOURS = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    HTTPPORT = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    XLDIRECTORY = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    SAMPLEDIRECTORY = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    MAPTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    WMTSSOURCE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    MAPLAYERTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SYSSETINGS", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "TARGETINFO",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    TARGETNAME = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    TARGECOLOR = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_TARGETINFO", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "TASKINFO",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    TASKSTATE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    TASKNAME = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    TASKTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    POSTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    MAINSAT = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    ADJA1SAT = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    ADJA2SAT = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    CAPDIR = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    CAPDIRFORMAT = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_TASKINFO", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "TASKRUNNNINGINFO",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    TASKID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    FREQUP = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    LASTDONEADFILETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_TASKRUNNNINGINFO", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "TXINFO",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    NAME = table.Column<string>(type: "NVARCHAR2(50)", maxLength: 50, nullable: false),
                    TXTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    LON = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    LAT = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    ENABLE = table.Column<bool>(type: "NUMBER(1)", nullable: false),
                    REMARK = table.Column<string>(type: "NVARCHAR2(200)", maxLength: 200, nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_TXINFO", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "XLINFO",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    SATCODE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SATNAME = table.Column<string>(type: "NVARCHAR2(450)", nullable: true),
                    TIMEUTC = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    LON = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    LINE1 = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    LINE2 = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_XLINFO", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "SIGDELAY",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    SIGINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SATINFOSATCODE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SAT = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    SATINFOID = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    DELAY = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SIGDELAY", x => x.ID);
                    table.ForeignKey(
                        name: "FK_SIGDELAY_SATINFOID",
                        column: x => x.SATINFOID,
                        principalTable: "SATINFO",
                        principalColumn: "ID");
                    table.ForeignKey(
                        name: "FK_SIGDELAY_SIGINFOID",
                        column: x => x.SIGINFOID,
                        principalTable: "SigInfo",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "CgRes",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    SIGTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    STATIONRESID = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    TASKID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    FIXEDSTATIONID = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    DTO1 = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    DFO1 = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    SNR1 = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    DTO2 = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    DFO2 = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    SNR2 = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    DTOCDB = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    DFOCDB = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    SNRCDB = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBMAINDTO = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBMAINDFO = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBMAINSNR = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBADJA1DTO = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBADJA1DFO = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBADJA1SNR = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBADJA2DTO = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBADJA2DFO = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    YBADJA2SNR = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    TARFREQUP = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    TARFREQDOWN = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    REFFREQUP = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    REFFREQDOWN = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    MAINCODE = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    ADJA1CODE = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    ADJA2CODE = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    MAINXLTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: true),
                    ADJA1XLTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: true),
                    ADJA2XLTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: true),
                    MAINX = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    MAINY = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    MAINZ = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    MAINVX = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    MAINVY = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    MAINVZ = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA1X = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA1Y = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA1Z = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA1VX = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA1VY = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA1VZ = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA2X = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA2Y = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA2Z = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA2VX = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA2VY = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    ADJA2VZ = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CGRES", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CGRES_FIXEDSTATIONID",
                        column: x => x.FIXEDSTATIONID,
                        principalTable: "FIXEDSTATION",
                        principalColumn: "ID");
                    table.ForeignKey(
                        name: "FK_CGRES_STATIONRESID",
                        column: x => x.STATIONRESID,
                        principalTable: "StationRes",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "TASKSIG",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    TASKINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SIGINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    FREQUP = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    FREQDOWN = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_TASKSIG", x => x.ID);
                    table.ForeignKey(
                        name: "FK_TASKSIG_SIGINFOID",
                        column: x => x.SIGINFOID,
                        principalTable: "SigInfo",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_TASKSIG_TASKINFOID",
                        column: x => x.TASKINFOID,
                        principalTable: "TASKINFO",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "RefCgRes",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    SIGTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    REFFREQUP = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    REFFREQDOWN = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    REFTXINFOID = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    REFTXINFOID1 = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    YBDTO = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    YBDFO = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    YBSNR = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATXLTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    SATX = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATY = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATZ = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATVX = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATVY = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATVZ = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_REFCGRES", x => x.ID);
                    table.ForeignKey(
                        name: "FK_REFCGRES_SATINFOID",
                        column: x => x.SATINFOID,
                        principalTable: "SATINFO",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_REFCGRES_REFTXINFOID",
                        column: x => x.REFTXINFOID1,
                        principalTable: "TXINFO",
                        principalColumn: "ID");
                });

            migrationBuilder.CreateTable(
                name: "SampleInfo",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    SAMPLENAME = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    REFTXINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SIGINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    FS = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    STARTSEC = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    ENDSEC = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SAMPLEFILENAME = table.Column<string>(type: "NVARCHAR2(200)", maxLength: 200, nullable: true),
                    SAMPLEPATH = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    REMARK = table.Column<string>(type: "NVARCHAR2(200)", maxLength: 200, nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SAMPLEINFO", x => x.ID);
                    table.ForeignKey(
                        name: "FK_SAMPLEINFO_SIGINFOID",
                        column: x => x.SIGINFOID,
                        principalTable: "SigInfo",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_SAMPLEINFO_REFTXINFOID",
                        column: x => x.REFTXINFOID,
                        principalTable: "TXINFO",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "CgXgfRes",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    CGRESID = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    CGTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SIGTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    DTO = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    DFO = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    SNR = table.Column<double>(type: "BINARY_DOUBLE", nullable: true),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CGXGFRES", x => x.ID);
                    table.ForeignKey(
                        name: "FK_CGXGFRES_CGRESID",
                        column: x => x.CGRESID,
                        principalTable: "CgRes",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "PosRes",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    TASKINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    FREQUPHZ = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    STATIONRESID = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    CXRESID = table.Column<long>(type: "NUMBER(19)", nullable: true),
                    CGRESID = table.Column<long>(type: "NUMBER(19)", nullable: false),
                    TARGETINFOID = table.Column<int>(type: "NUMBER(10)", nullable: true),
                    CHECKRESID = table.Column<long>(type: "NUMBER(19)", nullable: true),
                    POSRESTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    TARGETSTATE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    SIGTIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    POSLON = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    POSLAT = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    MIRRLON = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    MIRRLAT = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    CONFIDENCE = table.Column<int>(type: "NUMBER(10)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_POSRES", x => x.ID);
                    table.ForeignKey(
                        name: "FK_POSRES_CGRES_CGRESID",
                        column: x => x.CGRESID,
                        principalTable: "CgRes",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_POSRES_CHECKRESID",
                        column: x => x.CHECKRESID,
                        principalTable: "CheckRes",
                        principalColumn: "ID");
                    table.ForeignKey(
                        name: "FK_POSRES_CXRES_CXRESID",
                        column: x => x.CXRESID,
                        principalTable: "CxRes",
                        principalColumn: "ID");
                    table.ForeignKey(
                        name: "FK_POSRES_STATIONRESID",
                        column: x => x.STATIONRESID,
                        principalTable: "StationRes",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "RefTaskFreq",
                columns: table => new
                {
                    ID = table.Column<long>(type: "NUMBER(19)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    SAMPLEINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SATINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    CALCCCYCLE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SNR = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    DTOCENTER = table.Column<float>(type: "BINARY_FLOAT", nullable: false),
                    DTORANGE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    SAMPLELEN = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    ENABLE = table.Column<bool>(type: "NUMBER(1)", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_REFTASKFREQ", x => x.ID);
                    table.ForeignKey(
                        name: "FK_REFTASKFREQ_SAMPLEINFOID",
                        column: x => x.SAMPLEINFOID,
                        principalTable: "SampleInfo",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_REFTASKFREQ_SATINFOID",
                        column: x => x.SATINFOID,
                        principalTable: "SATINFO",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateIndex(
                name: "IX_CGRES_FIXEDSTATIONID",
                table: "CgRes",
                column: "FIXEDSTATIONID");

            migrationBuilder.CreateIndex(
                name: "IX_CGRES_STATIONRESID",
                table: "CgRes",
                column: "STATIONRESID");

            migrationBuilder.CreateIndex(
                name: "IX_CGRES_UPDATETIME",
                table: "CgRes",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_CGXGFRES_CGRESID",
                table: "CgXgfRes",
                column: "CGRESID");

            migrationBuilder.CreateIndex(
                name: "IX_CGXGFRES_UPDATETIME",
                table: "CgXgfRes",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_CHECKRES_UPDATETIME",
                table: "CheckRes",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_CXRES_UPDATETIME",
                table: "CxRes",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_FIXEDSTATION_UPDATETIME",
                table: "FIXEDSTATION",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_LOGRES_MODULE_TIME_TYPE",
                table: "LOGRES",
                columns: new[] { "MODULE", "LOGTIME", "LOGTYPE" });

            migrationBuilder.CreateIndex(
                name: "IX_LOGRES_UPDATETIME",
                table: "LOGRES",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_POSRES_CGRESID",
                table: "PosRes",
                column: "CGRESID");

            migrationBuilder.CreateIndex(
                name: "IX_POSRES_CHECKRESID",
                table: "PosRes",
                column: "CHECKRESID");

            migrationBuilder.CreateIndex(
                name: "IX_POSRES_CXRESID",
                table: "PosRes",
                column: "CXRESID");

            migrationBuilder.CreateIndex(
                name: "IX_POSRES_STATIONRESID",
                table: "PosRes",
                column: "STATIONRESID");

            migrationBuilder.CreateIndex(
                name: "IX_POSRES_UPDATETIME",
                table: "PosRes",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_REFCGRES_REFTXINFOID",
                table: "RefCgRes",
                column: "REFTXINFOID1");

            migrationBuilder.CreateIndex(
                name: "IX_REFCGRES_SATINFOID",
                table: "RefCgRes",
                column: "SATINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_REFCGRES_UPDATETIME",
                table: "RefCgRes",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_REFTASKFREQ_SAMPLEINFOID",
                table: "RefTaskFreq",
                column: "SAMPLEINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_REFTASKFREQ_SATINFOID",
                table: "RefTaskFreq",
                column: "SATINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_REFTASKFREQ_UPDATETIME",
                table: "RefTaskFreq",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_SAMPLEINFO_REFTXINFOID",
                table: "SampleInfo",
                column: "REFTXINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_SAMPLEINFO_SIGINFOID",
                table: "SampleInfo",
                column: "SIGINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_SAMPLEINFO_UPDATETIME",
                table: "SampleInfo",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_SATINFO_UPDATETIME",
                table: "SATINFO",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_SIGDELAY_SATINFOID",
                table: "SIGDELAY",
                column: "SATINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_SIGDELAY_SIGINFOID",
                table: "SIGDELAY",
                column: "SIGINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_SIGDELAY_UPDATETIME",
                table: "SIGDELAY",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_SIGINFO_UPDATETIME",
                table: "SigInfo",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_STATIONRES_UPDATETIME",
                table: "StationRes",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_SYSSETINGS_UPDATETIME",
                table: "SysSetings",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_TARGETINFO_UPDATETIME",
                table: "TARGETINFO",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_TASKINFO_UPDATETIME",
                table: "TASKINFO",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_TASKRUNNNINGINFO_UPDATETIME",
                table: "TASKRUNNNINGINFO",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_TASKSIG_SIGINFOID",
                table: "TASKSIG",
                column: "SIGINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_TASKSIG_TASKINFOID",
                table: "TASKSIG",
                column: "TASKINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_TASKSIG_UPDATETIME",
                table: "TASKSIG",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_TXINFO_UPDATETIME",
                table: "TXINFO",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_XLINFO_SATNAME_TIMEUTC_LON",
                table: "XLINFO",
                columns: new[] { "SATNAME", "TIMEUTC", "LON" });

            migrationBuilder.CreateIndex(
                name: "IX_XLINFO_UPDATETIME",
                table: "XLINFO",
                column: "UPDATETIME");
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "CgXgfRes");

            migrationBuilder.DropTable(
                name: "LOGRES");

            migrationBuilder.DropTable(
                name: "PosRes");

            migrationBuilder.DropTable(
                name: "RefCgRes");

            migrationBuilder.DropTable(
                name: "RefTaskFreq");

            migrationBuilder.DropTable(
                name: "SIGDELAY");

            migrationBuilder.DropTable(
                name: "SysSetings");

            migrationBuilder.DropTable(
                name: "TARGETINFO");

            migrationBuilder.DropTable(
                name: "TASKRUNNNINGINFO");

            migrationBuilder.DropTable(
                name: "TASKSIG");

            migrationBuilder.DropTable(
                name: "XLINFO");

            migrationBuilder.DropTable(
                name: "CgRes");

            migrationBuilder.DropTable(
                name: "CheckRes");

            migrationBuilder.DropTable(
                name: "CxRes");

            migrationBuilder.DropTable(
                name: "SampleInfo");

            migrationBuilder.DropTable(
                name: "SATINFO");

            migrationBuilder.DropTable(
                name: "TASKINFO");

            migrationBuilder.DropTable(
                name: "FIXEDSTATION");

            migrationBuilder.DropTable(
                name: "StationRes");

            migrationBuilder.DropTable(
                name: "SigInfo");

            migrationBuilder.DropTable(
                name: "TXINFO");
        }
    }
}