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?



  • No labels