Re: My StockManger Relational Model
Re: My StockManger Relational Model
- Subject: Re: My StockManger Relational Model
- From: David Avendasora <email@hidden>
- Date: Mon, 17 Nov 2008 07:28:28 -0500
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>
_______________________________________________
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