WellTracking geodatabase scheme

1. WellTracking data

1. 1. Spatial and table data

1. 2. Inclination data

1. 3. Data for reports generation

1. 4. Data for access management

1. 5. Configuration data

1. 6. Data to save layer properties

1. 7. Domains

1. 8. Relationship classes

 

2. WellTracking data history

2. 1. Spatial and table data history

2. 2. Data for access management history

2. 3. Configuration data history

2.4. Relationship classes of WellTracking data history

 

WellTracking geodatabase scheme fragment

 

1. WellTracking data

 

1. 1. Spatial and table data

 

LICENSE_AREA – License area

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

NAME

 

TEXT

License area name

MODIFICATION_UTC_TIME

DATE

Modification date

GEOTYPE

LONG

(LICENSE_AREA_GEOTYPE domain)

License area geotype

STATUS

LONG

(LICENSE_AREA_STATUS domain)

License area status

SHAPE

GEOMETRY

Geometry

 

MINE_TAKE – Горный отвод

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

NAME

 

TEXT

Mine take area name

MODIFICATION_UTC_TIME

DATE

Modification date

LICENSE_AREA_ID

LONG

License area identifier. Relate to  LICENSE_AREA.OBJECTID

SHAPE

GEOMETRY

Geometry

 

PAD – Pad area

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

 LONG

User identifier. Relate to USER.OBJECTID

NAME

TEXT

Pad area name

MAGNETIC_CORRECTION

DOUBLE

Pad area magnetic correction

FIELD_ID

LONG

Field identifier. Relate to FIELD.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

STATUS

LONG

(PAD_STATUS domain)

Pad area status

ALTITUDE

DOUBLE

Pad area altitude

MINE_TAKE_ID

LONG

Mine take area identifier

SHAPE

GEOMETRY

Geometry

 

 

CATWALK - Catwalk

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELL_SEQUENCE_ID

LONG

Well sequence identifier. Relate to WELL_SEQUENCE.OBJECTID

WELL_ID

LONG

Well identifier. Relate to WELL.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

SHAPE

GEOMETRY

Geometry

 

WELL – Well

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELL_NUMBER

TEXT

Well number

WELL_HEAD_NUMBER

LONG

Well head number on well sequence

FIELD_ID

LONG

Field identifier. Relate to FIELD.OBJECTID

PAD_ID

LONG

Pad identifier. Relate to PAD.OBJECTID

WELL_SEQUENCE_ID

LONG

Well sequence identifier. Relate to WELL_SEQUENCE.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

STATUS

 

LONG

(WELL_STATUS domain)

Well status

 

RIG_SKIDDING

DOUBLE

Skidding of drilling rig

MRK_FLANGE

DOUBLE

Flange mark

MRK_ROTOR

DOUBLE

Rotor mark

MINE_TAKE_ID

LONG

Mine take area identifier

SHAPE

GEOMETRY

Geometry

 

TARGET_POINT – Target-point

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

FORMATION_ID

LONG

Formation identifier. Relate to FORMATION.OBJECTID

WELLBORE_ID

LONG

Wellbore identifier. Relate to WELLBORE.OBJECTID

GEOTYPE

LONG

(TARGET_POINT_GEOTYPE domain)

Target-point geotype

MODIFICATION_UTC_TIME

DATE

Modification date

STATUS

LONG (WELL_STATUS domain)

Target-point status

SHAPE

GEOMETRY

Geometry

 

WELL_TOP – Formation intercepts

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

FORMATION_ID

LONG

Formation identifier. Relate to FORMATION.OBJECTID

WELLBORE_ID

LONG

Wellbore identifier. Relate to WELLBORE.OBJECTID

DEPTH

DOUBLE

Drilling depth of formation intercepts

ABS_H

DOUBLE

Absolute depth of formation intercepts

GEOTYPE

LONG

Geotype of formation intercepts

MODIFICATION_UTC_TIME

DATE

Modification date

SHAPE

GEOMETRY

Geometry

 

WELLBORE_GEOMETRY – Wellbore geometry

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELLBORE_ID

LONG

Wellbore identifier. Relate to WELLBORE.OBJECTID

STATUS

LONG

(WELLBORE_GEOMETRY_STATUS domain)

Wellbore geometry status

