search

jaduff / LabLog

Software for recording physical users of computers in a lab environment.
MIT License
0 stars 1 forks source link

What is the primary key of an event? #8

Closed jaduff closed 7 years ago

jaduff commented 7 years ago

Events have a Guid roomid, and a timestamp. But what is the primary key? There is no guid eventid?

Additionally, should all events be stored in a single table, or should roomcreated, computeradded, etc be separate tables of similar events?

Presumably they should all be in the one place for easy replaying. But implementing this is made difficult as the DbContext needs access to a non-generic type. LabEvent is generic and doesn't seem to be able to be used for this purpose.

simonjduff commented 7 years ago

Key is compound {RoomId, Version}. We haven't built version yet, I'll show you that today. All events go in the same table