AQ2DB 3: Database Tables

AQ2DB 3 database description

Document number 00-0000-X00-000
Version 1.41
September 27, 2004

NOTICE: The recipient of this document will not reproduce or distribute it, in whole or in part, without
the prior written consent of AQUILA Mining Systems Ltd., and will permanently keep confidential all
information contained herein. AQUILA Mining Systems Ltd. reserves all rights to this document.

Aquila Mining Systems Ltd.

 Revision History
Date Revision Description Author
Dec 5, 2003 1.40 Formalization Ryan Adams
Sept 27, 1.41 Fixed an inaccuracy regarding Ryan Adams
2004 hole_information.type
 Table of Contents

1. Introduction ______________________________________________________ 1
1.1. Purpose __________________________________________________________ 1
1.2. Overview _________________________________________________________ 1
2. Drill tables _______________________________________________________ 2
2.1. The nature of Aquila’s on-board drill reporting____________________________ 2
2.2. Shift information ___________________________________________________ 2
2.2.1. DRILLNUMBER __________________________________________________________ 2
2.2.2. TIME_START ____________________________________________________________ 2
2.2.3. TIME_END ______________________________________________________________ 3
2.2.4. OPERATOR_NAME _______________________________________________________ 3
2.3. Production / Delay information ________________________________________ 3
2.3.1. DRILLNUMBER __________________________________________________________ 4
2.3.2. TIME_START ____________________________________________________________ 4
2.3.3. TIME_END ______________________________________________________________ 4
2.3.4. DELAY / PRODUCTION_STRING____________________________________________ 4
2.3.5. TYPE ___________________________________________________________________ 5
2.4. State Information___________________________________________________ 5
2.4.1. DRILLNUMBER __________________________________________________________ 5
2.4.2. TIME_START ____________________________________________________________ 5
2.4.3. TIME_END ______________________________________________________________ 5
2.4.4. STATE__________________________________________________________________ 5
2.5. Drilling information_________________________________________________ 8
2.5.1. Relationship among drilling information tables ___________________________________ 10
2.5.2. Common column: Drillnumber _______________________________________________ 10
2.5.3. Common column: Time_start ________________________________________________ 10
2.5.4. Common column: Time_end_________________________________________________ 10
2.5.5. Consumables table ________________________________________________________ 10
2.5.5.1. Consumable __________________________________________________________ 10
2.5.5.2. Consumable_type______________________________________________________ 10
2.5.5.3. Meters ______________________________________________________________ 10
2.5.5.4. Rotation _____________________________________________________________ 10
2.5.5.5. Energy ______________________________________________________________ 11
2.5.6. Hole_Information table _____________________________________________________ 11
2.5.6.1. Drilling_time _________________________________________________________ 11
2.5.6.2. Actual_depth _________________________________________________________ 11
2.5.6.3. Actual_name _________________________________________________________ 11
2.5.6.4. Actual_pattern ________________________________________________________ 11
2.5.6.5. Actual_blast__________________________________________________________ 11
2.5.6.6. Design_depth _________________________________________________________ 11
2.5.6.7. Design_name _________________________________________________________ 11
2.5.6.8. Design_pattern________________________________________________________ 11
2.5.6.9. Design_blast _________________________________________________________ 11
2.5.6.10. Type_______________________________________________________________ 11
2.5.7. Hole_Position table ________________________________________________________ 12
2.5.7.1. Collar_elevation_______________________________________________________ 12
 2.5.7.2. Northing ____________________________________________________________ 12
2.5.7.3. Easting______________________________________________________________ 12
2.5.7.4. Elevation ____________________________________________________________ 12
2.5.7.5. Heading _____________________________________________________________ 12
2.5.7.6. Mast_angle __________________________________________________________ 12
2.5.7.7. Horizontal_accuracy____________________________________________________ 12
2.5.7.8. Vertical_accuracy______________________________________________________ 12
2.5.7.9. Design_northing_______________________________________________________ 12
2.5.7.10. Design_easting_______________________________________________________ 12
2.5.7.11. Design_elevation _____________________________________________________ 13
2.5.7.12. Design_heading ______________________________________________________ 13
2.5.7.13. Design_mastangle ____________________________________________________ 13
2.5.8. Hole_Profile table _________________________________________________________ 13
2.5.8.1. Depth_______________________________________________________________ 13
2.5.8.2. Rpm________________________________________________________________ 13
2.5.8.3. Weightonbit __________________________________________________________ 13
2.5.8.4. Torque ______________________________________________________________ 13
2.5.8.5. Rop ________________________________________________________________ 13
2.5.8.6. Air_pressure__________________________________________________________ 13
2.5.8.7. Vibration ____________________________________________________________ 13
2.5.8.8. Bi__________________________________________________________________ 13
2.5.8.9. Rock_type ___________________________________________________________ 13
2.5.9. Hole_Profile_Blob table ____________________________________________________ 14
2.5.9.1. : File_contents ________________________________________________________ 14

