Linked Questions
21 questions linked to/from Is there a name for this database schema of key values?
0
votes
1
answer
324
views
DB Structure: one table to hold all domain values? [duplicate]
One database I recently start working with was designed with one main table containing all possible values, and foreign keys in other tables are specifying the nature of each of those items.
CREATE ...
- 143
0
votes
0
answers
96
views
When is should/shouldn't the Entity Attribute Value (EAV) pattern be used? [duplicate]
Possible Duplicate:
Is there a name for this database structure?
The Entity Attribute Value (EAV) pattern usually has three columns: foreign key, attribute, and value. Attributes of data are ...
user10719
0
votes
2
answers
90
views
Multiple types of parts with multiple types of information (unspecified amount) [duplicate]
I'm having trouble designing a database for a project I was working on recently. It's to do with a garage management system.
So I've realised I need to store multiple types of parts (Tyres, engines, ...
0
votes
0
answers
64
views
How to properly design this type of relationship [duplicate]
I am building a model with the following requirements:
Items may have attributes
Attributes may be of type: 'Choice', 'FreeText', 'Number'
I am not quite sure how to relate the item to attribute ...
- 101
1
vote
0
answers
45
views
Advice on designing databases for things like Posts and categories; and general rule of thumbs [duplicate]
I'm creating my own website with a capability to CRUD posts and other related stuff like category, tags and other things (I believe it's similar to the first two mentioned).
Posts: (current create ...
- 151
45
votes
1
answer
22k
views
Commonly Used Acronyms by Database Administrators
What are the most commonly used acronyms among database administrators and what are their correlated meanings?
This is for the community and those searching for meanings of commonly used terms and ...
2
votes
1
answer
4k
views
Alternatives to EAV model
I am looking for a design pattern that would allow me to capture metadata relating to columns on a table. More specifically, here is my situation.
I have a database with fields in a field table, ...
4
votes
2
answers
520
views
Is EAV an appropriate design for a collection of coexisting metadata-rich "fact estimates" on objects? [closed]
I'm attempting to architect a system that will collect estimates on various quantities (10+) on each of many (300K+) objects, and make decisions from the historical record of these estimates. For ...
- 141
5
votes
1
answer
4k
views
Schema for analytics table in Postgres
We use Postgres for analytics (star schema).
Every few seconds we get reports on ~500 metrics types.
The simplest schema would be:
timestamp metric_type value
78930890 FOO ...
- 53
2
votes
1
answer
1k
views
Nullable columns or jsonb for storing user profile?
I'm deciding between using nullable fields or jsonb to store user profile. Initially, this would be used for contacts: email and phone. I anticipate that there may be other columns added later, such ...
- 749
2
votes
1
answer
2k
views
Attribute and Value tables on SQL - Is this a good practice?
I'm not a SQL expert and I'd like to ask for the best practices on the following schema.
On my current project, we're using Attribute and AttributeValue tables quite often. I'm thinking this might ...
- 121
3
votes
2
answers
2k
views
How to design future proof tables?
I am new to database design and have started developing my first schema.
Some of my tables (e.g. user_profile) I am struggling to come up with an exhaustive list of fields for the table. A particular ...
- 519
-1
votes
2
answers
1k
views
EAV in postgresql
I'm building an application that needs to be deployed several times, with a relatively well organized data model. A table needs to be configured for each deployment with a small number of additional ...
- 1
1
vote
0
answers
849
views
How to handle many columns / variable schema?
I apologize in advance in case this question has been asked already.
I'm working on revamping a reporting application used within my company. The requirements are:
Support addition of new fields (...
- 11
2
votes
1
answer
425
views
Is having all entity tables inherit from one main entity table a bad idea?
My co-worker is designing a schema where most entities (like contacts, quotes, tasks) inherit from an "entity" table, which keeps track of things like which tenant owns the entity, and chagnes to the ...