MEASUREMENT_DATE

DATE

Measurement date

GEOTYPE

LONG

(WELLBORE_GEOMETRY_GEOTYPE domain)

Wellbore geometry geotype

MAGNETIC_CORRECTION

DOUBLE

Magnetic correction value

 

MODIFICATION_UTC_TIME

DATE

Modification date

MERIDIAN_CONVERGENCE

DOUBLE

Meridian convergence value

SHAPE

GEOMETRY

Geometry

 

WELL_SEQUENCE - Well sequence

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELL_SEQUENCE_NUM

LONG

Well sequence number

ALTITUDE

DOUBLE

Well sequence altitude

PAD_ID

LONG

Pad area identifier. Relate to PAD.OBJECTID

STATUS

 

LONG

(WELL_SEQUENCE_STATUS domain)

 

Well sequence status

 

MODIFICATION_UTC_TIME

DATE

Modification date

AZIMUTH

DOUBLE

Directional angle

SHAPE

GEOMETRY

Geometry

 

WELLBORE – Wellbore

 

Field

Field type

 Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELL_ID

LONG

Well identifier. Relate to WELL.OBJECTID

WELLBORE_NUM

LONG

Wellbore number

MODIFICATION_UTC_TIME

DATE

Modification date

STATUS

LONG

(WELLBORE_STATUS domain)

Wellbore status

PROFILE

LONG

(WELLBORE_PROFILE domain)

Wellbore profile

PURPOSE

LONG

(WELLBORE_PURPOSE domain)

Wellbore purpose

 

NAME

TEXT

Wellbore purpose

PILOT_NUM

TEXT

Pilot wellbore number

EMERGENCY_WELLBORE_NUM

TEXT

Number of wellbore abandoned when drilling failure

FIRST_MEASUREMENT_LOADING__DATE

DATE

Date of first wellbore measurement  loading

 

FIELD - Field

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

NAME

TEXT

Field name

MODIFICATION_UTC_TIME

DATE

Modification date

MAGNETIC_CORRECTION

DOUBLE

Field magnetic correction value

 

FORMATION - Formation

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

FORMATION_NAME

TEXT

Formation name

DEPTH

DOUBLE

Formation occurrence absolute depth

CODE

TEXT

Formation code

MODIFICATION_UTC_TIME

DATE

Modification date

 

1. 2. Inclination data

 

INCLINATION_DATA_JOURNAL – Inclination data journal

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

EXTENSION

TEXT

Input file extension

ORIGINAL_FILENAME

TEXT

Input file name

FILE_DATA

BLOB

Input file data (file with inclination data measurement)

UTC_CREATION_TIME

DATE

Loading date

WELLBORE_GEOMETRY_ID

LONG

Wellbore geometry identifier. Relate to WELLBORE_GEOMETRY.OBJECTID

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

 

INCLINATION_DATA_READINGS - Inclination data readings

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

WELLBORE_GEOMETRY_ID

LONG

Wellbore geometry identifier. Relate to WELLBORE_GEOMETRY.OBJECTID

INCL

DOUBLE

Vertical deviation angle

AZM

DOUBLE

Azimuth

DEPTH

DOUBLE

Drilled depth

DX

DOUBLE

X- Closure

DY

DOUBLE

Y- Closure

ABS_H

DOUBLE

Absolute depth

 

1. 3. Data for reports generation

 

REPORT_FORMS – Report forms

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

REPORT_ID

LONG

Report identifier. Relate to REPORT.OBJECTID

REPORT_FORM

BLOB

Data

REPORT_FORM_TYPE

TEXT

Report form format (MS Word, MS Excel files)

FORM_NAME

TEXT

Report form name

 

COORDINATE_SYSTEMS – Coordinate systems

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

NAME

TEXT

Coordinate system name

DATA

BLOB

Data (*.prj file)

MODIFICATION_UTC_TIME

DATE

Modification date

TRANSFORMATION

BLOB

Geographic transformation

 

REPORT_HISTORY – Reports history

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

MODIFICATION_UTC_TIME

DATE

User identifier

REPORT_DESCRIPTION

TEXT

Report description

REPORT_DATA

BLOB

Data (report file)

REPORT_FORM_ID

LONG

Report form identifier. Relate to REPORT_FORMS.OBJECTID

