| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> Nullable Foreign Keys?
I have 3 tables: TUsers, TUserGroups, TUserGroupMembers. Now I want to
create a new table TPermissions which needs to contain information about
what a user or a usergroup has permissions for in my application. To that
end I'm thinking something like:
TPermissions
where the 2 last columns are foreign keys into TUsers and TUsergroups. The point being that each permissionitem must/can have *either* nUserID *or* nUserGroupID. Is this bad design? One of them will always be NULL. Is there a better way to implement something like this?
Jesper. Received on Mon Sep 13 2004 - 08:24:35 CDT
 |
 |