Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('private_ci2027_001.position_id_seq'::regclass) |
|
|
Unique ID der Probenfläche |
||||
| plot_id | int4 | 10 | null |
|
|
ID der Probenfläche |
|||||
| plot_location_id | int4 | 10 | √ | null |
|
|
|||||
| created_at | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
Erstellungszeitpunkt |
|||||
| modified_at | timestamp | 29,6 | √ | null |
|
|
|||||
| modified_by | regrole | 2147483647 | √ | (CURRENT_USER)::regrole |
|
|
|||||
| position_median | geometry | 2147483647 | null |
|
|
||||||
| position_mean | geometry | 2147483647 | null |
|
|
||||||
| hdop_mean | float8 | 17,17 | √ | null |
|
|
HDOP Mean |
||||
| pdop_mean | float8 | 17,17 | √ | null |
|
|
PDOP Mean |
||||
| satellites_count_mean | float8 | 17,17 | √ | null |
|
|
Satellites Count Mean |
||||
| measurement_count | int2 | 5 | √ | null |
|
|
Measurement Count |
||||
| rtcm_age | float8 | 17,17 | √ | null |
|
|
RTCM Age |
||||
| start_measurement | timestamp | 29,6 | √ | null |
|
|
Start Measurement |
||||
| stop_measurement | timestamp | 29,6 | √ | null |
|
|
Stop Measurement |
||||
| device_gps | varchar | 150 | √ | null |
|
|
Device GPS |
||||
| quality | "private_ci2027_001"."enum_gnss_quality" | 2147483647 | √ | null |
|
|
Quality of GNSS |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| position_pkey | Primary key | Asc | id |