Database Properties
Database Type: PostgreSQL - 14.2
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| data_profile | 0 | 5 | 7 | 0 | Table | Contains the summarized bin profile tag observations (migrated from proc_observations) |
| data_time_series | 0 | 5 | 6 | 0 | Table | Contains the continuous measurement archival time series of tag geophysical measurments (migrated from proc_observations) |
| data_histogram_bin_data | 0 | 7 | 8 | 0 | Table | Conatins the frequency for corresponding summary data binning schemes (migrated from proc_observations) |
| metadata_types | 1 | 0 | 8 | 142 | Table | Contains descriptive information on tag metadata based on the eTUFF specification |
| data_position | 9 | 1 | 8 | 0 | Table | Contains the tag positional data series with associated Lat/Lon error estimates where available (migrated from proc_observations) |
| data_histogram_bin_info | 2 | 1 | 5 | 0 | Table | Contains definitions of binning schemes for summary tag data (migrated from proc_observations) |
| observation_types | 5 | 0 | 7 | 204 | Table | Contains listings and descriptions of observation variable types based on the eTUFF specification |
| submission | 6 | 0 | 6 | 0 | Table | Contains information on source tag eTUFF files submitted for ingest into Tagbase |
| metadata | 0 | 2 | 4 | 0 | Table | Contains the ingested tag metadata consistent with the eTUFF specification |
| proc_observations | 0 | 2 | 6 | 0 | Table | Contains staged source tag eTUFF data imported into Tagbase |