Table cxgn.public.cxgn_bac_pipeline_processing_log

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('cxgn_bac_pipeline_processing_log_id_seq'::regclass)
deleted bool 1 false
timestamp timestamp 29,6 now()
uname varchar 40
host varchar 40
progname varchar 80
pid int4 10
search_key varchar 200  √  null
message text 2147483647  √  null

Table contained 832,083 rows at Wed May 20 01:40 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
search_key + deleted Performance Asc/Asc cxgn_bac_pipeline_processing_log_key
Performance cxgn_bac_pipeline_processing_log_timestamp