Table of Figures
Figure 1 - Shift panel ......................................................................................................................................................3
Figure 2 - Delay / Production code panel...................................................................................................................4
Figure 3 - Starting a hole...............................................................................................................................................6
Figure 4 - Operator confirms the end of hole.............................................................................................................6
Figure 5 - Leveling button..............................................................................................................................................6
Figure 6 - Leveling screen .............................................................................................................................................7
Figure 7 - Return button.................................................................................................................................................7
AQ2DB 3 Rev. 1. Aquila

1. Introduction

1.1. Purpose
The purpose of this document is to describe the structure and operation of the
database that is initialized and populated by AQ2DB3.

1.2. Overview
AQ2DB3 is responsible for creating a set of tables designated for containing
Aquila Drill, Aquila Dragline, and CAES productivity data, as well as populating
these tables with the data. This document will describe the table structures, the
data that is put in to each table, and the relationships between the various tables.

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 1
AQ2DB 3 Rev. 1. Aquila

2. Drill tables

2.1. The nature of Aquila’s on-board drill reporting

Aquila’s on-board system effectively records 4 main independent groups of data:
Shift information, production/delay information, state information, and drilling
information. For a given drill, each group of data operates independently from the
others, and each group of data consists of a series of sequential events. Thus, there
can only ever be one operator logged in at a time (or no operator), only one delay
or production code in effect at a time (or none), etc.
In addition, there are other sets of productivity data that are stored according to
unique events, such as the drill’s position & the addition of consumables.

2.2. Shift information

All shift information is contained within one table – the aptly named “SHIFTS”
table. The shifts table contains one entry (row) for each shift. This entry is
uniquely identified by a combination of the “drill number” (database ID of the
drill) and the “time start” (time when the operator logged in).

SHIFTS
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant Number of the current drill
PRIMARY KEY number
TIME_START DATETIME NOT Date / time Date / time when shift started.
NULL PRIMARY KEY stamp
TIME_END DATETIME NOT Date / time Date / time when shift
NULL stamp
OPERATOR_NAME VARCHAR(64) NOT Constant Name of operator for shift
NULL string
Table 1 - SHIFTS table

2.2.1. DRILLNUMBER
This column indicates the Aquila ID for the drill. It comes directly from the drill
configuration.

2.2.2. TIME_START
This column indicates the beginning of the shift. This is triggered on the Aquila system
when the operator punched in at the start of their shift. This is done by pushing a button
in the shift panel, as seen in the figure below.

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 2
AQ2DB 3 Rev. 1. Aquila

Figure 1 - Shift panel

2.2.3. TIME_END
This column indicates the end of the shift. This is triggered either when the user
manually punches out on the Aquila system (using the shift panel, illuminated in the
figure above), or when another user logs themselves in.

2.2.4. OPERATOR_NAME
This column indicates the name of the operator punched in for the current shift. This
name is selected from a list that is presented to the operator when they punch in on the
Aquila system.

2.3. Production / Delay information

Production and delay information is stored in two tables: the “DELAYS” table,
and the “PRODUCTION_CODE” table. At any given time there can only be one
delay or one production code. There can be no overlap of delays or production
codes. Delays/production codes are uniquely identified by a combination of the of
the “drill number” (database ID of the drill) and the “time start” (time when the
delay/production code was started).

PRODUCTION_CODE
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant number # of current drill
PRIMARY KEY
TIME_START DATETIME NOT NULL Date / time Date / time when
PRIMARY KEY stamp production code started
TIME_END DATETIME NOT NULL Date / time Date / time when
stamp production code ended
PRODUCTION_STRING VARCHAR(64) NULL Constant string Mine specific work code
TYPE LONG INT NULL Constant number Work code classification
(ex: Production, Relocation, survey)

