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








  • No labels