...
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. |
...