All Questions
Tagged with database-design schema
29
questions
0
votes
1
answer
413
views
Store UUID Reference vs. storing string in Mongodb
I am trying to store user preference for notifications.
One way to do is store types of notification in separate collection and store UUID of that notification type in user table.
e.g. notification-...
0
votes
1
answer
55
views
What is the schema to specify relationships in a flat-document structure?
I have a question about the best database schema to do this. So, we want our database schema to carry out some generic operation <> involving two units of data, x1 and x2 (e.g. a1).
// CURRENT ...
3
votes
1
answer
531
views
Is it recommended to use schemas on non-relational databases?
I'm trying to figure out if the use of schemas on non-relational schemaless databases like MongoDB is a recommended practice or a bad practice to be avoided.
I am doing research work and am looking ...
0
votes
1
answer
224
views
Database schema for products and their packages
The product is water purifier, and we are selling packages included support for changing filters.
Serial is a unique number identifying a single produced item and it's only for water purifiers not ...
0
votes
1
answer
472
views
Regarding data modeling in a NoSQL use case
I am reading the following link to learn about system designs of various systems. (This is a paid link, I am attaching all explanations below.)
In an attempt to explain the system design of Instagram ...
0
votes
1
answer
50
views
Descriptive short term for a field that has been set to read-only in anticipation of removal?
I'm currently writing a design to add the possibility to mark a field or attribute for an entity as read-only in preparation for imminent removal. The idea is that, once the field has been thus marked ...
0
votes
5
answers
1k
views
How to create a db schema for "if this then... elseif .... elseif ..." and so on?
I want to create an app where a user will go through a series of steps every day. All the subsequent step will depend on the previous ones, that is, 2 users can have different experiences depending on ...
9
votes
5
answers
9k
views
Use UUID on top of auto increment ID
I am trying to design the DB schema of my new project and I need some suggestions. I am thinking to have one extra column for some tables which is a UUID. I wanted mainly for tables which contain data ...
1
vote
1
answer
92
views
Database Schema design of server running status log
I am working with 4 AWS EC2 instances (servers). Each Instance has Instance ID and Instance Name. Instance ID is unique. Each of them having multiple application servers, like on of them is running ...
0
votes
1
answer
69
views
Using schemas for confining data for each customer (or filtering against a customer table)?
I'm planning a database which will contain data for many projects / customers.
Data for each customer will be totally independant. However they will all have the same structure.
So I'm wondering, ...
3
votes
1
answer
5k
views
CMS database schema design advice
I am designing a CMS, and would like to start with a simple database schema, with the requirements
Two main types of entity,Post and Category
For Post, it need to support multilingual and versioning
...
3
votes
2
answers
1k
views
Where to put the Country Table?
It might sounds like a silly question but here is my problem.
We have 100s of databases and in each of those databases, there is a country table. It was ok this way but we ran into minor problems at ...
0
votes
2
answers
908
views
DB Schema for a questionnaire - Different output from different combinations of responses
A user is required to complete a questionnaire - answering the questions in various categories.
Depending on the responses from the user, the user will be presented with a number of recommendations.
...
1
vote
1
answer
2k
views
Laravel relationships and database schema
I am playing around with Laravel and came across something in the documentation for defining 1 to 1 relationships between tables that I would like to get feedback on.
The example in the docs is ...
3
votes
3
answers
897
views
How to track temporal changes in a database?
Imagine a software for theater owners. You can accept reservations for the different cinema halls. Each hall has a different number of seats.
Say the owner wants to know how many people visited the ...