Hello, Well I have a dilemma here. Im not too good with db desings,.. so what I have its the following:

A table Employee with the following attributes:

id:PK
eMail
name
password.

a table Turn with the following

day (The name of the week day)
id:PK
code
startingTime
endTime
maxEmployee


and a Join table created via (create relationship button)

TurnXEmployee
id:pk
dateOfTurn
code
idEmployee
idTurn

the code's atributes are like the oid's

ok so a few questions... should I put the eMail as Pk in the EOModel.. or just put it as Unique in the db schema in openbase?
the same question as for the codes.?

in the TurnXEmployee, I will need to add the code as pk(inEOModeler) or unique(in the DB)? this is because a Employee may have multiple turns, btu at the same time multiple turns of day "monday" ie.
and the same question for eMail in Employee table?

Now. I asked a few days ago about the way to make this work. Overview: An Employee will log in to the system ( via eMail and password) and then a new page loads with a selectable calendar made with JS. when the user selects a day then in the right part of the page the turns for the selected day (day of the week) (mon - sun) will appear and the user can select during what time he want to work. and then submit. I read about the AjaxUpdateContainer, and the bindings it should have. but I dont know too much about JS or Ajax. (Im on the process in learning, pain in the ass), my question its.. if a WOIframe will work too? or will be easier and nicer to do it with the AjaxUpdateContainer. I tried to see the examples but could not find them...

thx

Gustavo
PS well there on the model explanations oare more things to validate in the .java's files but the main idea its there.



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to