Gulum
09f11cb4e3
- Gerbil.NameSearch (lowercase, strip whitespace/.-_) auto-synced in ApplicationContext .SaveChanges; Gridify-filterable so 'clan kleine chaoten' matches 'Clan-Kleine-Chaoten' (client strips separators the same way). GerbilSearch.Normalize shared helper. - Gerbil.OriginBreeder (free-text Herkunft) on DTO+Input, set by the FEAT-8 import from the source Zucht (imported animals have no OriginContact). Gridify-filterable. - GET /gerbils/breeders: distinct non-empty OriginBreeder values for the Herkunft dropdown. - Migration AddSearchFields (+ NameSearch backfill SQL for existing rows).
1037 lines
43 KiB
C#
1037 lines
43 KiB
C#
// <auto-generated />
|
|
using System;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Infrastructure;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
|
|
using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
|
|
|
|
#nullable disable
|
|
|
|
namespace GerbilManagerWebAPI.Migrations
|
|
{
|
|
[DbContext(typeof(ApplicationContext))]
|
|
[Migration("20260606070015_AddSearchFields")]
|
|
partial class AddSearchFields
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void BuildTargetModel(ModelBuilder modelBuilder)
|
|
{
|
|
#pragma warning disable 612, 618
|
|
modelBuilder
|
|
.HasAnnotation("ProductVersion", "10.0.8")
|
|
.HasAnnotation("Relational:MaxIdentifierLength", 63);
|
|
|
|
NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.BreederSettings", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Address")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("City")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Email")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Homepage")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Name")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Phone")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("ZuchtName")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("BreederSettings");
|
|
|
|
b.HasData(
|
|
new
|
|
{
|
|
Id = new Guid("11111111-1111-1111-1111-000000000001"),
|
|
Address = "",
|
|
City = "",
|
|
Email = "",
|
|
Homepage = "",
|
|
Name = "",
|
|
Phone = "",
|
|
ZuchtName = ""
|
|
});
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.ColorVariety", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("CanonicalGenotype")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Name")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<int>("SortOrder")
|
|
.HasColumnType("integer");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("ColorVarieties");
|
|
|
|
b.HasData(
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000001"),
|
|
CanonicalGenotype = "AA chch DD EE GG pp spsp rere",
|
|
Name = "Pink Eyed White (PEW)",
|
|
SortOrder = 0
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000002"),
|
|
CanonicalGenotype = "aa chch DD EE GG PP spsp rere",
|
|
Name = "Hermelin",
|
|
SortOrder = 1
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000003"),
|
|
CanonicalGenotype = "AA chch DD EE GG PP spsp rere",
|
|
Name = "Himalaya",
|
|
SortOrder = 2
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000004"),
|
|
CanonicalGenotype = "aa cchmcchm DD EE gg PP spsp rere",
|
|
Name = "Zobel",
|
|
SortOrder = 3
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000005"),
|
|
CanonicalGenotype = "AA CC DD efef GG PP spsp rere",
|
|
Name = "Schwarzschimmel",
|
|
SortOrder = 4
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000006"),
|
|
CanonicalGenotype = "AA CC DD efef GG pp spsp rere",
|
|
Name = "Rotaugenschimmel",
|
|
SortOrder = 5
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000007"),
|
|
CanonicalGenotype = "AA CC DD EE GG PP spsp rere",
|
|
Name = "Agouti",
|
|
SortOrder = 6
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000008"),
|
|
CanonicalGenotype = "aa CC DD EE GG PP spsp rere",
|
|
Name = "Schwarz",
|
|
SortOrder = 7
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000009"),
|
|
CanonicalGenotype = "AA CC DD EE gg PP spsp rere",
|
|
Name = "Silberagouti",
|
|
SortOrder = 8
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000010"),
|
|
CanonicalGenotype = "aa CC DD EE gg PP spsp rere",
|
|
Name = "Anthrazit",
|
|
SortOrder = 9
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000011"),
|
|
CanonicalGenotype = "AA CC DD ee GG PP spsp rere",
|
|
Name = "Algierfuchs",
|
|
SortOrder = 10
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000012"),
|
|
CanonicalGenotype = "aa CC dd EE GG PP spsp rere",
|
|
Name = "Blau",
|
|
SortOrder = 11
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000013"),
|
|
CanonicalGenotype = "AA CC DD EE GG pp spsp rere",
|
|
Name = "Gold",
|
|
SortOrder = 12
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000014"),
|
|
CanonicalGenotype = "aa CC DD EE GG pp spsp rere",
|
|
Name = "Platin",
|
|
SortOrder = 13
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000015"),
|
|
CanonicalGenotype = "AA CC DD ee GG pp spsp rere",
|
|
Name = "Goldfuchs",
|
|
SortOrder = 14
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000016"),
|
|
CanonicalGenotype = "aa CC DD ee GG pp spsp rere",
|
|
Name = "Rotfuchs",
|
|
SortOrder = 15
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000017"),
|
|
CanonicalGenotype = "AA CC dd EE GG pp spsp rere",
|
|
Name = "dd Gold",
|
|
SortOrder = 16
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000018"),
|
|
CanonicalGenotype = "aa CC dd EE GG pp spsp rere",
|
|
Name = "dd Platin",
|
|
SortOrder = 17
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000019"),
|
|
CanonicalGenotype = "aa CC DD EE gg pp spsp rere",
|
|
Name = "Altweiss (REW)",
|
|
SortOrder = 18
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000020"),
|
|
CanonicalGenotype = "AA CC DD ee gg pp spsp rere",
|
|
Name = "Apricot (Blassfuchs)",
|
|
SortOrder = 19
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000021"),
|
|
CanonicalGenotype = "aa CC DD ee gg PP spsp rere",
|
|
Name = "Blaufuchs",
|
|
SortOrder = 20
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000022"),
|
|
CanonicalGenotype = "aa CC DD ee gg pp spsp rere",
|
|
Name = "C-Separator",
|
|
SortOrder = 21
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000023"),
|
|
CanonicalGenotype = "AA CC DD EE gg pp spsp rere",
|
|
Name = "Elfenbein",
|
|
SortOrder = 22
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000024"),
|
|
CanonicalGenotype = "aa CC DD ee GG PP spsp rere",
|
|
Name = "Kohlfuchs",
|
|
SortOrder = 23
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000025"),
|
|
CanonicalGenotype = "aa cchmcchm DD EE GG PP spsp rere",
|
|
Name = "Marder",
|
|
SortOrder = 24
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000026"),
|
|
CanonicalGenotype = "aa cchmcchm DD EE GG PP spsp rere",
|
|
Name = "Siam (Marder-Hell)",
|
|
SortOrder = 25
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000027"),
|
|
CanonicalGenotype = "AA CC DD ee gg PP spsp rere",
|
|
Name = "Polarfuchs",
|
|
SortOrder = 26
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000028"),
|
|
CanonicalGenotype = "aa CC DD EE GG pp spsp rere",
|
|
Name = "Saphir",
|
|
SortOrder = 27
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000029"),
|
|
CanonicalGenotype = "AA CC DD efef GG PP spsp rere",
|
|
Name = "Schimmel (Orangeschimmel)",
|
|
SortOrder = 28
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000030"),
|
|
CanonicalGenotype = "AA CC DD EE GG pp spsp rere",
|
|
Name = "Topas",
|
|
SortOrder = 29
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000031"),
|
|
CanonicalGenotype = "aa CC DD EE GG pp spsp rere",
|
|
Name = "Platin-Hell",
|
|
SortOrder = 30
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000032"),
|
|
CanonicalGenotype = "AA CC dd EE GG PP spsp rere",
|
|
Name = "Agouti dd",
|
|
SortOrder = 31
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000033"),
|
|
CanonicalGenotype = "AA CC dd EE gg PP spsp rere",
|
|
Name = "Silberagouti dd",
|
|
SortOrder = 32
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000034"),
|
|
CanonicalGenotype = "aa CC dd ee GG PP spsp rere",
|
|
Name = "Kohlfuchs dd",
|
|
SortOrder = 33
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000035"),
|
|
CanonicalGenotype = "aa CC dd EE gg PP spsp rere",
|
|
Name = "Anthrazit dd",
|
|
SortOrder = 34
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000036"),
|
|
CanonicalGenotype = "AA cchmcchm DD EE GG PP spsp rere",
|
|
Name = "Agouti CP-Hell",
|
|
SortOrder = 35
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000037"),
|
|
CanonicalGenotype = "aa cchmcchm DD ee gg PP spsp rere",
|
|
Name = "Blaufuchs CP",
|
|
SortOrder = 36
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000038"),
|
|
CanonicalGenotype = "AA CC DD efef gg PP spsp rere",
|
|
Name = "Polarfuchsschimmel",
|
|
SortOrder = 37
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000039"),
|
|
CanonicalGenotype = "AA CC DD efef gg PP spsp rere",
|
|
Name = "Silberschimmel",
|
|
SortOrder = 38
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000040"),
|
|
CanonicalGenotype = "AA CC DD efef GG PP spsp rere",
|
|
Name = "Algierfuchsschimmel",
|
|
SortOrder = 39
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000041"),
|
|
CanonicalGenotype = "AA cchmcchm DD ee gg PP spsp rere",
|
|
Name = "Polarfuchs-Hell CP",
|
|
SortOrder = 40
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000042"),
|
|
CanonicalGenotype = "aa CC DD efef GG PP spsp rere",
|
|
Name = "Kohlfuchsschimmel",
|
|
SortOrder = 41
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000043"),
|
|
CanonicalGenotype = "aa CC DD efef gg PP spsp rere",
|
|
Name = "Blaufuchsschimmel",
|
|
SortOrder = 42
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000044"),
|
|
CanonicalGenotype = "aa CC DD ee GG PP spsp rere",
|
|
Name = "Kohlfuchs, hell",
|
|
SortOrder = 43
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000045"),
|
|
CanonicalGenotype = "AA CC DD ee GG pp spsp rere",
|
|
Name = "Goldfuchs, hell",
|
|
SortOrder = 44
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000046"),
|
|
CanonicalGenotype = "AA CC DD efef GG pp spsp rere",
|
|
Name = "Goldfuchsschimmel",
|
|
SortOrder = 45
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000047"),
|
|
CanonicalGenotype = "AA CC DD EE GG pp spsp rere",
|
|
Name = "Gold-Hell",
|
|
SortOrder = 46
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000048"),
|
|
CanonicalGenotype = "aa cchmcchm dd EE GG PP spsp rere",
|
|
Name = "Siam (Marder-Hell) dd",
|
|
SortOrder = 47
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000049"),
|
|
CanonicalGenotype = "aa cchmcchm dd EE GG PP spsp rere",
|
|
Name = "Marder dd",
|
|
SortOrder = 48
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000050"),
|
|
CanonicalGenotype = "aa cchmcchm DD EE gg PP spsp rere",
|
|
Name = "Zobel-Hell",
|
|
SortOrder = 49
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000051"),
|
|
CanonicalGenotype = "AA cchmcchm dd EE gg PP spsp rere",
|
|
Name = "Silberagouti dd CP",
|
|
SortOrder = 50
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000052"),
|
|
CanonicalGenotype = "AA cchmcchm dd EE gg PP spsp rere",
|
|
Name = "Silberagouti-Hell dd CP",
|
|
SortOrder = 51
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000053"),
|
|
CanonicalGenotype = "AA cchmcchm dd EE GG PP spsp rere",
|
|
Name = "Agouti dd CP",
|
|
SortOrder = 52
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000054"),
|
|
CanonicalGenotype = "AA cchmcchm dd EE GG PP spsp rere",
|
|
Name = "Agouti-Hell dd CP",
|
|
SortOrder = 53
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000055"),
|
|
CanonicalGenotype = "aa CC DD ee gg PP spsp rere",
|
|
Name = "Blaufuchs, hell",
|
|
SortOrder = 54
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000056"),
|
|
CanonicalGenotype = "aa CC DD efef GG pp spsp rere",
|
|
Name = "Rotfuchsschimmel",
|
|
SortOrder = 55
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000057"),
|
|
CanonicalGenotype = "AA CC DD ee gg PP spsp rere",
|
|
Name = "Polarfuchs, hell",
|
|
SortOrder = 56
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000058"),
|
|
CanonicalGenotype = "aa CC DD efef GG PP spsp rere",
|
|
Name = "Kohlfuchsschimmel, hell",
|
|
SortOrder = 57
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000059"),
|
|
CanonicalGenotype = "aa CC DD ee GG pp spsp rere",
|
|
Name = "Rotfuchs, hell",
|
|
SortOrder = 58
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000060"),
|
|
CanonicalGenotype = "aa cchmcchm dd EE gg PP spsp rere",
|
|
Name = "Zobel dd",
|
|
SortOrder = 59
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000061"),
|
|
CanonicalGenotype = "aa CC DD ee GG PP spsp rere",
|
|
Name = "Kohlfuchs-Hell",
|
|
SortOrder = 60
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000062"),
|
|
CanonicalGenotype = "aa cchmcchm DD ee GG PP spsp rere",
|
|
Name = "Kohlfuchs CP",
|
|
SortOrder = 61
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000063"),
|
|
CanonicalGenotype = "AA cchmcchm DD ee GG PP spsp rere",
|
|
Name = "Algierfuchs CP",
|
|
SortOrder = 62
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000064"),
|
|
CanonicalGenotype = "AA cchmcchm DD EE gg PP spsp rere",
|
|
Name = "Silberagouti CP",
|
|
SortOrder = 63
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000065"),
|
|
CanonicalGenotype = "AA cchmcchm DD EE GG PP spsp rere",
|
|
Name = "Agouti CP",
|
|
SortOrder = 64
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000066"),
|
|
CanonicalGenotype = "AA cchmcchm DD ee GG PP spsp rere",
|
|
Name = "Algierfuchs-Hell CP",
|
|
SortOrder = 65
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000067"),
|
|
CanonicalGenotype = "aa cchmcchm DD ee GG PP spsp rere",
|
|
Name = "Kohlfuchs,hell CP",
|
|
SortOrder = 66
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000068"),
|
|
CanonicalGenotype = "AA cchmcchm DD ee gg PP spsp rere",
|
|
Name = "Polarfuchs CP",
|
|
SortOrder = 67
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000069"),
|
|
CanonicalGenotype = "AA CC DD ee GG PP spsp rere",
|
|
Name = "Algierfuchs, hell",
|
|
SortOrder = 68
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000070"),
|
|
CanonicalGenotype = "AA CC dd EE GG pp spsp rere",
|
|
Name = "Topas dd",
|
|
SortOrder = 69
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000071"),
|
|
CanonicalGenotype = "aa cchmcchm dd EE gg PP spsp rere",
|
|
Name = "Zobel-Hell dd",
|
|
SortOrder = 70
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000072"),
|
|
CanonicalGenotype = "aa cchmcchm DD efef GG PP spsp rere",
|
|
Name = "Kohlfuchsschimmel CP",
|
|
SortOrder = 71
|
|
},
|
|
new
|
|
{
|
|
Id = new Guid("00000000-0000-0000-0000-000000000073"),
|
|
CanonicalGenotype = "aa CC dd ee gg PP spsp rere",
|
|
Name = "Blaufuchs dd",
|
|
SortOrder = 72
|
|
});
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.Contact", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Address")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Email")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Name")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Phone")
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("Contacts");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.Enclosure", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Name")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("Enclosures");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.Gerbil", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("CauseOfDeath")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<Guid?>("ColorVarietyId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<DateOnly?>("DateOfBirth")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<DateOnly?>("DateOfDeath")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<Guid?>("EnclosureId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("ExternalRef")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Gender")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Genotype")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<DateOnly?>("GoHomeDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<string>("ImportSource")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<Guid?>("LitterId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Name")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("NameSearch")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("OriginBreeder")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<Guid?>("OriginContactId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("RawImportData")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<Guid?>("ReceiverContactId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Status")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("ColorVarietyId");
|
|
|
|
b.HasIndex("EnclosureId");
|
|
|
|
b.HasIndex("LitterId");
|
|
|
|
b.HasIndex("OriginContactId");
|
|
|
|
b.HasIndex("ReceiverContactId");
|
|
|
|
b.ToTable("Gerbils");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.GerbilPhoto", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Caption")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("FileName")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<Guid>("GerbilId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<int>("SortOrder")
|
|
.HasColumnType("integer");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("GerbilId");
|
|
|
|
b.ToTable("GerbilPhotos");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.HealthRecord", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<DateOnly>("Date")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<string>("Description")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<Guid>("GerbilId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Type")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Veterinarian")
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("GerbilId");
|
|
|
|
b.ToTable("HealthRecords");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.Litter", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<DateOnly>("Date")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<DateOnly?>("ExpectedGoHomeDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<Guid?>("FatherId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<Guid?>("MotherId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Name")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("PairingCode")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<int?>("TotalBorn")
|
|
.HasColumnType("integer");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("FatherId");
|
|
|
|
b.HasIndex("MotherId");
|
|
|
|
b.ToTable("Litters");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.SaleContract", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<Guid>("ContactId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<DateOnly>("ContractDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("FileName")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<DateOnly>("HandoverDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<decimal>("Price")
|
|
.HasPrecision(10, 2)
|
|
.HasColumnType("numeric(10,2)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("ContactId");
|
|
|
|
b.ToTable("SaleContracts");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.SaleContractAnimal", b =>
|
|
{
|
|
b.Property<Guid>("SaleContractId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<Guid>("GerbilId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.HasKey("SaleContractId", "GerbilId");
|
|
|
|
b.HasIndex("GerbilId");
|
|
|
|
b.ToTable("SaleContractAnimal");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.WeightRecord", b =>
|
|
{
|
|
b.Property<Guid>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<DateOnly>("Date")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<Guid>("GerbilId")
|
|
.HasColumnType("uuid");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<int>("WeightGrams")
|
|
.HasColumnType("integer");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("GerbilId");
|
|
|
|
b.ToTable("WeightRecords");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.Gerbil", b =>
|
|
{
|
|
b.HasOne("GerbilManagerWebAPI.Models.ColorVariety", "ColorVariety")
|
|
.WithMany()
|
|
.HasForeignKey("ColorVarietyId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("GerbilManagerWebAPI.Models.Enclosure", "Enclosure")
|
|
.WithMany("Gerbils")
|
|
.HasForeignKey("EnclosureId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("GerbilManagerWebAPI.Models.Litter", "Litter")
|
|
.WithMany()
|
|
.HasForeignKey("LitterId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("GerbilManagerWebAPI.Models.Contact", "OriginContact")
|
|
.WithMany()
|
|
.HasForeignKey("OriginContactId")
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
b.HasOne("GerbilManagerWebAPI.Models.Contact", "ReceiverContact")
|
|
.WithMany()
|
|
.HasForeignKey("ReceiverContactId")
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
b.Navigation("ColorVariety");
|
|
|
|
b.Navigation("Enclosure");
|
|
|
|
b.Navigation("Litter");
|
|
|
|
b.Navigation("OriginContact");
|
|
|
|
b.Navigation("ReceiverContact");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.GerbilPhoto", b =>
|
|
{
|
|
b.HasOne("GerbilManagerWebAPI.Models.Gerbil", null)
|
|
.WithMany()
|
|
.HasForeignKey("GerbilId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.HealthRecord", b =>
|
|
{
|
|
b.HasOne("GerbilManagerWebAPI.Models.Gerbil", null)
|
|
.WithMany()
|
|
.HasForeignKey("GerbilId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.Litter", b =>
|
|
{
|
|
b.HasOne("GerbilManagerWebAPI.Models.Gerbil", "Father")
|
|
.WithMany()
|
|
.HasForeignKey("FatherId")
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
b.HasOne("GerbilManagerWebAPI.Models.Gerbil", "Mother")
|
|
.WithMany()
|
|
.HasForeignKey("MotherId")
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
b.Navigation("Father");
|
|
|
|
b.Navigation("Mother");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.SaleContract", b =>
|
|
{
|
|
b.HasOne("GerbilManagerWebAPI.Models.Contact", "Contact")
|
|
.WithMany()
|
|
.HasForeignKey("ContactId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Contact");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.SaleContractAnimal", b =>
|
|
{
|
|
b.HasOne("GerbilManagerWebAPI.Models.Gerbil", "Gerbil")
|
|
.WithMany()
|
|
.HasForeignKey("GerbilId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.HasOne("GerbilManagerWebAPI.Models.SaleContract", null)
|
|
.WithMany("Animals")
|
|
.HasForeignKey("SaleContractId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Gerbil");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.WeightRecord", b =>
|
|
{
|
|
b.HasOne("GerbilManagerWebAPI.Models.Gerbil", null)
|
|
.WithMany()
|
|
.HasForeignKey("GerbilId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.Enclosure", b =>
|
|
{
|
|
b.Navigation("Gerbils");
|
|
});
|
|
|
|
modelBuilder.Entity("GerbilManagerWebAPI.Models.SaleContract", b =>
|
|
{
|
|
b.Navigation("Animals");
|
|
});
|
|
#pragma warning restore 612, 618
|
|
}
|
|
}
|
|
}
|