I've created a custom table using this umbraco guide: https://docs.umbraco.com/umbraco-cms/extending/database The table now works. But I can't set a foreign key with the migration. Can someone help me with setting the StatusId as foreign key reference? The following code is the same but I've anonymize the tablenames etc.

C#
protected override void Migrate()
{
    Logger.LogDebug("Running migration {MigrationStep}", "AddCarTable");

    if (TableExists("Cars") == false)
    {
        Create.Table<CarStatusSchema>().Do();
        Create.Table<CarSchema>().Do();
    }
    else
    {
        Logger.LogDebug("The database table {DbTable} already exists, skipping", "Cars");
    }
}

[TableName("Cars")]
[PrimaryKey("Id", AutoIncrement = true)]
[ExplicitColumns]
public class CarSchema
{
    [PrimaryKeyColumn(AutoIncrement = true, IdentitySeed = 1)]
    [Column("Id")]
    public int Id { get; set; }

    [Column("Model")]
    public required string Model { get; set; }

    [Column("CarStatusId")]
    public required int CarStatusId { get; set; }
}

[TableName("CarStatus")]
[PrimaryKey("Id", AutoIncrement = true)]
public class CarStatusSchema
{
    [PrimaryKeyColumn(AutoIncrement = true, IdentitySeed = 1)]
    [Column("Id")]
    public int Id { get; set; }

    [Column("Status")]
    public string Status { get; set; }
}

I've also tried to add this reference (code below) but it also didn't work. (I can try to recreate the error if it helps)

C#
[References(typeof(CarStatusSchema))]
    [Column("Status")]
    public CarStatusSchema StatusReference { get; set; }