Design the entity model primarily.

6 files changed, 119 insertions, 2 deletions

diff --git a/Timeline/Entities/DatabaseContext.cs b/Timeline/Entities/DatabaseContext.cs
index 6c005b30..19df32c6 100644
--- a/Timeline/Entities/DatabaseContext.cs
+++ b/Timeline/Entities/DatabaseContext.cs
@@ -20,5 +20,7 @@ namespace Timeline.Entities
         public DbSet<User> Users { get; set; } = default!;

         public DbSet<UserAvatar> UserAvatars { get; set; } = default!;

         public DbSet<UserDetail> UserDetails { get; set; } = default!;

+        public DbSet<TimelineEntity> Timelines { get; set; } = default!;

+        public DbSet<TimelinePostEntity> TimelinePosts { get; set; } = default!;

     }

 }

diff --git a/Timeline/Entities/TimelineEntity.cs b/Timeline/Entities/TimelineEntity.cs
new file mode 100644
index 00000000..f4c7045d
--- /dev/null
+++ b/Timeline/Entities/TimelineEntity.cs
@@ -0,0 +1,46 @@
+using System;

+using System.Collections.Generic;

+using System.ComponentModel.DataAnnotations;

+using System.ComponentModel.DataAnnotations.Schema;

+

+namespace Timeline.Entities

+{

+    public enum TimelineVisibility

+    {

+        Public,

+        Private

+    }

+

+    [System.Diagnostics.CodeAnalysis.SuppressMessage("Usage", "CA2227:Collection properties should be read only", Justification = "This is entity object.")]

+    [Table("timelines")]

+    public class TimelineEntity

+    {

+        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

+        public long Id { get; set; }

+

+        /// <summary>

+        /// If null, then this timeline is a personal timeline.

+        /// </summary>

+        [Column("name")]

+        public string? Name { get; set; }

+

+        [Column("description")]

+        public string? Description { get; set; }

+

+        [Column("owner")]

+        public long OwnerId { get; set; }

+

+        [ForeignKey(nameof(OwnerId))]

+        public User Owner { get; set; } = default!;

+

+        [Column("visibility")]

+        public TimelineVisibility Visibility { get; set; }

+

+        [Column("create_time")]

+        public DateTime CreateTime { get; set; }

+

+        public List<TimelineMemberEntity> Members { get; set; } = default!;

+

+        public List<TimelinePostEntity> Posts { get; set; } = default!;

+    }

+}

diff --git a/Timeline/Entities/TimelineMemberEntity.cs b/Timeline/Entities/TimelineMemberEntity.cs
new file mode 100644
index 00000000..4631dc89
--- /dev/null
+++ b/Timeline/Entities/TimelineMemberEntity.cs
@@ -0,0 +1,27 @@
+using System;

+using System.Collections.Generic;

+using System.ComponentModel.DataAnnotations;

+using System.ComponentModel.DataAnnotations.Schema;

+using System.Linq;

+using System.Threading.Tasks;

+

+namespace Timeline.Entities

+{

+    public class TimelineMemberEntity

+    {

+        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

+        public long Id { get; set; }

+

+        [Column("user")]

+        public long UserId { get; set; }

+

+        [ForeignKey(nameof(UserId))]

+        public User User { get; set; } = default!;

+

+        [Column("timeline")]

+        public long TimelineId { get; set; }

+

+        [ForeignKey(nameof(TimelineId))]

+        public TimelineEntity Timeline { get; set; } = default!;

+    }

+}

diff --git a/Timeline/Entities/TimelinePostEntity.cs b/Timeline/Entities/TimelinePostEntity.cs
new file mode 100644
index 00000000..efef3ab5
--- /dev/null
+++ b/Timeline/Entities/TimelinePostEntity.cs
@@ -0,0 +1,34 @@
+using System;

+using System.ComponentModel.DataAnnotations;

+using System.ComponentModel.DataAnnotations.Schema;

+

+namespace Timeline.Entities

+{

+    [Table("timeline_posts")]

+    public class TimelinePostEntity

+    {

+        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]

+        public long Id { get; set; }

+

+        [Column("timeline")]

+        public long TimelineId { get; set; }

+

+        [ForeignKey(nameof(TimelineId))]

+        public TimelineEntity Timeline { get; set; } = default!;

+

+        [Column("author")]

+        public long AuthorId { get; set; }

+

+        [ForeignKey(nameof(AuthorId))]

+        public User Author { get; set; } = default!;

+

+        [Column("content")]

+        public string? Content { get; set; }

+

+        [Column("time")]

+        public DateTime Time { get; set; }

+

+        [Column("last_updated")]

+        public DateTime LastUpdated { get; set; }

+    }

+}

diff --git a/Timeline/Entities/User.cs b/Timeline/Entities/User.cs
index 02352b03..e725a69a 100644
--- a/Timeline/Entities/User.cs
+++ b/Timeline/Entities/User.cs
@@ -1,4 +1,5 @@
-using System.ComponentModel.DataAnnotations;

+using System.Collections.Generic;

+using System.ComponentModel.DataAnnotations;

 using System.ComponentModel.DataAnnotations.Schema;

 

 namespace Timeline.Entities

@@ -9,6 +10,7 @@ namespace Timeline.Entities
         public const string User = "user";

     }

 

+    [System.Diagnostics.CodeAnalysis.SuppressMessage("Usage", "CA2227:Collection properties should be read only", Justification = "This is an entity class.")]

     [Table("users")]

     public class User

     {

@@ -30,5 +32,11 @@ namespace Timeline.Entities
         public UserAvatar? Avatar { get; set; }

 

         public UserDetail? Detail { get; set; }

+

+        public List<TimelineEntity> Timelines { get; set; } = default!;

+

+        public List<TimelinePostEntity> TimelinePosts { get; set; } = default!;

+

+        public List<TimelineMemberEntity> TimelinesJoined { get; set; } = default!;

     }

 }

diff --git a/Timeline/Entities/UserAvatar.cs b/Timeline/Entities/UserAvatar.cs
index a5b18b94..114246f3 100644
--- a/Timeline/Entities/UserAvatar.cs
+++ b/Timeline/Entities/UserAvatar.cs
@@ -4,6 +4,7 @@ using System.ComponentModel.DataAnnotations.Schema;
 

 namespace Timeline.Entities

 {

+    [System.Diagnostics.CodeAnalysis.SuppressMessage("Performance", "CA1819:Properties should not return arrays", Justification = "This is data base entity.")]

     [Table("user_avatars")]

     public class UserAvatar

     {

@@ -11,7 +12,6 @@ namespace Timeline.Entities
         public long Id { get; set; }

 

         [Column("data")]

-        [System.Diagnostics.CodeAnalysis.SuppressMessage("Performance", "CA1819:Properties should not return arrays", Justification = "This is data base entity.")]

         public byte[]? Data { get; set; }

 

         [Column("type")]