REPORT_ID

LONG

Report identifier. Relate to REPORTS.OBJECTID

 

REPORTS - Reports

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

REPORT_NAME

TEXT

Report name

 

1. 4. Data for access management

 

GROUPS – User groups

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

GROUPNAME

TEXT

Group name

COMMANDS

BLOB

List of available commands

 

USERS - Users

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USERNAME

TEXT

User name

PASSWORDHASH

TEXT

Hash function value and password

DESCRIPTION

TEXT

User description

 

1. 5. Configuration data

 

CONFIG – Configuration table

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

PROPERTYNAME

TEXT

Name

PROPERTYVALUE

TEXT

Value

 

DEFAULT_MAPS - Maps

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

MAPNAME

TEXT

Map name

MAPDATA

BLOB

Data (*.mxd file)

 

1. 6. Data to save layer properties

 

WellTrackingToCltemInfo - Table of saved symbology and filtration parameters

 

Field

Field type

Description

OBJECTID

OBJECTID

Identifier

ToCItemName TEXT

Name of data source, for which the layer properties are saved

SettingCaption TEXT

Name of saved layer or table

ToCItemInfo

BLOB

Layer properties

 

1. 7. Domains

 

TARGET_POINT_GEOTYPE – Target-point geotype

Fields: TARGET_POINT .GEOTYPE. Fields type: LONG.

 

Code

Description

-1

Unknown

100

t0

0

t1

1

t2

3

Bottomhole

4

t3

5

t4

6

t5

7

t6

8

t7

9

t8

10

t9

11

t10

12

t11

13

t12

 

WELL_STATUS – Well status

Fields: TARGET_POINT.STATUS, WELL.STATUS. Fields type LONG.

 

Code

Description

-1

Unknown

0

Project

1

In the process of drilling

2

Active

3

Abandoned

4

Suspended

 

PAD_STATUS – Pad status

Fields: PAD.STATUS. Fields type LONG.

 

Code

Description

-1

Unknown

0

Project

1

In the process of drilling

2

Active

3

Abandoned

 

WELL_SEQUENCE_STATUS – Well sequence status

Fields: WELL_SEQUENCE.STATUS. Fields type LONG.

 

Code

Description

-1

Unknown

0

Project

1

Active

 

WELLBORE_GEOMETRY_STATUS – Wellbore geometry status

Fields: WELLBORE_GEOMETRY.STATUS. Fields type LONG.

 

Code

Description

-1

Unknown

0

Archive

1

Active

 

WELLBORE_GEOMETRY_GEOTYPE – Wellbore geometry geotype

Field: WELLBORE_GEOMETRY.GEOTYPE. Fields type LONG.

 

Code

Description

-1

Unknown

0

Project

1

Inclination

2

Gyroscope

3

Gyroscope-correction

4

Temporary measurement

5

Design-plan

 

WELLBORE_PROFILE – Wellbore profile

Fields: WELLBORE.PROFILE. Fields type LONG.

 

Code

Description

-1

Unknown

0

Vertical

1

Horizontal

2

Deviated

 

WELLBORE_STATUS – Wellbore status

Fields: WELLBORE.STATUS. Fields type LONG.

 

Code

Description

-1

Unknown

0

Project

1

In the process of drilling

2

Active

3

Abandoned when drilling failure

4

Abandoned after drilling

5

Abandoned when operating

6

Abandoned after operation

7

Suspended

8

Idle

9

Injecting

10

Monitoring

 

WELLBORE_PURPOSE – Wellbore purpose

Fields: WELLBORE.PURPOSE. Fields type LONG.

 

Code

Description

-1

Unknown

0

Producing

1

Injecting

2

Exploratory

3

Prospecting

4

Control-piestic

5

Pilot

6

Monitoring

 

LICENSE_AREA_GEOTYPE – License area geotype

Fields: GEOTYPE. Fields type LONG.

 

Code

Description

-1

Unknown

0

License area

1

Mine take

 

LICENSE_AREA_STATUS – License area status

Fields: STATUS. Fields type LONG.

 

Code

Description

-1

Unknown

0

Archive

1

Active

 

WELL_TOP_GEOTYPE – Formation intercepts geotype

Field: WELL_TOP_GEOTYPE. Fields type LONG.

 

Code

