Hi.
I have a pretty complex problem and i'm not sure how to map it.
I have a standard tomcat User & UserRoles tables setup.
I also have what's going to be an event/class scheduler with the tables Event & EventInstructor
the schema looks like this:
Code:
---------- ----------------
| User | | User_Role |
---------- ----------------
| ID (int) | | ID (int) |
| Name | | user_id (int) |
| ... | | role (varchar) |
---------- ----------------
---------- ---------------------
| Event | | Event_Instructor |
---------- ---------------------
| ID (int) | | instructor_id (int) |
| Name | | event_id (int) |
| ... | ---------------------
----------
Problem #1:
How do i map the Event & User using the Event_Instrucotr table?
I've looked at some posts about many-to-many, but my problem is that and event may or may not have an instructor, but if it does it can only have 1.
Problem #2:
An instructor is a User who has the role "instructor" in the User_Role table.
Not sure how to get only these Users to map to the Event_Instructor table.
Again, and event may or may not have up to 1 instructor, but and instructor can have many events.
Can anyone help me map this?
Thanks!
- Jonathan
Login
FAQ
Search