The Minnesota County Well Index


Database Dictionary

Table: PUMPTYPE
Pump Type.

PUMPTYPE Table Description   Pump type Codes
 Column Name   Format
 Code   CHAR 1 - Primary key  
 Descrptn   CHAR 30 NULL
 
Relationships
pumptype.code c5c1.pump_type
 
Code   Descrptn
A    Air lift
B    Bailer
C    Centrifugal
G    Gas Lift/bladder pump
H    Handpump
J    Jet
L    Peristaltic
O    Other (see remarks)
P    Piston
Q    Reciprocating
R    Rotary
S    Submersible
T    Turbine
U    Unknown
 
 Close