feat:菜单开发

sunpengfei

2025-08-04 d3f1887ba4a8b4ad822406a7a4fc97dbfea91850

 FlexJobApi.Database.Migrations/Migrations/20250801141922_UpdateUser0801.cs

File was renamed from FlexJobApi.Database.Migrations/Migrations/20250801013026_Init.cs
@@ -6,7 +6,7 @@
namespace FlexJobApi.Database.Migrations.Migrations
{
    /// <inheritdoc />
    public partial class Init : Migration
    public partial class UpdateUser0801 : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
@@ -21,11 +21,11 @@
                    FieldNames = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "字段名（逗号隔开）"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -51,11 +51,11 @@
                    ImageHeight = table.Column<int>(type: "int", nullable: true, comment: "高度（像素）"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -69,6 +69,7 @@
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    ParentId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "上级Id"),
                    Path = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "菜单路径"),
                    Code = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "编号"),
                    Name = table.Column<string>(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "名称"),
                    Type = table.Column<int>(type: "int", nullable: false, comment: "类型"),
@@ -76,18 +77,19 @@
                    Icon = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "图标"),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "链接地址"),
                    Group = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "分组名称（用于按钮/字段）"),
                    BindField = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "绑定字段"),
                    Location = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "位置（用于按钮）"),
                    Width = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "列宽（用于按钮/列/元素）"),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false, comment: "是否禁用"),
                    IsHidden = table.Column<bool>(type: "bit", nullable: false, comment: "是否隐藏"),
                    IsCache = table.Column<bool>(type: "bit", nullable: false, comment: "是否缓存"),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "备注"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -101,6 +103,32 @@
                comment: "菜单");

            migrationBuilder.CreateTable(
                name: "Resource",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Service = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Code = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Method = table.Column<int>(type: "int", nullable: false),
                    Route = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    RequestTypeName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    ResponseTypeName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    IsExpired = table.Column<bool>(type: "bit", nullable: false),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Resource", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Role",
                columns: table => new
                {
@@ -111,11 +139,11 @@
                    MinLevel = table.Column<int>(type: "int", nullable: false, comment: "最低级别"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -124,36 +152,13 @@
                comment: "角色");

            migrationBuilder.CreateTable(
                name: "WebApi",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Code = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "编号"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "名称"),
                    Method = table.Column<int>(type: "int", nullable: false, comment: "请求方式"),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "路由地址"),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false, comment: "是否禁用"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_WebApi", x => x.Id);
                },
                comment: "接口");

            migrationBuilder.CreateTable(
                name: "DictionaryData",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    CategoryId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "类别Id"),
                    ParentId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "上级Id"),
                    Path = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "字典路径"),
                    Code = table.Column<string>(type: "nvarchar(128)", maxLength: 128, nullable: true, comment: "编号"),
                    Content = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "显示内容"),
                    Field1 = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "字段1"),
@@ -163,11 +168,11 @@
                    Field5 = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "字段5"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -196,11 +201,11 @@
                    VirtualPath = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "虚拟路径"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -223,11 +228,11 @@
                    MenuId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "菜单Id"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -248,38 +253,37 @@
                comment: "角色菜单");

            migrationBuilder.CreateTable(
                name: "RoleWebApi",
                name: "RoleResource",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    RoleId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "角色Id"),
                    MenuId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "菜单Id"),
                    DataPower = table.Column<int>(type: "int", nullable: true, comment: "数据权限"),
                    RoleId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    MenuId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    DataPower = table.Column<int>(type: "int", nullable: true),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_RoleWebApi", x => x.Id);
                    table.PrimaryKey("PK_RoleResource", x => x.Id);
                    table.ForeignKey(
                        name: "FK_RoleWebApi_Menu_MenuId",
                        name: "FK_RoleResource_Menu_MenuId",
                        column: x => x.MenuId,
                        principalTable: "Menu",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_RoleWebApi_Role_RoleId",
                        name: "FK_RoleResource_Role_RoleId",
                        column: x => x.RoleId,
                        principalTable: "Role",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "角色接口");
                });

            migrationBuilder.CreateTable(
                name: "Enterprise",
@@ -305,11 +309,11 @@
                    IsReal = table.Column<bool>(type: "bit", nullable: false, comment: "是否实名"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -352,11 +356,11 @@
                    IsReal = table.Column<bool>(type: "bit", nullable: false, comment: "是否实名"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -390,17 +394,18 @@
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    ParentId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "上级Id"),
                    Path = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "部门路径"),
                    EnterpriseId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "企业Id"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "名称"),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "备注"),
                    IsDisabled = table.Column<bool>(type: "bit", nullable: false, comment: "是否禁用"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -438,11 +443,11 @@
                    EndTime = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "任务结束时间"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -467,8 +472,7 @@
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    UserId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "用户Id"),
                    UserAuthId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UserAuthId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "用户Id"),
                    Type = table.Column<int>(type: "int", nullable: false, comment: "用户类型"),
                    EnterpriseId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "企业Id"),
                    WxmpOpenId = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "微信开放Id"),
