This topic lists a summary of the tables that are generated for each RockWorks project database. These tables are generated automatically when you create a new borehole project (Project Folder | New Project).
These store the actual data for the boreholes. You can access these tables using the tabs with the same name in the main Borehole Manager program window.
- Aquifer - Entry of dates and water levels for borehole aquifers.
- Bitmap - Entry of depths and file names for downhole images.
- Fracture - Entry of depth, azimuth, inclination, aperture, radius, and color for fractures.
- Interval - Entry of depth intervals and measured values for up to 250 components. Links to IntervalType table.
- IText - Entry of depth intervals and text information. Links to ITextType table.
- Lithology - Entry of depth intervals and lithology keywords. Links to LithType table.
- Location - Entry of borehole location (Easting, Northing, surface elevation, and total depth), definition of well symbol and well name, and optional fields.
- Orientation - Entry of downhole survey measurements, with depth, azimuth bearing, and inclination.
- Pattern - Entry of depth intervals and a pattern design.
- Point - Entry of depth points and measured value for up to 250 components. Links to PointType table.
- PText - Entry of depth points and text values. Links to PTextType table.
- RockColor - Entry of depth intervals and rock/soil/core colors and comments.
- Stratigraphy - Entry of depth intervals and stratigraphy formation names. Links to StratTable.
- Symbol - Entry of depth points and symbols.
- TmInterval - Entry of time-based interval data. Links to TmIntervalType table.
- Vector - Entry of depth points and azimuth bearings, inclination, color, and magnitude.
- WellConstruction - Entry of depth intervals, inner and outer diameters, offsets, construction materials, and captions. Links to WellConstructionType table.
- Production - Entry of oil and gas production data for petroleum wells.
These define the type of data you can enter into selected data tables. You can access these tables from the individual data tables and from the Project Manager (Project Tables | Type Tables).
- AquiferType - Defines aquifer names, pattern/color, sequence, and show in legend. Links to Aquifer data table.
- BitmapType - Defines bitmap column names. Links to Bitmap data table.
- IntervalType - Defines Interval (I-Data) column names, data ranges, units, and description. Links to Interval data table.
- ITextType - Defines I-Text (Interval Text) column names. Links to the IText data table.
- LithType - Defines lithology material types, pattern/color, fill percent, rock density, G value, show in legend. Links to Lithology data table.
- PointType - Defines Point (P-Data) column names, data ranges, units, and description. Links to Point data table.
- PTextType - Defines P-Text (Point Text) column names. Links to the PText data table.
- StratType - Defines stratigraphy formation names, pattern/color, fill percent, rock density, formation sequence (G values), show in legend. Links to Stratigraphy data table.
- TmIntervalType - Defines Time Interval (T-Data) column names, data ranges, units, and description. Links to TmInterval table.
- WellConstructionType - Defines well construction material names, pattern/color, fill percent, rock density, G value, show in legend. (Some not used in program.) Links to WellConstruction data table.
These are accessory tables for your project which affect map and modeling settings; you can maintain multiple versions of these with unique names. (In earlier versions of RockWorks, these were stored as external ASCII files.) You can access these from the Project Manager (Project Tables | Map/Model Tables).
- t3DPointMapRange - Custom scaling and color definitions for 3D point maps.
- tContour - Custom contour line settings for 2D maps.
- tDWGriddingSector - Custom sectors and exponents for directional-weighting gridding.
- tFaults - Define fault polylines for fault-based gridding.
- tIDWSolidModelingSec - Custom sectors and exponents for directional-weighting solid modeling.
- tMinMaxColor - Custom color-fill tables for contour maps and solid models.
- tPointMapRange - Custom scaling and symbols for 2D points maps.
- tPolygon - Lists of polygon vertices, for filtering grid models and solid models.
- tPolygons - Lists of polygon table names, for those programs which can use multiple polygon tables.
These are accessory tables for your project which define cross section, fence, and striplog settings; you can maintain multiple versions of these with unique names. (In earlier versions of RockWorks, these were stored as external ASCII files.) You can access these from the Project Manager (Project Tables | Log/Section Tables).
- tBargraphScale - Custom scaling for I-Data and T-Data bargraphs in logs.
- tProfile - Define the XY coordinates for panel endpoints for profile diagrams.
- tXYCoordinate - Define the XY coordinates for vertices along a single "polyline" for use in scripting cross sections.
- tXYPair - Define the XY coordinates for panel endpoints for use in scripting fence diagrams. Also used for map faults.
These are accessory tables for your project which allow you to build customized legends for your 2D diagrams. (In earlier versions of RockWorks, these were stored as external ASCII files.) You can access these from the Project Manager (Project Tables | Index Tables).
- tColorIndex - Creates a custom color index legend.
- tLineStyleIndex - Creates a custom line style legend.
- tPatternIndex - Creates a custom pattern legend.
- tSymbolIndex - Creates a custom symbol legend.
You can access this from the Project Manager (Project Tables | Synonym Tables).
- tSynonym - Defines target and replacement text used by the Columns | Translate program.
- Fence - Stores the last fence diagram panel coordinates for the project so that they will be the defaults the next time a fence diagram is requested.
- ProjectDesc - Stores miscellaneous project information that the user can enter in the View / Project Information option.
- ProjectInfo - Stores output dimensions and units: X min, max, spacing, nodes; Y min, max, spacing, nodes; Z min, max, spacing, nodes; project coordinate system and units; table depths from elevation or collar; borehole name sort fields.
- ProjectTables - Stores the names of the miscellaneous project tables.
- Section - Stores the last section diagram panel coordinates for the project so that they will be the defaults the next time a section diagram is requested.
Back to Database Overview
RockWare home page