Tracks files associated with a given Request Handler request.
Definition:
Column | Type | Collation | Nullable | Default
----------------+-------------------+-----------+----------+---------
file_id | numeric | | not null |
request_id | numeric | | |
data_entity_id | numeric | | |
file_key | character varying | | not null |
namespace | character varying | | not null |
file_name | character varying | | not null |
file_type | character varying | | |
file_uri | character varying | | not null |
file_size | numeric | | not null |
rank | numeric | | |
permission | character varying | | |
medium_id | numeric | | |
Indexes:
"rh_files_pkey" PRIMARY KEY, btree (file_id)
"rh_file_data_entity" btree (data_entity_id)
"rh_file_request" btree (request_id)
"rh_files_file_key_idx" btree (file_key)
Check constraints:
"rh_files_check" CHECK (request_id IS NOT NULL AND data_entity_id IS NULL OR request_id IS NULL AND data_entity_id IS NOT NULL)
Foreign-key constraints:
"rh_files_data_entity_id_fkey" FOREIGN KEY (data_entity_id) REFERENCES rh_data_entities(data_entity_id)
"rh_fk_request_id_files" FOREIGN KEY (request_id) REFERENCES rh_requests(request_id)
Referenced by:
TABLE "rh_processes" CONSTRAINT "rh_processes_file_id_fkey" FOREIGN KEY (file_id) REFERENCES rh_files(file_id)
Columns:
file_id: primary key
request_id: foreign key into rh_requests
data_entity_id: data entity to which file belongs; foreign key into rh_data_entities
file_key: fileset ID without prefix
namespace: where file is hosted? values: DSOC, NAASC
file_name: filename
file_type: ? always null
file_uri: location from which file can be downloaded (e.g., "https://dl-nrao.aoc.nrao.edu/anonymous/2022692/bf1b4fdds1b0k0l2gt4krtha5f//15B-332_2015_12_31_T15_55_50.842.tar" or "file://lustre/aoc/sciops/jgoldste/20180418-prod//MD5SUMS"
file_size: file size, bytes
rank: something to do with sort order in UI? not populated
permission: file permission? not populated
medium_id: delivery medium? not populated