jeudi 26 avril 2018

MySQL Database Structure with revisions/history

I've been looking into various DB Structures for the task I'm trying to achieve but it seems like my ideas are flawed. I first looked into wiki's DB but seemed a bit complicated for what I want to do and then I saw https://www.themoviedb.org/movie/337167-fifty-shades-freed/changes this which looks closer to what I am trying to do.

I was thinking of having a table which will keep the final form and an extra table where it will keep all the revisions/history. I am not sure though if that would be too much. Although I am not sure the above example is using this method.

Aucun commentaire:

Enregistrer un commentaire