Description

-1

Unknown

0

Formation top intercept

1

Formation bottom intercept

 

1.8. Relationship classes

 

Name

Origin table/feature class

Destination table/ feature class

Cardinality

CATWALK_TO_WELL_SEQUENCE

WELL_SEQUENCE

CATWALK.

Key WELL_SEQUENCE_ID

1:M

CATWALK_TO_WELL

WELL

CATWALK.

Key  WELL_ID

1:1

CATWALK_TO_USERS

USERS

CATWALK.

Key USER_ID

1:M

COORDINATE_SYSTEMS_TO_USERS

  USERS

 COORDINATE_SYSTEMS.  

Key USER_ID

1:M

DEFAULT_MAPS_TO_USERS

USERS

DEFAULT_MAPS.

Key USER_ID

1:M

 

FIELD_TO_LICENSE_AREA

 LICENSE_AREA

 FIELD. 

Key LICENSE_AREA.

M:M

FIELD_TO_USERS

   USERS

 FIELD.

Key USER_ID

1:M

FORMATION_TO_USERS

    USERS

 FORMATION.

Key USER_ID

1:M

INCLINATION_DATA_JOURNAL_TO_WELLBORE_GEOMETRY

 WELLBORE_GEOMETRY

INCLINATION_DATA_JOURNAL.

Key WELLBORE_GEOMETRY_ID

1:1

INCLINATION_DATA_READINGS_TO_USERS

USERS

 INCLINATION_DATA_READINGS.  

Key USER_ID

1:M

INCLINATION_DATA_READINGS_TO_WELLBORE_GEOMETRY

 

WELLBORE_GEOMETRY

 INCLINATION_DATA_READINGS.

Key WELLBORE_GEOMETRY_ID

1:M

LICENSE_AREA_TO_USERS

USERS

LICENSE_AREA.

Key USER_ID

1:M

PAD_TO_FIELD

FIELD

PAD.

Key FIELD_ID

1:M

PAD_TO_USERS

  USERS

 PAD.

Key USER_ID

1:M

REPORT_FORMS_TO_REPORTS

 REPORTS

 REPORT_FORMS.

Key  REPORT_ID

1:M

REPORT_FORMS_TO_USERS

 

   USERS

REPORT_FORMS.

 Key USER_ID

1:M

REPORT_HISTORY_TO_REPORT_FORMS

 REPORT_FORMS

 REPORT_HISTORY.

Key REPORT_FORM_ID

1:M

REPORT_HISTORY_TO_REPORTS

REPORTS

REPORT_HISTORY.

Key  REPORT_ID

1:M

REPORT_HISTORY_TO_USERS

   USERS

REPORT_HISTORY.

Key  USER_ID

1:M

REPORTS_TO_USERS

 USERS

REPORTS.

Key USER_ID

1:M

TARGET_POINT_TO_FORMATION

FORMATION

 TARGET_POINT.

Key  FORMATION_ID

1:M

TARGET_POINT_TO_USERS

USERS

 TARGET_POINT.

Key USER_ID

1:M

TARGET_POINT_TO_WELLBORE

 WELLBORE

TARGET_POINT.

Key WELLBORE_ID

1:M

 

USERS_TO_GROUPS

GROUPS

USERS.    

Key GROUP_ID

M:M

WELL_SEQUENCE_TO_PAD

PAD

WELL_SEQUENCE.

Key PAD_ID

1:M

WELL_SEQUENCE_TO_USERS

USERS

WELL_SEQUENCE.

Key USER_ID

1:M

WELL_TO_FIELD

FIELD

WELL.

Key FIELD_ID

1:M

WELL_TO_PAD

PAD

WELL.

Key PAD_ID

1:M

WELL_TO_USERS

USERS

WELL.

Key USER_ID

1:M

WELL_TO_WELL_SEQUENCE

WELL_SEQUENCE

WELL.

 Key WELL_SEQUENCE_ID

1:M

WELL_TOP_TO_FORMATION

FORMATION

WELL_TOP.

Key FORMATION_ID

1:M

WELL_TOP_TO_USERS

 USERS

WELL_TOP.    

Key USER_ID

1:M

WELL_TOP_TO_WELLBORE

WELLBORE

WELL_TOP.    

Key WELLBORE_ID

