I am currently having a trouble with my Web Application. I made a Web application for a certain company. I made the app using CodeIgniter 3.
I built the database using Maria DB. For the id in each table, i am using Incremental Id for my application database for each table. I usually deploy the web app to the cloud server (sometimes the company have their own dedicated server, but sometimes haven't ). One day, there is a company that they don't want to deploy the app that i have made before to the cloud ( for the security purposes they said ).
This company wanted to deploy the app to the employee's PC personally in the office, while the pc for each employee not connected to each other ( i.e stand alone pc/personal computer/employee's Laptop ). They said, for every 5 months, they would collect all of the data from employee's personal computer to company's data center, and of course the data center are no connected to the internet. I told them that's not the good way to store their data. ( because the data will be duplicate when i am trying to merge all of the data into one, since my database id are in Incremental id ). The id would be collapse while my database are incremental ID. But, The company still kept to make the app that way, and i don't know how to solved this. Does anyone know how to solved this problem ?
They have at least 10 employees that would used this web app. According that, I have to deploy the app to the 10 PC personally.
Additional info : Each employee have their own unique id which they got from the company
The study cases is what i describe below: id | employee_id | employee_name | 1 | 156901010 | emp1 2 | 156901039 | emp2 3 | 156901019 | emp3 4 | 156901015 | emp4 5 | 156901009 | emp5 6 | 156901038 | emp6
the problem is whenever they fill the form from that application, some of the table are not stored the employee's id but the new id that come from increment id.
electronic_parts table. They have the attribute like below:
| id | electronic_part_name | kind_of electronic_part |
if the employee 1 fill the form from the web app , the table's content would like below.
| id | electronic_part_name | kind_of electronic_part | | 1 | switch | 1 |
and if the employee 2 fill the form from the web app , the table's content would like below.
| id | electronic_part_name | kind_of electronic_part | | 1 | duct tape | 10 |
When i tried to merge the contents of the table into the data center it would falling apart because the duplicate id.