FluentMigrator migrations, drawn as a database diagram

using FluentMigrator;

namespace Migrations;

[Migration(20240101000002)]
public class CreateVets : Migration
{
    public override void Up()
    {
        Create.Table("vets")
            .WithColumn("id").AsInt32().NotNullable().PrimaryKey("pk_vets")
            .WithColumn("first_name").AsString(50).NotNullable()
            .WithColumn("last_name").AsString(50).NotNullable();

        Create.Table("specialties")
            .WithColumn("id").AsInt32().NotNullable().PrimaryKey("pk_specialties")
            .WithColumn("name").AsString(80).NotNullable();

        // The composite key and both foreign keys are declared inside the table rather than added
        // afterwards. SQLite cannot add either to a table that already exists, and FluentMigrator
        // does not refuse in advance - it writes the ALTER TABLE and hands back SQLite's complaint.
        // Named inline, the two columns make one composite key, and every engine takes it.
        Create.Table("vet_specialties")
            .WithColumn("vet_id").AsInt32().NotNullable().PrimaryKey("pk_vet_specialties")
                .ForeignKey("fk_vet_specialties_vets", "vets", "id")
            .WithColumn("specialty_id").AsInt32().NotNullable().PrimaryKey("pk_vet_specialties")
                .ForeignKey("fk_vet_specialties_specialties", "specialties", "id");
    }

    public override void Down()
    {
        Delete.Table("vet_specialties");
        Delete.Table("specialties");
        Delete.Table("vets");
    }
}

using FluentMigrator;

namespace Migrations;

[Migration(20240101000003)]
public class CreateVisits : Migration
{
    public override void Up()
    {
        Create.Table("visits")
            .WithColumn("id").AsInt32().NotNullable().PrimaryKey("pk_visits")
            .WithColumn("pet_id").AsInt32().NotNullable().ForeignKey("fk_visits_pets", "pets", "id")
            .WithColumn("visit_date").AsDate().Nullable()
            .WithColumn("description").AsString(255).Nullable();
    }

    public override void Down()
    {
        Delete.Table("visits");
    }
}