Create a more effective database schema

MLH-Fellowship / CollabOn

A GitHub App to get updates about teams and members in your Organization.

ISC License

0 stars 0 forks source link

Create a more effective database schema #3

Open mgautam98 opened 4 years ago

mgautam98 commented 4 years ago

We are using SQLite, If time permits we will setup a MySQL server.

Currently we are just using a single table to store all the data. The schema for table looks like

Events(organization, username, action, textContent, repository, createdAt, url). We are not adding team info so create another table and make some changes to this one too.