Table 2 - PRODUCTION_CODE table

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 3
AQ2DB 3 Rev. 1. Aquila

DELAYS
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant # of current drill
PRIMARY KEY number
TIME_START DATETIME NOT NULL Date / time Date / time when delay started
PRIMARY KEY stamp
TIME_END DATETIME NOT NULL Date / time Date / time when delay ended
stamp
DELAY VARCHAR(64) NULL Constant string Mine specific delay name
TYPE LONG INT NULL Constant string Delay classification
(ex: Operational, Breakdown, Maintenance)

Table 3 - DELAYS table

2.3.1. DRILLNUMBER
This column indicates the Aquila ID for the drill. It comes directly from the drill
configuration.

2.3.2. TIME_START
This column indicates the beginning of the delay/production code. This is triggered on
the Aquila system when the operator chooses to start a production code/delay. This is
done by pushing a button in the delay/production code panel (highlighted in the figure
below).

Figure 2 - Delay / Production code panel

2.3.3. TIME_END
This column indicates the end of the delay/production code. This is triggered either
when the user manually ends the delay/production code on the Aquila system (using the
delay/production code panel, illuminated in the figure above), or when the user chooses
a new delay/production code.

2.3.4. DELAY / PRODUCTION_STRING

This column contains the name of the delay or production code as a line of text. These
delay / production names are chosen by the operator from a list. The list of delay and
production names is stored in configuration files within the on-board Aquila system.

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 4
AQ2DB 3 Rev. 1. Aquila

2.3.5. TYPE
This column indicates the classification of the delay/production code, as a number. This
is entirely mine-configurable, and the classification of delays is done in the same
configuration files that contain all the delay and production names.

2.4. State Information

Drill state information is contained within one table: the “STATES” table. A drill
can only be in one state at a given time, and all states for a given drill should be
contiguous; there should be no gaps in the state data.

STATES
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant # of current drill
PRIMARY KEY number
TIME_START DATETIME NOT NULL Date / time Date / time when state started
PRIMARY KEY stamp
TIME_END DATETIME NOT NULL Date / time Date / time when state ended
stamp
STATE VARCHAR(32) NULL Constant string State that occurred

Table 4 - STATES table

2.4.1. DRILLNUMBER
This column indicates the Aquila ID for the drill. It comes directly from the drill
configuration.

2.4.2. TIME_START
This column indicates the beginning of the state. This is triggered automatically by the
Aquila system when certain conditions are met. These conditions shall be outlined in the
description of the “STATE” column below.

2.4.3. TIME_END
This column indicates the end of the state. This is triggered automatically by the Aquila
system when certain conditions are met. These conditions shall be outlined in the
description of the “STATE” column below.

2.4.4. STATE
This column indicates the state that occurred. The state began at the time indicated by
the “TIME_START” column, and ended at the time indicated by the “TIME_END”
column. The available states are:
? Drilling
? Leveling
? Not Moving (idle)
? Power Off
? Power On
? Propelling

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 5
AQ2DB 3 Rev. 1. Aquila

The following are the conditions under which the various states are triggered.
“Drilling” state starts:
? When the operator finishes leveling, and confirms that they wish to start
the hole, as indicated in the figure below.
? When the drill stops pipe-handling (changing steels).

Figure 3 - Starting a hole

“Drilling” state ends:

? When the drill stops drilling and starts pipe-handling (changing steels)
? When the rotary head enters the “propel” zone and the operator confirms that
they wish to end the hole (as illustrated below)
? When the drill begins to propel, even though the rotary head has not entered
the “propel” zone.

Figure 4 - Operator confirms the end of hole

“Leveling” state starts:

? When the drill operator manually brings up the leveling screen by pressing the
“leveling” button (as seen in the figure below)

Figure 5 - Leveling button

? When the drill operator finishes propelling (turns off the propel switch) with
the head located over a hole. The “leveling screen” (as seen in the figure

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 6
AQ2DB 3 Rev. 1. Aquila

below) appears on the Aquila System

Figure 6 - Leveling screen

“Leveling” state ends:

? When the drill has finished leveling (level bubble is in the centered in the
screen)
? When the drill operator clicks on the “back” button located in the upper right-
hand corner of the screen. (depicted below)

Figure 7 - Return button

“Not moving” (idle) state starts:

