Dataset_Set_Inventory_X is used to resolve the many-to-many relationships between Seismic_Dataset_2D and Geophysical_Inventory. In addition to its own surrogate key, it contains only foreign keys Seismic_Dataset_Id to the Seismic_Data_Set_2D instance for each line and GeOphysical_Inventory_id to the instance of Geophysical_Inventory associated with the instances of Header_Text containing the records of the UKOOA P1/90 header.
Id |
Seismc_Dataset_Id |
Geophysical Id _inventory_Id |
100883 |
100655 |
100775 |
100884 |
100656 |
100775 |