Timestamp as part of composite primary key ?
Posted on 2006-06-03
I have a table which has a composite primary key - my primary key consists of 3 columns. After some thoughts, I find that those 3 columns does not make my records unique enough. I plan to add another column to those 3 and make it a 4 column primary key. The one I thought of adding is a timestamp column to ensure that records are unique. Is it all right to have timestamp as primary key ? Will I have problems retriving single rows if my primary key has a timestamp col ? Should I use datetime instead of timestamp ? Why ?
Thanks for answering.