DiamondDAO / discord-etl

This program takes the output from `discord-bot` then transforms and loads into a database
0 stars 1 forks source link

Refactor Reactions Datamodel #2

Open nathankoerschner opened 2 years ago

nathankoerschner commented 2 years ago

Refactor datamodel (in database and figma file) to include a reaction_history table as well as a reaction entity table.

Then refactor ETL accordingly.

reaction entity properties:

Then all other data, such as "deleted", "emoji", etc can go under the reaction_history table. This stays consistant with the rest of the datamodel.

nathankoerschner commented 2 years ago

Completed with this commit

nathankoerschner commented 2 years ago

Next need to update the database to include this new table, guild_message_reaction_histories, as outlined in the datamodel