The Minnesota County Well Index
Database Dictionary

Home   |   Table Relationships   |   Data Tables   |   Code Tables   |   Views


Table: C5C2
This table conatains ADDITIONAL information describing the construction of the well. This includes the casing, the screen, open hole, and grout. This table has a many-to-one relationship to the c5ix (index) table.

 

Column Name

Type

Length

Precision

Scale

Null

Default

Code Table

Data Range

Description

C5C2_SEQ_NO

NUMBER

12

0

0

N

 

 

Primary Key.

RELATEID

CHAR

10

 

 

N

 

 

Minnesota Unique Well Number.

CONSTYPE

CHAR

1

 

 

Y

 

Construction types; C - Casing, G - Grout, H - Open hole, S - Screen

FROM_DEPTH

NUMBER

8

1

0

Y

 

 

From depth in feet.

TO_DEPTH

NUMBER

8

1

0

Y

 

 

To depth in feet.

DIAMETER

NUMBER

8

2

0

Y

 

 

Diameter in inches.

SLOT

NUMBER

3

0

 

Y

 

 

For screen only (CONSTYPE = S). Slot refers to the width of screen openings in number of openings per inch

LENGTH

NUMBER

8

1

0

Y

 

 

Length of screen (CONSTYPE = S)

MATERIAL

CHAR

1

 

 

Y

 

GROUT

Type of grout material (CONSTYPE = G only)

AMOUNT

NUMBER

8

2

0

Y

 

 

Amount of grout used (CONSTYPE = G  - grout only) or  the weight per foot of the casing used in the permanent construction of a well or boring (CONSTYPE = C - casing only)

UNITS

CHAR

1

 

 

Y

 

GR_UNITS

Units for grout material. (CONSTYPE = G only).
OBJECTID NUMBER 38 0 0 N    

An ObjectID is a unique, not null integer field used to uniquely identify rows in tables in a geodatabase
WELLID NUMBER 10 0 0 N    

Minnesota Unique Well Number and Foreign Key


Home   |   Table Relationships   |   Data Tables   |   Code Tables   |   Views