Tuesday, February 14, 2012

date as PK

I have a bonus table with the following columns:

id dateto datefrom bonus

The PK is id AND dateto (because 1 id may have several different bonus at different dates!) which all seems fone.

In my front end the user can edit the bonus records, inc dateto... is it still okay to have date to as a PK?!yes, it is :)

No comments:

Post a Comment