As it is now, the relation table is very confusing. I see your point, but it is more important to use standard DBMS terminology. We want other DBA professionals to look at this and immediately understand it.

well maybe i am not DBA Pro enough for that, but i always prefer to think of what data i have where and not how i would call that column if my MySQL Version allready had foreign keys ;-) -- Mike Beck mikebeck@users.sourceforge.net