This area will explain and document the database schema, and explain the choices made during the design.
Schema Diagram:
Tables:
| Table Name | Description |
|---|---|
| account | Stores Request Handler user account information. |
| account_role | Connects account table to role table fro the request handler. |
| archive_log | Unused request Handler table for tracking downloads; not populated |
| authors | A listing of the authors of projects. |
| calibration_status_values | A listing of the allowed values for the calibration_status field of the execution_blocks table. |
| calibration_tables | not yet fully defined; will be used to store metadata about calibration tables. |
| configurations | The connecting table between data descriptions and execution blocks. |
| data_descriptions | A listing of the frequency, bandwidth, and polarizations used in each execution block. |
| databasechangelog | |
| databasechangeloglock | |
| datadesc | An artifact of the import process. Not used after import is complete. |
| events | A record of AAT/PPI events sent. |
| execblock_start_stop | |
| execution_blocks | The highest level of science data for an observation. contains one or more scans. |
| filegroups | Forms an arbitrary-level hierarchical structure between projects and files. |
| files | The file-specific data for an NGAS entity. Belongs to a filegroup. |
| flatfiles | An artifact of the import process. Not used after import is complete. |
| image_products | holds information shared among images which were created & ingested together. |
| images | holds metadata about images stored in the archive. |
| intents | a list of the intent_names that can be used in subscan_intents. currently empty and unused. |
| log_sequence | used for generating request handler request IDs |
| logs | A record of log messages generated by the AAT/PPI system. |
| new_vlba_data | An artifact of the import process. Not used after import is complete. |
| polarizations | A listing of the base polarizations. |
| projects | project-level data for images and observations. Contains filegroups and execution_blocks |
| receivers | Currently unused. |
| reingestion_queue | Tracking table for keeping the AAT/PPI system up to date with ALMA observations. |
| reingestion_states | Complete list of states for reingestion of ALMA data into the AAT/PPI structure |
| rh_commands | Lookup table containing types of commands issued for user-initiated AAT/PPI requests (i.e., those that come through the new archive UI) |
| rh_data_entities | Stores data entities (files or collections of files) associated with a Request Handler request. |
| rh_files | Tracks files associated with a given Request Handler request. |
| rh_operator_requests | Request Handler table for tracking requests made by operators (rather than end users). Unpopulated in new archive presently. |
| rh_processes | Tracks processes associated with a Request Handler request. |
| rh_request_parameters | Stores multiple key-value pairs associated with each Request Handler request. Each time the state of a request is updated, parameter values are inserted or update. |
| rh_requests | Tracks user download requests coming from the new archive UI |
| rh_requests_mediums | Unused Request Handler table, meant presumably to record the delivery medium for a request. |
| rh_site_delivery_medium | Unused Request Handler table, meant presumably to track details of delivery media. |
| role | Lookup table for request handler roles, referenced by account_role. |
| scans | the middle level of science data for an observation. Belongs to an execution_block, and contains one or more subscans. |
| subscan_data_descriptions | Deprecated |
| subscan_intents | |
| subscans | The lowest level of science data. belongs to a scan, and points to a file. |
| total_file_sizes | |
| workflow_input_files | the files taken as input by a workflow entry. |
| workflow_parameters | a set of name-value pairs listing the arguments for a workflow entry. |
| workflows | a listing of each processing job that takes in data from the archive and produces data that is stored in the archive. |