Database Requirement for Politribe

[alizul01]

Database Requirement for Politribe

We are using Supabase to manage the database for our project. Here are the requirements for the database:

Table model

• users: stores user information such as name, email, and password
• idea_box: stores ideas submitted by users

Each idea should contain:

1. title: the title of the idea (string)
2. description: a detailed description of the idea (string)
3. tags: keywords that describe the idea (array of strings)
4. creator: the user who submitted the idea (object reference to the user's table)

• team: stores information about project teams and their members

Each team should have the following fields:

1. name: the name of the team (string)
2. members: the users who are members of the team (array of object references to the user's table)

Security

User passwords should be encrypted

Backup

The database should be backed up daily / weekly? to ensure that data is not lost in the event of an unexpected incident.

Suggestions

What if we add a likes field to the idea_box table to keep track of how many users have liked an idea?