pl=# \d pl_inventory_analyzer_files_table
                  Table "public.pl_inventory_analyzer_files_table"
    Column     |            Type             |                                     Modifiers
---------------+-----------------------------+-----------------------------------------------------------------------------------
 file_id       | integer                     | not null default nextval('public.pl_inventory_evaluator_files_file_id_seq'::text)
 name          | character varying(150)      | not null
 status_id     | integer                     |
 date_uploaded | timestamp without time zone | default now()
 zip           | boolean                     | not null default true
 search_types  | character varying(20)       | not null
 delimited_by  | character varying(10)       | not null default 'TAB'::character varying
 uid           | integer                     |
 stored_name   | character varying(150)      | not null
   
Indexes:
	"pl_inventory_evaluator_files_pkey" primary key, btree (file_id)

Foreign-key constraints:
	"$1" FOREIGN KEY (status_id) REFERENCES pl02_status_table(status_id)
	"$2" FOREIGN KEY (uid) REFERENCES pl02_user_login_table(uid)

pl=# \d pl02_status_table
                       Table "public.pl02_status_table"
   Column    |          Type          |                    Modifiers
-------------+------------------------+-------------------------------------------------
 status_id   | integer                | not null default nextval('status_id_seq'::text)
 description | character varying(256) |

Indexes:
	"status_id_pkey" unique, btree (status_id)

Triggers:
	"_T1_denyaccess_51" BEFORE INSERT OR DELETE OR UPDATE ON pl02_status_table FOR EACH ROW EXECUTE PROCEDURE "_T1".denyaccess('_T1')

pl=#