bareos-# \d+ Media
                                                               Table "public.media"
      Column      |            Type             |                        Modifiers                        | Storage  | Stats target | Description 
------------------+-----------------------------+---------------------------------------------------------+----------+--------------+-------------
 mediaid          | integer                     | not null default nextval('media_mediaid_seq'::regclass) | plain    |              | 
 volumename       | text                        | not null                                                | extended |              | 
 slot             | integer                     | default 0                                               | plain    |              | 
 poolid           | integer                     | default 0                                               | plain    |              | 
 mediatype        | text                        | not null                                                | extended |              | 
 mediatypeid      | integer                     | default 0                                               | plain    |              | 
 labeltype        | integer                     | default 0                                               | plain    |              | 
 firstwritten     | timestamp without time zone |                                                         | plain    |              | 
 lastwritten      | timestamp without time zone |                                                         | plain    |              | 
 labeldate        | timestamp without time zone |                                                         | plain    |              | 
 voljobs          | integer                     | default 0                                               | plain    |              | 
 volfiles         | integer                     | default 0                                               | plain    |              | 
 volblocks        | integer                     | default 0                                               | plain    |              | 
 volmounts        | integer                     | default 0                                               | plain    |              | 
 volbytes         | bigint                      | default 0                                               | plain    |              | 
 volerrors        | integer                     | default 0                                               | plain    |              | 
 volwrites        | integer                     | default 0                                               | plain    |              | 
 volcapacitybytes | bigint                      | default 0                                               | plain    |              | 
 volstatus        | text                        | not null                                                | extended |              | 
 enabled          | smallint                    | default 1                                               | plain    |              | 
 recycle          | smallint                    | default 0                                               | plain    |              | 
 actiononpurge    | smallint                    | default 0                                               | plain    |              | 
 volretention     | bigint                      | default 0                                               | plain    |              | 
 voluseduration   | bigint                      | default 0                                               | plain    |              | 
 maxvoljobs       | integer                     | default 0                                               | plain    |              | 
 maxvolfiles      | integer                     | default 0                                               | plain    |              | 
 maxvolbytes      | bigint                      | default 0                                               | plain    |              | 
 inchanger        | smallint                    | default 0                                               | plain    |              | 
 storageid        | integer                     | default 0                                               | plain    |              | 
 deviceid         | integer                     | default 0                                               | plain    |              | 
 mediaaddressing  | smallint                    | default 0                                               | plain    |              | 
 volreadtime      | bigint                      | default 0                                               | plain    |              | 
 volwritetime     | bigint                      | default 0                                               | plain    |              | 
 endfile          | integer                     | default 0                                               | plain    |              | 
 endblock         | bigint                      | default 0                                               | plain    |              | 
 locationid       | integer                     | default 0                                               | plain    |              | 
 recyclecount     | integer                     | default 0                                               | plain    |              | 
 minblocksize     | integer                     | default 0                                               | plain    |              | 
 maxblocksize     | integer                     | default 0                                               | plain    |              | 
 initialwrite     | timestamp without time zone |                                                         | plain    |              | 
 scratchpoolid    | integer                     | default 0                                               | plain    |              | 
 recyclepoolid    | integer                     | default 0                                               | plain    |              | 
 encryptionkey    | text                        |                                                         | extended |              | 
 comment          | text                        |                                                         | extended |              | 
Indexes:
    "media_pkey" PRIMARY KEY, btree (mediaid)
    "media_volumename_id" UNIQUE, btree (volumename)
    "media_poolid_idx" btree (poolid)
Check constraints:
    "media_volstatus_check" CHECK (volstatus = ANY (ARRAY['Full'::text, 'Archive'::text, 'Append'::text, 'Recycle'::text, 'Purged'::text, 'Read-Only'::text, 'Disabled'::text, 'Error'::text, 'Busy'::text, 'Used':
:text, 'Cleaning'::text, 'Scratch'::text]))
Has OIDs: no