modelBuilder
                .HasDefaultSchema("public")
                .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn)
                .HasAnnotation("ProductVersion", "3.1.6")
                .HasAnnotation("Relational:MaxIdentifierLength", 63);

            modelBuilder.Entity("BO4E.BO.Ansprechpartner", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<Guid?>("AdresseGuid")
                        .HasColumnType("uuid");

                    b.Property<int?>("Anrede")
                        .HasColumnType("integer");

                    b.Property<string>("BoTyp")
                        .HasColumnType("text");

                    b.Property<string>("EMailAdresse")
                        .HasColumnType("text");

                    b.Property<Guid?>("GeschaeftspartnerGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("IndividuelleAnrede")
                        .HasColumnType("text");

                    b.Property<string>("Kommentar")
                        .HasColumnType("text");

                    b.Property<string>("Nachname")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<int?>("Titel")
                        .HasColumnType("integer");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<int>("VersionStruktur")
                        .HasColumnType("integer");

                    b.Property<string>("Vorname")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.HasIndex("AdresseGuid");

                    b.HasIndex("GeschaeftspartnerGuid");

                    b.ToTable("Ansprechpartner");
                });

            modelBuilder.Entity("BO4E.BO.Geschaeftspartner", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Amtsgericht")
                        .HasColumnType("text");

                    b.Property<int?>("Anrede")
                        .HasColumnType("integer");

                    b.Property<string>("BoTyp")
                        .HasColumnType("text");

                    b.Property<string>("EMailAdresse")
                        .HasColumnType("text");

                    b.Property<List<string>>("Geschaeftspartnerrolle")
                        .HasColumnType("text[]");

                    b.Property<bool>("Gewerbekennzeichnung")
                        .HasColumnType("boolean");

                    b.Property<string>("GlaeubigerId")
                        .HasColumnType("text");

                    b.Property<string>("Hrnummer")
                        .HasColumnType("text");

                    b.Property<List<string>>("Kontaktweg")
                        .HasColumnType("text[]");

                    b.Property<string>("Name1")
                        .HasColumnType("text");

                    b.Property<string>("Name2")
                        .HasColumnType("text");

                    b.Property<string>("Name3")
                        .HasColumnType("text");

                    b.Property<Guid?>("PartneradresseGuid")
                        .HasColumnType("uuid");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("Title")
                        .HasColumnType("text");

                    b.Property<string>("UmsatzsteuerId")
                        .HasColumnType("text");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<int>("VersionStruktur")
                        .HasColumnType("integer");

                    b.Property<string>("Website")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.HasIndex("PartneradresseGuid");

                    b.ToTable("Geschaeftspartner");
                });

            modelBuilder.Entity("BO4E.BO.Marktlokation", b =>
                {
                    b.Property<string>("MarktlokationsId")
                        .HasColumnType("text");

                    b.Property<string>("Bilanzierungsgebiet")
                        .HasColumnType("text");

                    b.Property<int>("Bilanzierungsmethode")
                        .HasColumnType("integer");

                    b.Property<string>("BoTyp")
                        .HasColumnType("text");

                    b.Property<Guid?>("EndkundeGuid")
                        .HasColumnType("uuid");

                    b.Property<int>("Energierichtung")
                        .HasColumnType("integer");

                    b.Property<int?>("Gasqualitaet")
                        .HasColumnType("integer");

                    b.Property<int?>("GebietType")
                        .HasColumnType("integer");

                    b.Property<Guid?>("GeoadresseGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("GrundversorgerCodeNr")
                        .HasColumnType("text");

                    b.Property<Guid?>("Guid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("KatasterinformationGuid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("LokationsadresseGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("Marktgebiet")
                        .HasColumnType("text");

                    b.Property<string>("NetzbetreiberCodeNr")
                        .HasColumnType("text");

                    b.Property<int>("Netzebene")
                        .HasColumnType("integer");

                    b.Property<string>("NetzgebietNr")
                        .HasColumnType("text");

                    b.Property<string>("Regelzone")
                        .HasColumnType("text");

                    b.Property<int>("Sparte")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<bool?>("Unterbrechbar")
                        .HasColumnType("boolean");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<int?>("Verbrauchsart")
                        .HasColumnType("integer");

                    b.Property<int>("VersionStruktur")
                        .HasColumnType("integer");

                    b.Property<int?>("Zeitreihentyp")
                        .HasColumnType("integer");

                    b.HasKey("MarktlokationsId");

                    b.HasIndex("EndkundeGuid");

                    b.HasIndex("GeoadresseGuid");

                    b.HasIndex("KatasterinformationGuid");

                    b.HasIndex("LokationsadresseGuid");

                    b.ToTable("Marktlokation");
                });

            modelBuilder.Entity("BO4E.BO.Messlokation", b =>
                {
                    b.Property<string>("MesslokationsId")
                        .HasColumnType("text");

                    b.Property<bool?>("Abrechnungmessstellenbetriebnna")
                        .HasColumnType("boolean");

                    b.Property<int?>("Bilanzierungsmethode")
                        .HasColumnType("integer");

                    b.Property<string>("BoTyp")
                        .HasColumnType("text");

                    b.Property<int?>("Gasqualitaet")
                        .HasColumnType("integer");

                    b.Property<Guid?>("GeoadresseGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("GrundzustaendigerMDLCodeNr")
                        .HasColumnType("text");

                    b.Property<string>("GrundzustaendigerMSBCodeNr")
                        .HasColumnType("text");

                    b.Property<string>("GrundzustaendigerMSBIMCodeNr")
                        .HasColumnType("text");

                    b.Property<Guid?>("Guid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("KatasterinformationGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("MarktlokationsId")
                        .HasColumnType("text");

                    b.Property<Guid?>("MessadresseGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("MessgebietNr")
                        .HasColumnType("text");

                    b.Property<int?>("NetzebeneMessung")
                        .HasColumnType("integer");

                    b.Property<int>("Sparte")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<decimal?>("Verlustfaktor")
                        .HasColumnType("numeric");

                    b.Property<int>("VersionStruktur")
                        .HasColumnType("integer");

                    b.HasKey("MesslokationsId");

                    b.HasIndex("GeoadresseGuid");

                    b.HasIndex("KatasterinformationGuid");

                    b.HasIndex("MarktlokationsId");

                    b.HasIndex("MessadresseGuid");

                    b.ToTable("Messlokation");
                });

            modelBuilder.Entity("BO4E.BO.Vertrag", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Beschreibung")
                        .HasColumnType("text");

                    b.Property<string>("BoTyp")
                        .HasColumnType("text");

                    b.Property<decimal?>("Gemeinderabatt")
                        .HasColumnType("numeric");

                    b.Property<Guid?>("KorrespondenzpartnerGuid")
                        .HasColumnType("uuid");

                    b.Property<int>("Sparte")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<int>("VersionStruktur")
                        .HasColumnType("integer");

                    b.Property<int>("Vertragsart")
                        .HasColumnType("integer");

                    b.Property<DateTimeOffset>("Vertragsbeginn")
                        .HasColumnType("timestamp with time zone");

                    b.Property<DateTimeOffset>("Vertragsende")
                        .HasColumnType("timestamp with time zone");

                    b.Property<Guid?>("VertragskonditionenGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("Vertragsnummer")
                        .HasColumnType("text");

                    b.Property<Guid?>("Vertragspartner1Guid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("Vertragspartner2Guid")
                        .HasColumnType("uuid");

                    b.Property<int>("Vertragstatus")
                        .HasColumnType("integer");

                    b.HasKey("Guid");

                    b.HasIndex("KorrespondenzpartnerGuid");

                    b.HasIndex("VertragskonditionenGuid");

                    b.HasIndex("Vertragspartner1Guid");

                    b.HasIndex("Vertragspartner2Guid");

                    b.ToTable("Vertrag");
                });

            modelBuilder.Entity("BO4E.BO.Zaehler", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("BoTyp")
                        .HasColumnType("text");

                    b.Property<DateTimeOffset?>("EichungBis")
                        .HasColumnType("timestamp with time zone");

                    b.Property<int?>("Fernschaltung")
                        .HasColumnType("integer");

                    b.Property<string>("Gateway")
                        .HasColumnType("text");

                    b.Property<DateTimeOffset?>("LetzteEichung")
                        .HasColumnType("timestamp with time zone");

                    b.Property<string>("MesslokationsId")
                        .HasColumnType("text");

                    b.Property<int?>("Messwerterfassung")
                        .HasColumnType("integer");

                    b.Property<int>("Sparte")
                        .HasColumnType("integer");

                    b.Property<int>("Tarifart")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<int>("VersionStruktur")
                        .HasColumnType("integer");

                    b.Property<int>("Zaehlerauspraegung")
                        .HasColumnType("integer");

                    b.Property<Guid?>("ZaehlerherstellerGuid")
                        .HasColumnType("uuid");

                    b.Property<decimal>("Zaehlerkonstante")
                        .HasColumnType("numeric");

                    b.Property<string>("Zaehlernummer")
                        .HasColumnType("text");

                    b.Property<int?>("Zaehlertyp")
                        .HasColumnType("integer");

                    b.HasKey("Guid");

                    b.HasIndex("MesslokationsId");

                    b.HasIndex("ZaehlerherstellerGuid");

                    b.HasIndex("Zaehlernummer");

                    b.ToTable("Zaehler");
                });

            modelBuilder.Entity("BO4E.COM.Adresse", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Adresszusatz")
                        .HasColumnType("text");

                    b.Property<string>("CoErgaenzung")
                        .HasColumnType("text");

                    b.Property<string>("Hausnummer")
                        .HasColumnType("text");

                    b.Property<int?>("Landescode")
                        .HasColumnType("integer");

                    b.Property<string>("Ort")
                        .HasColumnType("text");

                    b.Property<string>("Postfach")
                        .HasColumnType("text");

                    b.Property<string>("Postleitzahl")
                        .HasColumnType("text");

                    b.Property<string>("Strasse")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.ToTable("bo4e_adresse");
                });

            modelBuilder.Entity("BO4E.COM.Dienstleistung", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Bezeichnung")
                        .HasColumnType("text");

                    b.Property<int>("Dienstleistungstyp")
                        .HasColumnType("integer");

                    b.Property<string>("MesslokationsId")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.HasIndex("MesslokationsId");

                    b.ToTable("Dienstleistung");
                });

            modelBuilder.Entity("BO4E.COM.ExterneReferenz", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<Guid?>("AnsprechpartnerGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("ExRefName")
                        .HasColumnType("text");

                    b.Property<string>("ExRefWert")
                        .HasColumnType("text");

                    b.Property<Guid?>("GeschaeftspartnerGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("MarktlokationsId")
                        .HasColumnType("text");

                    b.Property<string>("MesslokationsId")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<Guid?>("VertragGuid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("ZaehlerGuid")
                        .HasColumnType("uuid");

                    b.HasKey("Guid");

                    b.HasIndex("AnsprechpartnerGuid");

                    b.HasIndex("GeschaeftspartnerGuid");

                    b.HasIndex("MarktlokationsId");

                    b.HasIndex("MesslokationsId");

                    b.HasIndex("VertragGuid");

                    b.HasIndex("ZaehlerGuid");

                    b.ToTable("ExterneReferenz");
                });

            modelBuilder.Entity("BO4E.COM.Geokoordinaten", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<decimal>("Breitengrad")
                        .HasColumnType("numeric");

                    b.Property<decimal>("Laengengrad")
                        .HasColumnType("numeric");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.ToTable("Geokoordinaten");
                });

            modelBuilder.Entity("BO4E.COM.Geraeteeigenschaften", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<int?>("Geraetemerkmal")
                        .HasColumnType("integer");

                    b.Property<int>("Geraetetyp")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.ToTable("Geraeteeigenschaften");
                });

            modelBuilder.Entity("BO4E.COM.Hardware", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Bezeichnung")
                        .HasColumnType("text");

                    b.Property<Guid?>("GeraeteeigenschaftenGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("Geraetenummer")
                        .HasColumnType("text");

                    b.Property<string>("Geraetereferenz")
                        .HasColumnType("text");

                    b.Property<int>("Geraetetyp")
                        .HasColumnType("integer");

                    b.Property<string>("MesslokationsId")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.HasIndex("GeraeteeigenschaftenGuid");

                    b.HasIndex("MesslokationsId");

                    b.ToTable("Hardware");
                });

            modelBuilder.Entity("BO4E.COM.Katasteradresse", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Flurstueck")
                        .HasColumnType("text");

                    b.Property<string>("Gemarkung_flur")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.ToTable("Katasteradresse");
                });

            modelBuilder.Entity("BO4E.COM.Konzessionsabgabe", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Kategorie")
                        .HasColumnType("text");

                    b.Property<decimal>("Kosten")
                        .HasColumnType("numeric");

                    b.Property<int>("Satz")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.ToTable("Konzessionsabgabe");
                });

            modelBuilder.Entity("BO4E.COM.MarktpartnerDetails", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Code")
                        .HasColumnType("text");

                    b.Property<string>("MarktlokationsId")
                        .HasColumnType("text");

                    b.Property<string>("MesslokationsId")
                        .HasColumnType("text");

                    b.Property<string>("Rollencodenummer")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<int>("marktrolle")
                        .HasColumnType("integer");

                    b.HasKey("Guid");

                    b.HasIndex("MarktlokationsId");

                    b.HasIndex("MesslokationsId");

                    b.ToTable("MarktpartnerDetails");
                });

            modelBuilder.Entity("BO4E.COM.Menge", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<int>("Einheit")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<decimal>("Wert")
                        .HasColumnType("numeric");

                    b.HasKey("Guid");

                    b.ToTable("Menge");
                });

            modelBuilder.Entity("BO4E.COM.Messlokationszuordnung", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<int?>("Arithmetik")
                        .HasColumnType("integer");

                    b.Property<DateTimeOffset?>("GueltigBis")
                        .HasColumnType("timestamp with time zone");

                    b.Property<DateTimeOffset?>("GueltigSeit")
                        .HasColumnType("timestamp with time zone");

                    b.Property<string>("MarktlokationsId")
                        .HasColumnType("text");

                    b.Property<string>("MesslokationsId")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.HasIndex("MarktlokationsId");

                    b.ToTable("Messlokationszuordnung");
                });

            modelBuilder.Entity("BO4E.COM.PhysikalischerWert", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<int>("Einheit")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<decimal>("Wert")
                        .HasColumnType("numeric");

                    b.HasKey("Guid");

                    b.ToTable("PhysikalischerWert");
                });

            modelBuilder.Entity("BO4E.COM.Rufnummer", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<Guid?>("AnsprechpartnerGuid")
                        .HasColumnType("uuid");

                    b.Property<int>("Nummerntyp")
                        .HasColumnType("integer");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<string>("rufnummer")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.HasIndex("AnsprechpartnerGuid");

                    b.ToTable("Rufnummer");
                });

            modelBuilder.Entity("BO4E.COM.Unterschrift", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<DateTimeOffset?>("Datum")
                        .HasColumnType("timestamp with time zone");

                    b.Property<string>("Name")
                        .HasColumnType("text");

                    b.Property<string>("Ort")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<Guid?>("VertragGuid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("VertragGuid1")
                        .HasColumnType("uuid");

                    b.HasKey("Guid");

                    b.HasIndex("VertragGuid");

                    b.HasIndex("VertragGuid1");

                    b.ToTable("Unterschrift");
                });

            modelBuilder.Entity("BO4E.COM.Verbrauch", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<int>("Einheit")
                        .HasColumnType("integer");

                    b.Property<DateTime>("Enddatum")
                        .HasColumnType("timestamp without time zone");

                    b.Property<string>("MarktlokationsId")
                        .HasColumnType("text");

                    b.Property<string>("Obiskennzahl")
                        .HasColumnType("text");

                    b.Property<DateTime>("Startdatum")
                        .HasColumnType("timestamp without time zone");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<int?>("Type")
                        .HasColumnType("integer");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<decimal>("Wert")
                        .HasColumnType("numeric");

                    b.Property<int>("Wertermittlungsverfahren")
                        .HasColumnType("integer");

                    b.HasKey("Guid");

                    b.HasIndex("MarktlokationsId");

                    b.ToTable("Verbrauch");
                });

            modelBuilder.Entity("BO4E.COM.Vertragskonditionen", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<Guid?>("AbschlagszyklusGuid")
                        .HasColumnType("uuid");

                    b.Property<int?>("AnzahlAbschlaege")
                        .HasColumnType("integer");

                    b.Property<string>("Beschreibung")
                        .HasColumnType("text");

                    b.Property<Guid?>("GeplanteTurnusablesungGuid")
                        .HasColumnType("uuid");

                    b.Property<bool?>("Haushaltskunde")
                        .HasColumnType("boolean");

                    b.Property<Guid?>("KuendigungsfristGuid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("NetznutzungsabrechnungGuid")
                        .HasColumnType("uuid");

                    b.Property<int?>("NetznutzungsabrechnungIntervall")
                        .HasColumnType("integer");

                    b.Property<int?>("Netznutzungsabrechnungsgrundlage")
                        .HasColumnType("integer");

                    b.Property<int?>("Netznutzungsabrechnungsvariante")
                        .HasColumnType("integer");

                    b.Property<int?>("Netznutzungsvertrag")
                        .HasColumnType("integer");

                    b.Property<int?>("Netznutzungszahler")
                        .HasColumnType("integer");

                    b.Property<DateTimeOffset?>("StartAbrechnungsjahr")
                        .HasColumnType("timestamp with time zone");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<int?>("TurnusablesungIntervall")
                        .HasColumnType("integer");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<Guid?>("VertragslaufzeitGuid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("VertragsverlaengerungGuid")
                        .HasColumnType("uuid");

                    b.HasKey("Guid");

                    b.HasIndex("AbschlagszyklusGuid");

                    b.HasIndex("GeplanteTurnusablesungGuid");

                    b.HasIndex("KuendigungsfristGuid");

                    b.HasIndex("NetznutzungsabrechnungGuid");

                    b.HasIndex("VertragslaufzeitGuid");

                    b.HasIndex("VertragsverlaengerungGuid");

                    b.ToTable("Vertragskonditionen");
                });

            modelBuilder.Entity("BO4E.COM.Vertragsteil", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<Guid?>("JahresverbrauchsprognoseGuid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("KundenwertGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("Lokation")
                        .HasColumnType("text");

                    b.Property<Guid?>("MaximaleAbnahmemengeGuid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("MinimaleAbnahmemengeGuid")
                        .HasColumnType("uuid");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<string>("Verbrauchsaufteilung")
                        .HasColumnType("text");

                    b.Property<Guid?>("VertragGuid")
                        .HasColumnType("uuid");

                    b.Property<Guid?>("VertraglichFixierteMengeGuid")
                        .HasColumnType("uuid");

                    b.Property<DateTimeOffset>("Vertragsteilbeginn")
                        .HasColumnType("timestamp with time zone");

                    b.Property<DateTimeOffset>("Vertragsteilende")
                        .HasColumnType("timestamp with time zone");

                    b.HasKey("Guid");

                    b.HasIndex("JahresverbrauchsprognoseGuid");

                    b.HasIndex("KundenwertGuid");

                    b.HasIndex("MaximaleAbnahmemengeGuid");

                    b.HasIndex("MinimaleAbnahmemengeGuid");

                    b.HasIndex("VertragGuid");

                    b.HasIndex("VertraglichFixierteMengeGuid");

                    b.ToTable("Vertragsteil");
                });

            modelBuilder.Entity("BO4E.COM.Zaehlwerk", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<bool?>("Abrechnungsrelevant")
                        .HasColumnType("boolean");

                    b.Property<string>("Bezeichnung")
                        .HasColumnType("text");

                    b.Property<int>("Einheit")
                        .HasColumnType("integer");

                    b.Property<string>("Kennzahl")
                        .HasColumnType("text");

                    b.Property<Guid?>("KonzessionsabgabeGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("MarktlokationsId")
                        .HasColumnType("text");

                    b.Property<int?>("Nachkommastelle")
                        .HasColumnType("integer");

                    b.Property<string>("ObisKennzahl")
                        .HasColumnType("text");

                    b.Property<int>("Richtung")
                        .HasColumnType("integer");

                    b.Property<int?>("Schwachlastfaehig")
                        .HasColumnType("integer");

                    b.Property<bool?>("Steuerbefreit")
                        .HasColumnType("boolean");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<int?>("Unterbrechbarkeit")
                        .HasColumnType("integer");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.Property<int?>("Verbrauchsart")
                        .HasColumnType("integer");

                    b.Property<List<string>>("Verwendungszwecke")
                        .HasColumnType("text[]");

                    b.Property<int?>("Vorkommastelle")
                        .HasColumnType("integer");

                    b.Property<int?>("Waermenutzung")
                        .HasColumnType("integer");

                    b.Property<decimal>("Wandlerfaktor")
                        .HasColumnType("numeric");

                    b.Property<Guid?>("ZaehlerGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("ZaehlwerkId")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.HasIndex("KonzessionsabgabeGuid");

                    b.HasIndex("MarktlokationsId");

                    b.HasIndex("ZaehlerGuid");

                    b.ToTable("Zaehlwerk");
                });

            modelBuilder.Entity("BO4E.COM.Zeitraum", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<decimal?>("Dauer")
                        .HasColumnType("numeric");

                    b.Property<int?>("Einheit")
                        .HasColumnType("integer");

                    b.Property<DateTimeOffset?>("Enddatum")
                        .HasColumnType("timestamp with time zone");

                    b.Property<DateTimeOffset?>("Startdatum")
                        .HasColumnType("timestamp with time zone");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.ToTable("Zeitraum");
                });

            modelBuilder.Entity("BO4E.COM.Zustaendigkeit", b =>
                {
                    b.Property<Guid?>("Guid")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("Abteilung")
                        .HasColumnType("text");

                    b.Property<Guid?>("AnsprechpartnerGuid")
                        .HasColumnType("uuid");

                    b.Property<string>("Jobtitel")
                        .HasColumnType("text");

                    b.Property<string>("Themengebiet")
                        .HasColumnType("text");

                    b.Property<DateTime?>("Timestamp")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("timestamp without time zone")
                        .HasDefaultValueSql("NOW()");

                    b.Property<string>("UserProperties")
                        .HasColumnType("text");

                    b.HasKey("Guid");

                    b.HasIndex("AnsprechpartnerGuid");

                    b.ToTable("Zustaendigkeit");
                });

            modelBuilder.Entity("TechnicalMasterData.Model.DomainModel.Ids.ZaehlerId", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<string>("IdAsStringPrefix")
                        .HasColumnType("text");

                    b.HasKey("Id");

                    b.ToTable("ZaehlerId");
                });

            modelBuilder.Entity("TechnicalMasterData.Model.ReadModel.Database.EF.Geraet", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uuid");

                    b.Property<Guid?>("BoModelGuid")
                        .HasColumnType("uuid");

                    b.Property<DateTimeOffset>("DatumErzeugt")
                        .HasColumnType("timestamp with time zone");

                    b.Property<DateTimeOffset>("DatumGeaendert")
                        .HasColumnType("timestamp with time zone");

                    b.Property<string>("ExterneId")
                        .HasColumnType("text");

                    b.Property<Guid?>("ZaehlerIdId")
                        .HasColumnType("uuid");

                    b.HasKey("Id");

                    b.HasIndex("BoModelGuid");

                    b.HasIndex("ExterneId")
                        .IsUnique();

                    b.HasIndex("ZaehlerIdId");

                    b.ToTable("Geraet");
                });

            modelBuilder.Entity("TechnicalMasterData.Model.ReadModel.Database.EF.Marktnachricht", b =>
                {
                    b.Property<string>("Id")
                        .HasColumnType("text");

                    b.Property<DateTimeOffset>("DatumErzeugt")
                        .HasColumnType("timestamp with time zone");

                    b.Property<DateTimeOffset>("DatumGeaendert")
                        .HasColumnType("timestamp with time zone");

                    b.Property<string>("ExterneId")
                        .HasColumnType("text");

                    b.Property<DateTimeOffset?>("ProzessDatum")
                        .HasColumnType("timestamp with time zone");

                    b.Property<string>("ProzessId")
                        .HasColumnType("text");

                    b.Property<int>("Typ")
                        .HasColumnType("integer");

                    b.HasKey("Id");

                    b.ToTable("Marktnachrichten");
                });

            modelBuilder.Entity("BO4E.BO.Ansprechpartner", b =>
                {
                    b.HasOne("BO4E.COM.Adresse", "Adresse")
                        .WithMany()
                        .HasForeignKey("AdresseGuid");

                    b.HasOne("BO4E.BO.Geschaeftspartner", "Geschaeftspartner")
                        .WithMany()
                        .HasForeignKey("GeschaeftspartnerGuid");
                });

            modelBuilder.Entity("BO4E.BO.Geschaeftspartner", b =>
                {
                    b.HasOne("BO4E.COM.Adresse", "Partneradresse")
                        .WithMany()
                        .HasForeignKey("PartneradresseGuid");
                });

            modelBuilder.Entity("BO4E.BO.Marktlokation", b =>
                {
                    b.HasOne("BO4E.BO.Geschaeftspartner", "Endkunde")
                        .WithMany()
                        .HasForeignKey("EndkundeGuid");

                    b.HasOne("BO4E.COM.Geokoordinaten", "Geoadresse")
                        .WithMany()
                        .HasForeignKey("GeoadresseGuid");

                    b.HasOne("BO4E.COM.Katasteradresse", "Katasterinformation")
                        .WithMany()
                        .HasForeignKey("KatasterinformationGuid");

                    b.HasOne("BO4E.COM.Adresse", "Lokationsadresse")
                        .WithMany()
                        .HasForeignKey("LokationsadresseGuid");
                });

            modelBuilder.Entity("BO4E.BO.Messlokation", b =>
                {
                    b.HasOne("BO4E.COM.Geokoordinaten", "Geoadresse")
                        .WithMany()
                        .HasForeignKey("GeoadresseGuid");

                    b.HasOne("BO4E.COM.Katasteradresse", "Katasterinformation")
                        .WithMany()
                        .HasForeignKey("KatasterinformationGuid");

                    b.HasOne("BO4E.BO.Marktlokation", null)
                        .WithMany("Messlokationen")
                        .HasForeignKey("MarktlokationsId");

                    b.HasOne("BO4E.COM.Adresse", "Messadresse")
                        .WithMany()
                        .HasForeignKey("MessadresseGuid");
                });

            modelBuilder.Entity("BO4E.BO.Vertrag", b =>
                {
                    b.HasOne("BO4E.BO.Geschaeftspartner", "Korrespondenzpartner")
                        .WithMany()
                        .HasForeignKey("KorrespondenzpartnerGuid");

                    b.HasOne("BO4E.COM.Vertragskonditionen", "Vertragskonditionen")
                        .WithMany()
                        .HasForeignKey("VertragskonditionenGuid");

                    b.HasOne("BO4E.BO.Geschaeftspartner", "Vertragspartner1")
                        .WithMany()
                        .HasForeignKey("Vertragspartner1Guid");

                    b.HasOne("BO4E.BO.Geschaeftspartner", "Vertragspartner2")
                        .WithMany()
                        .HasForeignKey("Vertragspartner2Guid");
                });

            modelBuilder.Entity("BO4E.BO.Zaehler", b =>
                {
                    b.HasOne("BO4E.BO.Messlokation", null)
                        .WithMany("Messlokationszaehler")
                        .HasForeignKey("MesslokationsId");

                    b.HasOne("BO4E.BO.Geschaeftspartner", "Zaehlerhersteller")
                        .WithMany()
                        .HasForeignKey("ZaehlerherstellerGuid");
                });

            modelBuilder.Entity("BO4E.COM.Dienstleistung", b =>
                {
                    b.HasOne("BO4E.BO.Messlokation", null)
                        .WithMany("Messdienstleistung")
                        .HasForeignKey("MesslokationsId");
                });

            modelBuilder.Entity("BO4E.COM.ExterneReferenz", b =>
                {
                    b.HasOne("BO4E.BO.Ansprechpartner", null)
                        .WithMany("ExterneReferenzen")
                        .HasForeignKey("AnsprechpartnerGuid");

                    b.HasOne("BO4E.BO.Geschaeftspartner", null)
                        .WithMany("ExterneReferenzen")
                        .HasForeignKey("GeschaeftspartnerGuid");

                    b.HasOne("BO4E.BO.Marktlokation", null)
                        .WithMany("ExterneReferenzen")
                        .HasForeignKey("MarktlokationsId");

                    b.HasOne("BO4E.BO.Messlokation", null)
                        .WithMany("ExterneReferenzen")
                        .HasForeignKey("MesslokationsId");

                    b.HasOne("BO4E.BO.Vertrag", null)
                        .WithMany("ExterneReferenzen")
                        .HasForeignKey("VertragGuid");

                    b.HasOne("BO4E.BO.Zaehler", null)
                        .WithMany("ExterneReferenzen")
                        .HasForeignKey("ZaehlerGuid");
                });

            modelBuilder.Entity("BO4E.COM.Hardware", b =>
                {
                    b.HasOne("BO4E.COM.Geraeteeigenschaften", "Geraeteeigenschaften")
                        .WithMany()
                        .HasForeignKey("GeraeteeigenschaftenGuid");

                    b.HasOne("BO4E.BO.Messlokation", null)
                        .WithMany("Geraete")
                        .HasForeignKey("MesslokationsId");
                });

            modelBuilder.Entity("BO4E.COM.MarktpartnerDetails", b =>
                {
                    b.HasOne("BO4E.BO.Marktlokation", null)
                        .WithMany("Marktrollen")
                        .HasForeignKey("MarktlokationsId");

                    b.HasOne("BO4E.BO.Messlokation", null)
                        .WithMany("Marktrollen")
                        .HasForeignKey("MesslokationsId");
                });

            modelBuilder.Entity("BO4E.COM.Messlokationszuordnung", b =>
                {
                    b.HasOne("BO4E.BO.Marktlokation", null)
                        .WithMany("ZugehoerigeMesslokationen")
                        .HasForeignKey("MarktlokationsId");
                });

            modelBuilder.Entity("BO4E.COM.Rufnummer", b =>
                {
                    b.HasOne("BO4E.BO.Ansprechpartner", null)
                        .WithMany("Rufnummern")
                        .HasForeignKey("AnsprechpartnerGuid");
                });

            modelBuilder.Entity("BO4E.COM.Unterschrift", b =>
                {
                    b.HasOne("BO4E.BO.Vertrag", null)
                        .WithMany("Unterzeichnervp1")
                        .HasForeignKey("VertragGuid");

                    b.HasOne("BO4E.BO.Vertrag", null)
                        .WithMany("Unterzeichnervp2")
                        .HasForeignKey("VertragGuid1");
                });

            modelBuilder.Entity("BO4E.COM.Verbrauch", b =>
                {
                    b.HasOne("BO4E.BO.Marktlokation", null)
                        .WithMany("Verbrauchsmenge")
                        .HasForeignKey("MarktlokationsId");
                });

            modelBuilder.Entity("BO4E.COM.Vertragskonditionen", b =>
                {
                    b.HasOne("BO4E.COM.Zeitraum", "Abschlagszyklus")
                        .WithMany()
                        .HasForeignKey("AbschlagszyklusGuid");

                    b.HasOne("BO4E.COM.Zeitraum", "GeplanteTurnusablesung")
                        .WithMany()
                        .HasForeignKey("GeplanteTurnusablesungGuid");

                    b.HasOne("BO4E.COM.Zeitraum", "Kuendigungsfrist")
                        .WithMany()
                        .HasForeignKey("KuendigungsfristGuid");

                    b.HasOne("BO4E.COM.Zeitraum", "Netznutzungsabrechnung")
                        .WithMany()
                        .HasForeignKey("NetznutzungsabrechnungGuid");

                    b.HasOne("BO4E.COM.Zeitraum", "Vertragslaufzeit")
                        .WithMany()
                        .HasForeignKey("VertragslaufzeitGuid");

                    b.HasOne("BO4E.COM.Zeitraum", "Vertragsverlaengerung")
                        .WithMany()
                        .HasForeignKey("VertragsverlaengerungGuid");
                });

            modelBuilder.Entity("BO4E.COM.Vertragsteil", b =>
                {
                    b.HasOne("BO4E.COM.Menge", "Jahresverbrauchsprognose")
                        .WithMany()
                        .HasForeignKey("JahresverbrauchsprognoseGuid");

                    b.HasOne("BO4E.COM.Menge", "Kundenwert")
                        .WithMany()
                        .HasForeignKey("KundenwertGuid");

                    b.HasOne("BO4E.COM.Menge", "MaximaleAbnahmemenge")
                        .WithMany()
                        .HasForeignKey("MaximaleAbnahmemengeGuid");

                    b.HasOne("BO4E.COM.Menge", "MinimaleAbnahmemenge")
                        .WithMany()
                        .HasForeignKey("MinimaleAbnahmemengeGuid");

                    b.HasOne("BO4E.BO.Vertrag", null)
                        .WithMany("Vertragsteile")
                        .HasForeignKey("VertragGuid");

                    b.HasOne("BO4E.COM.Menge", "VertraglichFixierteMenge")
                        .WithMany()
                        .HasForeignKey("VertraglichFixierteMengeGuid");
                });

            modelBuilder.Entity("BO4E.COM.Zaehlwerk", b =>
                {
                    b.HasOne("BO4E.COM.Konzessionsabgabe", "Konzessionsabgabe")
                        .WithMany()
                        .HasForeignKey("KonzessionsabgabeGuid");

                    b.HasOne("BO4E.BO.Marktlokation", null)
                        .WithMany("Zaehlwerke")
                        .HasForeignKey("MarktlokationsId");

                    b.HasOne("BO4E.BO.Zaehler", null)
                        .WithMany("Zaehlwerke")
                        .HasForeignKey("ZaehlerGuid");
                });

            modelBuilder.Entity("BO4E.COM.Zustaendigkeit", b =>
                {
                    b.HasOne("BO4E.BO.Ansprechpartner", null)
                        .WithMany("Zustaendigkeit")
                        .HasForeignKey("AnsprechpartnerGuid");
                });

            modelBuilder.Entity("TechnicalMasterData.Model.ReadModel.Database.EF.Geraet", b =>
                {
                    b.HasOne("BO4E.COM.Hardware", "BoModel")
                        .WithMany()
                        .HasForeignKey("BoModelGuid");

                    b.HasOne("TechnicalMasterData.Model.DomainModel.Ids.ZaehlerId", "ZaehlerId")
                        .WithMany()
                        .HasForeignKey("ZaehlerIdId");
                });