Data Loading Order

This is the order in which the data objects should be loaded. It is assumed for the purposes of this example that the well, borehole, and the borehole�s working coordinate system entries are already in existence.

1      Create the Drill_String entry with a foreign key reference to the Borehole.

2      Create the Drill_Bit record and associate it with the Drill_String via Facility_Composition. Create the Facility_Connector records for the connectors and associate them to the Drill_Bit.

3      Create the BHA record and associate it with the Drill_String via Facility_Composition.

4      Create the BHA component records and associate them with the BHA via Facility_Composition. Create the Facility_Connector records for the connectors and associate them to the BHA Component.

5      Create the Drill_Pipe record (Generic_Tubular of category Drill Pipe) and associate it to the Drill_String via Facility_Composition. Create the Facility_Connector records for the connectors and associate them to the Drill Pipe (Generic_Tubular of category Drill Pipe).