[
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
>
>