Order to tables

[khinshankhan]

Is there an order to the tables?

I want to contribute several keys I found exhausted but wanted to double-check before I added them to the end of the list 🙂

[AlexanderTheGrey]

I'm still working out the exact schema, and some stuff is probably out of order based on what I'm about to say, but the general order that I was thinking of is:

1. Humble Bundle Keys with Expiration Dates table - tracks games with expiration dates
   1. Non-expired (rows without a strikethrough) are sorted by Expiration (ascending)
   2. Expired keys (rows with a strikethough) are sorted by Expiration (descending)
   3. If rows have the same expiration, first group them by bundle name (i.e., alphebetical sort on the Bundle column first), then sort alphebetically based on the Game column
      1. Note: Even if titles are in the same bundle, if the expiration date differs, they shouldn't be grouped together
2. Humble Bundle Exhausted Keys table - tracks games that have run out of keys
   1. First group and sort based on the bundle end date (descending, i.e., newer bundles at the top), then group them by bundle name (i.e., alphebetical sort on the Bundle column first), then sort alphebetically based on the Game column
3. Humble Bundle Steam Keys Replaced with Other DRM (Without Notice) table - tracks DRM platform changes
   1. First group and sort based on the bundle end date (descending, i.e., newer bundles at the top), then group them by bundle name (i.e., alphebetical sort on the Bundle column first), then sort alphebetically based on the Game column
4. Humble Bundle Publisher Behavior - synthesizes data from the other tables to track publisher behavior
   1. Sorted alphabetically based on the Publisher name
   2. No publisher should be included here unless they meet at least one of the publisher behavior criteria