Scaffolding not accurate

[RonaldGHempel]

The issue

When scaffolding an existing database, there are some issues with the generated classes.

1. Columns marked as NOT NULL are generated as optional members.
2. Unique index spreading over serveral columns isn't marked as unique. See index RDB$19 down below, which is not marked as IsUnique()

Steps to reproduce

Table definition

id (D_ID) INTEGER Not Null
Stelle (D_ID) INTEGER Not Null
Art (D_ErlaeuterungsArt) SMALLINT Not Null
check (value >= 0)
Nummer1 (D_Nummer) SMALLINT Not Null
check (value >= -1)
Nummer2 (D_Nummer) SMALLINT Not Null
check (value >= -1)
Nummer3 SMALLINT Nullable
Txt1 (D_ID) INTEGER Not Null
Txt2 (D_ID) INTEGER Not Null
Txt3 INTEGER Nullable
Anzahl_Init (D_Anzahl_Stelle_Positiv) DECIMAL(10, 2) Not Null default 0
check (value >= 0)
Wegfall DATE Nullable
Ersatzplanstelle (D_JaNein) CHAR(1) Not Null
check (value in ('J','N'))
Status SMALLINT Not Null
CONSTRAINT FK_Erlaeuterungen_Stelle:
Foreign key (Stelle) References Stelle (id) On Delete Cascade
CONSTRAINT FK_Erlaeuterungen_TexteEbene1:
Foreign key (Txt1) References TexteEbene1 (id)
CONSTRAINT FK_Erlaeuterungen_TexteEbene2:
Foreign key (Txt2) References TexteEbene2 (id)
CONSTRAINT FK_Erlaeuterungen_TexteEbene3:
Foreign key (Txt3) References TexteEbene3 (id)
CONSTRAINT PK_Erlaeuterungen:
Primary key (id)
CONSTRAINT INTEG_37:
Unique key (Stelle, Art, Nummer1, Nummer2, Nummer3)

Triggers on Table Erlaeuterungen:
Erlaeuterungen_Before, Sequence: 0, Type: BEFORE INSERT OR UPDATE, Active

Generated model

classpublic void Configure(EntityTypeBuilder builder)
{
builder.ToTable("Erlaeuterungen ");

        builder.HasIndex(e => e.Art)
            .HasName("IDXErlaeuterungen_Art")
            .IsUnique();

        builder.HasIndex(e => e.Id)
            .HasName("PK_Erlaeuterungen");

        builder.HasIndex(e => e.Stelle)
            .HasName("FK_Erlaeuterungen_Stelle")
            .IsUnique();

        builder.HasIndex(e => e.Txt1)
            .HasName("FK_Erlaeuterungen_TexteEbene1")
            .IsUnique();

        builder.HasIndex(e => e.Txt2)
            .HasName("FK_Erlaeuterungen_TexteEbene2")
            .IsUnique();

        builder.HasIndex(e => e.Txt3)
            .HasName("FK_Erlaeuterungen_TexteEbene3")
            .IsUnique();

        builder.HasIndex(e => new { e.Art, e.Nummer1, e.Nummer2, e.Nummer3, e.Stelle })
            .HasName("RDB$19");

        builder.Property(e => e.Id).HasColumnName("id");

        builder.Property(e => e.AnzahlInit)
            .HasColumnName("Anzahl_Init")
            .HasColumnType("DECIMAL(10, 2)")
            .HasDefaultValueSql("default 0");

        builder.Property(e => e.Ersatzplanstelle).HasColumnType("CHAR(1) CHARACTER SET UTF8");

        builder.Property(e => e.Wegfall).HasColumnType("DATE");
    }:

Model information:

public partial class Erlaeuterungen
{
public int Id { get; set; }
public int? Stelle { get; set; }
public short? Art { get; set; }
public short? Nummer1 { get; set; }
public short? Nummer2 { get; set; }
public short? Nummer3 { get; set; }
public int? Txt1 { get; set; }
public int? Txt2 { get; set; }
public int? Txt3 { get; set; }
public decimal? AnzahlInit { get; set; }
public DateTime? Wegfall { get; set; }
public string Ersatzplanstelle { get; set; }
public short Status { get; set; }
}

Error details

See for example properties Stelle and Art, which are marked as optional within the model.
See index RDB$19 which is not marked as unique.

Further technical details

Firebird version: ISQL Version: WI-V3.0.3.32900 Firebird 3.0

Other details about my project setup: