source: StockMaster/Migrations/StockDbContextModelSnapshot.cs

main
Last change on this file was dfe03b8, checked in by Ceyda <ceyda.huseini@…>, 2 days ago

Initialize StockMaster project
  • Property mode set to 100644
File size: 26.9 KB
Line 
1// <auto-generated />
2using System;
3using Microsoft.EntityFrameworkCore;
4using Microsoft.EntityFrameworkCore.Infrastructure;
5using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
6using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
7using StockMaster.Data;
8
9#nullable disable
10
11namespace StockMaster.Migrations
12{
13 [DbContext(typeof(StockDbContext))]
14 partial class StockDbContextModelSnapshot : ModelSnapshot
15 {
16 protected override void BuildModel(ModelBuilder modelBuilder)
17 {
18#pragma warning disable 612, 618
19 modelBuilder
20 .HasAnnotation("ProductVersion", "8.0.4")
21 .HasAnnotation("Relational:MaxIdentifierLength", 63);
22
23 NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
24
25 modelBuilder.Entity("StockMaster.Models.Category", b =>
26 {
27 b.Property<int>("CategoryId")
28 .ValueGeneratedOnAdd()
29 .HasColumnType("integer")
30 .HasColumnName("category_id");
31
32 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("CategoryId"));
33
34 b.Property<DateTime>("CreatedAt")
35 .HasColumnType("timestamp without time zone")
36 .HasColumnName("created_at");
37
38 b.Property<string>("Description")
39 .IsRequired()
40 .HasColumnType("text")
41 .HasColumnName("description");
42
43 b.Property<string>("Name")
44 .IsRequired()
45 .HasMaxLength(50)
46 .HasColumnType("character varying(50)")
47 .HasColumnName("name");
48
49 b.HasKey("CategoryId");
50
51 b.ToTable("category", "stock_management");
52 });
53
54 modelBuilder.Entity("StockMaster.Models.Customer", b =>
55 {
56 b.Property<int>("CustomerId")
57 .ValueGeneratedOnAdd()
58 .HasColumnType("integer")
59 .HasColumnName("customer_id");
60
61 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("CustomerId"));
62
63 b.Property<string>("Address")
64 .IsRequired()
65 .HasColumnType("text")
66 .HasColumnName("address");
67
68 b.Property<DateTime>("CreatedAt")
69 .HasColumnType("timestamp without time zone")
70 .HasColumnName("created_at");
71
72 b.Property<string>("Email")
73 .IsRequired()
74 .HasMaxLength(100)
75 .HasColumnType("character varying(100)")
76 .HasColumnName("email");
77
78 b.Property<string>("Name")
79 .IsRequired()
80 .HasMaxLength(100)
81 .HasColumnType("character varying(100)")
82 .HasColumnName("name");
83
84 b.Property<string>("Phone")
85 .IsRequired()
86 .HasMaxLength(20)
87 .HasColumnType("character varying(20)")
88 .HasColumnName("phone");
89
90 b.HasKey("CustomerId");
91
92 b.ToTable("customer", "stock_management");
93 });
94
95 modelBuilder.Entity("StockMaster.Models.Product", b =>
96 {
97 b.Property<int>("ProductId")
98 .ValueGeneratedOnAdd()
99 .HasColumnType("integer")
100 .HasColumnName("product_id");
101
102 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("ProductId"));
103
104 b.Property<int?>("CategoryId")
105 .HasColumnType("integer")
106 .HasColumnName("category_id");
107
108 b.Property<DateTime>("CreatedAt")
109 .HasColumnType("timestamp without time zone")
110 .HasColumnName("created_at");
111
112 b.Property<string>("Description")
113 .IsRequired()
114 .HasColumnType("text")
115 .HasColumnName("description");
116
117 b.Property<bool>("IsActive")
118 .HasColumnType("boolean")
119 .HasColumnName("is_active");
120
121 b.Property<string>("Name")
122 .IsRequired()
123 .HasMaxLength(100)
124 .HasColumnType("character varying(100)")
125 .HasColumnName("name");
126
127 b.Property<int>("ReorderLevel")
128 .HasColumnType("integer")
129 .HasColumnName("reorder_level");
130
131 b.Property<string>("Sku")
132 .IsRequired()
133 .HasMaxLength(50)
134 .HasColumnType("character varying(50)")
135 .HasColumnName("sku");
136
137 b.Property<int?>("SupplierId")
138 .HasColumnType("integer")
139 .HasColumnName("supplier_id");
140
141 b.Property<decimal>("UnitPrice")
142 .HasPrecision(12, 2)
143 .HasColumnType("numeric(12,2)")
144 .HasColumnName("unit_price");
145
146 b.HasKey("ProductId");
147
148 b.HasIndex("CategoryId");
149
150 b.HasIndex("SupplierId");
151
152 b.ToTable("product", "stock_management");
153 });
154
155 modelBuilder.Entity("StockMaster.Models.ProductPriceLog", b =>
156 {
157 b.Property<int>("LogId")
158 .ValueGeneratedOnAdd()
159 .HasColumnType("integer")
160 .HasColumnName("log_id");
161
162 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("LogId"));
163
164 b.Property<DateTime>("ChangedAt")
165 .HasColumnType("timestamp without time zone")
166 .HasColumnName("changed_at");
167
168 b.Property<string>("ChangedBy")
169 .IsRequired()
170 .HasColumnType("text")
171 .HasColumnName("changed_by");
172
173 b.Property<decimal>("NewPrice")
174 .HasColumnType("numeric")
175 .HasColumnName("new_price");
176
177 b.Property<decimal>("OldPrice")
178 .HasColumnType("numeric")
179 .HasColumnName("old_price");
180
181 b.Property<int>("ProductId")
182 .HasColumnType("integer")
183 .HasColumnName("product_id");
184
185 b.Property<string>("ProductName")
186 .IsRequired()
187 .HasColumnType("text")
188 .HasColumnName("product_name");
189
190 b.HasKey("LogId");
191
192 b.ToTable("product_price_log", "stock_management");
193 });
194
195 modelBuilder.Entity("StockMaster.Models.PurchaseOrder", b =>
196 {
197 b.Property<int>("PoId")
198 .ValueGeneratedOnAdd()
199 .HasColumnType("integer")
200 .HasColumnName("po_id");
201
202 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("PoId"));
203
204 b.Property<DateTime?>("ActualDeliveryDate")
205 .HasColumnType("timestamp without time zone")
206 .HasColumnName("actual_delivery_date");
207
208 b.Property<DateTime>("CreatedAt")
209 .HasColumnType("timestamp without time zone")
210 .HasColumnName("created_at");
211
212 b.Property<DateTime>("ExpectedDeliveryDate")
213 .HasColumnType("timestamp without time zone")
214 .HasColumnName("expected_delivery_date");
215
216 b.Property<DateTime>("OrderDate")
217 .HasColumnType("timestamp without time zone")
218 .HasColumnName("order_date");
219
220 b.Property<string>("Status")
221 .IsRequired()
222 .HasMaxLength(20)
223 .HasColumnType("character varying(20)")
224 .HasColumnName("status");
225
226 b.Property<int?>("SupplierId")
227 .HasColumnType("integer")
228 .HasColumnName("supplier_id");
229
230 b.Property<int>("WarehouseId")
231 .HasColumnType("integer")
232 .HasColumnName("warehouse_id");
233
234 b.HasKey("PoId");
235
236 b.HasIndex("SupplierId");
237
238 b.HasIndex("WarehouseId");
239
240 b.ToTable("purchase_order", "stock_management");
241 });
242
243 modelBuilder.Entity("StockMaster.Models.PurchaseOrderItem", b =>
244 {
245 b.Property<int>("PoId")
246 .HasColumnType("integer")
247 .HasColumnName("po_id");
248
249 b.Property<int>("ProductId")
250 .HasColumnType("integer")
251 .HasColumnName("product_id");
252
253 b.Property<int>("Quantity")
254 .HasColumnType("integer")
255 .HasColumnName("quantity");
256
257 b.Property<int>("ReceivedQuantity")
258 .HasColumnType("integer")
259 .HasColumnName("received_quantity");
260
261 b.Property<decimal>("UnitCost")
262 .HasPrecision(12, 2)
263 .HasColumnType("numeric(12,2)")
264 .HasColumnName("unit_cost");
265
266 b.HasKey("PoId", "ProductId");
267
268 b.HasIndex("ProductId");
269
270 b.ToTable("purchase_order_item", "stock_management");
271 });
272
273 modelBuilder.Entity("StockMaster.Models.Sale", b =>
274 {
275 b.Property<int>("SaleId")
276 .ValueGeneratedOnAdd()
277 .HasColumnType("integer")
278 .HasColumnName("sale_id");
279
280 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("SaleId"));
281
282 b.Property<int?>("CustomerId")
283 .HasColumnType("integer")
284 .HasColumnName("customer_id");
285
286 b.Property<DateTime>("DateTime")
287 .HasColumnType("timestamp without time zone")
288 .HasColumnName("date_time");
289
290 b.Property<decimal>("TotalAmount")
291 .HasPrecision(15, 2)
292 .HasColumnType("numeric(15,2)")
293 .HasColumnName("total_amount");
294
295 b.Property<int?>("UserId")
296 .HasColumnType("integer")
297 .HasColumnName("user_id");
298
299 b.Property<int>("WarehouseId")
300 .HasColumnType("integer")
301 .HasColumnName("warehouse_id");
302
303 b.HasKey("SaleId");
304
305 b.HasIndex("CustomerId");
306
307 b.HasIndex("UserId");
308
309 b.HasIndex("WarehouseId");
310
311 b.ToTable("sale", "stock_management");
312 });
313
314 modelBuilder.Entity("StockMaster.Models.SaleItem", b =>
315 {
316 b.Property<int>("SaleId")
317 .HasColumnType("integer")
318 .HasColumnName("sale_id");
319
320 b.Property<int>("ProductId")
321 .HasColumnType("integer")
322 .HasColumnName("product_id");
323
324 b.Property<int>("Quantity")
325 .HasColumnType("integer")
326 .HasColumnName("quantity");
327
328 b.Property<decimal>("UnitPriceAtSale")
329 .HasPrecision(12, 2)
330 .HasColumnType("numeric(12,2)")
331 .HasColumnName("unit_price_at_sale");
332
333 b.HasKey("SaleId", "ProductId");
334
335 b.HasIndex("ProductId");
336
337 b.ToTable("sale_item", "stock_management");
338 });
339
340 modelBuilder.Entity("StockMaster.Models.Supplier", b =>
341 {
342 b.Property<int>("SupplierId")
343 .ValueGeneratedOnAdd()
344 .HasColumnType("integer")
345 .HasColumnName("supplier_id");
346
347 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("SupplierId"));
348
349 b.Property<string>("Address")
350 .IsRequired()
351 .HasColumnType("text")
352 .HasColumnName("address");
353
354 b.Property<string>("ContactPerson")
355 .IsRequired()
356 .HasMaxLength(100)
357 .HasColumnType("character varying(100)")
358 .HasColumnName("contact_person");
359
360 b.Property<DateTime>("CreatedAt")
361 .HasColumnType("timestamp without time zone")
362 .HasColumnName("created_at");
363
364 b.Property<string>("Email")
365 .IsRequired()
366 .HasMaxLength(100)
367 .HasColumnType("character varying(100)")
368 .HasColumnName("email");
369
370 b.Property<string>("Name")
371 .IsRequired()
372 .HasMaxLength(100)
373 .HasColumnType("character varying(100)")
374 .HasColumnName("name");
375
376 b.Property<string>("Phone")
377 .IsRequired()
378 .HasMaxLength(20)
379 .HasColumnType("character varying(20)")
380 .HasColumnName("phone");
381
382 b.HasKey("SupplierId");
383
384 b.ToTable("supplier", "stock_management");
385 });
386
387 modelBuilder.Entity("StockMaster.Models.User", b =>
388 {
389 b.Property<int>("UserId")
390 .ValueGeneratedOnAdd()
391 .HasColumnType("integer")
392 .HasColumnName("user_id");
393
394 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("UserId"));
395
396 b.Property<DateTime>("CreatedAt")
397 .HasColumnType("timestamp without time zone")
398 .HasColumnName("created_at");
399
400 b.Property<string>("Email")
401 .IsRequired()
402 .HasMaxLength(100)
403 .HasColumnType("character varying(100)")
404 .HasColumnName("email");
405
406 b.Property<string>("FullName")
407 .IsRequired()
408 .HasMaxLength(100)
409 .HasColumnType("character varying(100)")
410 .HasColumnName("full_name");
411
412 b.Property<bool>("IsActive")
413 .HasColumnType("boolean")
414 .HasColumnName("is_active");
415
416 b.Property<string>("Password")
417 .IsRequired()
418 .HasMaxLength(255)
419 .HasColumnType("character varying(255)")
420 .HasColumnName("password");
421
422 b.Property<string>("Role")
423 .IsRequired()
424 .HasMaxLength(20)
425 .HasColumnType("character varying(20)")
426 .HasColumnName("role");
427
428 b.Property<string>("Username")
429 .IsRequired()
430 .HasMaxLength(50)
431 .HasColumnType("character varying(50)")
432 .HasColumnName("username");
433
434 b.HasKey("UserId");
435
436 b.ToTable("users", "stock_management");
437 });
438
439 modelBuilder.Entity("StockMaster.Models.VwEmployeeRanking", b =>
440 {
441 b.Property<decimal>("AvgSaleValue")
442 .HasColumnType("numeric")
443 .HasColumnName("avg_sale_value");
444
445 b.Property<string>("FullName")
446 .IsRequired()
447 .HasColumnType("text")
448 .HasColumnName("full_name");
449
450 b.Property<long>("RevenueRank")
451 .HasColumnType("bigint")
452 .HasColumnName("revenue_rank");
453
454 b.Property<string>("Role")
455 .IsRequired()
456 .HasColumnType("text")
457 .HasColumnName("role");
458
459 b.Property<decimal>("TotalRevenue")
460 .HasColumnType("numeric")
461 .HasColumnName("total_revenue");
462
463 b.Property<long>("TotalSales")
464 .HasColumnType("bigint")
465 .HasColumnName("total_sales");
466
467 b.Property<long>("UniqueCustomers")
468 .HasColumnType("bigint")
469 .HasColumnName("unique_customers");
470
471 b.Property<int>("UserId")
472 .HasColumnType("integer")
473 .HasColumnName("user_id");
474
475 b.ToTable((string)null);
476
477 b.ToView("vw_employee_sales_ranking", "stock_management");
478 });
479
480 modelBuilder.Entity("StockMaster.Models.VwSalesByDay", b =>
481 {
482 b.Property<decimal>("AvgSaleValue")
483 .HasColumnType("numeric")
484 .HasColumnName("avg_sale_value");
485
486 b.Property<string>("DayName")
487 .IsRequired()
488 .HasColumnType("text")
489 .HasColumnName("day_name");
490
491 b.Property<int>("DayNumber")
492 .HasColumnType("integer")
493 .HasColumnName("day_number");
494
495 b.Property<decimal>("TotalItemsSold")
496 .HasColumnType("numeric")
497 .HasColumnName("total_items_sold");
498
499 b.Property<decimal>("TotalRevenue")
500 .HasColumnType("numeric")
501 .HasColumnName("total_revenue");
502
503 b.Property<long>("TotalSales")
504 .HasColumnType("bigint")
505 .HasColumnName("total_sales");
506
507 b.ToTable((string)null);
508
509 b.ToView("vw_sales_by_day_of_week", "stock_management");
510 });
511
512 modelBuilder.Entity("StockMaster.Models.VwTodaysSummary", b =>
513 {
514 b.Property<long>("ActiveWarehouses")
515 .HasColumnType("bigint")
516 .HasColumnName("active_warehouses_today");
517
518 b.Property<decimal>("TotalItemsSold")
519 .HasColumnType("numeric")
520 .HasColumnName("total_items_sold_today");
521
522 b.Property<decimal>("TotalRevenue")
523 .HasColumnType("numeric")
524 .HasColumnName("total_revenue_today");
525
526 b.Property<long>("TotalTransactions")
527 .HasColumnType("bigint")
528 .HasColumnName("total_transactions_today");
529
530 b.Property<long>("UniqueCustomers")
531 .HasColumnType("bigint")
532 .HasColumnName("unique_customers_today");
533
534 b.ToTable((string)null);
535
536 b.ToView("vw_todays_sales_summary", "stock_management");
537 });
538
539 modelBuilder.Entity("StockMaster.Models.Warehouse", b =>
540 {
541 b.Property<int>("WarehouseId")
542 .ValueGeneratedOnAdd()
543 .HasColumnType("integer")
544 .HasColumnName("warehouse_id");
545
546 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("WarehouseId"));
547
548 b.Property<int>("Capacity")
549 .HasColumnType("integer")
550 .HasColumnName("capacity");
551
552 b.Property<DateTime>("CreatedAt")
553 .HasColumnType("timestamp without time zone")
554 .HasColumnName("created_at");
555
556 b.Property<string>("Location")
557 .IsRequired()
558 .HasMaxLength(255)
559 .HasColumnType("character varying(255)")
560 .HasColumnName("location");
561
562 b.Property<string>("Name")
563 .IsRequired()
564 .HasMaxLength(100)
565 .HasColumnType("character varying(100)")
566 .HasColumnName("name");
567
568 b.HasKey("WarehouseId");
569
570 b.ToTable("warehouse", "stock_management");
571 });
572
573 modelBuilder.Entity("StockMaster.Models.WarehouseStock", b =>
574 {
575 b.Property<int>("WarehouseId")
576 .HasColumnType("integer")
577 .HasColumnName("warehouse_id");
578
579 b.Property<int>("ProductId")
580 .HasColumnType("integer")
581 .HasColumnName("product_id");
582
583 b.Property<DateTime>("LastUpdated")
584 .HasColumnType("timestamp without time zone")
585 .HasColumnName("last_updated");
586
587 b.Property<int>("QuantityOnHand")
588 .HasColumnType("integer")
589 .HasColumnName("quantity_on_hand");
590
591 b.HasKey("WarehouseId", "ProductId");
592
593 b.HasIndex("ProductId");
594
595 b.ToTable("warehouse_stock", "stock_management");
596 });
597
598 modelBuilder.Entity("StockMaster.Models.Product", b =>
599 {
600 b.HasOne("StockMaster.Models.Category", "Category")
601 .WithMany()
602 .HasForeignKey("CategoryId");
603
604 b.HasOne("StockMaster.Models.Supplier", "Supplier")
605 .WithMany()
606 .HasForeignKey("SupplierId");
607
608 b.Navigation("Category");
609
610 b.Navigation("Supplier");
611 });
612
613 modelBuilder.Entity("StockMaster.Models.PurchaseOrder", b =>
614 {
615 b.HasOne("StockMaster.Models.Supplier", "Supplier")
616 .WithMany()
617 .HasForeignKey("SupplierId");
618
619 b.HasOne("StockMaster.Models.Warehouse", "Warehouse")
620 .WithMany()
621 .HasForeignKey("WarehouseId")
622 .OnDelete(DeleteBehavior.Cascade)
623 .IsRequired();
624
625 b.Navigation("Supplier");
626
627 b.Navigation("Warehouse");
628 });
629
630 modelBuilder.Entity("StockMaster.Models.PurchaseOrderItem", b =>
631 {
632 b.HasOne("StockMaster.Models.PurchaseOrder", "PurchaseOrder")
633 .WithMany("PurchaseOrderItems")
634 .HasForeignKey("PoId")
635 .OnDelete(DeleteBehavior.Cascade)
636 .IsRequired();
637
638 b.HasOne("StockMaster.Models.Product", "Product")
639 .WithMany()
640 .HasForeignKey("ProductId")
641 .OnDelete(DeleteBehavior.Cascade)
642 .IsRequired();
643
644 b.Navigation("Product");
645
646 b.Navigation("PurchaseOrder");
647 });
648
649 modelBuilder.Entity("StockMaster.Models.Sale", b =>
650 {
651 b.HasOne("StockMaster.Models.Customer", "Customer")
652 .WithMany()
653 .HasForeignKey("CustomerId");
654
655 b.HasOne("StockMaster.Models.User", "User")
656 .WithMany()
657 .HasForeignKey("UserId");
658
659 b.HasOne("StockMaster.Models.Warehouse", "Warehouse")
660 .WithMany()
661 .HasForeignKey("WarehouseId")
662 .OnDelete(DeleteBehavior.Cascade)
663 .IsRequired();
664
665 b.Navigation("Customer");
666
667 b.Navigation("User");
668
669 b.Navigation("Warehouse");
670 });
671
672 modelBuilder.Entity("StockMaster.Models.SaleItem", b =>
673 {
674 b.HasOne("StockMaster.Models.Product", "Product")
675 .WithMany()
676 .HasForeignKey("ProductId")
677 .OnDelete(DeleteBehavior.Cascade)
678 .IsRequired();
679
680 b.HasOne("StockMaster.Models.Sale", "Sale")
681 .WithMany("SaleItems")
682 .HasForeignKey("SaleId")
683 .OnDelete(DeleteBehavior.Cascade)
684 .IsRequired();
685
686 b.Navigation("Product");
687
688 b.Navigation("Sale");
689 });
690
691 modelBuilder.Entity("StockMaster.Models.WarehouseStock", b =>
692 {
693 b.HasOne("StockMaster.Models.Product", "Product")
694 .WithMany()
695 .HasForeignKey("ProductId")
696 .OnDelete(DeleteBehavior.Cascade)
697 .IsRequired();
698
699 b.HasOne("StockMaster.Models.Warehouse", "Warehouse")
700 .WithMany()
701 .HasForeignKey("WarehouseId")
702 .OnDelete(DeleteBehavior.Cascade)
703 .IsRequired();
704
705 b.Navigation("Product");
706
707 b.Navigation("Warehouse");
708 });
709
710 modelBuilder.Entity("StockMaster.Models.PurchaseOrder", b =>
711 {
712 b.Navigation("PurchaseOrderItems");
713 });
714
715 modelBuilder.Entity("StockMaster.Models.Sale", b =>
716 {
717 b.Navigation("SaleItems");
718 });
719#pragma warning restore 612, 618
720 }
721 }
722}
Note: See TracBrowser for help on using the repository browser.