search

cancelei / search_engine

Eco-Friendly Meta-SearchEngine with Rails. Works for Google Custom Search and Bing API.
https://ecosearch-test.oasisofchange.org/
MIT License
5 stars 3 forks source link

Database Design #8

Open mohashyne opened 3 days ago

mohashyne commented 3 days ago

Kindly check the database design below and see if it matches the structure for this app , because it better for us to have the structure to ease our work and also wireframes for the frontend for make refrence if a member of the team is doing something wrong:

search_engine_design

Relationships:

One-to-Many (1
) Relationships:
    user_profile to user_account: Each user_profile can have one user_account.
    user_profile to search_history: Each user_profile can have many search_history entries.
    search_result to search_history: Each search_result can be associated with multiple search_history entries.
mohashyne commented 3 days ago

search_engine_design

Awesome_search_engine

cancelei commented 3 days ago

@mohashyne I think your effort is nice!

Before we implement changes, I think it's appropriate for you to work with @Hemit99123 on the Reward system, and implement the PR related to rails MVC to make his front end work. He told me that the front end is ready (but most likely on his local).

Then we also would have a Settings page that @Gabriel-Dalton mentioned before you joined, which would add more fields to the tables.

If I were you, I wouldn't worry about the database design just yet, since things are still solidifying and more features could be necessary with database changes.

Hemit99123 commented 3 days ago

@mohashyne may I ask what software you used to create the diagram?

Hemit99123 commented 3 days ago

Also for the rewards program (ecoquest)... I am done frontend, just need to push to GitHub so we can start work on backend.

I will use whatever program @mohashyne for db design :)