Select Table Type Dialog

Selecting a type of table to create

Select Table Type

To access this dialog:

This dialog is used to select a database table structure type from the supplied list.

note.gif (1017 bytes) Creating a table using this facility will create the necessary data components in memory. The table will not immediately exist as a physical file, so it is necessary to save your project after creating a table in this way if you wish to preserve the results. You will be prompted, on saving your project, to save the new data, and optionally include a reference to it in the source Datamine file.

 

Data tables, for each type, require a minimum field specification. For example, Collars tables will, as a minimum, require a Hole ID, Easting, Northing, Elevation, Length and Azimuth information for each collar position, so these columns are automatically created, without corresponding values.

The following list shows a full breakdown of the fields included in each new table type:

Table type

Contains fields

Collars

  • Hole Name,

  • Easting,

  • Northing,

  • Elevation,

  • Length,

  • Azimuth,

  • Inclination

Surveys

  • Hole Name,

  • Depth At,

  • Azimuth,

  • Inclination

Traces

  • Hole Name,

  • Depth At,

  • Easting,

  • Northing,

  • Elevation,

  • Azimuth,

  • Inclination

Assays

  • Hole Name,

  • Depth From,

  • Depth To,

  • Grade_1, Grade_2, ....Grade_15,

Lithology

  • Hole Name,

  • Depth From,

  • Depth To,

  • Lithology

Intersections

  • Hole Name,

  • Depth From,

  • Depth To,

  • Zone,

  • length weighted average grades

Header

  • Hole Name

Interval log

  • Hole Name,

  • Depth From,

  • Depth To

Depth log

  • Hole Name,

  • Depth At

Not set

  • None

 

You can view your newly created table using the Data Object Manager, before or after saving your project (select the Loaded Data control bar, and right-click the new file icon to select Object Manager...).