PreSpecd products and their CRUD sys

[dreamingmind]

I've made a new PreSpecd Model, an alias of OrderItem. It has HABTM to Image and Content. I haven't written anything else, but the associations all work in find() mode.

This is my plan for a CRUD system:

But one big open question remains. Will these records remain loose in the OrderItem table? And if so, how will they be identified? A couple of possible strategies:

• Collect these items to a PreSpecd Order
  • But the Order/Cart system is all built to work from the user_id or session_id. This would be a third type of Order discovery pattern and it's not clear how well the current code could accommodate it.
• Discover the OrderItem/PreSpecd records by their lack of order_id value
  • This seems a little vague
• Change the OrderItem/PreSpecd schema to provide a new role field that could carry the value 'prespecd'.
  • This open the opportunity to have other categories of items. Don't know what they'd be.
  • It would also allow records that came from other sources (like a customer Order) to also serve as a PreSpecd. There would be some risk of exposing customer information in the spec, but since I'm the only one who could set this field, the problem could be avoided. And at any rate, the alternative is to clone the users item to a new record and set it to PreSpecd and this would present the same risk.

[dreamingmind]

The 3rd option, Change the schema, sounds like the best course