db design and WOIFrame or AJaxUpdateCOntainer
db design and WOIFrame or AJaxUpdateCOntainer
- Subject: db design and WOIFrame or AJaxUpdateCOntainer
- From: WebObjects <email@hidden>
- Date: Fri, 3 Oct 2008 10:00:28 -0500
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden