Database Properties
Database Type: PostgreSQL - 12.7 (Ubuntu 12.7-0ubuntu0.20.04.1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| ob_groupmembers | 0 | 3 | 8 | 0 | Table | Successful observations made under OB groups |
| qa_tests | 1 | 0 | 12 | 6 | Table | Quality Assurance test definitions |
| raw | 17 | 1 | 23 | 42477 | Table | Raw data PHU section - primary table with deletion cascades to connected packets |
| qa | 0 | 2 | 9 | 0 | Table | Quality Assurance test results and evaluation |
| observation | 0 | 1 | 23 | 42477 | Table | Observation PHU packet |
| guiderr | 0 | 1 | 7 | 588614 | Table | The Guiding Errors table |
| target_catalogue | 0 | 1 | 6 | 96 | Table | FITS Target Catalogues |
| autoguider | 0 | 1 | 151 | 9015 | Table | Autoguider PHU packet |
| proc_prefs | 0 | 0 | 10 | 4 | Table | Per-node settings for processing alerts (0:none,1:error,2:warning,3:info) and retraction clobbering |
| ob_status | 3 | 1 | 19 | 2539 | Table | All OBs observed, including repeats |
| nightlog | 26 | 0 | 25 | 453 | Table | Nightly statistics for observations (no double counting for red+blue) |
| ob_retraction | 0 | 0 | 9 | 210 | Table | List of OBs that have been set to retracted |
| camera | 0 | 1 | 28 | 42477 | Table | Camera PHU packet |
| metinfo | 0 | 1 | 14 | 4266730 | Table | The Meteorological FITS table |
| primefocus | 0 | 1 | 13 | 42477 | Table | Prime focus corrector PHU packet |
| cache | 0 | 0 | 6 | 4 | Table | Keep track of cached spectra plots etc |
| ob_groups | 1 | 1 | 11 | 0 | Table | All defined OB groups |
| pipe_stateinfo | 0 | 0 | 9 | 46 | Table | Description of pipeline states (OB and product-level) for OR visualisation |
| validation_log | 0 | 1 | 8 | 27419 | Table | Warnings and errors from validation of data products by the Operational Repository |
| proc_daemon | 0 | 2 | 9 | 1 | Table | WEAVE daemon event processor info |
| flash_notify | 0 | 0 | 6 | 1 | Table | Notification messages to broadcast via TurboGears flash |
| pos | 0 | 1 | 73 | 9015 | Table | Fibre positioner PHU packet |
| l1_calib | 0 | 1 | 8 | 8 | Table | L1 calibration files |
| proc_state | 3 | 1 | 16 | 1814 | Table | Current processing and dataflow state of WEAVE data products |
| spectrograph | 0 | 1 | 23 | 42477 | Table | Spectrograph PHU packet |
| l1_target | 0 | 2 | 27 | 1226672 | Table | L1 target data (from the L1 fibinfo table) |
| l1_super | 0 | 0 | 3 | 0 | Table | L1 processed supertacked target table |
| ob_comments | 0 | 1 | 5 | 0 | Table | OISMT comments on the Observing Blocks, provided by EON |
| tcs | 0 | 1 | 49 | 9015 | Table | Telescope Control System PHU packet |
| stat_mon | 0 | 0 | 10 | 5 | Table | Status of various services |
| raw_target | 1 | 1 | 43 | 4370108 | Table | Raw target data (from the raw fibinfo table) |
| environment | 0 | 1 | 29 | 42477 | Table | Environment PHU packet |
| l2_target | 0 | 1 | 8 | 0 | Table | L2 target data (from the L2 fibinfo table) |
| detector2 | 0 | 1 | 18 | 9015 | Table | Detector CCD 2 (raw) |
| ob | 0 | 1 | 16 | 9015 | Table | Observing Block PHU packet |
| detector1 | 0 | 1 | 18 | 9015 | Table | Detector CCD 1 (raw) |
| integrity | 0 | 1 | 11 | 269314 | Table | Checksum and datasum info for each WEAVE file |
| l1 | 2 | 2 | 38 | 2714 | Table | The WEAVE L1 data product |
| l2 | 2 | 3 | 38 | 798 | Table | L2 multispec PHU |
| detector | 0 | 0 | 26 | 0 | Table | L1 merged detector |
| observing_block | 0 | 2 | 40 | 2624 | Table | Observing Block XML file |
| survey_log | 0 | 2 | 6 | 11245 | Table | Register of which surveys received data in an observation |
| cs | 0 | 1 | 11 | 0 | Table | Contributed software data table |
| proc_log | 1 | 2 | 18 | 6209 | Table | Log of changes to processing state of data (info updates ignored) |
| proc_loginfo | 0 | 1 | 4 | 8006 | Table | Log of info updates generated |
| pipe_filestate | 0 | 1 | 9 | 2 | Table | Per-pipeline progress reporting at product level (one row per pipeline) |
| request | 0 | 0 | 11 | 288 | Table | |
| pipe_obstate | 0 | 1 | 11 | 2 | Table | Per-pipeline progress reporting at OB level (one row per pipeline) |
| provenance | 0 | 1 | 6 | 2400 | Table | Provenance data for stack and cube products |
| casu_idserver | 0 | 0 | 1 | 0 | Table | Provides the CASUID for Observing Blocks |
| l2_patch | 0 | 1 | 7 | 281 | Table | L2 patch PHU data |
| l2_view | 0 | 1 | 24 | 0 | View | |
| raw_view | 0 | 1 | 17 | 0 | View | |
| rawcalib_view | 0 | 1 | 8 | 0 | View | |
| target_view | 0 | 0 | 5 | 0 | View | |
| l1_moreview | 0 | 1 | 20 | 0 | View | |
| l1_view | 0 | 1 | 19 | 0 | View | |
| rawmore_view | 0 | 1 | 27 | 0 | View | |
| l2_moreview | 0 | 1 | 25 | 0 | View |