1:M

WELLBORE_GEOMETRY_TO_USERS

     USERS

WELLBORE_GEOMETRY.

Key USER_ID

1:M

WELLBORE_GEOMETRY_TO_WELLBORE

WELLBORE

WELLBORE_GEOMETRY.

Key WELLBORE_ID

1:M

WELLBORE_TO_USERS

USERS

WELLBORE.

Key USER_ID

1:M

WELLBORE_TO_WELL

WELL

WELLBORE.

Key WELL_ID

1:M

MINE_TAKE_TO_MINE_TAKE_HISTORY

MINE_TAKE_HISTORY

 MINE_TAKE.

Key MINE_TAKE_HISTORY_ID

1:M

MINE_TAKE_TO_LICENSE_AREA

 LICENSE_AREA

MINE_TAKE.

Key LICENSE_AREA_ID

1:М

MINE_TAKE_TO_USERS

USERS

MINE_TAKE

Key USER_ID

1:M

 

2. WellTracking data history

 

2. 1. Spatial and table data history

 

LICENSE_AREA_HISTORY – License area history

 

Field

Field type

Description

OBJECTID

OBJECTID

License area history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

NAME

 

TEXT

License area name

MODIFICATION_UTC_TIME

DATE

Modification date

GEOTYPE

LONG

(LICENSE_AREA_GEOTYPE domain)

License area geotype

STATUS

LONG

(LICENSE_AREA_STATUS domain)

License area status

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

License_area identifier. Relate to LICENSE_AREA.OBJECTID

SHAPE

GEOMETRY

Geometry

 

MINE_TAKE_HISTORY - Mine take area history

 

Field

Field type

Description

OBJECTID

OBJECTID

Mine take area history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

LICENSE_AREA_ID

LONG

License area identifier

Relate to LICENSE_AREA.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

NAME

TEXT

Mine take area name

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Mine take area identifier. Relate to MINE_TAKE.OBJECTID

SHAPE

GEOMETRY

Geometry

 

 

PAD_HISTORY – Pad area history

 

Field

Field type

Description

OBJECTID

OBJECTID

Pad history identifier

USER_ID

 LONG

User identifier. Relate to USER.OBJECTID

NAME

TEXT

Pad area name

MAGNETIC_CORRECTION

DOUBLE

Pad area magnetic correction

FIELD_ID

LONG

Field identifier. Relate to FIELD.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

STATUS

LONG

(PAD_STATUS domain)

Pad area status

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Pad area identifier. Relate to PAD.OBJECTID

ALTITUDE

DOUBLE

Pad area altitude

MINE_TAKE_ID

LONG

Mine take area identifier

SHAPE

GEOMETRY

Geometry

 

 

CATWALK_HISTORY - Catwalk history

 

Field

Field type

Description

OBJECTID

OBJECTID

Catwalk history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELL_SEQUENCE_ID

LONG

Well sequence identifier. Relate to WELL_SEQUENCE.OBJECTID

WELL_ID

LONG

Well identifier. Relate to WELL.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Catwalk identifier. Relate to CATWALK.OBJECTID

SHAPE

GEOMETRY

Geometry

 

WELL_HISTORY – Well history

 

Field

Field type

Description

OBJECTID

OBJECTID

Well history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELL_NUMBER

TEXT

Well number

WELL_HEAD_NUMBER

LONG

Well head number on well sequence

FIELD_ID

LONG

Field identifier. Relate to FIELD.OBJECTID

PAD_ID

LONG

Pad area identifier. Relate to PAD.OBJECTID

WELL_SEQUENCE_ID

LONG

Well sequence identifier. Relate to WELL_SEQUENCE.OBJECTID

MODIFICATION_UTC_TIME

DATE

Modification date

STATUS

 

LONG

(WELL_STATUS domain)

Well status

 

RIG_SKIDDING

DOUBLE

Skidding of drilling rig

FLANGE_MRK

DOUBLE

Flange mark

ROTOR_MRK

DOUBLE

Rotor mark

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Well identifier. Relate to WELL.OBJECTID

MINE_TAKE_ID

LONG

Mine take area identifier

SHAPE

GEOMETRY

Geometry

 

TARGET_POINT_HISTORY – Target-point history

 

Field

Field type

Description

OBJECTID

