The Minnesota County Well Index
Database Dictionary

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


Table: C5ID
Alternate identifiers for the well. Assigned by state and local agencies. Commonly used identifiers are the property-parcel numbers used for tax purposes or emergency numbering system identifiers in some counties.

 

Column Name

Type

Length

Precision

Scale

Null

Default

Code Table

Data Range

Description

C5ID_SEQ_NO

NUMBER

12

0

 

N

     

     

Primary Key

RELATEID

CHAR

10

     

     

N

     

     

Minnesota Unique Well Number.

IDENTIFIER

VARCHAR2

24

     

     

Y

     

     

Alternate identifier for the well.

ID_TYPE

 VARCHAR2 5     Y   AGENCY The agency or group that has primacy of the identifier.
ID_PROG VARCHAR2 7     Y   PROGRAM The name or type of IDENTIFIER. i.e. Minnesota Unique well and boring number.
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