Some rework on the ServiceViewer (which will be repurposed for live multi-GTFS serving)

1 files changed, 5 insertions, 2 deletions

diff --git a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs
index 977fb74..1543ef5 100644
--- a/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs
+++ b/src/Costasdev.Busurbano.ServiceViewer/Data/Gtfs/GtfsCalendarDate.cs
@@ -5,8 +5,8 @@ using Microsoft.EntityFrameworkCore;
 
 namespace Costasdev.ServiceViewer.Data.Gtfs;
 
-[Table("calendar_dates")]
-[PrimaryKey(nameof(ServiceId), nameof(Date))]
+[Table("gtfs_calendar_dates")]
+[PrimaryKey(nameof(ServiceId), nameof(Date), nameof(FeedId))]
 public class GtfsCalendarDate
 {
     [Column("service_id")]
@@ -16,6 +16,9 @@ public class GtfsCalendarDate
     [Column("date")]
     public required DateTime Date { get; set; }
 
+    [Column("feed_id")] public int FeedId { get; set; }
+    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
+
     [Column("exception_type")]
     public required ExceptionType ExceptionType { get; set; }
 }