One thing we need to decide is whether each entry needs to have a unique identifier.. this would make it easier to link one event to another using a foreign-key type relationship, but it requires some maintenance and extra work when creating records, especially if one is merging data from multiple sources (which should definitely be possible and encouraged). Although, it could be possible to use timestamp+user to reference nearly any event.. that might be a possibility though perhaps not perfect.
My initial feeling is that if any, it should be based on the timestamp and not an auto incrementing type number
One thing we need to decide is whether each entry needs to have a unique identifier.. this would make it easier to link one event to another using a foreign-key type relationship, but it requires some maintenance and extra work when creating records, especially if one is merging data from multiple sources (which should definitely be possible and encouraged). Although, it could be possible to use timestamp+user to reference nearly any event.. that might be a possibility though perhaps not perfect.
My initial feeling is that if any, it should be based on the timestamp and not an auto incrementing type number