Re: database
Re: database
- Subject: Re: database
- From: David LeBer <email@hidden>
- Date: Fri, 26 Mar 2004 21:29:22 -0500
On 26-Mar-04, at 9:12 PM, Ken Foust wrote:
I have a database in eom that is comprised of (but not limited to)
user
password
firstname
lastname
address
email
you can input data from multiple pages so I need to lock the records
to the username
so do I use a relationship or a subclass?
the user has the ability to update so i need the information to always
be with the username
hope this is clear.
how do I set up the database?
I'm not sure I understand...
But I would model that with a User and Address Entity:
User Address
userID (pk)<-------->>userID (fk)
username addressID(pk)
password streetAddress
firstname city
lastname province
email country
postalcode
Is that what you are looking for?
;david
--
David LeBer
Codebase Software Systems
site: http://www.codebase.ca
blog: http://david.codebase.ca
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
References: | |
| >database (From: Ken Foust <email@hidden>) |