I need to work on a project where we have a "case". Within this case we need to attach different things, in a timeline.
Those things can be:
- Status change (Open, On hold, Closed)
- Messages (just text)
- Calls (call history, "call lasted x seconds")
- Call rating
Now I don't really have a way of storing this in a MS SQL database. We are using EF Core for net5.0
.
How do I make a database structure that has different tables all linked in one timeline? I'm struggling with my data layer.
Example:
10:12 AM - Pete wrote: "Foo bar"
10:14 AM - Pete called John, call lasted x seconds. Click here to view the call.
10:14 AM - John rated the call x x x 0 0. (three stars visualized)
11:12 AM - Pete put this case on hold.
11:14 AM - John wrote "ABC"
11:15 AM - John closed this case
This is the "timeline" for a case in text. But ofcourse in the actual front-end we'll show a thumbnail of the video call. And we'll show a status change in color. And we'll show actual stars instead of writing x x x 0 0
.
I don't expect an answer where my program is realized. But could you point me in the right direction so that this is expandable with new tables in the future.