| The Minnesota County Well Index |
| Database Dictionary |
| Home | | | Table Relationships | | | Data Tables | | | Code Tables | | | Views | | | Data Entry |
Table: C5PL |
|
Column Name |
Type |
Length |
Precision |
Scale |
Null |
Default |
Code Table Data Range |
Description |
|
C5PL_SEQ_NO |
NUMBER |
12 |
|
|
N |
|
|
Primary key. |
|
RELATEID |
CHAR |
10 |
|
|
N |
|
|
Minnesota Unique Well Number. |
|
PUMPTESTID |
NUMBER |
|
|
|
Y |
|
|
Pump test id number. |
|
TEST_DATE |
NUMBER |
|
|
|
Y |
|
|
Date of test (YYYYMMDD). |
|
START_MEAS |
NUMBER |
|
|
|
Y |
|
|
Water level measurement at the start
of test. |
|
FLOW_RATE |
NUMBER |
|
|
|
Y |
|
|
Flow
rate in gallons per minute. |
| DURATION |
NUMBER |
|
|
Y |
|
|
Duration
of test in hours. |
|
| PUMP_MEAS |
NUMBER |
|
|
Y |
|
|
Water
level measurement. |
|
| OBJECTID | NUMBER | 38 | 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 | N |
Minnesota Unique Well Number and Foreign Key |
| Home | | | Table Relationships | | | Data Tables | | | Code Tables | | | Views | | | Data Entry |