Hello guys, I was planning to implement a table st...
# sql
j
Hello guys, I was planning to implement a table structure similar to the following one in my project (see picture below). But looking at it, I was thinking that inheritance could be a better fit, isn’t it? My media table would have a Many-to-one relation to multiple other tables. So I was thinking that I could just have a base « Media » table and one sub Media table per other table. That would increase performance since I could just select, insert, delete in a specific small table instead of a big Media table? I would like to have advices on this. Thanks in advance!