? When the drill leaves the “propelling” and doesn’t go into the “leveling” state.
? When the drill leaves the “drilling” state and doesn’t go into the “propelling”
state.
“Not moving” (idle) state ends:
? When the drill starts leveling, drilling, or propelling.
? When the drill is turned off.

“Power off” state starts:

? When the drill is powered off
“Power off” state ends:
? When the drill is powered on

“Power on” state starts:

? When the drill is powered on
“Power on” state ends:
? When the Aquila system finishes booting up

“Propelling” state starts:

? When the propel switch is engaged (IE drill enters propel mode)
“Propelling” state end:

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 7
AQ2DB 3 Rev. 1. Aquila

? When the propel switch is disengaged (IE drill leaves propel mode)

2.5. Drilling information

Whenever a hole is completed, information about the hole’s design, position, and
down-the- hole profile is recorded. Consumable usage for that hole is also
recorded. All the information for a given hole is stored within 5 tables:
“CONSUMABLES”, “HOLE_INFORMATION”, “HOLE_POSITION”,
“HOLE_PROFILE”, and “HOLE_PROFILE_BLOB”

CONSUMABLES
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant # of current drill
PRIMARY KEY number
TIME_START DATETIME NOT NULL Date / time Starting date/time stamp of co-
PRIMARY KEY stamp responding hole
TIME_END DATETIME NOT NULL Date / time Ending date/time stamp of co-
stamp responding hole
CONSUMABLE VARCHAR(32) NULL Constant string Consumable serial # / name
PRIMARY KEY
CONSUMABLE_TYPE VARCHAR(16) NULL Constant string Consumable type
(ex:Bit,Steel1,Stabilizer)
PRIMARY KEY
METERS DOUBLE NULL Meters Meters drilled (hole depth)
ROTATIONS DOUBLE NULL Rotation # of rotations
ENERGY DOUBLE NULL MJ (Mega Energy dissapated
Joule)
Table 5 - CONSUMABLES table

HOLE_INFORMATION
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant # of current drill
PRIMARY KEY number
TIME_START DATETIME NOT NULL Date / time Moment the operator confirms
PRIMARY KEY stamp that they are starting a hole.
TIME_END DATETIME NOT NULL Date / time Propel, starts raising bit, hits
stamp red x
DRILLING_TIME LONG INT NULL Seconds Time spent with bit breaking
ground (describe)
ACTUAL_DEPTH DOUBLE NULL Meters Depth drilled
ACTUAL_NAME VARCHAR(32) NULL Variable string Hole name
ACTUAL_PATTERN VARCHAR(32) NULL Variable string Pattern name
ACTUAL_BLAST VARCHAR(32) NULL Variable string Blast name
DESIGN_DEPTH DOUBLE NULL Meters Design depth
DESIGN_NAME VARCHAR(32) NULL Variable string Design name
DESIGN_PATTERN VARCHAR(32) NULL Variable string Design pattern
DESIGN_BLAST VARCHAR(32) NULL Variable string Design blast
TYPE LONG INT NULL Constant Type of hole
number (2=Drilled, 3=Redrilled, 4=Created)

Table 6 - HOLE_INFORMATION table

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 8
AQ2DB 3 Rev. 1. Aquila

HOLE_POSITION
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant # of current drill
PRIMARY KEY number
TIME_START DATETIME NOT Date / time Starting date/time stamp of co-
NULL PRIMARY KEY stamp responding hole
COLLAR_ELEVATION DOUBLE NULL Meters Collar elevation of hole
NORTHING DOUBLE NULL Meters Northing of hole
EASTING DOUBLE NULL Meters Easting of hole
ELEVATION DOUBLE NULL Meters Elevation of hole
HEADING DOUBLE NULL degrees Heading of hole
MAST_ANGLE DOUBLE NULL degrees Mast angle at hole
HORIZONTAL_ACCURACY DOUBLE NULL Meters Horizontal Accuracy (Euclidian,
from design) of drilled hole
VERTICAL_ACCURACY DOUBLE NULL Meters Vertical accuracy of drilled
hole.
DESIGN_NORTHING DOUBLE NULL Meters Design northing
DESIGN_EASTING DOUBLE NULL Meters Design easting
DESIGN_ELEVATION DOUBLE NULL Meters Design elevation
DESIGN_HEADING DOUBLE NULL degrees Design heading
DESIGN_MASTANGLE DOUBLE NULL degrees Design mast angle

Table 7 - HOLE_POSITION table

