| 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 |
|