Data Loading Example 1

Data Loading example 1 (BHA no components)

If you use the above configuration, the data would look like the data presented in the following table, if there is no need to store the actual composition of the BHA.

Drill_String

The Borehole_Id is a foreign key to the borehole table and is the borehole in which the drill string is used.

BHA

The Bottom Hole Assembly is a logical facility used to hold the individual components that comprise it.

Drill_Bit

Drill_Bit_Type is a foreign key to the R_Drill_Bit class.

Generic_Tubular

Facility_Connector

The facility_id is the foreign key attribute that links this connector to the facility to which it belongs. The attribute Facility_Tbl holds the table name where that facility can be found.

Facility_Composition

The whole_facility_id is the foreign key attribute to the whole facility, and the attribute whole_facility_tbl holds the name of the table in which this facility_id can be found.

The part_facility_id is the foreign key attribute to the part facility, and the attribute part_facility_tbl holds the name of the table in which this facility_id can be found.

The linear_sequence is the sequence in which the components are arranged. The convention in drilling is that the first item placed in the hole is item #1, and so on. In this case, the Drill bit is the first thing in, then the BHA, and finally the drill pipe.