Home Projects Jobs Clientele Contact


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Latest DB schema

> No, these are per-object-relation. Although you are right in that
> the info is missing.
>> Also we need to handle user types somehow, probably using user_types
>> table.
> There are no user-types as such. There are access kinds users
> have to different objects. ACL tables handle that.

I know that. But even if "bla_access:int" fields will have numbers
assigned to all user_access types, additional table that contain
"User-type Name -> integer" data may be useful when you, for example, need
to retrieve all Author co-Authors or Translators, or all Teachers's
Students(which btw is not possible to do using our current schema, since
Teacher may have a Student who is not currently using any of his courses)

> --
> Ilya A. Volynets-Evenbakh
> Total Knowledge. CTO
> http://www.total-knowledge.com

Authoright © Total Knowledge: 2001-2008