jeudi 23 novembre 2017

MySQL organisation - arrays or ids

so currently I have a video table and a source table, like this:

Video:

id | description | sources
--------------------------
1  | Video Desc  |[0,2,3]

Source:

id | link
---------------------
0  | http://stuff.org/film
2  | http://video.net/vid

My question is, should I keep it like this or should I remove the "sources" field from my video table, and add a videoid field to my source table?

Thanks in advance




Aucun commentaire:

Enregistrer un commentaire