bacula=# \d file
                             Table "public.file"
   Column   |  Type   |                       Modifiers                       
------------+---------+-------------------------------------------------------
 fileid     | integer | not null default nextval('file_fileid_seq'::regclass)
 fileindex  | integer | not null default 0
 jobid      | integer | not null
 pathid     | integer | not null
 filenameid | integer | not null
 markid     | integer | not null default 0
 lstat      | text    | not null
 md5        | text    | not null
Indexes:
    "file_pkey" PRIMARY KEY, btree (fileid)
    "file_filenameid_idx" btree (filenameid)
    "file_fp_idx" btree (filenameid, pathid)
    "file_jobid_idx" btree (jobid)
    "file_jpfid_idx" btree (jobid, pathid, filenameid)
    "file_pathid" btree (pathid)
"file_filenameid_idx" btree (filenameid)