Re: My StockManger Relational Model
Re: My StockManger Relational Model
- Subject: Re: My StockManger Relational Model
- From: Ken Anderson <email@hidden>
- Date: Mon, 17 Nov 2008 10:41:54 -0500
Even better... some databases use 'desc' to mean descending sort,
and is a reserved word...
I always use descr
:)
Ken
On Nov 17, 2008, at 10:34 AM, Ray Kiddy wrote:
On Nov 17, 2008, at 4:28 AM, David Avendasora wrote:
Hey Gus,
You'll probably need a "Purchase Order" entity with information
like vendor, order date, due date, user who placed the order, etc.
And a "PO Item" entity that has information like Product, Quantity
Ordered, Quantity Received, Price, etc.
Going beyond the basic, you may want individual due dates for each
PO Item so that you can order multiple things on one PO that are
due at different times. You may also want to have a "PO Item
Receiving" entity that keeps track of each time a product is
received for a given PO Item in case the Provider makes more than
one shipment.
Other than that, the Model looks sound from both a DB and a EOF
stand point.
Dave
On Nov 17, 2008, at 6:00 AM, Gustavo Pizano wrote:
Ok so here is an initial Model of the new app im making. The main
idea of this phase is to be able to implement the operations of
insert delete, update for the app, also I want to implement some
method who will tell me when one product is getting close to be
out of stock, and email the admin about it so he can place an
order. So far thats it, just place an order, but do nothing else.
So here is the model, I dunno what Im missing, comments are
welcome.
Gus
<StockManagerRM.pdf>
There is a "description" attribute in the "PRODUCT" entity. This may
no longer be relevant, but I avoid the use of the word "description"
and I use "desc" instead. It may no longer matter, but why tempt
fate? In the old EOF tools, this word in particular would cause a
problem because (if I recall...) it was a method in the ObjC
NSObject class. There are also SQL keywords that I try to avoid in
attribute or entity names. Every once in a while, I forget and put
in a "class" attribute, which does wonky things. This may depend on
one's choice of database....
Are the other words that people stay away from? We do have a new
tool chain, but there are new bugs and a lot of NPEs in the eclipse
tools....
cheers - ray
_______________________________________________
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
_______________________________________________
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