How to get backordered shipment line details from sql query

Summary:

Fetch Lines details for Shipments which are Backordered through query

Content (please ensure you mask any confidential information):

We have a shipment which is backordered due to certain business condition but we would like to retrieve the shipment line level information which we updated against the shipment before backordering the shipment.

Once we backorder the shipment we loose the line details from the header of shipment and the shipment when we query will only show the header details.

I would like to get the line details which were associated to this backordered shipment from query. Can somone help me with the tables from where i can get this information.