Results 1 to 2 of 2

Thread: date as PK

  1. #1
    Join Date
    Feb 2005
    Posts
    76

    Unanswered: 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?!
    Last edited by STUCK1234; 10-20-06 at 09:33.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, it is
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •