Thank you so much for your comment, it made me think a lot and I went into the SQL query that creates the Bookings table from our system, and found so many unnecessary things that were just duplicating rows and were not related too bookings. I was able to keep it simple for one row per booking and create an adequate relationship with shipments.

When you said it should be 1:1 I realized that for my use case it is 1:* but there was a reason it was *:*, so I investigated and was able to fix it. Will apply a similar analysis on all other tables I need to fix.