@@ -484,11 +488,11 @@
                    Weight = table.Column<int>(type: "int", nullable: true, comment: "体重"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -517,7 +521,8 @@
                        name: "FK_UserInfo_UserAuth_UserAuthId",
                        column: x => x.UserAuthId,
                        principalTable: "UserAuth",
                        principalColumn: "Id");
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                },
                comment: "用户信息");

@@ -531,11 +536,11 @@
                    BenefitId1 = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -564,11 +569,11 @@
                    TypeId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "证书类型Id"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -599,11 +604,11 @@
                    SignContractTime = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "签约时间"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -634,11 +639,11 @@
                    PhoneNumber = table.Column<string>(type: "nvarchar(11)", maxLength: 11, nullable: false, comment: "银行预留手机号"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -668,11 +673,11 @@
                    BackImgId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "证书反面照片Id"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -711,11 +716,11 @@
                    DepartmentId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "部门Id"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -744,11 +749,11 @@
                    PersonalIdentityId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "期望岗位Id"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -777,11 +782,11 @@
                    ImgId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "照片Id"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -810,11 +815,11 @@
                    RoleId = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "角色Id"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false)
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
@@ -841,8 +846,8 @@

            migrationBuilder.InsertData(
                table: "UserInfo",
                columns: new[] { "Id", "CityId", "CreatedTime", "CreatedUserInfoId", "EducationalBackgroundId", "EnterpriseId", "FreeTime", "Height", "IsDeleted", "JobSeekingStatus", "Level", "PersonalIdentityId", "Sort", "TraceId", "Type", "UpdatedTime", "UpdatedUserInfoId", "UserAuthId", "UserId", "Weight", "WorkExperience", "WorkSeniority", "WxmpOpenId" },
                values: new object[] { new Guid("11111111-1111-1111-1111-111111111112"), null, new DateTimeOffset(new DateTime(2000, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, null, false, null, 999, null, 0, null, 100, null, null, null, new Guid("11111111-1111-1111-1111-111111111111"), null, null, null, null });
                columns: new[] { "Id", "CityId", "CreatedTime", "CreatedUserInfoId", "EducationalBackgroundId", "EnterpriseId", "FreeTime", "Height", "IsDeleted", "JobSeekingStatus", "Level", "PersonalIdentityId", "Sort", "TraceId", "Type", "UpdatedTime", "UpdatedUserInfoId", "UserAuthId", "Weight", "WorkExperience", "WorkSeniority", "WxmpOpenId" },
                values: new object[] { new Guid("11111111-1111-1111-1111-111111111112"), null, new DateTimeOffset(new DateTime(2000, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, null, false, null, 999, null, 0, null, 100, null, null, new Guid("11111111-1111-1111-1111-111111111111"), null, null, null, null });

            migrationBuilder.CreateIndex(
                name: "IX_Department_EnterpriseId",
@@ -900,13 +905,13 @@
                column: "RoleId");

            migrationBuilder.CreateIndex(
                name: "IX_RoleWebApi_MenuId",
                table: "RoleWebApi",
                name: "IX_RoleResource_MenuId",
                table: "RoleResource",
                column: "MenuId");

            migrationBuilder.CreateIndex(
                name: "IX_RoleWebApi_RoleId",
                table: "RoleWebApi",
                name: "IX_RoleResource_RoleId",
                table: "RoleResource",
                column: "RoleId");

            migrationBuilder.CreateIndex(
@@ -1064,10 +1069,13 @@
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "Resource");

            migrationBuilder.DropTable(
                name: "RoleMenu");

            migrationBuilder.DropTable(
                name: "RoleWebApi");
                name: "RoleResource");

            migrationBuilder.DropTable(
                name: "TaskInfoBenefit");
@@ -1095,9 +1103,6 @@

            migrationBuilder.DropTable(
                name: "UserInfoRole");

            migrationBuilder.DropTable(
                name: "WebApi");

            migrationBuilder.DropTable(
                name: "Menu");