I have a log table that captures the datetime stamp of when certain files were exported to another system.
The exportedLog table currently has three fields:
id (primary key)
messageId (int)
exportedDateTime (datetime)
Reviewing this I found that the id
field serves no purpose, as there are no joins to this table.
The only thing working on this table is the insert of the batch job that processes the messages and inserts into this log table.
Should I remove the id
field?
Should I have a primary key on either messageId
or exportedDateTime
or both?