Primary Key Issue - Githubissues

gregjoeval / KnightcardSignInDevice

A device to store information from Knightcards to replace the physical sign-in clipboard.

2 stars 1 forks source link

Primary Key Issue #16

Closed aleccaputo closed 7 years ago

aleccaputo commented 7 years ago

Primary key is time, and even though time is is down to like milliseconds, there is a chance that someone swipes at the exact same time of day as someone else. Therefore they wouldn't get logged because the key would be a duplicate.....

But what are the chances of that...

aleccaputo commented 7 years ago

Combine Date and Time keys...

gregjoeval commented 7 years ago

Why not make date and time a composite key in the database?

aleccaputo commented 7 years ago

resolved by making date and time both the primary keys....