• K. Brian Kelley - Tuesday, January 30, 2018 11:21 AM

    Another idea for a PK is a composite key (two columns) consisting of the year + the day of the year. There are some uses for this.

    I would just use the date itself.  It's only a single field instead of being a composite key.  It's more human readable.  I could see having an index on year/day of the year, but I would not make it the PK.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA