1 files changed, 46 insertions, 0 deletions
diff --git a/src/Enmarcha.Experimental.ServiceViewer/Data/Gtfs/GtfsAgency.cs b/src/Enmarcha.Experimental.ServiceViewer/Data/Gtfs/GtfsAgency.cs
new file mode 100644
index 0000000..8ce129c
--- /dev/null
+++ b/src/Enmarcha.Experimental.ServiceViewer/Data/Gtfs/GtfsAgency.cs
@@ -0,0 +1,46 @@
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using Microsoft.EntityFrameworkCore;
+
+namespace Enmarcha.Experimental.ServiceViewer.Data.Gtfs;
+
+[Table("gtfs_agencies")]
+[PrimaryKey(nameof(Id), nameof(FeedId))]
+public class GtfsAgency
+{
+    [Key]
+    [Column("agency_id")]
+    [MaxLength(255)]
+    public required string Id { get; set; }
+
+    [Column("feed_id")] public int FeedId { get; set; }
+    [ForeignKey(nameof(FeedId))] public required Feed Feed { get; set; }
+
+    [Column("agency_name")]
+    [MaxLength(255)]
+    public string Name { get; set; } = string.Empty;
+
+    [Column("agency_url")]
+    [MaxLength(255)]
+    public string Url { get; set; } = string.Empty;
+
+    [Column("agency_timezone")]
+    [MaxLength(50)]
+    public string Timezone { get; set; } = string.Empty;
+
+    [Column("agency_lang")]
+    [MaxLength(5)]
+    public string Language { get; set; } = string.Empty;
+
+    [Column("agency_phone")]
+    [MaxLength(30)]
+    public string? Phone { get; set; } = string.Empty;
+
+    [Column("agency_email")]
+    [MaxLength(255)]
+    public string? Email { get; set; } = string.Empty;
+
+    [Column("agency_fare_url")]
+    [MaxLength(255)]
+    public string? FareUrl { get; set; } = string.Empty;
+}