Design Question on Inventory System
Hi Team,
I'm scratching my head at this one. I have 4 tables:
1. Sites
2. Daily Inventory Update (linked CSV file from SFTP site)
3. Manual Inventory Updates
4. Appointments
Typically for my inventory apps, i make a warehouse table but in this use case, the sites that need the stuff are also the warehouse that store the stuff in several cases. Does it make sense to create 2 relationships between the MIU table and the Sites table to indicate to and from regarding listed inventory items?
------------------------------
GMacri
------------------------------
I'm scratching my head at this one. I have 4 tables:
1. Sites
2. Daily Inventory Update (linked CSV file from SFTP site)
3. Manual Inventory Updates
4. Appointments
Typically for my inventory apps, i make a warehouse table but in this use case, the sites that need the stuff are also the warehouse that store the stuff in several cases. Does it make sense to create 2 relationships between the MIU table and the Sites table to indicate to and from regarding listed inventory items?
------------------------------
GMacri
------------------------------
