1 of 1 people found this helpful
It depends. Data modeling is an imperfect science.
Sounds like your project can get pretty complex quickly.
I think that the data arrangement that you specified sounds reasonable. Instead of an entity called "Production", I might name it "Jobs". The job would go through specified stages of production...printing, stretching, and finishing. This can be specified by a Status or Job Stage field in the Jobs table. Sounds like each job might relate to a line item on an invoice (one particular image)? I might create a script that creates multiple jobs from an invoice.
Hope that helps.
I have developed an ERP system for my printing company. Attached is a high level chart of it's basic workflow. While it sounds like your printing companies structure is considerably different than ours ( I sure would like to get paid before production begins), you may find it useful.
Below is how it somewhat corrosponds to your sytructure,
Company Items = Products
Invoices = Invoices
Accounts = Customers
All major modules (Sales Orders, Work Orders, Shipments, Invoices, etc.) have Line Items.
FlexoEDGE Workflow.pdf 1.6 MB
Thank you for your input. I think this could probably work. When I did it the first time (still a beginniner), I forgot the lineitem table and got problems later. Now I am trying to fix it but am a bit lost in the process. The majority of the peoples selling products will sell non custom items.
In this case, everything about the item is custom (image from the client, material, completely custom size, other options, etc). And the prices changes by quantity of each material on the same order. For example, if I order 5 differents images x 10 copies each on the same material, the price quantity of 50+ will be applied on all prints. So I am a bit lost on which info to put in the product table and which info in the lineitem table.
I would like to work in this order. The client is selected ----> new invoice ----> add the first file, which will each time create a new product and will after get added on the invoice -----> add the second file and so on.
Thank you again!