HOLE_PROFILE
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant number # of current drill
PRIMARY KEY
TIME_START DATETIME NOT NULL Date / time Starting date/time stamp of
PRIMARY KEY stamp co-responding hole
DEPTH DOUBLE NOT NULL Meters Current hole depth
PRIMARY KEY
RPM DOUBLE NULL Rotation / minute Current RPM reading
WEIGHTONBIT DOUBLE NULL kN Current weight on bit
TORQUE DOUBLE NULL kNm Current torque
ROP DOUBLE NULL m/s Current ROP
AIR_PRESSURE DOUBLE NULL kPa Current Air Pressure
VIBRATION DOUBLE NULL G Current Vibration
BI DOUBLE NULL % Current BI
ROCK_TYPE VARCHAR(16) Constant string Current rock type

Table 8 - HOLE_PROFILE table

HOLE_PROFILE_BLOB
Column Name Type Units Description
DRILLNUMBER LONG INT NOT NULL Constant number # of current drill
PRIMARY KEY
TIME_START DATETIME NOT NULL Date / time Starting date/time stamp of
PRIMARY KEY stamp co-responding hole
FILE_CONTENTS BLOB NULL Variable (long) Contents of HOLE_PROFILE
string report file.
Table 9 - HOLE_PROFILE_BLOB table

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 9
AQ2DB 3 Rev. 1. Aquila

2.5.1. Relationship among drilling information tables

Each and every hole can be uniquely identified by the number of the drill that drilled it,
along with the time at which the hole was started. Hence for every hole, one or more
entries with the drill number & start time of the hole are put in each of the drilling
information tables. More complete information for any hole can then be obtained by
retrieving information from multiple drilling information tables by using this hole key.

2.5.2. Common column: Drillnumber

This column indicates the Aquila ID of the drill that drilled the hole. It comes directly
from the drill configuration.

2.5.3. Common column: Time_start

This column indicates the time at which the hole was started, and is stored in the local
time format. The hole is considered to have started when the operator has finished
leveling, lowers the bit to the ground, and manually confirms that they wish to start
drilling a hole, as illustrated in “Figure 3 - Starting a hole”

2.5.4. Common column: Time_end

This column, not present in all drilling information tables, indicates the time at which
the hole was ended, and is stored in the local time format. The hole is considered to have
ended when the operator places the rotary head into the “propel” zone and confirms that
they wish to end the hole, as illustrated in “Figure 4 - Operator confirms the end of
hole”

2.5.5. Consumables table

The consumables table tracks consumable usage on a per-hole basis, with one entry for
each consumable used per hole. The following columns are specific to the consumables
table:

2.5.5.1. Consumable
Either the serial number or the name of the consumable being referred to. This
number / name is manually entered by the operator when the consumables are
changed.

2.5.5.2. Consumable_type
Refers to category of consumable that the serial number refers to. It is usually
one of: “bit”, “stabilizer”, “steel_1”, “steel_2”, “steel_3”, but can be user-
configured for specialized consumable tracking.

2.5.5.3. Meters
The number of meters drilled in the hole while the current consumable was
active.

2.5.5.4. Rotation
The number of drill bit rotations that occurred while the current consumable
was active.

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 10
AQ2DB 3 Rev. 1. Aquila

2.5.5.5. Energy
The amount of energy dissipated while the current consumable was active.

2.5.6. Hole_Information table

The hole_information table contains design & as -drilled non-positional information
about drilled holes. There is one entry per drilled hole. When the drill is stopped &
leveled, the nearest design hole that the Aquila system knows about (within range) is
taken to be the design hole, and its information is used as design information for the
drilled hole . It is possible for a hole to have no design information (strings are blank and
all numbers are 0) if the Aquila system does not lock on to a hole, or the operator
overrides the locked-on hole.

2.5.6.1. Drilling_time
The amount of time, in seconds, where the drill’s bit was detected to be
breaking ground. The bit is considered to be breaking ground when certain
thresholds are met (pressure, downward movement, etc).

2.5.6.2. Actual_depth
The actual depth of the drilled hole.

2.5.6.3. Actual_name
The actual name of the drilled hole (the design name can be
changed/overridden on-board by the operator).

2.5.6.4. Actual_pattern
The actual pattern (area) of the drilled hole (the design pattern name can be
changed/overridden on-board by the operator).

2.5.6.5. Actual_blast
The actual blast (sub-area) of the drilled hole (the design name can be
changed/overridden on-board by the operator).

