A
A
aglgl2020-03-20 14:07:04
Database design
aglgl, 2020-03-20 14:07:04

Inventory on django how to properly link tables?

Stuck when thinking about the inventory system.

There is the following part of the structure, the correctness of which I am not sure.

space location of
work station
---includes computers and monitors
---relevant to 1 space

Worker
---relevant to 1 work station

InventoryObject from which all inventory objects are inherited
Comp
---relevant to 1 work station
Monitor
---Relates a lot to 1 work station
Phone
---Relates a lot to 1 worker
Tablet
---Relates a lot to 1 worker

It turns out that some inventory objects cling to the worker through the work station, and some directly

. If I want to log the movement of objects, then confusion is obtained.

Please let me know if I have set up the connections correctly. Or is it better to do it differently from the beginning and not attach the work station to the employee, but at the same time you will have to make a lot of changes when the employee is fired?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question