Chris Chen
831b868d9d
Add PayerEin (nullable string, max 20) to ChurchProfile entity, AppDbContext config, ChurchProfileDto response, UpdateChurchProfileRequest, and ChurchProfileService round-trip — mirroring the Phone/BankRoutingNumber nullable-string pattern. Migration AddPayerEinToChurchProfile adds only the one nullable column to ChurchProfiles. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
2678 lines
98 KiB
C#
2678 lines
98 KiB
C#
// <auto-generated />
|
|
using System;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Infrastructure;
|
|
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
|
|
using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
|
|
using ROLAC.API.Data;
|
|
|
|
#nullable disable
|
|
|
|
namespace ROLAC.API.Migrations
|
|
{
|
|
[DbContext(typeof(AppDbContext))]
|
|
partial class AppDbContextModelSnapshot : ModelSnapshot
|
|
{
|
|
protected override void BuildModel(ModelBuilder modelBuilder)
|
|
{
|
|
#pragma warning disable 612, 618
|
|
modelBuilder
|
|
.HasAnnotation("ProductVersion", "8.0.11")
|
|
.HasAnnotation("Relational:MaxIdentifierLength", 63);
|
|
|
|
NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("ClaimType")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("ClaimValue")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("RoleId")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("RoleId");
|
|
|
|
b.ToTable("AspNetRoleClaims", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("ClaimType")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("ClaimValue")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("UserId")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("UserId");
|
|
|
|
b.ToTable("AspNetUserClaims", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
|
|
{
|
|
b.Property<string>("LoginProvider")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("ProviderKey")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("ProviderDisplayName")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("UserId")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("LoginProvider", "ProviderKey");
|
|
|
|
b.HasIndex("UserId");
|
|
|
|
b.ToTable("AspNetUserLogins", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
|
|
{
|
|
b.Property<string>("UserId")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("RoleId")
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("UserId", "RoleId");
|
|
|
|
b.HasIndex("RoleId");
|
|
|
|
b.ToTable("AspNetUserRoles", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
|
|
{
|
|
b.Property<string>("UserId")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("LoginProvider")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Name")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Value")
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("UserId", "LoginProvider", "Name");
|
|
|
|
b.ToTable("AspNetUserTokens", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.AppRole", b =>
|
|
{
|
|
b.Property<string>("Id")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("ConcurrencyStamp")
|
|
.IsConcurrencyToken()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Description")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("Name")
|
|
.HasMaxLength(256)
|
|
.HasColumnType("character varying(256)");
|
|
|
|
b.Property<string>("NormalizedName")
|
|
.HasMaxLength(256)
|
|
.HasColumnType("character varying(256)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("NormalizedName")
|
|
.IsUnique()
|
|
.HasDatabaseName("RoleNameIndex");
|
|
|
|
b.ToTable("AspNetRoles", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.AppUser", b =>
|
|
{
|
|
b.Property<string>("Id")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<int>("AccessFailedCount")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("ConcurrencyStamp")
|
|
.IsConcurrencyToken()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<DateTime>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("Email")
|
|
.HasMaxLength(256)
|
|
.HasColumnType("character varying(256)");
|
|
|
|
b.Property<bool>("EmailConfirmed")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("LanguagePreference")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)")
|
|
.HasDefaultValue("en");
|
|
|
|
b.Property<DateTime?>("LastLoginAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<bool>("LockoutEnabled")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<DateTimeOffset?>("LockoutEnd")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<int?>("MemberId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("NormalizedEmail")
|
|
.HasMaxLength(256)
|
|
.HasColumnType("character varying(256)");
|
|
|
|
b.Property<string>("NormalizedUserName")
|
|
.HasMaxLength(256)
|
|
.HasColumnType("character varying(256)");
|
|
|
|
b.Property<string>("PasswordHash")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("PhoneNumber")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<bool>("PhoneNumberConfirmed")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("SecurityStamp")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<bool>("TwoFactorEnabled")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("UserName")
|
|
.HasMaxLength(256)
|
|
.HasColumnType("character varying(256)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("MemberId")
|
|
.IsUnique()
|
|
.HasFilter("\"MemberId\" IS NOT NULL");
|
|
|
|
b.HasIndex("NormalizedEmail")
|
|
.HasDatabaseName("EmailIndex");
|
|
|
|
b.HasIndex("NormalizedUserName")
|
|
.IsUnique()
|
|
.HasDatabaseName("UserNameIndex");
|
|
|
|
b.ToTable("AspNetUsers", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Check", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<decimal>("Amount")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<DateOnly>("CheckDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<string>("CheckNumber")
|
|
.IsRequired()
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<DateTimeOffset?>("DeletedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("DeletedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<bool>("IsDeleted")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<DateTimeOffset>("IssuedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("IssuedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<int?>("MemberId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("Memo")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("PayeeAddress")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("PayeeCity")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("PayeeName")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("PayeeState")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<string>("PayeeType")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<string>("PayeeZip")
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<string>("ReceiptCapturedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("ReceiptSignatureBlobPath")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<DateTimeOffset?>("ReceiptSignedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("ReceiptSignedName")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Status")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)")
|
|
.HasDefaultValue("Issued");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("VoidReason")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<DateTimeOffset?>("VoidedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("VoidedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("CheckDate");
|
|
|
|
b.HasIndex("CheckNumber")
|
|
.IsUnique()
|
|
.HasFilter("\"IsDeleted\" = false");
|
|
|
|
b.HasIndex("MemberId");
|
|
|
|
b.HasIndex("Status")
|
|
.HasFilter("\"IsDeleted\" = false");
|
|
|
|
b.ToTable("Checks");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.CheckLine", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<decimal>("Amount")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<int>("CheckId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Description")
|
|
.IsRequired()
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<int>("ExpenseId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("CheckId");
|
|
|
|
b.HasIndex("ExpenseId");
|
|
|
|
b.ToTable("CheckLines");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ChurchProfile", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Address")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("AiProvider")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)")
|
|
.HasDefaultValue("Claude");
|
|
|
|
b.Property<string>("BankAccountNumber")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<string>("BankName")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("BankRoutingNumber")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<string>("City")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("ClaudeApiKey")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("ClaudeModel")
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)")
|
|
.HasDefaultValue("claude-haiku-4-5-20251001");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Email")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("GeminiApiKey")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("GeminiModel")
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)")
|
|
.HasDefaultValue("gemini-2.5-flash-lite");
|
|
|
|
b.Property<string>("Name")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("NameZh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int>("NextCheckNumber")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("PayerEin")
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<string>("Phone")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<string>("State")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Website")
|
|
.HasMaxLength(300)
|
|
.HasColumnType("character varying(300)");
|
|
|
|
b.Property<string>("ZipCode")
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<uint>("xmin")
|
|
.IsConcurrencyToken()
|
|
.ValueGeneratedOnAddOrUpdate()
|
|
.HasColumnType("xid")
|
|
.HasColumnName("xmin");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("ChurchProfiles");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Expense", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<decimal>("Amount")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<string>("CheckNumber")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<DateTimeOffset?>("DeletedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("DeletedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Description")
|
|
.IsRequired()
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<DateOnly>("ExpenseDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<bool>("IsDeleted")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<int?>("MemberId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<int>("MinistryId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<DateTimeOffset?>("PaidAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("PaidBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<int?>("PayeeId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("ReceiptBlobPath")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("ReviewNotes")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<DateTimeOffset?>("ReviewedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("ReviewedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Status")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(30)
|
|
.HasColumnType("character varying(30)")
|
|
.HasDefaultValue("Draft");
|
|
|
|
b.Property<DateTimeOffset?>("SubmittedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("SubmittedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Type")
|
|
.IsRequired()
|
|
.HasMaxLength(30)
|
|
.HasColumnType("character varying(30)");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("VendorName")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("ExpenseDate");
|
|
|
|
b.HasIndex("MemberId");
|
|
|
|
b.HasIndex("MinistryId");
|
|
|
|
b.HasIndex("PayeeId");
|
|
|
|
b.HasIndex("Status")
|
|
.HasFilter("\"IsDeleted\" = false");
|
|
|
|
b.ToTable("Expenses");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseCategoryGroup", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<int?>("Form1099BoxId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<int?>("Form990LineId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("Name_en")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Name_zh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int>("SortOrder")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Form1099BoxId");
|
|
|
|
b.HasIndex("Form990LineId");
|
|
|
|
b.ToTable("ExpenseCategoryGroups");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseLine", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<decimal>("Amount")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<int>("CategoryGroupId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Description")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<int>("ExpenseId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("FunctionalClass")
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<int>("SubCategoryId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("CategoryGroupId");
|
|
|
|
b.HasIndex("ExpenseId");
|
|
|
|
b.HasIndex("SubCategoryId");
|
|
|
|
b.ToTable("ExpenseLines");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseSnapshot", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("CheckNumber")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<DateTimeOffset?>("DeletedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("DeletedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Description")
|
|
.IsRequired()
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<bool>("IsDeleted")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<int>("MinistryId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("Name")
|
|
.IsRequired()
|
|
.HasMaxLength(150)
|
|
.HasColumnType("character varying(150)");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("VendorName")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("CreatedAt");
|
|
|
|
b.HasIndex("MinistryId");
|
|
|
|
b.ToTable("ExpenseSnapshots");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseSnapshotLine", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<decimal>("Amount")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<int>("CategoryGroupId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Description")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("FunctionalClass")
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<int>("SnapshotId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<int>("SubCategoryId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("CategoryGroupId");
|
|
|
|
b.HasIndex("SnapshotId");
|
|
|
|
b.HasIndex("SubCategoryId");
|
|
|
|
b.ToTable("ExpenseSnapshotLines");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseSubCategory", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<int?>("Form1099BoxId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<int?>("Form990LineId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<int>("GroupId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("Name_en")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Name_zh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int>("SortOrder")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Form1099BoxId");
|
|
|
|
b.HasIndex("Form990LineId");
|
|
|
|
b.HasIndex("GroupId");
|
|
|
|
b.ToTable("ExpenseSubCategories");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.FamilyUnit", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("FamilyName_en")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("FamilyName_zh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("FamilyUnits");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Form1099Box", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("BoxCode")
|
|
.IsRequired()
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("FormType")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("Name_en")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Name_zh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int>("SortOrder")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("BoxCode")
|
|
.IsUnique();
|
|
|
|
b.ToTable("Form1099Boxes");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Form990ExpenseLine", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("LineCode")
|
|
.IsRequired()
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)");
|
|
|
|
b.Property<string>("Name_en")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Name_zh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int>("SortOrder")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("LineCode")
|
|
.IsUnique();
|
|
|
|
b.ToTable("Form990ExpenseLines");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Giving", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<decimal>("Amount")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<string>("CheckNumber")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<int>("GivingCategoryId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateOnly>("GivingDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<bool>("IsAnonymous")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<int?>("MemberId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<int?>("OfferingSessionId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("PayPalTransactionId")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("PaymentMethod")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("ZelleReferenceCode")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("GivingCategoryId");
|
|
|
|
b.HasIndex("GivingDate");
|
|
|
|
b.HasIndex("OfferingSessionId")
|
|
.HasFilter("\"OfferingSessionId\" IS NOT NULL");
|
|
|
|
b.HasIndex("MemberId", "GivingDate");
|
|
|
|
b.ToTable("Givings");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.GivingCategory", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Description_en")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("Description_zh")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("Name_en")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Name_zh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int>("SortOrder")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("GivingCategories");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Logging.AuditLog", b =>
|
|
{
|
|
b.Property<long>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bigint");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
|
|
|
|
b.Property<string>("Action")
|
|
.IsRequired()
|
|
.HasMaxLength(40)
|
|
.HasColumnType("character varying(40)");
|
|
|
|
b.Property<string>("Category")
|
|
.IsRequired()
|
|
.HasMaxLength(40)
|
|
.HasColumnType("character varying(40)");
|
|
|
|
b.Property<string>("Changes")
|
|
.HasColumnType("jsonb");
|
|
|
|
b.Property<string>("CorrelationId")
|
|
.HasMaxLength(64)
|
|
.HasColumnType("character varying(64)");
|
|
|
|
b.Property<string>("EntityId")
|
|
.HasMaxLength(64)
|
|
.HasColumnType("character varying(64)");
|
|
|
|
b.Property<string>("EntityName")
|
|
.HasMaxLength(128)
|
|
.HasColumnType("character varying(128)");
|
|
|
|
b.Property<string>("IpAddress")
|
|
.HasMaxLength(45)
|
|
.HasColumnType("character varying(45)");
|
|
|
|
b.Property<byte>("Level")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<string>("Summary")
|
|
.HasMaxLength(512)
|
|
.HasColumnType("character varying(512)");
|
|
|
|
b.Property<DateTimeOffset>("Timestamp")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UserEmail")
|
|
.HasMaxLength(256)
|
|
.HasColumnType("character varying(256)");
|
|
|
|
b.Property<string>("UserId")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Action");
|
|
|
|
b.HasIndex("Timestamp");
|
|
|
|
b.HasIndex("UserId")
|
|
.HasFilter("\"UserId\" IS NOT NULL");
|
|
|
|
b.HasIndex("Category", "Timestamp");
|
|
|
|
b.HasIndex("EntityName", "EntityId");
|
|
|
|
b.ToTable("AuditLogs", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Logging.SystemLog", b =>
|
|
{
|
|
b.Property<long>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bigint");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
|
|
|
|
b.Property<string>("Category")
|
|
.IsRequired()
|
|
.HasMaxLength(256)
|
|
.HasColumnType("character varying(256)");
|
|
|
|
b.Property<string>("CorrelationId")
|
|
.HasMaxLength(64)
|
|
.HasColumnType("character varying(64)");
|
|
|
|
b.Property<int?>("EventId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("Exception")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("HttpMethod")
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)");
|
|
|
|
b.Property<string>("IpAddress")
|
|
.HasMaxLength(45)
|
|
.HasColumnType("character varying(45)");
|
|
|
|
b.Property<byte>("Level")
|
|
.HasColumnType("smallint");
|
|
|
|
b.Property<string>("Message")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("RequestPath")
|
|
.HasMaxLength(2048)
|
|
.HasColumnType("character varying(2048)");
|
|
|
|
b.Property<int?>("StatusCode")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTimeOffset>("Timestamp")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UserId")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Level");
|
|
|
|
b.HasIndex("Timestamp");
|
|
|
|
b.HasIndex("UserId")
|
|
.HasFilter("\"UserId\" IS NOT NULL");
|
|
|
|
b.HasIndex("Timestamp", "Level");
|
|
|
|
b.ToTable("SystemLogs", (string)null);
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.MealAttendance", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<int>("AdultCount")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer")
|
|
.HasDefaultValue(0);
|
|
|
|
b.Property<DateOnly>("AttendanceDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<int>("KidCount")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer")
|
|
.HasDefaultValue(0);
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<int>("YouthCount")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer")
|
|
.HasDefaultValue(0);
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("AttendanceDate")
|
|
.IsUnique();
|
|
|
|
b.ToTable("MealAttendances");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Member", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Address")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("BaptismChurch")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<DateOnly?>("BaptismDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<string>("City")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("Country")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)")
|
|
.HasDefaultValue("USA");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<DateOnly?>("DateOfBirth")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<DateTimeOffset?>("DeletedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("DeletedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Email")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Entity")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int?>("FamilyUnitId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("FirstName_en")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("FirstName_zh")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("Gender")
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)");
|
|
|
|
b.Property<bool>("IsDeleted")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<DateOnly?>("JoinDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<string>("LanguagePreference")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)")
|
|
.HasDefaultValue("en");
|
|
|
|
b.Property<string>("LastName_en")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("LastName_zh")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("NickName")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("PhoneCell")
|
|
.HasMaxLength(30)
|
|
.HasColumnType("character varying(30)");
|
|
|
|
b.Property<string>("PhoneHome")
|
|
.HasMaxLength(30)
|
|
.HasColumnType("character varying(30)");
|
|
|
|
b.Property<string>("PhotoBlobPath")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("State")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<string>("Status")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)")
|
|
.HasDefaultValue("Member");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("ZipCode")
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Email")
|
|
.HasFilter("\"Email\" IS NOT NULL");
|
|
|
|
b.HasIndex("FamilyUnitId");
|
|
|
|
b.HasIndex("Status")
|
|
.HasFilter("\"IsDeleted\" = false");
|
|
|
|
b.ToTable("Members");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Ministry", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("DefaultFunctionalClass")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)")
|
|
.HasDefaultValue("Program");
|
|
|
|
b.Property<string>("Description_en")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Description_zh")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("Name_en")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Name_zh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int>("SortOrder")
|
|
.HasColumnType("integer");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("Ministries");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.MonthlyStatement", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<decimal>("BankStatementBalance")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<decimal>("CalculatedClosingBalance")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<decimal>("Difference")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<DateTimeOffset?>("FinalizedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("FinalizedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<bool>("IsFinalized")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<int>("Month")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<decimal>("OpeningBalance")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<decimal>("TotalExpenses")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<decimal>("TotalGiving")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<decimal>("TotalOtherIncome")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<int>("Year")
|
|
.HasColumnType("integer");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Year", "Month")
|
|
.IsUnique();
|
|
|
|
b.ToTable("MonthlyStatements");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.NotificationSetting", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<bool>("EnableEmail")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<bool>("EnableLine")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("FromAddress")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("FromName")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("LineChannelAccessToken")
|
|
.IsRequired()
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("LineChannelSecret")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("SmtpHost")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("SmtpPassword")
|
|
.IsRequired()
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<int>("SmtpPort")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<bool>("SmtpUseSsl")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("SmtpUser")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("NotificationSettings");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Notifications.LineBindingCode", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Code")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<DateTime?>("ConsumedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<DateTime>("ExpiresAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<int>("MemberId")
|
|
.HasColumnType("integer");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Code");
|
|
|
|
b.HasIndex("MemberId");
|
|
|
|
b.ToTable("LineBindingCodes");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Notifications.MemberChannelBinding", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTime>("BoundAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("Channel")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<string>("ExternalId")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<int>("MemberId")
|
|
.HasColumnType("integer");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Channel", "ExternalId")
|
|
.IsUnique();
|
|
|
|
b.HasIndex("MemberId", "Channel")
|
|
.IsUnique();
|
|
|
|
b.ToTable("MemberChannelBindings");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Notifications.MessagingGroup", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Channel")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<string>("ExternalId")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("Name")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<DateTime>("RegisteredAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Channel", "ExternalId")
|
|
.IsUnique();
|
|
|
|
b.ToTable("MessagingGroups");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Notifications.NotificationLog", b =>
|
|
{
|
|
b.Property<long>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bigint");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
|
|
|
|
b.Property<string>("Body")
|
|
.IsRequired()
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("Channel")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<string>("Error")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<int?>("MemberId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<int?>("MessagingGroupId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<DateTime>("SentAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("SentByUserId")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Status")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.Property<string>("Subject")
|
|
.HasMaxLength(300)
|
|
.HasColumnType("character varying(300)");
|
|
|
|
b.Property<string>("TargetExternalId")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("TargetType")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("Channel");
|
|
|
|
b.HasIndex("MemberId");
|
|
|
|
b.HasIndex("MessagingGroupId");
|
|
|
|
b.HasIndex("SentAt");
|
|
|
|
b.ToTable("NotificationLogs");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.OfferingSession", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<decimal>("CashTotal")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<decimal>("CheckTotal")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<decimal>("Difference")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasColumnType("text");
|
|
|
|
b.Property<string>("ProofPdfPath")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<DateTimeOffset?>("ReconciledAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("ReconciledBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<DateOnly>("SessionDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<string>("Status")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)")
|
|
.HasDefaultValue("Draft");
|
|
|
|
b.Property<DateTimeOffset?>("SubmittedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("SubmittedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<decimal>("SystemTotal")
|
|
.HasColumnType("decimal(18,2)");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("SessionDate")
|
|
.IsUnique();
|
|
|
|
b.ToTable("OfferingSessions");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Payee1099", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("AddressLine1")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("AddressLine2")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("City")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<DateTimeOffset?>("DeletedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("DeletedBy")
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("DisplayName")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("Email")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<bool>("Is1099Tracked")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<bool>("IsDeleted")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("LegalName")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<int?>("MemberId")
|
|
.HasColumnType("integer");
|
|
|
|
b.Property<string>("Notes")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("Phone")
|
|
.HasMaxLength(30)
|
|
.HasColumnType("character varying(30)");
|
|
|
|
b.Property<string>("State")
|
|
.HasMaxLength(2)
|
|
.HasColumnType("character varying(2)");
|
|
|
|
b.Property<string>("TaxClassification")
|
|
.IsRequired()
|
|
.HasMaxLength(40)
|
|
.HasColumnType("character varying(40)");
|
|
|
|
b.Property<string>("TinEncrypted")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<string>("TinLast4")
|
|
.HasMaxLength(4)
|
|
.HasColumnType("character varying(4)");
|
|
|
|
b.Property<string>("TinType")
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("W9BlobPath")
|
|
.HasMaxLength(500)
|
|
.HasColumnType("character varying(500)");
|
|
|
|
b.Property<DateOnly?>("W9ReceivedDate")
|
|
.HasColumnType("date");
|
|
|
|
b.Property<string>("W9Status")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.HasColumnType("character varying(20)")
|
|
.HasDefaultValue("Missing");
|
|
|
|
b.Property<string>("Zip")
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("MemberId");
|
|
|
|
b.ToTable("Payee1099s");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.RefreshToken", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTime>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("DeviceInfo")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<DateTime>("ExpiresAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("IpAddress")
|
|
.HasMaxLength(45)
|
|
.HasColumnType("character varying(45)");
|
|
|
|
b.Property<string>("ReplacedByHash")
|
|
.HasMaxLength(64)
|
|
.HasColumnType("character varying(64)");
|
|
|
|
b.Property<DateTime?>("RevokedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("TokenHash")
|
|
.IsRequired()
|
|
.HasMaxLength(64)
|
|
.HasColumnType("character varying(64)");
|
|
|
|
b.Property<string>("UserId")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("TokenHash")
|
|
.IsUnique();
|
|
|
|
b.HasIndex("UserId");
|
|
|
|
b.ToTable("RefreshTokens");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.RolePermission", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<bool>("CanApprove")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<bool>("CanDelete")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<bool>("CanRead")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<bool>("CanWrite")
|
|
.HasColumnType("boolean");
|
|
|
|
b.Property<string>("Module")
|
|
.IsRequired()
|
|
.HasMaxLength(60)
|
|
.HasColumnType("character varying(60)");
|
|
|
|
b.Property<string>("RoleId")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("RoleId", "Module")
|
|
.IsUnique();
|
|
|
|
b.ToTable("RolePermissions");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.SiteSetting", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTimeOffset>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<string>("Currency")
|
|
.IsRequired()
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)");
|
|
|
|
b.Property<string>("DateFormat")
|
|
.IsRequired()
|
|
.HasMaxLength(50)
|
|
.HasColumnType("character varying(50)");
|
|
|
|
b.Property<string>("DefaultLanguage")
|
|
.IsRequired()
|
|
.HasMaxLength(10)
|
|
.HasColumnType("character varying(10)");
|
|
|
|
b.Property<string>("SiteTitle")
|
|
.IsRequired()
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("SiteTitleZh")
|
|
.HasMaxLength(200)
|
|
.HasColumnType("character varying(200)");
|
|
|
|
b.Property<string>("TimeZone")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.HasColumnType("character varying(100)");
|
|
|
|
b.Property<DateTimeOffset>("UpdatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UpdatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.ToTable("SiteSettings");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.UserInvitation", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("integer");
|
|
|
|
NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTime>("CreatedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("CreatedBy")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.Property<DateTime>("ExpiresAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<DateTime?>("RevokedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("TokenHash")
|
|
.IsRequired()
|
|
.HasMaxLength(64)
|
|
.HasColumnType("character varying(64)");
|
|
|
|
b.Property<DateTime?>("UsedAt")
|
|
.HasColumnType("timestamp with time zone");
|
|
|
|
b.Property<string>("UserId")
|
|
.IsRequired()
|
|
.HasMaxLength(450)
|
|
.HasColumnType("character varying(450)");
|
|
|
|
b.HasKey("Id");
|
|
|
|
b.HasIndex("TokenHash")
|
|
.IsUnique();
|
|
|
|
b.HasIndex("UserId");
|
|
|
|
b.ToTable("UserInvitations");
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.AppRole", null)
|
|
.WithMany()
|
|
.HasForeignKey("RoleId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.AppUser", null)
|
|
.WithMany()
|
|
.HasForeignKey("UserId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.AppUser", null)
|
|
.WithMany()
|
|
.HasForeignKey("UserId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.AppRole", null)
|
|
.WithMany()
|
|
.HasForeignKey("RoleId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.HasOne("ROLAC.API.Entities.AppUser", null)
|
|
.WithMany()
|
|
.HasForeignKey("UserId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
});
|
|
|
|
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.AppUser", null)
|
|
.WithMany()
|
|
.HasForeignKey("UserId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Check", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Member", "Member")
|
|
.WithMany()
|
|
.HasForeignKey("MemberId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.Navigation("Member");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.CheckLine", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Check", "Check")
|
|
.WithMany("Lines")
|
|
.HasForeignKey("CheckId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.HasOne("ROLAC.API.Entities.Expense", "Expense")
|
|
.WithMany()
|
|
.HasForeignKey("ExpenseId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Check");
|
|
|
|
b.Navigation("Expense");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Expense", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Member", "Member")
|
|
.WithMany()
|
|
.HasForeignKey("MemberId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("ROLAC.API.Entities.Ministry", "Ministry")
|
|
.WithMany()
|
|
.HasForeignKey("MinistryId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.HasOne("ROLAC.API.Entities.Payee1099", "Payee")
|
|
.WithMany()
|
|
.HasForeignKey("PayeeId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.Navigation("Member");
|
|
|
|
b.Navigation("Ministry");
|
|
|
|
b.Navigation("Payee");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseCategoryGroup", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Form1099Box", "Form1099Box")
|
|
.WithMany()
|
|
.HasForeignKey("Form1099BoxId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("ROLAC.API.Entities.Form990ExpenseLine", "Form990Line")
|
|
.WithMany()
|
|
.HasForeignKey("Form990LineId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.Navigation("Form1099Box");
|
|
|
|
b.Navigation("Form990Line");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseLine", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.ExpenseCategoryGroup", "CategoryGroup")
|
|
.WithMany()
|
|
.HasForeignKey("CategoryGroupId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.HasOne("ROLAC.API.Entities.Expense", "Expense")
|
|
.WithMany("Lines")
|
|
.HasForeignKey("ExpenseId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.HasOne("ROLAC.API.Entities.ExpenseSubCategory", "SubCategory")
|
|
.WithMany()
|
|
.HasForeignKey("SubCategoryId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("CategoryGroup");
|
|
|
|
b.Navigation("Expense");
|
|
|
|
b.Navigation("SubCategory");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseSnapshot", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Ministry", "Ministry")
|
|
.WithMany()
|
|
.HasForeignKey("MinistryId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Ministry");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseSnapshotLine", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.ExpenseCategoryGroup", "CategoryGroup")
|
|
.WithMany()
|
|
.HasForeignKey("CategoryGroupId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.HasOne("ROLAC.API.Entities.ExpenseSnapshot", "Snapshot")
|
|
.WithMany("Lines")
|
|
.HasForeignKey("SnapshotId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.HasOne("ROLAC.API.Entities.ExpenseSubCategory", "SubCategory")
|
|
.WithMany()
|
|
.HasForeignKey("SubCategoryId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("CategoryGroup");
|
|
|
|
b.Navigation("Snapshot");
|
|
|
|
b.Navigation("SubCategory");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseSubCategory", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Form1099Box", "Form1099Box")
|
|
.WithMany()
|
|
.HasForeignKey("Form1099BoxId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("ROLAC.API.Entities.Form990ExpenseLine", "Form990Line")
|
|
.WithMany()
|
|
.HasForeignKey("Form990LineId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("ROLAC.API.Entities.ExpenseCategoryGroup", "Group")
|
|
.WithMany("SubCategories")
|
|
.HasForeignKey("GroupId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Form1099Box");
|
|
|
|
b.Navigation("Form990Line");
|
|
|
|
b.Navigation("Group");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Giving", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.GivingCategory", "GivingCategory")
|
|
.WithMany()
|
|
.HasForeignKey("GivingCategoryId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.HasOne("ROLAC.API.Entities.Member", "Member")
|
|
.WithMany()
|
|
.HasForeignKey("MemberId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("ROLAC.API.Entities.OfferingSession", "OfferingSession")
|
|
.WithMany("Givings")
|
|
.HasForeignKey("OfferingSessionId")
|
|
.OnDelete(DeleteBehavior.Cascade);
|
|
|
|
b.Navigation("GivingCategory");
|
|
|
|
b.Navigation("Member");
|
|
|
|
b.Navigation("OfferingSession");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Member", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.FamilyUnit", "FamilyUnit")
|
|
.WithMany()
|
|
.HasForeignKey("FamilyUnitId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.Navigation("FamilyUnit");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Notifications.LineBindingCode", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Member", "Member")
|
|
.WithMany()
|
|
.HasForeignKey("MemberId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Member");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Notifications.MemberChannelBinding", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Member", "Member")
|
|
.WithMany()
|
|
.HasForeignKey("MemberId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Member");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Notifications.NotificationLog", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Member", "Member")
|
|
.WithMany()
|
|
.HasForeignKey("MemberId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.HasOne("ROLAC.API.Entities.Notifications.MessagingGroup", "MessagingGroup")
|
|
.WithMany()
|
|
.HasForeignKey("MessagingGroupId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.Navigation("Member");
|
|
|
|
b.Navigation("MessagingGroup");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Payee1099", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.Member", "Member")
|
|
.WithMany()
|
|
.HasForeignKey("MemberId")
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
b.Navigation("Member");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.RefreshToken", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.AppUser", "User")
|
|
.WithMany("RefreshTokens")
|
|
.HasForeignKey("UserId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("User");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.RolePermission", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.AppRole", "Role")
|
|
.WithMany()
|
|
.HasForeignKey("RoleId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Role");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.UserInvitation", b =>
|
|
{
|
|
b.HasOne("ROLAC.API.Entities.AppUser", "User")
|
|
.WithMany()
|
|
.HasForeignKey("UserId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("User");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.AppUser", b =>
|
|
{
|
|
b.Navigation("RefreshTokens");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Check", b =>
|
|
{
|
|
b.Navigation("Lines");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.Expense", b =>
|
|
{
|
|
b.Navigation("Lines");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseCategoryGroup", b =>
|
|
{
|
|
b.Navigation("SubCategories");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.ExpenseSnapshot", b =>
|
|
{
|
|
b.Navigation("Lines");
|
|
});
|
|
|
|
modelBuilder.Entity("ROLAC.API.Entities.OfferingSession", b =>
|
|
{
|
|
b.Navigation("Givings");
|
|
});
|
|
#pragma warning restore 612, 618
|
|
}
|
|
}
|
|
}
|