OBJECTID

Target-point history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

FORMATION_ID

LONG

Formation identifier. Relate to FORMATION.OBJECTID

WELLBORE_ID

LONG

Wellbore identifier. Relate to WELLBORE.OBJECTID

GEOTYPE

LONG

(TARGET_POINT_GEOTYPE domain)

Target-point geotype

MODIFICATION_UTC_TIME

DATE

Modification date

STATUS

LONG (WELL_STATUS domain)

Target-point status

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Target-point identifier. Relate to TARGET_POINT.OBJECTID

SHAPE

GEOMETRY

Geometry

 

WELL_TOP_HISTORY – Formation intercepts history

 

Field

Field type

Description

OBJECTID

OBJECTID

intercepts history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

FORMATION_ID

LONG

Formation identifier. Relate to FORMATION.OBJECTID

WELLBORE_ID

LONG

Wellbore identifier. Relate to WELLBORE.OBJECTID

DEPTH

DOUBLE

Drilling depth of formation intercepts

ABS_H

DOUBLE

Absolute depth of formation intercepts

GEOTYPE

LONG

Geotype of formation intercepts

MODIFICATION_UTC_TIME

DATE

Modification date

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

intercepts identifier. Relate to WELL_TOP.OBJECTID

SHAPE

GEOMETRY

Geometry

 

WELLBORE_GEOMETRY_HISTORY – Wellbore geometry history

 

Field

Field type

Description

OBJECTID

OBJECTID

Wellbore geometry history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELLBORE_ID

LONG

Wellbore identifier. Relate to WELLBORE.OBJECTID

STATUS

LONG

(WELLBORE_GEOMETRY_STATUS domain)

Wellbore geometry status

MEASUREMENT_DATE

DATE

Measurement date

GEOTYPE

LONG

(WELLBORE_GEOMETRY_GEOTYPE domain)

Wellbore geometry geotype

MAGNETIC_CORRECTION

DOUBLE

Magnetic correction value

MODIFICATION_UTC_TIME

DATE

Modification date

MERIDIAN_CONVERGENCE

DOUBLE

Meridian convergence value

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Wellbore geometry identifier. Relate to WELLBORE_GEOMETRY.OBJECTID

SHAPE

GEOMETRY

Geometry

 

WELL_SEQUENCE_HISTORY - Well sequence history

 

Field

Field type

Description

OBJECTID

OBJECTID

Well sequence history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELL_SEQUENCE_NUM

LONG

Well sequence number

ALTITUDE

DOUBLE

Well sequence altitude

PAD_ID

LONG

Pad area identifier. Relate to PAD.OBJECTID

STATUS

 

LONG

(WELL_SEQUENCE_STATUS domain)

 

Well sequence status

 

MODIFICATION_UTC_TIME

DATE

Modification date

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Well sequence identifier. Relate to WELL_SEQUENCE.OBJECTID

AZIMUTH

DOUBLE

Azimuth

SHAPE

GEOMETRY

Geometry

 

WELLBORE_HISTORY – Wellbore history

 

Field

Field type

 Description

OBJECTID

OBJECTID

Wellbore history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

WELL_ID

LONG

Well identifier. Relate to WELL.OBJECTID

WELLBORE_NUM

LONG

Wellbore number

MODIFICATION_UTC_TIME

DATE

Modification date

STATUS

LONG

(WELLBORE_STATUS domain)

Wellbore status

PROFILE

LONG

(WELLBORE_PROFILE domain)

Wellbore profile

PURPOSE

LONG

(WELLBORE_PURPOSE domain)

Wellbore purpose

 

NAME

TEXT

Wellbore name

PILOT_NUM

TEXT

Pilot wellbore number

EMERGENCY_WELLBORE_NUM

TEXT

Number of wellbore abandoned when drilling failure

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Wellbore identifier. Relate to WELLBORE.OBJECTID

FIRST_MEASUREMENT_LOADING__DATE

DATE

Date of first wellbore measurement  loading

 

FIELD_HISTORY - Field history

 

Field

Field type

Description

OBJECTID

OBJECTID

Field history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

NAME

TEXT

Field name

MODIFICATION_UTC_TIME

DATE

Modification date

MAGNETIC_CORRECTION

DOUBLE

