On Fri, 15 Sep 2000 11:34:20 +0200, Turbine wrote:
> Jon Stevens wrote:
>
> > > ouch. this was discussed before. what about "UserGroup", I'd like to
keep
> > > class
> > > name though (we have 'User' class and 'Visitor' table...)
> >
> > I still don't like it. What is your dislike of "Team"...group and team
are
> > the same thing.
>
> Oh maybe it's just me not being native speaker. For me 'a team of people
entitled
> to press a button' souds silly.
> On the other hand, it seems the cleanest soulution because of 'group'
being reserved
> word in SQL. I take back 'UserGroup' proposal. It would be very
misleading.
> If none better alternatives show up, I'll rename it to Team in a few
days.
>
> I think that we could also rearange the DB schemas.
> Visitor -> User
> UserRole -> Role
> VisitorRole -> UserTeamRole
+1 I like your renaming.
But I am still in confusion. Those should rather be Objects or projects...
Could anyone give a live example of teams' application?
>
> We should also decide what to do with the columns of Visitor (User)
table.
> It's not practical to try including there all fields that applications
would
> need. Such special attributes should be kept in Perm (objectData). On the
> other hand we need to have the attributes that are likely to be used for
> looking up an user as column (LDAP attributes), because otherwise they
> couldn't be used in queries.
I have a suggestion. What about factoring out all attributes (except, maybe,
for those used by system: login, passwd, e-mail etc.) into a USER_ATTRIBUTE
table with ATTRIBUTE_TYPE_ID foreign key to USER_ATTRIBUTE_TYPE. This would
make queries somewhat slower and more complex, but would allow to flexibly
configure attribute set depending on real needs without schema & code
changes. But unlike using objectdata it would still allow querying for them.
fedor.
_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
