PartNumber Management
I'm working at Telit Comunications S.p.A. What we need is a group of modules that will be added to an intranet site that already exists. The modules will be an interface for various users that have to manage some types of data, all this data is saved to a database structure that already exists. Some users may need to upload different files that belongs to some data inserted before by another user.
The whole purpose of this intranet site is to have a better flow control of the new products before they are released.
A brief introduction to the components follows:
Sofware Versions management:
-
Allows to insert in the database each software version to be released with it's binary file.
-
Allows to read and modified the data inserted in the database.
Software version package management:
-
Insert a new software version package. The properties of a SWPackage would be:
-
A group of files that could be inserted at the moment or/and selected form those already saved in the database.
-
Internal release date
-
Production Release Date
-
Validation proccess (an Enum)
-
Bugged (a boolean)
-
-
Read: presents the information of the seleced Software version
Product management:
-
Insert a new product (Name of the product) and inserting also some properties of that product.
-
Read: Shows up a table of all the products and allows you to inspect the products individually
PartNumber management:
-
Insert a new PartNumber (15 digit string), and relate it to one SWPackage and one Production
-
Read: List all the PartNumbers in a table that shows up also some other data ad the Relase Date and the validation status of the SWPackage related.
We use MySql 5.0 and PHP 5. I will provide the database dump (a .sql file) and the MySql workbech Model File (.mwb) of the database and also further explanations.
We need this before the second half of August 2010.
