I designed out a mostly attribute driven database. Originally i was
going to use PHP, but have now decided to use RoR. Being able to use the
built in OR functionality would be nice, but I am not sure how well it
melds with attribute dbs.
If anyone can give me some pointers, I would really appreciate it
(especially since this is my first endeavor and on an important project
Db Schema: http://urbaninfluencedev.com/schema.html
tbl_workspace is the core table. This is where the working objects are
housed (projects, tasks, to-dos, contacts, invoices, notes, email,
tbl_entities holds the base information for users, groups and such.
the tbl_attributes is then the attributes associated to any given
workspace or entity.
There are 3 primary levels of security in that is database/data driven.
- the item level active state (boolean - aka tinyint)
- sec type - which defines if the item is has explicit or relative
security (for security inheritance)
- the security table reference which then gives the actual security
As such, you will note that there are a lot of relationships between the
differing tables as well as inner-table relationships.
The thing is that i am not sure if the Act As functionality
(act_as_list) will be enough to pull the data as needed and to be as
clean and simple as OR is suppose to be.
Any advice… or even simple smack in the right direction would be highly