2.5.6.6. Design_depth
The depth of the design hole that was locked on to.

2.5.6.7. Design_name
The name of the design hole that was locked on to.

2.5.6.8. Design_pattern
The pattern of the design hole that was locked on to.

2.5.6.9. Design_blast
The blast of the design hole that was locked on to.

2.5.6.10. Type
A number that indicates the type of hole that was drilled. A hole can be one of
three types:
1. Drilled: Indicates that the drill locked on to a design hole, and drilled
this hole once.

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 11
AQ2DB 3 Rev. 1. Aquila

2. Redrilled: Indicates that the drill locked on to a design hole that had
already been drilled.
3. Created: Indicates that the drill either did not lock on to a design hole,
or that the operator overrode the chosen design hole. Either way, this
hole will not have any design information.

2.5.7. Hole_Position table

The hole_information table contains design & as -drilled positional information about
drilled holes. There is one entry per drilled hole. When the drill is stopped & leveled, the
nearest design hole that the Aquila system knows about (within range) is taken to be the
design hole, and its information is used as design information for the drilled hole. It is
possible for a hole to have no design information (strings are blank and all numbers are
0) if the Aquila system does not lock on to a hole, or the operator overrides the locked-
on hole.

2.5.7.1. Collar_elevation
Actual collar elevation of the drilled hole.

2.5.7.2. Northing
Actual northing of the drilled hole.

2.5.7.3. Easting
Actual easting of the drilled hole.

2.5.7.4. Elevation
Actual elevation of the drilled hole.

2.5.7.5. Heading
Actual drill heading for the drilled hole.

2.5.7.6. Mast_angle
Actual mast angle of the drilled hole.

2.5.7.7. Horizontal_accuracy
Average horizontal accuracy of the drilled hole.

2.5.7.8. Vertical_accuracy
Average vertical accuracy of the drilled hole.

2.5.7.9. Design_northing
The design northing of the drilled hole. May be 0 if no design information was
used for the hole.

2.5.7.10. Design_easting
The design easting of the drilled hole. May be 0 if no design information was
used for the hole.

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 12
AQ2DB 3 Rev. 1. Aquila

2.5.7.11. Design_elevation
The design elevation of the drilled hole. May be 0 if no design information was
used for the hole.

2.5.7.12. Design_heading
The design drill heading for the drilled hole. May be 0 if no design information
was used for the hole.

2.5.7.13. Design_mastangle
The design mast angle of the drilled hole. May be 0 if no design information
was used for the hole.

2.5.8. Hole_Profile table

The hole profile table records down-the-hole signals for a given drilled hole. For each
hole, there are multiple hole profile entries. For any given hole, a new entry is generated
after having drilled a distance. Thus, while the drill number and start time are sufficient
to match a series of hole profile entries to the corresponding hole, the drill number, start
time and depth are required to uniquely identify a record.

2.5.8.1. Depth
The depth at which the entry was recorded.

2.5.8.2. Rpm
The RPM of the drill bit when the entry was recorded

2.5.8.3. Weightonbit
The pressure or force on the drill bit when the entry was recorded

2.5.8.4. Torque
The torque exerted on the bit when the entry was recorded

2.5.8.5. Rop
The rate of penetration when the entry was recorded

2.5.8.6. Air_pressure
The drill’s air pressure when the entry was recorded

2.5.8.7. Vibration
The vibration when the entry was recorded

2.5.8.8. Bi
The blastability index of the rock when the entry was recorded. BI is an
Aquila-specific unit indicating the hardness of the rock, calculated using a
machine-specific configuration.

2.5.8.9. Rock_type
The type of rock encountered when the entry was recorded. The names of the

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 13
AQ2DB 3 Rev. 1. Aquila

rock types are configurable on the on-board system, and the rock types are
determined based on the BI and other factors.

2.5.9. Hole_Profile_Blob table

Because the hole_profile can table can grow to contain an excessive number of records
this alternative is provided. For each set of hole_profile data associated with a drilled
hole, there is only one record keyed by the corresponding drill number and start time.
The remainder of the data is stored as the report file contents in a BLOB (binary large
object) field.

2.5.9.1. : File_contents
Contains the contents of the hole_profile report file that corresponds to the
drilled hole.

00-0000-X00-000© 2004 Aquila Mining Systems Ltd. Proprietary and Confidential Page 14