Field magnetic correction value

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Field identifier. Relate to FIELD.OBJECTID

 

FORMATION_HISTORY - Formation history

 

Field

Field type

Description

OBJECTID

OBJECTID

Formation history identifier

USER_ID

LONG

User identifier. Relate to USER.OBJECTID

FORMATION_NAME

TEXT

Formation name

DEPTH

DOUBLE

Formation occurrence absolute depth

CODE

TEXT

Formation code

MODIFICATION_UTC_TIME

DATE

Modification date

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Formation identifier. Relate to FORMATION.OBJECTID

 

2. 2. Data for access management history

 

GROUPS_HISTORY – User groups history

 

Field

Field type

Description

OBJECTID

OBJECTID

Groups history identifier

GROUPNAME

TEXT

Group name

COMMANDS

BLOB

List of available commands

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Groups identifier. Relate to GROUPS.OBJECTID

 

USERS_HISTORY - Users history

 

Field

Field type

Description

OBJECTID

OBJECTID

Users history identifier

USERNAME

TEXT

User name

PASSWORDHASH

TEXT

Hash function value and password

DESCRIPTION

TEXT

User description

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Users identifier. Relate to USERS.OBJECTID

 

2. 3. Configuration data history

 

CONFIG_HISTORY – Configuration table history

 

Field

Field type

Description

OBJECTID

OBJECTID

Configuration table history identifier

PROPERTYNAME

TEXT

Name

PROPERTYVALUE

TEXT

Value

EDITING_START_DATE

DATE

Editing start date

EDITING_END_DATE

DATE

Editing end date

ORIGINAL_OBJECTID

LONG

Configuration table identifier. Relate to CONFIG.OBJECTID

 

 

2. 4. Relationship classes of WellTracking data history

 

Name

Origin table/ feature class

Destination table/ feature

Cardinality

CATWALK_TO_CATWALK_HISTORY

CATWALK_HISTORY.

Key ORIGINAL_OBJECTID

CATWALK

1:M

CONFIG_TO_CONFIG_HISTORY

CONFIG_HISTORY.

Key ORIGINAL_OBJECTID

 CONFIG

1:M

FIELD_TO_FIELD_HISTORY

 FIELD_HISTORY.

Key ORIGINAL_OBJECTID

FIELD

1:M

FORMATION_TO_FORMATION_HISTORY

 FORMATION_HISTORY.

Key ORIGINAL_OBJECTID

FORMATION

1:M

GROUPS_TO_GROUPS_HISTORY

GROUPS_HISTORY.

Key ORIGINAL_OBJECTID

GROUPS

1:M

LICENSE_AREA_TO_LICENSE_AREA_HISTORY

 LICENSE_AREA_HISTORY.

Key ORIGINAL_OBJECTID

LICENSE_AREA

1:M

PAD_TO_PAD_HISTORY

PAD_HISTORY.

Key ORIGINAL_OBJECTID

PAD

1:М

TARGET_POINT_TO_TARGET_POINT_HISTORY

TARGET_POINT_HISTORY.     

     Key ORIGINAL_OBJECTID

TARGET_POINT

1:M

USERS_TO_USERS_HISTORY

 USERS_HISTORY.             

Key ORIGINAL_OBJECTID

USERS

1:M

WELL_SEQUENCE_TO_WELL_SEQUENCE_HISTORY

 WELL_SEQUENCE_HISTORY.

Key ORIGINAL_OBJECTID

WELL_SEQUENCE

1:M

WELL_TO_WELL_HISTORY

WELL_HISTORY.

Key ORIGINAL_OBJECTID

WELL

1:M

WELLBORE_GEOMETRY_TO_WELLBORE_GEOMETRY_HISTORY

WELLBORE_GEOMETRY_HISTORY.

Key ORIGINAL_OBJECTID

WELLBORE_GEOMETRY

1:М

WELLBORE_TO_WELLBORE_HISTORY

 WELLBORE_GEOMETRY_HISTORY.

Key ORIGINAL_OBJECTID

WELLBORE

1:М

MINE_TAKE_TO_MINE_TAKE_HISTORY

 MINE_TAKE_HISTORY.

Key ORIGINAL_OBJECTID

MINE_TAKE

1:M

 

 

 

*****

 

Table of Contents

-Search-

Back