New_REP_SYSTEM/ERP_Distribution
8
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
refactor/main_flow
ERP_Distribution/Distribution/Migrations/AppDBContextModelSnapshot.cs
T

4421 lines
178 KiB
C#
Raw Permalink Blame History

// <auto-generated />
using System;
using Distribution.Data;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
#nullable disable
namespace Distribution.Migrations
{
[DbContext(typeof(AppDBContext))]
partial class AppDBContextModelSnapshot : ModelSnapshot
{
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "9.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 64);
MySqlModelBuilderExtensions.AutoIncrementColumns(modelBuilder);
modelBuilder.Entity("Distribution.Models.Brand", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int?>("ExternalErpId")
.HasColumnType("int");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.ToTable("Brands");
b.HasData(
new
{
Id = new Guid("21000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Coca-Cola"
},
new
{
Id = new Guid("21000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Lays"
});
});
modelBuilder.Entity("Distribution.Models.Category", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<bool>("AllowCustomerReturn")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int?>("ExternalErpId")
.HasColumnType("int");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.ToTable("Categories");
b.HasData(
new
{
Id = new Guid("20000000-0000-0000-0000-000000000001"),
AllowCustomerReturn = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Beverages"
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000002"),
AllowCustomerReturn = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Snacks"
});
});
modelBuilder.Entity("Distribution.Models.Claim", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Details")
.IsRequired()
.HasColumnType("longtext");
b.Property<Guid>("FK_AgencyUserId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("SettledAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("SettledByUserId")
.HasColumnType("char(36)");
b.Property<decimal?>("SettlementAmount")
.HasColumnType("decimal(65,30)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_AgencyUserId");
b.HasIndex("SettledByUserId");
b.ToTable("Claims");
b.HasData(
new
{
Id = new Guid("53000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 27, 0, 0, 0, 0, DateTimeKind.Unspecified),
Details = "Distributor margin claim for Q3 promotional shortfall",
FK_AgencyUserId = new Guid("70000000-0000-0000-0000-000000000001"),
IsActive = true,
SettledAt = new DateTime(2026, 8, 28, 0, 0, 0, 0, DateTimeKind.Unspecified),
SettledByUserId = new Guid("29000000-0000-0000-0000-000000000006"),
SettlementAmount = 15000m,
Status = 1
});
});
modelBuilder.Entity("Distribution.Models.CreditNote", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal>("Amount")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_SaleReturnId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("IssuedAt")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_SaleReturnId");
b.ToTable("CreditNotes");
b.HasData(
new
{
Id = new Guid("54000000-0000-0000-0000-000000000001"),
Amount = 300m,
CreatedAt = new DateTime(2026, 8, 26, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_SaleReturnId = new Guid("51000000-0000-0000-0000-000000000001"),
IsActive = true,
IssuedAt = new DateTime(2026, 8, 26, 0, 0, 0, 0, DateTimeKind.Unspecified)
});
});
modelBuilder.Entity("Distribution.Models.DeliveryRun", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("CancelReason")
.HasColumnType("longtext");
b.Property<int?>("CancelTypeCode")
.HasColumnType("int");
b.Property<DateTime?>("ClosedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_DriverProfileId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_VehicleId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Meterend")
.HasColumnType("int");
b.Property<int>("Meterstart")
.HasColumnType("int");
b.Property<DateTime?>("StartedAt")
.HasColumnType("datetime(6)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_DriverProfileId");
b.HasIndex("FK_VehicleId");
b.ToTable("DeliveryRuns");
b.HasData(
new
{
Id = new Guid("31000000-0000-0000-0000-000000000001"),
ClosedAt = new DateTime(2026, 8, 25, 14, 0, 0, 0, DateTimeKind.Unspecified),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
FK_DriverProfileId = new Guid("30000000-0000-0000-0000-000000000001"),
FK_VehicleId = new Guid("28000000-0000-0000-0000-000000000001"),
IsActive = true,
Meterend = 10550,
Meterstart = 10500,
StartedAt = new DateTime(2026, 8, 25, 8, 0, 0, 0, DateTimeKind.Unspecified),
Status = 2
},
new
{
Id = new Guid("31000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 30, 8, 45, 0, 0, DateTimeKind.Unspecified),
FK_DriverProfileId = new Guid("30000000-0000-0000-0000-000000000002"),
FK_VehicleId = new Guid("28000000-0000-0000-0000-000000000002"),
IsActive = true,
Meterend = 0,
Meterstart = 20300,
StartedAt = new DateTime(2026, 8, 30, 9, 0, 0, 0, DateTimeKind.Unspecified),
Status = 0
});
});
modelBuilder.Entity("Distribution.Models.DeliveryTask", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime?>("ConfirmedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("CustomerConfirmed")
.HasColumnType("tinyint(1)");
b.Property<Guid>("FK_RideId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Note")
.HasColumnType("longtext");
b.Property<int>("Sequence")
.HasColumnType("int");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_RideId");
b.HasIndex("FK_ShopPOId");
b.ToTable("DeliveryTasks");
b.HasData(
new
{
Id = new Guid("37000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 30, 10, 5, 0, 0, DateTimeKind.Unspecified),
CustomerConfirmed = false,
FK_RideId = new Guid("31000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000002"),
IsActive = true,
Sequence = 1,
Status = 0
});
});
modelBuilder.Entity("Distribution.Models.DriverComplianceConfig", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<bool>("EnforceLicenseExpiry")
.HasColumnType("tinyint(1)");
b.Property<bool>("EnforceMedicalClearance")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("UpdatedBy")
.HasColumnType("char(36)");
b.HasKey("Id");
b.ToTable("DriverComplianceConfigs");
b.HasData(
new
{
Id = new Guid("64000000-0000-0000-0000-000000000001"),
EnforceLicenseExpiry = true,
EnforceMedicalClearance = true,
UpdatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
UpdatedBy = new Guid("29000000-0000-0000-0000-000000000001")
});
});
modelBuilder.Entity("Distribution.Models.DriverProfile", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("LicenseExpiry")
.HasColumnType("datetime(6)");
b.Property<string>("LicenseNumber")
.IsRequired()
.HasColumnType("longtext");
b.Property<DateTime>("MedicalClearanceExpiry")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_UserId")
.IsUnique();
b.ToTable("DriverProfiles");
b.HasData(
new
{
Id = new Guid("30000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_UserId = new Guid("29000000-0000-0000-0000-000000000004"),
IsActive = true,
LicenseExpiry = new DateTime(2027, 6, 30, 0, 0, 0, 0, DateTimeKind.Unspecified),
LicenseNumber = "B1234567",
MedicalClearanceExpiry = new DateTime(2027, 1, 31, 0, 0, 0, 0, DateTimeKind.Unspecified)
},
new
{
Id = new Guid("30000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_UserId = new Guid("29000000-0000-0000-0000-000000000005"),
IsActive = true,
LicenseExpiry = new DateTime(2027, 9, 30, 0, 0, 0, 0, DateTimeKind.Unspecified),
LicenseNumber = "B7654321",
MedicalClearanceExpiry = new DateTime(2027, 3, 31, 0, 0, 0, 0, DateTimeKind.Unspecified)
});
});
modelBuilder.Entity("Distribution.Models.GoodsReceipt", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("DiscountPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.Property<Guid?>("FK_PurchaseOrderId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ReceivedByUserId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_SupplierId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_WarehouseId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("NbtPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.Property<DateTime>("ReceivedAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("VatPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.HasKey("Id");
b.HasIndex("FK_PurchaseOrderId");
b.HasIndex("FK_SupplierId");
b.HasIndex("FK_WarehouseId");
b.ToTable("GoodsReceipts");
b.HasData(
new
{
Id = new Guid("43000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
DiscountPercent = 0m,
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000001"),
FK_ReceivedByUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_WarehouseId = new Guid("27000000-0000-0000-0000-000000000001"),
IsActive = true,
NbtPercent = 0m,
ReceivedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
VatPercent = 0m
});
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<int>("AcceptedQuantity")
.HasColumnType("int");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("DiscountPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.Property<Guid>("FK_GoodsReceiptId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_PurchaseOrderItemId")
.HasColumnType("char(36)");
b.Property<int>("FreeQuantity")
.HasColumnType("int");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("NbtPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.Property<int>("RejectedQuantity")
.HasColumnType("int");
b.Property<decimal>("UnitCost")
.HasPrecision(18, 2)
.HasColumnType("decimal(18,2)");
b.Property<decimal>("VatPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.HasKey("Id");
b.HasIndex("FK_GoodsReceiptId");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_PurchaseOrderItemId");
b.ToTable("GoodsReceiptItems");
b.HasData(
new
{
Id = new Guid("44000000-0000-0000-0000-000000000001"),
AcceptedQuantity = 200,
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
DiscountPercent = 0m,
FK_GoodsReceiptId = new Guid("43000000-0000-0000-0000-000000000001"),
FK_PurchaseOrderItemId = new Guid("42000000-0000-0000-0000-000000000001"),
FreeQuantity = 0,
IsActive = true,
NbtPercent = 0m,
RejectedQuantity = 0,
UnitCost = 0m,
VatPercent = 0m
},
new
{
Id = new Guid("44000000-0000-0000-0000-000000000002"),
AcceptedQuantity = 98,
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
DiscountPercent = 0m,
FK_GoodsReceiptId = new Guid("43000000-0000-0000-0000-000000000001"),
FK_PurchaseOrderItemId = new Guid("42000000-0000-0000-0000-000000000002"),
FreeQuantity = 0,
IsActive = true,
NbtPercent = 0m,
RejectedQuantity = 2,
UnitCost = 0m,
VatPercent = 0m
});
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItemBatch", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_GoodsReceiptItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemBatchId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Quantity")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_GoodsReceiptItemId");
b.HasIndex("FK_ItemBatchId");
b.ToTable("GoodsReceiptItemBatches");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItemSerial", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_GoodsReceiptItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemSerialNumberId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.HasIndex("FK_GoodsReceiptItemId");
b.HasIndex("FK_ItemSerialNumberId");
b.ToTable("GoodsReceiptItemSerials");
});
modelBuilder.Entity("Distribution.Models.Invoice", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("CreatedBy")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<DateTime?>("FinalizedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("FinalizedBy")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("PaymentStatus")
.HasColumnType("int");
b.Property<DateTime?>("PrintedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("PrintedBy")
.HasColumnType("char(36)");
b.Property<int>("Status")
.HasColumnType("int");
b.Property<decimal>("TotalAmount")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ShopPOId");
b.ToTable("Invoices");
b.HasData(
new
{
Id = new Guid("34500000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 8, 30, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
FinalizedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FinalizedBy = new Guid("29000000-0000-0000-0000-000000000001"),
IsActive = true,
PaymentStatus = 2,
PrintedAt = new DateTime(2026, 8, 25, 8, 45, 0, 0, DateTimeKind.Unspecified),
PrintedBy = new Guid("29000000-0000-0000-0000-000000000002"),
Status = 2,
TotalAmount = 3000m
},
new
{
Id = new Guid("34500000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 31, 9, 0, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000003"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000003"),
IsActive = true,
PaymentStatus = 1,
PrintedAt = new DateTime(2026, 8, 31, 9, 15, 0, 0, DateTimeKind.Unspecified),
PrintedBy = new Guid("29000000-0000-0000-0000-000000000003"),
Status = 1,
TotalAmount = 2400m
});
});
modelBuilder.Entity("Distribution.Models.Item", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<bool>("AllowCustomWarrantyPeriod")
.HasColumnType("tinyint(1)");
b.Property<decimal?>("CostPrice")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Description")
.HasColumnType("longtext");
b.Property<int?>("ExternalErpItemId")
.HasColumnType("int");
b.Property<Guid>("FK_BaseUomId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_BrandId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_CategoryId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_SubCategoryId")
.HasColumnType("char(36)");
b.Property<bool>("HasWarranty")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("LastSyncedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<decimal?>("ReorderLevel")
.HasColumnType("decimal(65,30)");
b.Property<decimal?>("SalePrice")
.HasColumnType("decimal(65,30)");
b.Property<string>("Sku")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("SyncSource")
.HasColumnType("int");
b.Property<bool>("TracksBatches")
.HasColumnType("tinyint(1)");
b.Property<bool>("TracksExpiryDate")
.HasColumnType("tinyint(1)");
b.Property<bool>("TracksSerialNumbers")
.HasColumnType("tinyint(1)");
b.Property<int?>("WarrantyPeriodDays")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_BaseUomId");
b.HasIndex("FK_BrandId");
b.HasIndex("FK_CategoryId");
b.HasIndex("FK_SubCategoryId");
b.ToTable("Items");
b.HasData(
new
{
Id = new Guid("23000000-0000-0000-0000-000000000001"),
AllowCustomWarrantyPeriod = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Coca-Cola 500ml bottle",
FK_BaseUomId = new Guid("22000000-0000-0000-0000-000000000001"),
FK_BrandId = new Guid("21000000-0000-0000-0000-000000000001"),
FK_CategoryId = new Guid("20000000-0000-0000-0000-000000000001"),
HasWarranty = false,
IsActive = true,
Name = "Coca-Cola 500ml",
SalePrice = 60m,
Sku = "BEV-COKE-500",
SyncSource = 0,
TracksBatches = false,
TracksExpiryDate = false,
TracksSerialNumbers = false
},
new
{
Id = new Guid("23000000-0000-0000-0000-000000000002"),
AllowCustomWarrantyPeriod = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Coca-Cola 1.5L bottle",
FK_BaseUomId = new Guid("22000000-0000-0000-0000-000000000001"),
FK_BrandId = new Guid("21000000-0000-0000-0000-000000000001"),
FK_CategoryId = new Guid("20000000-0000-0000-0000-000000000001"),
HasWarranty = false,
IsActive = true,
Name = "Coca-Cola 1.5L",
SalePrice = 120m,
Sku = "BEV-COKE-1500",
SyncSource = 0,
TracksBatches = false,
TracksExpiryDate = false,
TracksSerialNumbers = false
},
new
{
Id = new Guid("23000000-0000-0000-0000-000000000003"),
AllowCustomWarrantyPeriod = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Lays Classic Salted 52g pack",
FK_BaseUomId = new Guid("22000000-0000-0000-0000-000000000001"),
FK_BrandId = new Guid("21000000-0000-0000-0000-000000000002"),
FK_CategoryId = new Guid("20000000-0000-0000-0000-000000000002"),
HasWarranty = false,
IsActive = true,
Name = "Lays Classic 52g",
SalePrice = 50m,
Sku = "SNK-LAYS-52",
SyncSource = 0,
TracksBatches = false,
TracksExpiryDate = false,
TracksSerialNumbers = false
},
new
{
Id = new Guid("23000000-0000-0000-0000-000000000004"),
AllowCustomWarrantyPeriod = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Lays Family Pack 150g",
FK_BaseUomId = new Guid("22000000-0000-0000-0000-000000000001"),
FK_BrandId = new Guid("21000000-0000-0000-0000-000000000002"),
FK_CategoryId = new Guid("20000000-0000-0000-0000-000000000002"),
HasWarranty = false,
IsActive = true,
Name = "Lays Family Pack 150g",
SalePrice = 150m,
Sku = "SNK-LAYS-FAM",
SyncSource = 0,
TracksBatches = false,
TracksExpiryDate = false,
TracksSerialNumbers = false
});
});
modelBuilder.Entity("Distribution.Models.ItemBatch", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("BatchNumber")
.HasColumnType("varchar(255)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime?>("ExpiryDate")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("ManufactureDate")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_ItemId", "BatchNumber");
b.ToTable("ItemBatches");
});
modelBuilder.Entity("Distribution.Models.ItemSerialNumber", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("CurrentLocationId")
.HasColumnType("char(36)");
b.Property<int?>("CurrentLocationType")
.HasColumnType("int");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("ReceivedAt")
.HasColumnType("datetime(6)");
b.Property<string>("SerialNumber")
.IsRequired()
.HasColumnType("varchar(255)");
b.Property<int>("Status")
.HasColumnType("int");
b.Property<DateTime?>("WarrantyExpiresAt")
.HasColumnType("datetime(6)");
b.Property<int?>("WarrantyPeriodDaysOverride")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_ItemId", "SerialNumber")
.IsUnique();
b.ToTable("ItemSerialNumbers");
});
modelBuilder.Entity("Distribution.Models.LoadingSheet", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime?>("ConfirmedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("ConfirmedBy")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RideId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("PopulatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("PopulatedBy")
.HasColumnType("char(36)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_RideId");
b.ToTable("LoadingSheets");
b.HasData(
new
{
Id = new Guid("35000000-0000-0000-0000-000000000001"),
ConfirmedAt = new DateTime(2026, 8, 25, 7, 45, 0, 0, DateTimeKind.Unspecified),
ConfirmedBy = new Guid("29000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
FK_RideId = new Guid("31000000-0000-0000-0000-000000000001"),
IsActive = true,
PopulatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
PopulatedBy = new Guid("29000000-0000-0000-0000-000000000001"),
Status = 1
});
});
modelBuilder.Entity("Distribution.Models.LoadingSheetItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_LoadingSheetId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ShopPOItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_WarehouseId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("QuantityDispatched")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_LoadingSheetId");
b.HasIndex("FK_ShopPOItemId");
b.HasIndex("FK_WarehouseId");
b.ToTable("LoadingSheetItems");
b.HasData(
new
{
Id = new Guid("36000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_LoadingSheetId = new Guid("35000000-0000-0000-0000-000000000001"),
FK_WarehouseId = new Guid("27000000-0000-0000-0000-000000000001"),
IsActive = true,
QuantityDispatched = 50m
},
new
{
Id = new Guid("36000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_LoadingSheetId = new Guid("35000000-0000-0000-0000-000000000001"),
FK_WarehouseId = new Guid("27000000-0000-0000-0000-000000000001"),
IsActive = true,
QuantityDispatched = 30m
});
});
modelBuilder.Entity("Distribution.Models.LoadingSheetOrder", b =>
{
b.Property<Guid>("FK_LoadingSheetId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.HasKey("FK_LoadingSheetId", "FK_ShopPOId");
b.HasIndex("FK_ShopPOId");
b.ToTable("LoadingSheetOrders");
});
modelBuilder.Entity("Distribution.Models.Payment", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal>("Amount")
.HasColumnType("decimal(65,30)");
b.Property<DateTime?>("ChequeDate")
.HasColumnType("datetime(6)");
b.Property<string>("ChequeNumber")
.HasColumnType("longtext");
b.Property<DateTime>("CollectedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("CollectedBy")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int>("EntryMode")
.HasColumnType("int");
b.Property<Guid>("FK_InvoiceId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Method")
.HasColumnType("int");
b.Property<Guid?>("RecordedBy")
.HasColumnType("char(36)");
b.HasKey("Id");
b.HasIndex("FK_InvoiceId");
b.ToTable("Payments");
b.HasData(
new
{
Id = new Guid("47000000-0000-0000-0000-000000000001"),
Amount = 3000m,
CollectedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified),
CollectedBy = new Guid("29000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified),
EntryMode = 0,
FK_InvoiceId = new Guid("34500000-0000-0000-0000-000000000001"),
IsActive = true,
Method = 0
},
new
{
Id = new Guid("47000000-0000-0000-0000-000000000002"),
Amount = 1000m,
CollectedAt = new DateTime(2026, 8, 31, 9, 20, 0, 0, DateTimeKind.Unspecified),
CollectedBy = new Guid("29000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 31, 9, 20, 0, 0, DateTimeKind.Unspecified),
EntryMode = 0,
FK_InvoiceId = new Guid("34500000-0000-0000-0000-000000000002"),
IsActive = true,
Method = 0
},
new
{
Id = new Guid("47000000-0000-0000-0000-000000000003"),
Amount = 800m,
ChequeDate = new DateTime(2026, 8, 31, 0, 0, 0, 0, DateTimeKind.Unspecified),
ChequeNumber = "000456",
CollectedAt = new DateTime(2026, 8, 31, 11, 0, 0, 0, DateTimeKind.Unspecified),
CollectedBy = new Guid("29000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 31, 18, 0, 0, 0, DateTimeKind.Unspecified),
EntryMode = 1,
FK_InvoiceId = new Guid("34500000-0000-0000-0000-000000000002"),
IsActive = true,
Method = 1,
RecordedBy = new Guid("29000000-0000-0000-0000-000000000001")
},
new
{
Id = new Guid("47000000-0000-0000-0000-000000000004"),
Amount = 300m,
CollectedAt = new DateTime(2026, 8, 31, 11, 5, 0, 0, DateTimeKind.Unspecified),
CollectedBy = new Guid("29000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 31, 11, 5, 0, 0, DateTimeKind.Unspecified),
EntryMode = 0,
FK_InvoiceId = new Guid("34500000-0000-0000-0000-000000000002"),
IsActive = true,
Method = 2
});
});
modelBuilder.Entity("Distribution.Models.Permission", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("Code")
.IsRequired()
.HasColumnType("longtext");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.ToTable("Permissions");
});
modelBuilder.Entity("Distribution.Models.PriceList", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("EffectiveFrom")
.HasColumnType("datetime(6)");
b.Property<DateTime>("EffectiveTo")
.HasColumnType("datetime(6)");
b.Property<Guid?>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_RegionId");
b.ToTable("PriceLists");
b.HasData(
new
{
Id = new Guid("39000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
EffectiveFrom = new DateTime(2026, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
EffectiveTo = new DateTime(2026, 12, 31, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Name = "Western Province Price List"
});
});
modelBuilder.Entity("Distribution.Models.PriceListItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal?>("AgencyMarginPercent")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PriceListId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal?>("MinPrice")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("Price")
.HasColumnType("decimal(65,30)");
b.Property<decimal?>("RetailPrice")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_PriceListId", "FK_ItemId")
.IsUnique();
b.ToTable("PriceListItems");
b.HasData(
new
{
Id = new Guid("40000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_PriceListId = new Guid("39000000-0000-0000-0000-000000000001"),
IsActive = true,
MinPrice = 55m,
Price = 60m
},
new
{
Id = new Guid("40000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_PriceListId = new Guid("39000000-0000-0000-0000-000000000001"),
IsActive = true,
MinPrice = 45m,
Price = 50m
});
});
modelBuilder.Entity("Distribution.Models.PurchaseOrder", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("CancelReason")
.HasColumnType("longtext");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_CreatedByUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SupplierId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_SupplierId");
b.ToTable("PurchaseOrders");
b.HasData(
new
{
Id = new Guid("41000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_CreatedByUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_SupplierId = new Guid("38000000-0000-0000-0000-000000000001"),
IsActive = true,
Status = 2
},
new
{
Id = new Guid("41000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_CreatedByUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_SupplierId = new Guid("38000000-0000-0000-0000-000000000002"),
IsActive = true,
Status = 2
});
});
modelBuilder.Entity("Distribution.Models.PurchaseOrderItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<int>("CancelledQuantity")
.HasColumnType("int");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PurchaseOrderId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsCancelled")
.HasColumnType("tinyint(1)");
b.Property<int>("Quantity")
.HasColumnType("int");
b.Property<int>("ReceivedQuantity")
.HasColumnType("int");
b.Property<decimal>("UnitCost")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_PurchaseOrderId");
b.ToTable("PurchaseOrderItems");
b.HasData(
new
{
Id = new Guid("42000000-0000-0000-0000-000000000001"),
CancelledQuantity = 0,
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000001"),
IsActive = true,
IsCancelled = false,
Quantity = 200,
ReceivedQuantity = 200,
UnitCost = 40m
},
new
{
Id = new Guid("42000000-0000-0000-0000-000000000002"),
CancelledQuantity = 0,
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000002"),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000001"),
IsActive = true,
IsCancelled = false,
Quantity = 100,
ReceivedQuantity = 98,
UnitCost = 80m
},
new
{
Id = new Guid("42000000-0000-0000-0000-000000000003"),
CancelledQuantity = 0,
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000002"),
IsActive = true,
IsCancelled = false,
Quantity = 150,
ReceivedQuantity = 150,
UnitCost = 35m
});
});
modelBuilder.Entity("Distribution.Models.PurchaseReturn", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_PurchaseOrderId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Reason")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_PurchaseOrderId");
b.ToTable("PurchaseReturns");
b.HasData(
new
{
Id = new Guid("45000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 16, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000002"),
IsActive = true,
Reason = "Damaged in transit"
});
});
modelBuilder.Entity("Distribution.Models.PurchaseReturnItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PurchaseReturnId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Quantity")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_PurchaseReturnId");
b.ToTable("PurchaseReturnItems");
b.HasData(
new
{
Id = new Guid("46000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 16, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_PurchaseReturnId = new Guid("45000000-0000-0000-0000-000000000001"),
IsActive = true,
Quantity = 10
});
});
modelBuilder.Entity("Distribution.Models.Region", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("Code")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("varchar(50)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("Code")
.IsUnique();
b.ToTable("Regions");
b.HasData(
new
{
Id = new Guid("24000000-0000-0000-0000-000000000001"),
Code = "REG-0001",
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Western Province"
},
new
{
Id = new Guid("24000000-0000-0000-0000-000000000002"),
Code = "REG-0002",
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Central Province"
});
});
modelBuilder.Entity("Distribution.Models.RegionAgencyMap", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_AgencyUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.HasIndex("FK_AgencyUserId");
b.HasIndex("FK_RegionId", "FK_AgencyUserId")
.IsUnique();
b.ToTable("RegionAgencyMaps");
b.HasData(
new
{
Id = new Guid("57000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_AgencyUserId = new Guid("70000000-0000-0000-0000-000000000001"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.RegionalBudget", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal>("BudgetAmount")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Period")
.IsRequired()
.HasColumnType("varchar(255)");
b.HasKey("Id");
b.HasIndex("FK_RegionId", "Period")
.IsUnique();
b.ToTable("RegionalBudgets");
b.HasData(
new
{
Id = new Guid("58000000-0000-0000-0000-000000000001"),
BudgetAmount = 200000m,
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Period = "2026-08"
});
});
modelBuilder.Entity("Distribution.Models.RegionalTarget", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Period")
.IsRequired()
.HasColumnType("varchar(255)");
b.Property<decimal>("TargetValue")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_RegionId", "Period")
.IsUnique();
b.ToTable("RegionalTargets");
b.HasData(
new
{
Id = new Guid("59000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Period = "2026-08",
TargetValue = 500000m
});
});
modelBuilder.Entity("Distribution.Models.RegionalTaxRule", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("RuleConfig")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_RegionId")
.IsUnique();
b.ToTable("RegionalTaxRules");
b.HasData(
new
{
Id = new Guid("60000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
RuleConfig = "{\"rate\": 0.15}"
});
});
modelBuilder.Entity("Distribution.Models.Role", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Level")
.HasColumnType("int");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.ToTable("Roles");
b.HasData(
new
{
Id = new Guid("10000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 10,
Name = "SalesRep"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 20,
Name = "Supervisor"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 30,
Name = "AreaManager"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 40,
Name = "AreaSupervisor"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 50,
Name = "RegionalManager"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000006"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 60,
Name = "RegionalAgency"
});
});
modelBuilder.Entity("Distribution.Models.RolePermission", b =>
{
b.Property<Guid>("FK_RoleId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PermissionId")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("Id")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("FK_RoleId", "FK_PermissionId");
b.HasIndex("FK_PermissionId");
b.ToTable("RolePermissions");
});
modelBuilder.Entity("Distribution.Models.Route", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("EndPoint")
.HasColumnType("longtext");
b.Property<Guid?>("FK_OwnerUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal?>("Length")
.HasColumnType("decimal(65,30)");
b.Property<string>("RouteName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("StartPoint")
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_OwnerUserId");
b.HasIndex("FK_RegionId");
b.ToTable("Routes");
b.HasData(
new
{
Id = new Guid("25000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
EndPoint = "Dehiwala",
FK_OwnerUserId = new Guid("29000000-0000-0000-0000-000000000002"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Length = 18.5m,
RouteName = "Colombo City Route",
StartPoint = "Colombo Fort"
},
new
{
Id = new Guid("25000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
EndPoint = "Negombo",
FK_OwnerUserId = new Guid("29000000-0000-0000-0000-000000000002"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Length = 32.0m,
RouteName = "Negombo Coastal Route",
StartPoint = "Wattala"
},
new
{
Id = new Guid("25000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
EndPoint = "Peradeniya",
FK_OwnerUserId = new Guid("29000000-0000-0000-0000-000000000003"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000002"),
IsActive = true,
Length = 12.0m,
RouteName = "Kandy Town Route",
StartPoint = "Kandy Lake"
},
new
{
Id = new Guid("25000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
EndPoint = "Matale",
FK_OwnerUserId = new Guid("29000000-0000-0000-0000-000000000003"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000002"),
IsActive = true,
Length = 26.0m,
RouteName = "Matale Route",
StartPoint = "Kandy"
});
});
modelBuilder.Entity("Distribution.Models.RouteVisitLog", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CheckInAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("CheckInLatitude")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("CheckInLongitude")
.HasColumnType("decimal(65,30)");
b.Property<DateTime?>("CheckOutAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RouteId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_StoreId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsDeviationFlagged")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.HasIndex("FK_RouteId");
b.HasIndex("FK_StoreId");
b.HasIndex("FK_UserId");
b.ToTable("RouteVisitLogs");
b.HasData(
new
{
Id = new Guid("66000000-0000-0000-0000-000000000001"),
CheckInAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
CheckInLatitude = 6.9344m,
CheckInLongitude = 79.8428m,
CheckOutAt = new DateTime(2026, 8, 25, 9, 25, 0, 0, DateTimeKind.Unspecified),
CreatedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000001"),
FK_UserId = new Guid("29000000-0000-0000-0000-000000000002"),
IsActive = true,
IsDeviationFlagged = false
},
new
{
Id = new Guid("66000000-0000-0000-0000-000000000002"),
CheckInAt = new DateTime(2026, 8, 25, 10, 0, 0, 0, DateTimeKind.Unspecified),
CheckInLatitude = 6.9000m,
CheckInLongitude = 79.8654m,
CreatedAt = new DateTime(2026, 8, 25, 10, 0, 0, 0, DateTimeKind.Unspecified),
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000002"),
FK_UserId = new Guid("29000000-0000-0000-0000-000000000002"),
IsActive = true,
IsDeviationFlagged = true
});
});
modelBuilder.Entity("Distribution.Models.SaleReturn", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("CreatedByUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Mode")
.HasColumnType("int");
b.Property<decimal>("TotalCreditAmount")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("CreatedByUserId");
b.HasIndex("FK_ShopPOId");
b.ToTable("SaleReturns");
b.HasData(
new
{
Id = new Guid("51000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 26, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreatedByUserId = new Guid("29000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
IsActive = true,
Mode = 0,
TotalCreditAmount = 300m
});
});
modelBuilder.Entity("Distribution.Models.SaleReturnItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SaleReturnId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("Quantity")
.HasColumnType("decimal(65,30)");
b.Property<int>("ReasonCode")
.HasColumnType("int");
b.Property<decimal>("UnitPrice")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_SaleReturnId");
b.ToTable("SaleReturnItems");
b.HasData(
new
{
Id = new Guid("52000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 26, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_SaleReturnId = new Guid("51000000-0000-0000-0000-000000000001"),
IsActive = true,
Quantity = 5m,
ReasonCode = 1,
UnitPrice = 60m
});
});
modelBuilder.Entity("Distribution.Models.SaleRoute", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.ToTable("SaleRoutes");
b.HasData(
new
{
Id = new Guid("69000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true
},
new
{
Id = new Guid("69000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.Scheme", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<bool>("AgentLimitExempt")
.HasColumnType("tinyint(1)");
b.Property<decimal?>("BaselineExpectedSales")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("DateRangeFrom")
.HasColumnType("datetime(6)");
b.Property<DateTime>("DateRangeTo")
.HasColumnType("datetime(6)");
b.Property<string>("EligibleSegment")
.HasColumnType("longtext");
b.Property<Guid?>("FK_FreeItemId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_TriggerItemId")
.HasColumnType("char(36)");
b.Property<decimal?>("FreeQty")
.HasColumnType("decimal(65,30)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<Guid?>("RegionId")
.HasColumnType("char(36)");
b.Property<string>("RuleConfig")
.HasColumnType("longtext");
b.Property<int>("RuleType")
.HasColumnType("int");
b.Property<int?>("TriggerQty")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_FreeItemId");
b.HasIndex("FK_TriggerItemId");
b.HasIndex("RegionId");
b.ToTable("Schemes");
b.HasData(
new
{
Id = new Guid("48000000-0000-0000-0000-000000000001"),
AgentLimitExempt = false,
BaselineExpectedSales = 500000m,
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DateRangeFrom = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DateRangeTo = new DateTime(2026, 12, 31, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_FreeItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
FK_TriggerItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FreeQty = 1m,
IsActive = true,
Name = "Buy 10 Coke Get 1 Free",
RuleType = 0,
TriggerQty = 10
},
new
{
Id = new Guid("48000000-0000-0000-0000-000000000002"),
AgentLimitExempt = false,
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DateRangeFrom = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DateRangeTo = new DateTime(2026, 12, 31, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_FreeItemId = new Guid("23000000-0000-0000-0000-000000000004"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000002"),
FreeQty = 1m,
IsActive = true,
Name = "Snack Combo Bundle",
RuleType = 3
});
});
modelBuilder.Entity("Distribution.Models.SchemeBundleComponent", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SchemeId")
.HasColumnType("char(36)");
b.Property<int>("Qty")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_SchemeId", "FK_ItemId")
.IsUnique();
b.ToTable("SchemeBundleComponents");
b.HasData(
new
{
Id = new Guid("49000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_SchemeId = new Guid("48000000-0000-0000-0000-000000000002"),
Qty = 5
});
});
modelBuilder.Entity("Distribution.Models.SchemeRedemption", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal?>("DiscountAmount")
.HasColumnType("decimal(65,30)");
b.Property<Guid?>("FK_FreeItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SchemeId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<Guid?>("FieldInvoiceId")
.HasColumnType("char(36)");
b.Property<decimal?>("FreeItemCostValue")
.HasColumnType("decimal(65,30)");
b.Property<decimal?>("FreeQty")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("RedeemedAt")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_FreeItemId");
b.HasIndex("FK_SchemeId");
b.HasIndex("FK_ShopPOId");
b.ToTable("SchemeRedemptions");
b.HasData(
new
{
Id = new Guid("50000000-0000-0000-0000-000000000001"),
DiscountAmount = 0m,
FK_FreeItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_SchemeId = new Guid("48000000-0000-0000-0000-000000000001"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
FreeItemCostValue = 40m,
FreeQty = 1m,
RedeemedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified)
});
});
modelBuilder.Entity("Distribution.Models.ShopPO", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("CancelReason")
.HasColumnType("longtext");
b.Property<DateTime?>("CancelledAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("CancelledBy")
.HasColumnType("char(36)");
b.Property<DateTime?>("ConfirmedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("ConfirmedBy")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_StoreId")
.HasColumnType("char(36)");
b.Property<DateTime?>("FulfilledAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("InvoiceId")
.HasColumnType("char(36)")
.HasColumnName("InvoiceId");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<Guid>("RaisedById")
.HasColumnType("char(36)");
b.Property<int>("Status")
.HasColumnType("int");
b.Property<decimal>("TotalAmount")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_StoreId");
b.ToTable("ShopPOs");
b.HasData(
new
{
Id = new Guid("33000000-0000-0000-0000-000000000001"),
ConfirmedAt = new DateTime(2026, 8, 25, 8, 30, 0, 0, DateTimeKind.Unspecified),
ConfirmedBy = new Guid("29000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000001"),
FulfilledAt = new DateTime(2026, 8, 25, 13, 0, 0, 0, DateTimeKind.Unspecified),
InvoiceId = new Guid("34500000-0000-0000-0000-000000000001"),
IsActive = true,
RaisedById = new Guid("29000000-0000-0000-0000-000000000002"),
Status = 2,
TotalAmount = 3000m
},
new
{
Id = new Guid("33000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 30, 10, 0, 0, 0, DateTimeKind.Unspecified),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000005"),
IsActive = true,
RaisedById = new Guid("29000000-0000-0000-0000-000000000003"),
Status = 0,
TotalAmount = 1200m
},
new
{
Id = new Guid("33000000-0000-0000-0000-000000000003"),
ConfirmedAt = new DateTime(2026, 8, 31, 8, 30, 0, 0, DateTimeKind.Unspecified),
ConfirmedBy = new Guid("29000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 31, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000005"),
FulfilledAt = new DateTime(2026, 8, 31, 13, 0, 0, 0, DateTimeKind.Unspecified),
InvoiceId = new Guid("34500000-0000-0000-0000-000000000002"),
IsActive = true,
RaisedById = new Guid("29000000-0000-0000-0000-000000000003"),
Status = 2,
TotalAmount = 2400m
});
});
modelBuilder.Entity("Distribution.Models.ShopPOItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Quantity")
.HasColumnType("int");
b.Property<int>("QuantityFulfilled")
.HasColumnType("int");
b.Property<decimal>("UnitPrice")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_ShopPOId");
b.ToTable("ShopPOItems");
b.HasData(
new
{
Id = new Guid("34000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
IsActive = true,
Quantity = 30,
QuantityFulfilled = 30,
UnitPrice = 60m
},
new
{
Id = new Guid("34000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
IsActive = true,
Quantity = 24,
QuantityFulfilled = 24,
UnitPrice = 50m
},
new
{
Id = new Guid("34000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 30, 10, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000002"),
IsActive = true,
Quantity = 10,
QuantityFulfilled = 0,
UnitPrice = 120m
},
new
{
Id = new Guid("34000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 31, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000003"),
IsActive = true,
Quantity = 20,
QuantityFulfilled = 20,
UnitPrice = 120m
});
});
modelBuilder.Entity("Distribution.Models.StockBalance", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemBatchId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemSerialNumberId")
.HasColumnType("char(36)");
b.Property<Guid>("LocationId")
.HasColumnType("char(36)");
b.Property<int>("LocationType")
.HasColumnType("int");
b.Property<decimal>("Quantity")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_ItemBatchId");
b.HasIndex("FK_ItemSerialNumberId");
b.HasIndex("FK_ItemId", "LocationId", "FK_ItemBatchId", "FK_ItemSerialNumberId")
.IsUnique();
b.ToTable("StockBalances");
b.HasData(
new
{
Id = new Guid("61000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
LocationId = new Guid("27000000-0000-0000-0000-000000000001"),
LocationType = 0,
Quantity = 150m,
UpdatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified)
},
new
{
Id = new Guid("61000000-0000-0000-0000-000000000002"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
LocationId = new Guid("27000000-0000-0000-0000-000000000001"),
LocationType = 0,
Quantity = 90m,
UpdatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified)
},
new
{
Id = new Guid("61000000-0000-0000-0000-000000000003"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
LocationId = new Guid("28000000-0000-0000-0000-000000000001"),
LocationType = 1,
Quantity = 20m,
UpdatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified)
});
});
modelBuilder.Entity("Distribution.Models.StockMovement", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("CreatedBy")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemBatchId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemSerialNumberId")
.HasColumnType("char(36)");
b.Property<Guid?>("FromLocationId")
.HasColumnType("char(36)");
b.Property<int?>("FromLocationType")
.HasColumnType("int");
b.Property<decimal>("Quantity")
.HasColumnType("decimal(65,30)");
b.Property<string>("ReasonCode")
.HasColumnType("longtext");
b.Property<Guid?>("ReferenceId")
.HasColumnType("char(36)");
b.Property<Guid?>("ToLocationId")
.HasColumnType("char(36)");
b.Property<int?>("ToLocationType")
.HasColumnType("int");
b.Property<int>("Type")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_ItemBatchId");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_ItemSerialNumberId");
b.ToTable("StockMovements");
b.HasData(
new
{
Id = new Guid("62000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FromLocationId = new Guid("00000000-0000-0000-0000-000000000000"),
FromLocationType = 2,
Quantity = 200m,
ReferenceId = new Guid("43000000-0000-0000-0000-000000000001"),
ToLocationId = new Guid("27000000-0000-0000-0000-000000000001"),
ToLocationType = 0,
Type = 6
},
new
{
Id = new Guid("62000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FromLocationId = new Guid("27000000-0000-0000-0000-000000000001"),
FromLocationType = 0,
Quantity = 50m,
ReferenceId = new Guid("35000000-0000-0000-0000-000000000001"),
ToLocationId = new Guid("28000000-0000-0000-0000-000000000001"),
ToLocationType = 1,
Type = 5
},
new
{
Id = new Guid("62000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000002"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FromLocationId = new Guid("28000000-0000-0000-0000-000000000001"),
FromLocationType = 1,
Quantity = 30m,
ReferenceId = new Guid("32000000-0000-0000-0000-000000000001"),
ToLocationId = new Guid("00000000-0000-0000-0000-000000000000"),
ToLocationType = 2,
Type = 0
});
});
modelBuilder.Entity("Distribution.Models.Store", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("ContactNumber")
.HasColumnType("longtext");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("CreditAmount")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("CreditLimit")
.HasColumnType("decimal(65,30)");
b.Property<Guid>("FK_RouteId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("Latitude")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("Longitude")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("OneTimeAmount")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("OutstandingBalance")
.HasColumnType("decimal(65,30)");
b.Property<string>("OwnerName")
.HasColumnType("longtext");
b.Property<string>("Segment")
.HasColumnType("longtext");
b.Property<string>("StoreAddress")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("StoreName")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_RouteId");
b.ToTable("Stores");
b.HasData(
new
{
Id = new Guid("26000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 50000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
IsActive = true,
Latitude = 6.9344m,
Longitude = 79.8428m,
OneTimeAmount = 0m,
OutstandingBalance = 0m,
OwnerName = "Saman Kumara",
Segment = "Gold",
StoreAddress = "12 York Street, Colombo Fort",
StoreName = "Fort Mini Mart"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 30000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
IsActive = true,
Latitude = 6.8508m,
Longitude = 79.8654m,
OneTimeAmount = 0m,
OutstandingBalance = 5000m,
OwnerName = "Nadeesha Silva",
Segment = "Silver",
StoreAddress = "45 Galle Road, Dehiwala",
StoreName = "Dehiwala Grocery"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 40000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000002"),
IsActive = true,
Latitude = 6.9890m,
Longitude = 79.8912m,
OneTimeAmount = 0m,
OutstandingBalance = 1200m,
OwnerName = "Ruwan Gunasekara",
Segment = "Gold",
StoreAddress = "88 Negombo Road, Wattala",
StoreName = "Wattala Supermarket"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 25000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000002"),
IsActive = true,
Latitude = 7.2094m,
Longitude = 79.8380m,
OneTimeAmount = 0m,
OutstandingBalance = 0m,
OwnerName = "Chamari Peiris",
StoreAddress = "5 Beach Road, Negombo",
StoreName = "Negombo Beach Store"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 35000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000003"),
IsActive = true,
Latitude = 7.2906m,
Longitude = 80.6337m,
OneTimeAmount = 0m,
OutstandingBalance = 0m,
OwnerName = "Dinesh Wickramasinghe",
Segment = "Key Account",
StoreAddress = "3 Lake Road, Kandy",
StoreName = "Kandy Lake View Store"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000006"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 20000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000004"),
IsActive = true,
Latitude = 7.4675m,
Longitude = 80.6234m,
OneTimeAmount = 0m,
OutstandingBalance = 0m,
OwnerName = "Ishara Bandara",
StoreAddress = "20 Main Street, Matale",
StoreName = "Matale Central Store"
});
});
modelBuilder.Entity("Distribution.Models.SubCategory", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int?>("ExternalErpId")
.HasColumnType("int");
b.Property<Guid>("FK_CategoryId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_CategoryId");
b.ToTable("SubCategories");
});
modelBuilder.Entity("Distribution.Models.Supplier", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("ContactInfo")
.HasColumnType("longtext");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<decimal?>("PerformanceScore")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.ToTable("Suppliers");
b.HasData(
new
{
Id = new Guid("38000000-0000-0000-0000-000000000001"),
ContactInfo = "+94 11 234 5678",
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Ceylon Beverages Ltd",
PerformanceScore = 4.2m
},
new
{
Id = new Guid("38000000-0000-0000-0000-000000000002"),
ContactInfo = "+94 11 876 5432",
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Snack Foods (Pvt) Ltd"
});
});
modelBuilder.Entity("Distribution.Models.SupplierClaim", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Details")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("EvidenceUrl")
.HasColumnType("longtext");
b.Property<Guid?>("FK_GoodsReceiptId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PurchaseOrderId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<Guid>("RaisedByUserId")
.HasColumnType("char(36)");
b.Property<decimal?>("ResolutionAmount")
.HasColumnType("decimal(65,30)");
b.Property<string>("ResolutionNotes")
.HasColumnType("longtext");
b.Property<int?>("ResolutionType")
.HasColumnType("int");
b.Property<DateTime?>("ResolvedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("ResolvedByUserId")
.HasColumnType("char(36)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_GoodsReceiptId");
b.HasIndex("FK_PurchaseOrderId");
b.HasIndex("RaisedByUserId");
b.HasIndex("ResolvedByUserId");
b.ToTable("SupplierClaims");
b.HasData(
new
{
Id = new Guid("55000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
Details = "2 units of Coke 1.5L received damaged",
FK_GoodsReceiptId = new Guid("43000000-0000-0000-0000-000000000001"),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000001"),
IsActive = true,
RaisedByUserId = new Guid("29000000-0000-0000-0000-000000000001"),
ResolutionAmount = 160m,
ResolutionNotes = "Credited against next invoice",
ResolutionType = 1,
ResolvedAt = new DateTime(2026, 8, 16, 0, 0, 0, 0, DateTimeKind.Unspecified),
ResolvedByUserId = new Guid("29000000-0000-0000-0000-000000000006"),
Status = 1
});
});
modelBuilder.Entity("Distribution.Models.SupplierClaimItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SupplierClaimId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("IssueType")
.HasColumnType("int");
b.Property<decimal>("Quantity")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_SupplierClaimId");
b.ToTable("SupplierClaimItems");
b.HasData(
new
{
Id = new Guid("56000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000002"),
FK_SupplierClaimId = new Guid("55000000-0000-0000-0000-000000000001"),
IsActive = true,
IssueType = 0,
Quantity = 2m
});
});
modelBuilder.Entity("Distribution.Models.SysConfig", b =>
{
b.Property<string>("Key")
.HasMaxLength(100)
.HasColumnType("varchar(100)");
b.Property<DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("UpdatedBy")
.HasColumnType("char(36)");
b.Property<string>("Value")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Key");
b.ToTable("SysConfigs");
b.HasData(
new
{
Key = "InvoiceCreationMode",
UpdatedAt = new DateTime(2026, 9, 17, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "ModeB"
},
new
{
Key = "Feature.SerialNumberTracking",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.BatchTracking",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.ExpiryDateTracking",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.WarrantyTracking",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.CustomWarrantyOverride",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.DefaultWarrantyPeriodDays",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "0"
});
});
modelBuilder.Entity("Distribution.Models.Uom", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int?>("ExternalErpId")
.HasColumnType("int");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.ToTable("Uoms");
b.HasData(
new
{
Id = new Guid("22000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Piece"
},
new
{
Id = new Guid("67000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Case"
});
});
modelBuilder.Entity("Distribution.Models.UomConversion", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<Guid>("FK_FromUomId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ToUomId")
.HasColumnType("char(36)");
b.Property<decimal>("Factor")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_FromUomId");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_ToUomId");
b.ToTable("UomConversions");
b.HasData(
new
{
Id = new Guid("67000000-0000-0000-0000-000000000002"),
FK_FromUomId = new Guid("67000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_ToUomId = new Guid("22000000-0000-0000-0000-000000000001"),
Factor = 24m
});
});
modelBuilder.Entity("Distribution.Models.User", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("FK_ReportsToUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RoleId")
.HasColumnType("char(36)");
b.Property<string>("FullName")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("PasswordHash")
.IsRequired()
.HasColumnType("longtext");
b.Property<DateTime?>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Username")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_ReportsToUserId");
b.HasIndex("FK_RoleId");
b.ToTable("Users");
b.HasData(
new
{
Id = new Guid("29000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000002"),
FullName = "Sunil Fernando",
IsActive = true,
PasswordHash = "AQAAAAIAAYagAAAAEKGnq/U4j6uM9g5mFkxbUE8WU/AhnSNiwrKCiPAqGnzNcaMgZAF5Zal/rJUUYPZPpg==",
Username = "sunil.fernando"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ReportsToUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000001"),
FullName = "Nimal Perera",
IsActive = true,
PasswordHash = "AQAAAAIAAYagAAAAEKGnq/U4j6uM9g5mFkxbUE8WU/AhnSNiwrKCiPAqGnzNcaMgZAF5Zal/rJUUYPZPpg==",
Username = "nimal.perera"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ReportsToUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000001"),
FullName = "Kamal Silva",
IsActive = true,
PasswordHash = "AQAAAAIAAYagAAAAEKGnq/U4j6uM9g5mFkxbUE8WU/AhnSNiwrKCiPAqGnzNcaMgZAF5Zal/rJUUYPZPpg==",
Username = "kamal.silva"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ReportsToUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000001"),
FullName = "Ruwan Jayasuriya",
IsActive = true,
PasswordHash = "AQAAAAIAAYagAAAAEKGnq/U4j6uM9g5mFkxbUE8WU/AhnSNiwrKCiPAqGnzNcaMgZAF5Zal/rJUUYPZPpg==",
Username = "ruwan.jayasuriya"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ReportsToUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000001"),
FullName = "Priyantha Kumara",
IsActive = true,
PasswordHash = "AQAAAAIAAYagAAAAEKGnq/U4j6uM9g5mFkxbUE8WU/AhnSNiwrKCiPAqGnzNcaMgZAF5Zal/rJUUYPZPpg==",
Username = "priyantha.kumara"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000006"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000005"),
FullName = "Priya Rajapaksa",
IsActive = true,
PasswordHash = "AQAAAAIAAYagAAAAEKGnq/U4j6uM9g5mFkxbUE8WU/AhnSNiwrKCiPAqGnzNcaMgZAF5Zal/rJUUYPZPpg==",
Username = "priya.rajapaksa"
},
new
{
Id = new Guid("70000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000006"),
FullName = "Channa De Silva",
IsActive = true,
PasswordHash = "AQAAAAIAAYagAAAAEKGnq/U4j6uM9g5mFkxbUE8WU/AhnSNiwrKCiPAqGnzNcaMgZAF5Zal/rJUUYPZPpg==",
Username = "channa.desilva"
});
});
modelBuilder.Entity("Distribution.Models.UserRegionScope", b =>
{
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("Id")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("FK_UserId", "FK_RegionId");
b.HasIndex("FK_RegionId");
b.ToTable("UserRegionScopes");
b.HasData(
new
{
FK_UserId = new Guid("29000000-0000-0000-0000-000000000006"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("68000000-0000-0000-0000-000000000001"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.UserRouteScope", b =>
{
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RouteId")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("Id")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("FK_UserId", "FK_RouteId");
b.HasIndex("FK_RouteId");
b.ToTable("UserRouteScopes");
b.HasData(
new
{
FK_UserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("68000000-0000-0000-0000-000000000002"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.UserStoreScope", b =>
{
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_StoreId")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("Id")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("FK_UserId", "FK_StoreId");
b.HasIndex("FK_StoreId");
b.ToTable("UserStoreScopes");
b.HasData(
new
{
FK_UserId = new Guid("29000000-0000-0000-0000-000000000003"),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("68000000-0000-0000-0000-000000000003"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.Vehicle", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("DefaultWarehouseId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("NumberPlate")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("RegNumber")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("Type")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("DefaultWarehouseId");
b.ToTable("Vehicles");
b.HasData(
new
{
Id = new Guid("28000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
DefaultWarehouseId = new Guid("27000000-0000-0000-0000-000000000001"),
IsActive = true,
NumberPlate = "CAB-1234",
RegNumber = "WP-CAB-1234",
Type = 2
},
new
{
Id = new Guid("28000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
DefaultWarehouseId = new Guid("27000000-0000-0000-0000-000000000002"),
IsActive = true,
NumberPlate = "KY-5678",
RegNumber = "CP-KY-5678",
Type = 1
});
});
modelBuilder.Entity("Distribution.Models.Warehouse", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Location")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("Type")
.HasColumnType("int");
b.Property<Guid?>("VehicleId")
.HasColumnType("char(36)");
b.HasKey("Id");
b.HasIndex("VehicleId");
b.ToTable("Warehouses");
b.HasData(
new
{
Id = new Guid("27000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Location = "Peliyagoda, Colombo",
Name = "Colombo Distribution Center",
Type = 0
},
new
{
Id = new Guid("27000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Location = "Katugastota, Kandy",
Name = "Kandy Fulfillment Center",
Type = 1
});
});
modelBuilder.Entity("Distribution.Models.Claim", b =>
{
b.HasOne("Distribution.Models.User", "AgencyUser")
.WithMany()
.HasForeignKey("FK_AgencyUserId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.User", "SettledByUser")
.WithMany()
.HasForeignKey("SettledByUserId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("AgencyUser");
b.Navigation("SettledByUser");
});
modelBuilder.Entity("Distribution.Models.CreditNote", b =>
{
b.HasOne("Distribution.Models.SaleReturn", "SaleReturn")
.WithMany()
.HasForeignKey("FK_SaleReturnId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("SaleReturn");
});
modelBuilder.Entity("Distribution.Models.DeliveryRun", b =>
{
b.HasOne("Distribution.Models.DriverProfile", "DriverProfile")
.WithMany()
.HasForeignKey("FK_DriverProfileId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.Vehicle", "Vehicle")
.WithMany()
.HasForeignKey("FK_VehicleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("DriverProfile");
b.Navigation("Vehicle");
});
modelBuilder.Entity("Distribution.Models.DeliveryTask", b =>
{
b.HasOne("Distribution.Models.DeliveryRun", "Ride")
.WithMany()
.HasForeignKey("FK_RideId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Ride");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.DriverProfile", b =>
{
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.GoodsReceipt", b =>
{
b.HasOne("Distribution.Models.PurchaseOrder", "PurchaseOrder")
.WithMany()
.HasForeignKey("FK_PurchaseOrderId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Supplier", "Supplier")
.WithMany()
.HasForeignKey("FK_SupplierId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Warehouse", "Warehouse")
.WithMany()
.HasForeignKey("FK_WarehouseId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("PurchaseOrder");
b.Navigation("Supplier");
b.Navigation("Warehouse");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItem", b =>
{
b.HasOne("Distribution.Models.GoodsReceipt", "GoodsReceipt")
.WithMany("Items")
.HasForeignKey("FK_GoodsReceiptId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.PurchaseOrderItem", "PurchaseOrderItem")
.WithMany()
.HasForeignKey("FK_PurchaseOrderItemId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("GoodsReceipt");
b.Navigation("Item");
b.Navigation("PurchaseOrderItem");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItemBatch", b =>
{
b.HasOne("Distribution.Models.GoodsReceiptItem", "GoodsReceiptItem")
.WithMany("Batches")
.HasForeignKey("FK_GoodsReceiptItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ItemBatch", "ItemBatch")
.WithMany()
.HasForeignKey("FK_ItemBatchId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("GoodsReceiptItem");
b.Navigation("ItemBatch");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItemSerial", b =>
{
b.HasOne("Distribution.Models.GoodsReceiptItem", "GoodsReceiptItem")
.WithMany("Serials")
.HasForeignKey("FK_GoodsReceiptItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ItemSerialNumber", "ItemSerialNumber")
.WithMany()
.HasForeignKey("FK_ItemSerialNumberId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("GoodsReceiptItem");
b.Navigation("ItemSerialNumber");
});
modelBuilder.Entity("Distribution.Models.Invoice", b =>
{
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.Item", b =>
{
b.HasOne("Distribution.Models.Uom", "BaseUom")
.WithMany()
.HasForeignKey("FK_BaseUomId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Brand", "Brand")
.WithMany()
.HasForeignKey("FK_BrandId");
b.HasOne("Distribution.Models.Category", "Category")
.WithMany()
.HasForeignKey("FK_CategoryId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.SubCategory", "SubCategory")
.WithMany()
.HasForeignKey("FK_SubCategoryId");
b.Navigation("BaseUom");
b.Navigation("Brand");
b.Navigation("Category");
b.Navigation("SubCategory");
});
modelBuilder.Entity("Distribution.Models.ItemBatch", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
});
modelBuilder.Entity("Distribution.Models.ItemSerialNumber", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
});
modelBuilder.Entity("Distribution.Models.LoadingSheet", b =>
{
b.HasOne("Distribution.Models.DeliveryRun", "Ride")
.WithMany()
.HasForeignKey("FK_RideId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Ride");
});
modelBuilder.Entity("Distribution.Models.LoadingSheetItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.LoadingSheet", "LoadingSheet")
.WithMany("Items")
.HasForeignKey("FK_LoadingSheetId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPOItem", "ShopPOItem")
.WithMany()
.HasForeignKey("FK_ShopPOItemId")
.OnDelete(DeleteBehavior.SetNull);
b.HasOne("Distribution.Models.Warehouse", "Warehouse")
.WithMany()
.HasForeignKey("FK_WarehouseId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("LoadingSheet");
b.Navigation("ShopPOItem");
b.Navigation("Warehouse");
});
modelBuilder.Entity("Distribution.Models.LoadingSheetOrder", b =>
{
b.HasOne("Distribution.Models.LoadingSheet", "LoadingSheet")
.WithMany("Orders")
.HasForeignKey("FK_LoadingSheetId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("LoadingSheet");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.Payment", b =>
{
b.HasOne("Distribution.Models.Invoice", "Invoice")
.WithMany("Payments")
.HasForeignKey("FK_InvoiceId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Invoice");
});
modelBuilder.Entity("Distribution.Models.PriceList", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId");
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.PriceListItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.PriceList", "PriceList")
.WithMany("Items")
.HasForeignKey("FK_PriceListId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Item");
b.Navigation("PriceList");
});
modelBuilder.Entity("Distribution.Models.PurchaseOrder", b =>
{
b.HasOne("Distribution.Models.Supplier", "Supplier")
.WithMany()
.HasForeignKey("FK_SupplierId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Supplier");
});
modelBuilder.Entity("Distribution.Models.PurchaseOrderItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.PurchaseOrder", "PurchaseOrder")
.WithMany("Items")
.HasForeignKey("FK_PurchaseOrderId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("PurchaseOrder");
});
modelBuilder.Entity("Distribution.Models.PurchaseReturn", b =>
{
b.HasOne("Distribution.Models.PurchaseOrder", "PurchaseOrder")
.WithMany()
.HasForeignKey("FK_PurchaseOrderId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("PurchaseOrder");
});
modelBuilder.Entity("Distribution.Models.PurchaseReturnItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.PurchaseReturn", "PurchaseReturn")
.WithMany("Items")
.HasForeignKey("FK_PurchaseReturnId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("PurchaseReturn");
});
modelBuilder.Entity("Distribution.Models.RegionAgencyMap", b =>
{
b.HasOne("Distribution.Models.User", "AgencyUser")
.WithMany()
.HasForeignKey("FK_AgencyUserId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("AgencyUser");
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RegionalBudget", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RegionalTarget", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RegionalTaxRule", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RolePermission", b =>
{
b.HasOne("Distribution.Models.Permission", "Permission")
.WithMany()
.HasForeignKey("FK_PermissionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Role", "Role")
.WithMany()
.HasForeignKey("FK_RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Permission");
b.Navigation("Role");
});
modelBuilder.Entity("Distribution.Models.Route", b =>
{
b.HasOne("Distribution.Models.User", "OwnerUser")
.WithMany()
.HasForeignKey("FK_OwnerUserId");
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("OwnerUser");
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RouteVisitLog", b =>
{
b.HasOne("Distribution.Models.Route", "Route")
.WithMany()
.HasForeignKey("FK_RouteId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Store", "Store")
.WithMany()
.HasForeignKey("FK_StoreId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Route");
b.Navigation("Store");
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.SaleReturn", b =>
{
b.HasOne("Distribution.Models.User", "CreatedByUser")
.WithMany()
.HasForeignKey("CreatedByUserId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("CreatedByUser");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.SaleReturnItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.SaleReturn", "SaleReturn")
.WithMany("Items")
.HasForeignKey("FK_SaleReturnId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("SaleReturn");
});
modelBuilder.Entity("Distribution.Models.Scheme", b =>
{
b.HasOne("Distribution.Models.Item", "FreeItem")
.WithMany()
.HasForeignKey("FK_FreeItemId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Item", "TriggerItem")
.WithMany()
.HasForeignKey("FK_TriggerItemId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("RegionId");
b.Navigation("FreeItem");
b.Navigation("Region");
b.Navigation("TriggerItem");
});
modelBuilder.Entity("Distribution.Models.SchemeBundleComponent", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.Scheme", "Scheme")
.WithMany("BundleComponents")
.HasForeignKey("FK_SchemeId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Item");
b.Navigation("Scheme");
});
modelBuilder.Entity("Distribution.Models.SchemeRedemption", b =>
{
b.HasOne("Distribution.Models.Item", "FreeItem")
.WithMany()
.HasForeignKey("FK_FreeItemId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Scheme", "Scheme")
.WithMany("Redemptions")
.HasForeignKey("FK_SchemeId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("FreeItem");
b.Navigation("Scheme");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.ShopPO", b =>
{
b.HasOne("Distribution.Models.Store", "Store")
.WithMany()
.HasForeignKey("FK_StoreId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Store");
});
modelBuilder.Entity("Distribution.Models.ShopPOItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany("Items")
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.StockBalance", b =>
{
b.HasOne("Distribution.Models.ItemBatch", "ItemBatch")
.WithMany()
.HasForeignKey("FK_ItemBatchId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.ItemSerialNumber", "ItemSerialNumber")
.WithMany()
.HasForeignKey("FK_ItemSerialNumberId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("Item");
b.Navigation("ItemBatch");
b.Navigation("ItemSerialNumber");
});
modelBuilder.Entity("Distribution.Models.StockMovement", b =>
{
b.HasOne("Distribution.Models.ItemBatch", "ItemBatch")
.WithMany()
.HasForeignKey("FK_ItemBatchId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.ItemSerialNumber", "ItemSerialNumber")
.WithMany()
.HasForeignKey("FK_ItemSerialNumberId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("Item");
b.Navigation("ItemBatch");
b.Navigation("ItemSerialNumber");
});
modelBuilder.Entity("Distribution.Models.Store", b =>
{
b.HasOne("Distribution.Models.Route", "Route")
.WithMany()
.HasForeignKey("FK_RouteId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Route");
});
modelBuilder.Entity("Distribution.Models.SubCategory", b =>
{
b.HasOne("Distribution.Models.Category", "Category")
.WithMany()
.HasForeignKey("FK_CategoryId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Category");
});
modelBuilder.Entity("Distribution.Models.SupplierClaim", b =>
{
b.HasOne("Distribution.Models.GoodsReceipt", "GoodsReceipt")
.WithMany()
.HasForeignKey("FK_GoodsReceiptId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.PurchaseOrder", "PurchaseOrder")
.WithMany()
.HasForeignKey("FK_PurchaseOrderId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.User", "RaisedByUser")
.WithMany()
.HasForeignKey("RaisedByUserId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.User", "ResolvedByUser")
.WithMany()
.HasForeignKey("ResolvedByUserId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("GoodsReceipt");
b.Navigation("PurchaseOrder");
b.Navigation("RaisedByUser");
b.Navigation("ResolvedByUser");
});
modelBuilder.Entity("Distribution.Models.SupplierClaimItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.SupplierClaim", "SupplierClaim")
.WithMany("Items")
.HasForeignKey("FK_SupplierClaimId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("SupplierClaim");
});
modelBuilder.Entity("Distribution.Models.UomConversion", b =>
{
b.HasOne("Distribution.Models.Uom", "FromUom")
.WithMany()
.HasForeignKey("FK_FromUomId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Item", "Item")
.WithMany("Conversions")
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Uom", "ToUom")
.WithMany()
.HasForeignKey("FK_ToUomId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("FromUom");
b.Navigation("Item");
b.Navigation("ToUom");
});
modelBuilder.Entity("Distribution.Models.User", b =>
{
b.HasOne("Distribution.Models.User", "ReportsTo")
.WithMany()
.HasForeignKey("FK_ReportsToUserId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Role", "Role")
.WithMany()
.HasForeignKey("FK_RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("ReportsTo");
b.Navigation("Role");
});
modelBuilder.Entity("Distribution.Models.UserRegionScope", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Region");
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.UserRouteScope", b =>
{
b.HasOne("Distribution.Models.Route", "Route")
.WithMany()
.HasForeignKey("FK_RouteId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Route");
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.UserStoreScope", b =>
{
b.HasOne("Distribution.Models.Store", "Store")
.WithMany()
.HasForeignKey("FK_StoreId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Store");
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.Vehicle", b =>
{
b.HasOne("Distribution.Models.Warehouse", null)
.WithMany()
.HasForeignKey("DefaultWarehouseId")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("Distribution.Models.Warehouse", b =>
{
b.HasOne("Distribution.Models.Vehicle", "Vehicle")
.WithMany()
.HasForeignKey("VehicleId");
b.Navigation("Vehicle");
});
modelBuilder.Entity("Distribution.Models.GoodsReceipt", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItem", b =>
{
b.Navigation("Batches");
b.Navigation("Serials");
});
modelBuilder.Entity("Distribution.Models.Invoice", b =>
{
b.Navigation("Payments");
});
modelBuilder.Entity("Distribution.Models.Item", b =>
{
b.Navigation("Conversions");
});
modelBuilder.Entity("Distribution.Models.LoadingSheet", b =>
{
b.Navigation("Items");
b.Navigation("Orders");
});
modelBuilder.Entity("Distribution.Models.PriceList", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.PurchaseOrder", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.PurchaseReturn", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.SaleReturn", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.Scheme", b =>
{
b.Navigation("BundleComponents");
b.Navigation("Redemptions");
});
modelBuilder.Entity("Distribution.Models.ShopPO", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.SupplierClaim", b =>
{
b.Navigation("Items");
});
#pragma warning restore 612, 618
}
}
}
Reference in New Issue View Git Blame Copy Permalink