- trunk_35
- ALL MODELS
- Filter noise
- trunk_35
- trunk_34
- trunk_33
- trunk_32
- trunk_31
- trunk_30
- trunk_29
- trunk_28
- trunk_27
- trunk_26
- trunk_25
- trunk_24
- trunk_23
- trunk_22
- trunk_21
- trunk_20
- trunk_19
- trunk_18
- trunk_17
- trunk_16
- trunk_15
- trunk_14
- trunk_13
- trunk_12
- trunk_11
- trunk_10
- trunk_9
- trunk_8
- trunk_7
- trunk_6
- trunk_5
- trunk_4
- trunk_3
- trunk_2
- trunk_1
GVX Data Model
GVX Data Model
Favorites 2 Followers
Viewed 283 times
trunk_35
ID_CLIENT
PKINTEGER
NAME
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_TUNNEL
PKINTEGER
ID_PROJECT
FKINTEGER
IDENTIFIER
VARCHAR
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
GEOMETRY
geography
ID_INSTRUMENT
PKINTEGER
ID_INSTRUMENT_TYPE
FKINTEGER
ID_PROJECT
FKINTEGER
IDENTIFIER
VARCHAR
SERIAL_NUMBER
VARCHAR
COOR_EAST
DOUBLE PRECISION
COOR_NORTH
DOUBLE PRECISION
ALTITUDE
INTEGER
ID_DATUM
FKINTEGER
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
GEOMETRY
geography
id_utm_zone
FKVARCHAR
ID_PROJECT
PKINTEGER
ID_CLIENT
FKINTEGER
NAME
VARCHAR
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_INSTRUMENT
PFKINTEGER
ID_TUNNEL
PFKINTEGER
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
ID_BOREHOLE
PKINTEGER
ID_PROJECT
FKINTEGER
ID_BOREHOLE_TYPE
FKINTEGER
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
GEOMETRY
geography
ID_BUILDING
PKINTEGER
ID_PROJECT
FKINTEGER
ID_BUILDING_STATE
FKINTEGER
ID_BUILDING_TYPE
FKINTEGER
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
GEOMETRY
geography
ID_CONTOUR_LINE
PKINTEGER
ID_PROJECT
FKINTEGER
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
GEOMETRY
geography
ID_INSTRUMENT_TYPE
PKINTEGER
NAME
VARCHAR
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIFY
VARCHAR
DATE_MODIFY
TIMESTAMP WITHOUT TIME ZONE
ID_DATA_PIEZOMETER
PKINTEGER
COLLECT_DATE
TIMESTAMP WITHOUT TIME ZONE
DEPTH_WATER_LVL
NUMERIC
HEIGHT
NUMERIC
WATER COLUMN
NUMERIC
CORRECTION
NUMERIC
KNOWN_REASON
VARCHAR
ID_INSTRUMENT
FKINTEGER
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
VARCHAR
ID_REFERENCE_DATA
PKINTEGER
ID_INSTRUMENT
FKINTEGER
GROUND_HEIGHT
NUMERIC
HOLE_HEIGHT
NUMERIC
COLLECT_DATE
TIMESTAMP WITHOUT TIME ZONE
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
VARCHAR
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
IP_MODIF
VARCHAR
ID_DATA_INCLINOMETER
PKINTEGER
ID_INSTRUMENT
FKINTEGER
COLLECT_DATE
TIMESTAMP WITHOUT TIME ZONE
DEPTH
NUMERIC
DIRECTION_A0
NUMERIC
DIRECTION_A180
NUMERIC
DIRECTION_B0
NUMERIC
DIRECTION_B180
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
VARCHAR
MEAN_DIRECTION_A
NUMERIC
MEAN_DIRECTION_B
NUMERIC
ID_DATA_EXTENSOMETER
PKINTEGER
ID_INSTRUMENT
FKINTEGER
HEIGHT
NUMERIC
SETTLEMENT
NUMERIC
COLLECT_DATE
TIMESTAMP WITHOUT TIME ZONE
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
VARCHAR
ID_DATA_SETTLING_PIN
PKINTEGER
ID_INSTRUMENT
FKINTEGER
HEIGHT
NUMERIC
SETTLEMENT
NUMERIC
COLLECT_DATE
TIMESTAMP WITHOUT TIME ZONE
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
VARCHAR
ID_DATA_CONVERGENCE_TAPE
PKINTEGER
ID_INSTRUMENT
FKINTEGER
Id of the instrument
COLLECT_DATE
TIMESTAMP WITHOUT TIME ZONE
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
VARCHAR
ID_TUNNEL_SEGMENT
PKINTEGER
ID_TUNNEL
PFKINTEGER
ROCK_MASS_CLASSIFICATION
NUMERIC
OBSERVATION
VARCHAR
DATE_SEGMENT
TIMESTAMP WITHOUT TIME ZONE
COOR_EAST_PT1
DOUBLE PRECISION
COOR_NORTH_PT1
DOUBLE PRECISION
COOR_EAST_PT2
DOUBLE PRECISION
COOR_NORTH_PT2
DOUBLE PRECISION
ZONA
INTEGER
ID_DATUM
FKINTEGER
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
VARCHAR
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
IP_MODIF
VARCHAR
GEOMETRY
geography
ID_INSTRUMENT_TYPE
PFKINTEGER
ID_DATUM
PKINTEGER
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_BUILDING_STATE
PKINTEGER
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIFY
VARCHAR
DATE_MODIFY
TIMESTAMP WITHOUT TIME ZONE
ID_PIPELINE
PKINTEGER
ID_PROJECT
FKINTEGER
IDENTIFIER
VARCHAR
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_PIPELINE_PART
PKINTEGER
ID_PIPELINE
PFKINTEGER
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
GEOMETRY
geography
ID_BUILDING_TYPE
PKINTEGER
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_PIPELINE_SEGMENT
PKINTEGER
ID_PIPELINE
PFKINTEGER
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
GEOMETRY
geography
ID_DOWNLOAD_MONITORING
PKINTEGER
ID_PROJECT
PFKINTEGER
USER_LOGIN
PKVARCHAR
IP_LOGIN
VARCHAR
DOWNLOAD_DATE
TIMESTAMP WITHOUT TIME ZONE
FILENAME
VARCHAR
PATH
VARCHAR
ID_BOREHOLE_TYPE
PKINTEGER
DESCRIPTION
VARCHAR
ABREVIATION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_ROAD
PKINTEGER
ID_PROJECT
FKINTEGER
NAME
VARCHAR
ID_ROAD_TYPE
FKINTEGER
ID_ROAD_SURFACE_TYPE
FKINTEGER
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
GEOMETRY
geography
ID_ROAD_TYPE
PKINTEGER
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_ROAD_SURFACE_TYPE
PKINTEGER
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_CONVERGENCE_SECTION
PKINTEGER
ID_TUNNEL
FKINTEGER
IDENTIFIER
VARCHAR
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_STAKING_LINE
PKINTEGER
ID_PROJECT
FKINTEGER
IDENTIFIER
VARCHAR
DESCRIPTION
VARCHAR
USER_CREATION
VARCHAR
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
VARCHAR
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
ID_TUNNEL_SEGMENT
PFKINTEGER
ID_TUNNEL
PFKINTEGER
ID_FILE
PFKINTEGER
ID_INSTRUMENT_TYPE
PFKINTEGER
ID_FILE
PKINTEGER
FILENAME
CHARACTER VARYING
PATH
CHARACTER VARYING
DESCRIPTION
CHARACTER VARYING
USER_CREATION
CHARACTER VARYING
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
CHARACTER VARYING
USER_MODIF
CHARACTER VARYING
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
IP_MODIF
CHARACTER VARYING
ID_PROJECT
FKINTEGER
ID_DATA_SISMOGRAFO
PKINTEGER
ID_INSTRUMENT
FKINTEGER
COLLECT_DATE
TIMESTAMP WITHOUT TIME ZONE
CME
NUMERIC
DISTANCE
NUMERIC
SPEED_LONGITUDINAL
NUMERIC
FREQUENCY_LONGITUDINAL
NUMERIC
SPEED_TRANSVERSAL
NUMERIC
FREQUENCY_TRANSVERSAL
NUMERIC
SPEED_VERTICAL
NUMERIC
FREQUENCY_VERTICAL
NUMERIC
PROPAGATION_SPEED
NUMERIC
ACOUSTIC_PRESSURE
NUMERIC
OBSERVATION
CHARACTER VARYING
USER_CREATION
CHARACTER VARYING
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
IP_CREATION
CHARACTER VARYING
ID_INSTRUMENT
PFKINTEGER
ID_FILE
PFKINTEGER
ID_SEISMIC_ZONE
PKINTEGER
ID_PROJECT
FKINTEGER
IDENTIFIER
CHARACTER VARYING
DESCRIPTION
CHARACTER VARYING
USER_CREATION
CHARACTER VARYING
DATE_CREATION
TIMESTAMP WITHOUT TIME ZONE
USER_MODIF
CHARACTER VARYING
DATE_MODIF
TIMESTAMP WITHOUT TIME ZONE
Table to store the configuration of maximum values for alert
id_instrument
PFKINTEGER
mean_direction_a_max
NUMERIC
Value maximum for mean_direction_a field to raise alert
mean_direction_b_max
NUMERIC
Value maximum for mean_direction_b field to raise alert
flg_active_mean_direction_a
CHARACTER
Flag to indicate if the alert is active or not for this field
flg_active_mean_direction_b
CHARACTER
Flag to indicate if the alert is active or not for this field
user_creation
CHARACTER VARYING
date_creation
TIMESTAMP WITHOUT TIME ZONE
ip_creation
CHARACTER VARYING
user_modif
CHARACTER VARYING
date_modif
TIMESTAMP WITHOUT TIME ZONE
ip_modif
CHARACTER VARYING
id_project
PFKINTEGER
id_utm_zone
PFKVARCHAR
id_utm_zone
PKVARCHAR
description
VARCHAR
user_creation
VARCHAR
date_creation
TIMESTAMP WITHOUT TIME ZONE
user_modify
VARCHAR
date_modify
TIMESTAMP WITHOUT TIME ZONE
Historic table use to store the config alert values of inclinometers
id_config_alert_inclinometer
PKINTEGER
id_instrument
FKINTEGER
mean_direction_a_max
NUMERIC
mean_direction_b_max
NUMERIC
flg_active_mean_direction_a
CHARACTER
flg_active_mean_direction_b
CHARACTER
user_creation
CHARACTER VARYING
date_creation
TIMESTAMP WITHOUT TIME ZONE
ip_creation
CHARACTER VARYING
user_modif
CHARACTER VARYING
date_modif
TIMESTAMP WITHOUT TIME ZONE
ip_modif
CHARACTER VARYING
Historic table use to store the config alert values of settling pins
id_config_alert_settling_pin
PKINTEGER
id_instrument
FKINTEGER
settlement_max
NUMERIC
flg_active_settlement
CHARACTER
user_begin
CHARACTER VARYING
date_begin
TIMESTAMP WITHOUT TIME ZONE
ip_begin
CHARACTER VARYING
user_end
CHARACTER VARYING
date_end
TIMESTAMP WITHOUT TIME ZONE
ip_end
CHARACTER VARYING
Table to store the configuration of maximum values for settling pin alert
id_instrument
PFKINTEGER
settlement_max
NUMERIC
flg_active_settlement
CHARACTER
user_creation
CHARACTER VARYING
date_creation
TIMESTAMP WITHOUT TIME ZONE
ip_creation
CHARACTER VARYING
user_modif
CHARACTER VARYING
date_modif
TIMESTAMP WITHOUT TIME ZONE
ip_modif
CHARACTER VARYING
Table to store the configuration of maximum values for piezometer alert
id_instrument
PFKINTEGER
depth_water_lvl_max
NUMERIC
flg_active_depth_water_lvl
CHARACTER
user_creation
CHARACTER VARYING
date_creation
TIMESTAMP WITHOUT TIME ZONE
ip_creation
CHARACTER VARYING
user_modif
CHARACTER VARYING
date_modif
TIMESTAMP WITHOUT TIME ZONE
ip_modif
CHARACTER VARYING
id_config_alert_piezometer
PKINTEGER
id_instrument
FKINTEGER
depth_water_lvl_max
NUMERIC
flg_active_depth_water_lvl
CHARACTER
user_begin
CHARACTER VARYING
date_begin
TIMESTAMP WITHOUT TIME ZONE
ip_begin
CHARACTER VARYING
user_end
CHARACTER VARYING
date_end
TIMESTAMP WITHOUT TIME ZONE
ip_end
CHARACTER VARYING
id_instrument
PFKINTEGER
id_unit
PKINTEGER
Id of the unit
symbol
CHARACTER VARYING
Symbol of the unit
description
CHARACTER VARYING
Description of the unit
user_creation
CHARACTER VARYING
date_creation
TIMESTAMP WITHOUT TIME ZONE
ip_creation
CHARACTER VARYING
user_modif
CHARACTER VARYING
date_modif
TIMESTAMP WITHOUT TIME ZONE
ip_modif
CHARACTER VARYING
id
PKVARCHAR
id_unit_from
PFKINTEGER
Id of the unit at origin of conversion
id_unit_to
PFKINTEGER
Id of the unit resulting of conversion
conversion
NUMERIC
Multiplication factor of the conversion between the unit_from to unit_to
user_creation
CHARACTER VARYING
date_creation
TIMESTAMP WITHOUT TIME ZONE
ip_creation
CHARACTER VARYING
user_modif
CHARACTER VARYING
date_modif
TIMESTAMP WITHOUT TIME ZONE
ip_modif
CHARACTER VARYING
id_table
PKINTEGER
Id of the table
name
CHARACTER VARYING
Name of the table
description
CHARACTER VARYING
Description of the table
user_creation
CHARACTER VARYING
date_creation
TIMESTAMP WITHOUT TIME ZONE
ip_creation
CHARACTER VARYING
user_modif
CHARACTER VARYING
date_modif
TIMESTAMP WITHOUT TIME ZONE
ip_modif
CHARACTER VARYING
id_column
PKINTEGER
id_table
PFKINTEGER
name
CHARACTER VARYING
id_date_format
PKINTEGER
id of the date format
format
CHARACTER VARYING
Format of the date
description
CHARACTER VARYING
Description of the date format
user_creation
CHARACTER VARYING
date_creation
TIMESTAMP WITHOUT TIME ZONE
ip_creation
VARCHAR
user_modif
CHARACTER VARYING
date_modif
TIMESTAMP WITHOUT TIME ZONE
ip_modif
CHARACTER VARYING
