I’m new to Laravel and I currently working on a website for our department, our department has different teams and each team has its own data in data tables. Each team has access only to the team tables and doesn’t’ have access to other teams' tables.
Also, all tables are standardized so every team has the same tables as the other teams but with different content.
1- Can you help me what is the best approach to implement this? in coding and in the database.
2- Should I store everything in a centralized database or should I make a different database for a different team?
3- can I implement this using Laratrust?
4- How I will ensure the performance of the website will be fast?
1- Can you help me what is the best approach to implement this? Sure I will do my best
2- Should I store everything in a centralized database or should I make a different database for a different team? If the data in the same format, then you should store them in the same table. If you want to distinguish them you can add another column that detriment to which department the record belong to.
4- How I will ensure the performance of the website will be fast? To answer that questions we can spend days, but if you are asking only for databases, then make sure to use indexes.
