WellTracking Help - Database Shema

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

*****