Unused Request Handler table, meant presumably to track details of delivery media.
Definition:
Column | Type | Collation | Nullable | Default
----------------+--------------------------------+-----------+----------+-----------------------------------------------------------
medium_id | numeric | | not null |
active | character(1) | | not null |
media_type | character varying | | not null |
host_name | character varying | | not null |
device | character varying | | not null |
capacity | real | | not null |
request_id | numeric | | |
state | character varying | | not null |
last_mod | timestamp(6) without time zone | | | '2018-04-18 15:21:15.783814'::timestamp without time zone
status_message | character varying | | not null |
Indexes:
"rh_site_delivery_medium_pkey" PRIMARY KEY, btree (medium_id)
Referenced by:
TABLE "rh_requests_mediums" CONSTRAINT "rh_requests_mediums_rh_si_fk1" FOREIGN KEY (medium_id) REFERENCES rh_site_delivery_medium(medium_id)
Triggers:
rh_site_delivery_medium_update_trigger BEFORE UPDATE ON rh_site_delivery_medium FOR EACH ROW EXECUTE PROCEDURE rh_site_delivery_medium_update()
Columns:
medium_id: primary key
active: intended to be boolean?
media_type: intended to be foreign key to lookup value?
host_name: intended to be server on which media are stored?
device: intended to be hardware location of storage device?
capacity: storage capacity of medium?
request_id: foreign key into rh_requests
state: intended to indicate request state?
last_mod: timestamp
status_message: message for user regarding request status?