Entity Framework Core 创建表一对一，表之间外键【约束】

 entityBuilder.HasOne(m => m.ManageRole)
                         .WithOne()
                         .HasForeignKey<UserRoleMapping>(m => m.ManageRoleId)
                         .HasPrincipalKey<ManageRole>(r => r.Id);

将会生成如下表结构

CREATE TABLE [dbo].[FxkUserRoleMpping] (
    [Id]              INT           IDENTITY (1, 1) NOT NULL,
    [BanForumTimeEnd] DATETIME2 (7) NOT NULL,
    [BanStoreTimeEnd] DATETIME2 (7) NOT NULL,
    [CustomerId]      INT           NOT NULL,
    [ManageRoleId]    INT           NOT NULL,
    [StoreRoleId]     INT           NOT NULL,
    CONSTRAINT [PK_FxkUserRoleMpping] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_FxkUserRoleMpping_FxkManageRole_ManageRoleId] FOREIGN KEY ([ManageRoleId]) REFERENCES [dbo].[FxkManageRole] ([Id]) ON DELETE CASCADE,
    CONSTRAINT [FK_FxkUserRoleMpping_FxkStoreRole_StoreRoleId] FOREIGN KEY ([StoreRoleId]) REFERENCES [dbo].[FxkStoreRole] ([Id]) ON DELETE CASCADE
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_FxkUserRoleMpping_ManageRoleId]
    ON [dbo].[FxkUserRoleMpping]([ManageRoleId] ASC);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_FxkUserRoleMpping_StoreRoleId]
    ON [dbo].[FxkUserRoleMpping]([StoreRoleId] ASC);