mardi 19 juillet 2016

How to model Abstraction in SQL?

I have a list of "home appliances" and i want to model a database to save them in a table. There are different device types with different properties/columns. Example :

User "mike" has a "TV (size inch ,energy consumption)", "fridge(min. tempreture,height,width)".

A user has a list of "home appliances".

I don't know how i could model this in a nice way. In the end, i just want to query the db : which appliances ( and their properties ) does the user have ?

Aucun commentaire:

Enregistrer un commentaire