Question : I am having a doubt on designing a schema for my current project in MySQL. It is mainly […]
Tag: eav
Table with relation to two others (three-way relation?)
Question : I stumbled across a weird situation that one table has relation to two others but record in it […]
Designing a schema for an entity with 40 attributes
Question : I am having a doubt on designing a schema for my current project in MySQL. It is mainly […]
SQL to merge related documents into 1 query row (MySQL)
Question : I’m working with the following data structure: users | field| value | — | — | id | […]
MYSQL Select data from two different tables BUT represent the data in multiple rows
Question : I am needing to select all email addresses from two different tables with a single query. The goal […]
Query to find products with all the given attributes
Question : I have a table in mySQL to store product attributes like this: ———————————— | product_id | att_val1 | […]
MySQL Best approach for recording last update timestamp for every column and every row
Question : This question is about possible approaches for time stamping every column of every row in a table. I […]
Disadvantage of Changing database schema – Insert or delete new columns/tables in middle
Question : As a read in lot of links , for e-commerce shopping sites, as it may require to add […]
How To Store EAV Data When It Has Nested Objects/Entities
Question : I have json data that have both nested objects and attributes. Eg of one json object: (After json_decode […]
Inventory database structure when inventory items have varying attributes
Question : I’m building an inventory database to store enterprise hardware information. The devices the database keeps track of range […]