In the application I am building Projects need to be able to have Revisions. So when a user is on a specific Project's detail view I want them to be able to switch to a different Revision of that same Project from a popup menu (ex, Select Revision: 1, 2, 3, 4). The only thing we need to know about a Revision is the "Revision Number and Date." I'm assuming a project_REVISION would have its own unique ID.
Is the proper way to go about this by making a completely separate table called Revisions and create a One to Many relationship? Or would something like a Self-Relationship be what I need to do there?