Questions tagged [relational-database]
A relational database is a digital database based on the relational model of data. This model organizes data into one or more tables (or "relations") of columns and rows
393 questions
-2 votes
2 answers
152 views
Preventing duplicate customers from company entry vs mobile sign-in [closed]
We have a system where customers can be created in two ways: By a company — the customer belongs to that company and the company can edit their information. By a mobile user — the customer has a ...
- 13
2 votes
3 answers
418 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
17 votes
8 answers
4k views
How do we distinguish between "not filled in" and "unknown" in our data store?
In our domain model "not filled in" and "unknown" are two different concepts. For example, time of death may be missing or, on the other hand, may be filled in as "unknown&...
- 2,030
-1 votes
2 answers
194 views
Should uniqueness validation be on the database level or backend codebase level in data import
There is a kinda ETL task of importing data from csv to the database in project with legacy codebase and legacy database**. Data should be validated before persisting to database. Validation includes ...
- 1,935
0 votes
0 answers
83 views
How to restructure a schema in order to support conditional (one of two tables) relations
I've been stuck on this for a while now so I decided to ask for some help. My SetTemplate needs to EITHER be connected directly to exerciseTemplate OR connected to exerciseTemplate through a ...
- 11
3 votes
1 answer
610 views
Object-oriented programming design with relational database tables
I want to understand what is considered best-practice to better align with OOP when handling relational databases. I cannot find any online examples where classes and a more maintainable/re-usable ...
- 147
0 votes
1 answer
79 views
Database Modeling for Application with Many Integrations
I’m working on an application that requires many 3rd-party integrations. I’m using Postgres to store these API responses but am having trouble for a number of reasons. These objects are frequently ...
- 109
3 votes
2 answers
227 views
how to deal with schema/constraint changes in insert-only Relational DBs?
as per request, I'll reduce this whole set of questions to 1-2 core points (thanks for the feedback ;)). I'm considering using insert-only tables for keeping the history of my data. while the ...
- 41