alexhrao / TheGiftHub

An app where users can list what gifts they want, and can reserve gifts for others.

https://www.thegifthub.org

1 stars 0 forks source link

Redo events #18

Closed alexhrao closed 7 years ago

alexhrao commented 7 years ago

What

The current scheme for storing events assumes an event occurs the same day every year. This is clearly not true

Why

Events play critical role in helping users. Accurately tracking them is therefore of paramount importance.

How

Add a new table: events_futures
This table has:
- ID
- Year
- Month
- Day

If the event is NOT recurring, then this table stores the date of every year - any year not defined is not a year when the event happens.

hook this up with SQL for getting events - now dates will be date arrays

alexhrao commented 7 years ago

Done. Additionally, the normal events table still keeps a day, month, year - if recurs, only recurs after that year