From a304c24b32c0327436bbd8c2853e60668e161b42 Mon Sep 17 00:00:00 2001
From: Ariel Costas Guerrero <ariel@costas.dev>
Date: Mon, 29 Dec 2025 00:41:52 +0100
Subject: Rename a lot of stuff, add Santiago real time

---
 .../Data/Gtfs/GtfsStopTime.cs                      | 44 ++++++++++++++++++++++
 1 file changed, 44 insertions(+)
 create mode 100644 src/Enmarcha.Experimental.ServiceViewer/Data/Gtfs/GtfsStopTime.cs

(limited to 'src/Enmarcha.Experimental.ServiceViewer/Data/Gtfs/GtfsStopTime.cs')

diff --git a/src/Enmarcha.Experimental.ServiceViewer/Data/Gtfs/GtfsStopTime.cs b/src/Enmarcha.Experimental.ServiceViewer/Data/Gtfs/GtfsStopTime.cs
new file mode 100644
index 0000000..2bed623
--- /dev/null
+++ b/src/Enmarcha.Experimental.ServiceViewer/Data/Gtfs/GtfsStopTime.cs
@@ -0,0 +1,44 @@
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using Enmarcha.Experimental.ServiceViewer.Data.Extensions;
+using Microsoft.EntityFrameworkCore;
+
+namespace Enmarcha.Experimental.ServiceViewer.Data.Gtfs;
+
+[Table("gtfs_stop_times")]
+[PrimaryKey(nameof(TripId), nameof(StopSequence), nameof(FeedId))]
+public class GtfsStopTime
+{
+    [Column("trip_id")]
+    [ForeignKey("TripId")]
+    [MaxLength(32)]
+    public string TripId { get; set; } = null!;
+
+    [Column("feed_id")]public int FeedId { get; set; }
+    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
+
+    [ForeignKey(nameof(TripId))] public GtfsTrip GtfsTrip { get; set; } = null!;
+
+    [Column("arrival_time")] public string Arrival { get; set; }
+    public TimeSpan ArrivalTime => TimeSpan.FromGtfsTime(Arrival);
+
+    [Column("departure_time")] public string Departure { get; set; }
+    public TimeSpan DepartureTime => TimeSpan.FromGtfsTime(Departure);
+
+    [Column("stop_id")]
+    [ForeignKey(nameof(GtfsStop))]
+    [MaxLength(32)]
+    public required string StopId { get; set; }
+
+    [ForeignKey(nameof(StopId))] public GtfsStop GtfsStop { get; set; } = null!;
+
+    [Column("stop_sequence")] public int StopSequence { get; set; } = 0;
+
+    // [Column("pickup_type")]
+    // public int? PickupType { get; set; }
+    //
+    // [Column("drop_off_type")]
+    // public int? DropOffType { get; set; }
+
+    [Column("shape_dist_traveled")] public double? ShapeDistTraveled { get; set; } = null!;
+}
-- 
cgit v1.3