All Questions
Tagged with relational-database mysql
29 questions
2
votes
3
answers
367
views
Should I break a large user table into smaller tables for specific roles and information?
I am designing a database for a system that has a users table. Currently, the table has around 50 columns, which include:
Personal information (e.g. name, email, phone_number, address, etc.)
Work-...
- 131
-2
votes
2
answers
261
views
Designing a database schema for a website related to my town's history
I am working on digitizing old photographs, articles, ephemera, etc. related to my town's history, and I've been tasked to put these scans I've made onto a website for the public to see. There are ...
- 13
1
vote
0
answers
128
views
Backend Design: System requires both ElasticSearch and MySQL. In which scenario we fetch data from MySQL or ElasticSearch?
So, one of the backend system, having 5 resource types (tables) and some foreign keys as well, requires full text support for two of the tables.
Also, for some use-cases, we require inner-joins for ...
- 121
1
vote
0
answers
505
views
Design MySQL database to store user workout data for Workout App
I am building a fitness app and I'm trying to figure out the optimal way to store the data is a MySQL database.
I would like to have specific programs (for example, 'get jacked'), I would like a users ...
- 121
-2
votes
2
answers
214
views
Avoid redundant field using JSON type in MySQL [closed]
I have experienc with designing relational dbs but first time attempting to store JSON in a mysql table. I am using mysql 5.7.8 which has the ability to store json data type as a column.
When I create ...
- 139
0
votes
1
answer
348
views
Does it make sense to have redundant DB fields to improve query performance, programming speed and code readability?
I am a bit torn about the database design for a solution. I have the following structure: (only the relevant fields are marked with #)
+------------------+
| activities |
|------------------|
| ...
- 129
0
votes
0
answers
173
views
DataBase Design for frequent delete operations
We have a use case wherein we want to store incoming data and invalidate all the previously existing data pertaining to one parent entity.
ie Parent p1 --> has List< child> old_data ( already ...
- 1
0
votes
1
answer
47
views
Ensure that Room No. of a Course's Section is within the permitted Rooms for that Course with some Constraint
I am facing difficulties establishing constraints in the following situation. This is a hypothetical scenario for practicing DB designing.
Imagine, a rule in a School states that the Courses there ...
- 129
1
vote
1
answer
724
views
Using the primary key as a foreign key
I have data spread across two tables shipments and shipment_data. Currently I have the standard auto increment primary key id for shipments and a manually assigned unique primary key id for ...
- 165
2
votes
2
answers
2k
views
Designing database: split into different tables or group them together?
I am fairly new to database design and now trying to build my own forum-based application. The app will have nested categories as
countries > systems > levels > subjects
In every subject ...
- 123
0
votes
2
answers
552
views
Application/Database design where two tables have both 1-to-many and 1-to-1 relationships
I have an application where the requirements are to show a list of (just for example) car manufacturers. When you click on one of the manufacturers, a list of car models show up. You can then click on ...
- 323
-1
votes
3
answers
736
views
DB architecture for managing items of different categories
I'm making a rental app which has many categories with unique properties
Example:
Category 1
Car which has
Fuel, model, color, speed
Category 2
Apartment which has
Rooms, lift, ...
0
votes
1
answer
370
views
MySQL linter: Letting an installed python package Integrate with a user-written python module
I'm working on a new style of database migration system that is coming along nicely. There is one last aspect of it that I want to finish, which is to enable MySQL linting. For background, this is a ...
- 396
3
votes
2
answers
2k
views
How to Define Service Area – with Zip Codes?
I'm working on a site for at-home services. What is the best practice to define a service provider's service area?
My initial thought was to define each provider’s service area as a set of zip codes. ...
- 41
56
votes
4
answers
15k
views
Why is using MySQL for a dictionary website a bad idea?
I'm planning to design and set up a database to store dictionary entries (usually single words) and their meaning in another language. So, for example, the table Glossary must have entry and ...
- 491