Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

melx's avatar
Level 4

Make Table Relationship

I have a table issue and store data like this.

      Id            Unit_id        slave_id        Team_id             AcknowlegdeStatus
      1               2                   3                 5                   0
      2               2                   4                 5                   0
      3               2                   5                 5                    0
      4               3                   null             6                    0
      5               7                   null             6                     0

So i want to create a table My stock after guys acknowledged the in mystock table i will have this data Unit_id,slave_id and team_id,

How can i make the relationship with issue,mystock,sales table

Note: Unit_id, and slaveid can be combine because one unit_id can have two or three tables

0 likes
0 replies

Please or to participate in this conversation.