• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: My StockManger Relational Model
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: My StockManger Relational Model


  • Subject: Re: My StockManger Relational Model
  • From: Gustavo Pizano <email@hidden>
  • Date: Mon, 17 Nov 2008 16:33:38 +0100

Hello David, thanks for the advices, if I understood good, then my initial phase RM shold looks like this.



Attachment: StockManagerRM.pdf
Description: Adobe PDF document



I have a doubt about the following:

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
So wha tyou are suggesting is to pass the dueDate attribute from PURCHASEORDER to PURCHASEORDERITEM?

well let me know what you think, for me it looks fine, but well thats for me... hehehe.. so I can continue to create the EO and then use migrations.
regards


Gus



On 17.11.2008, at 13:28, 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>



_______________________________________________
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

  • Follow-Ups:
    • Re: My StockManger Relational Model
      • From: David Avendasora <email@hidden>
References: 
 >My StockManger Relational Model (From: Gustavo Pizano <email@hidden>)
 >Re: My StockManger Relational Model (From: David Avendasora <email@hidden>)

  • Prev by Date: Re: My StockManger Relational Model
  • Next by Date: Re: My StockManger Relational Model
  • Previous by thread: Re: My StockManger Relational Model
  • Next by thread: Re: My StockManger Relational Model
  • Index(es):
    • Date
    • Thread