Forum OpenACS Development: Re: cr_item or acs_object

Collapse
3: Re: cr_item or acs_object (response to 2)
Posted by Dave Bauer on
Do you need to permission each row of the rates table? If not you might not need acs_objects or content_items at all.

I think a simple table of current rates and an archive table of historical rates would work. You could do it all in one table as well, depends how often you need to refer to each.

Collapse
4: Re: cr_item or acs_object (response to 3)
Posted by Iuri Sampaio on
In fact I don't. That simplifies a lot!

I'll design it to storage all in one table only, with a new column to storage the date (timestamptz)

The idea is to show the latest rate in a headline panel, plus I'll built a forecast graphic based on its historic.

Thanks Dave.

Best wishes