Table "product"
       Column        |           Type           |                      Modifiers                      
---------------------+--------------------------+-----------------------------------------------------
 productid           | integer                  | not null default nextval('productpksequence'::text)
 ecwnumber           | character varying(25)    | 
 title               | character varying(250)   | 
 datecreated         | timestamp with time zone | default now()
 datemodified        | timestamp with time zone | 
 displaydatestart    | timestamp with time zone | 
 displaydateend      | timestamp with time zone | 
 description         | text                     | 
 cost                | double precision         | default 0
 productfileurl      | character varying(250)   | 
 productfilesize     | integer                  | 
 downloadable        | boolean                  | default 'f'::bool
 yrpublished         | character varying(4)     | 
 pages               | integer                  | 
 reportsummary       | text                     | 
 reportfileurl       | character varying(250)   | 
 reportfilesize      | integer                  | 
 requestable         | boolean                  | default 't'::bool
 keywords            | text                     | 
 rank                | integer                  | 
 producttypeid       | integer                  | 
 imageid             | integer                  | 
 preferredcategoryid | integer                  | 
 notes               | text                     | 
 heading             | text                     | 
 kicker              | text                     | 
 byline              | character varying(50)    | 
 fmi                 | text                     | 
 body                | text                     | 
 extra1              | text                     | 
 extra2              | text                     | 
 extra3              | text                     | 
Indexes: product_date1_idx,
         product_date2_idx
Primary key: product_pkey