I’m struggling to get the relations right for some reason on some tables I’m trying to setup today. I’m building an app which allows posting of articles and maintaining older versions. My intent is to have an ‘articles’ and ‘article_versions’ table. The article_versions table will have an article_id table that points to articles.id.

My thinking is I want to add a current_version_id on the articles table, but I'm not sure how I should define that relationship. As of now I have an article that belongsTo article_versions. This muddles up my creation process though. As of now I'm overloading save() to do the following:

1. Save the article
2. Create a new version and save it
3. Update the current_version_id on the article table and saving it

This mostly works but feels pretty kludgey. Ideally these are the final things I want to achieve:

1. An article should have multiple versions stored
2. An article should be able to be reverted to an older version

Any thoughts or suggestions would be appreciated.