Is this possible?

[Roberto Grzinic]

Hello to all,

well to put it simply I want to make a program for my work/diploma that would expedite the unloading and loading procces in a warehouse.

And just wanted to ask the experts here if this is possible wit SQL?

I will try develop it all by myself.

In short the program would have 4 Users accessing the same database at the sime time and would need to have live updates (30s-1 min would also be acceptable).

The program would look like a excel sheet in which evry row would cotntain the following data:
- Container(12 var chars)
- Ready for pick up(yes or no selection)
- Date (DD/MM/YY)
- Loaded truck deparuter- LTD (HH:MM)
- License plate (30 varchar)

After insertin varius data the row would change colors to indicate the status of the order:

-green completed (Container ready for pick up, truck license plate, LTD)

-orange ( Container ready for pick up, truck license plate, wating for LTD)

-yellow (Container ready for pick up, missing truck license plate and LTD)

-blue ( truck license plate missing , Container and LTD)

-red (CNT not ready)

The users would have all diferent priveleges regarding editing but all of them can see all the data

User-1 (admin)-control of all the data

User-2 (truck arrival registratio)- input and modify truck arrival time and license plate

User-3 (container unloading and loading)- input and modify truck arrival time to warehouse, time of unloading and time of finished lodaing of the truck

User-4 (moderator/supervisor)- input containers that are to be picked up in port, be able to modify existing combinations of data(example combining the blue and yelow row by copy paste the values)

Thank you in advace for any input :)