Table and index definitions

gistfile1.txt

shorty=# \d siteanalytics_pageview
                               Table "public.siteanalytics_pageview"
         Column          |           Type           |                   Modifiers                   
-------------------------+--------------------------+-----------------------------------------------
 domain                  | integer                  | 
 visit_id                | uuid                     | 
 pageview_id             | uuid                     | 
 page_url                | text                     | 
 pageview_timestamp      | timestamp with time zone | 
 pageview_state          | integer                  | 
 _open_duration_began    | timestamp with time zone | 
 open_duration           | integer                  | 
 visible                 | boolean                  | 
 _visible_duration_began | timestamp with time zone | 
 visible_duration        | integer                  | 
 page_title              | text                     | 
 stream_serial           | integer                  | default nextval('peoplestream_seq'::regclass)
 sweep                   | boolean                  | 
Indexes:
    "siteanalytics_pageview_domain_idx" btree (domain)
    "siteanalytics_pageview_pageview_id_idx" btree (pageview_id)
    "siteanalytics_pageview_pageview_state_idx" btree (pageview_state)
    "siteanalytics_pageview_stream_serial_idx" btree (stream_serial)
    "siteanalytics_pageview_visit_id_idx" btree (visit_id)

shorty=# \d siteanalytics_pageview_domain_idx
Index "public.siteanalytics_pageview_domain_idx"
 Column |  Type   | Definition 
--------+---------+------------
 domain | integer | domain
btree, for table "public.siteanalytics_pageview"

shorty=# \d siteanalytics_pageview_pageview_id_idx 
Index "public.siteanalytics_pageview_pageview_id_idx"
   Column    | Type | Definition  
-------------+------+-------------
 pageview_id | uuid | pageview_id
btree, for table "public.siteanalytics_pageview"

shorty=# \d siteanalytics_pageview_pageview_state_idx 
Index "public.siteanalytics_pageview_pageview_state_idx"
     Column     |  Type   |   Definition   
----------------+---------+----------------
 pageview_state | integer | pageview_state
btree, for table "public.siteanalytics_pageview"

shorty=# \d siteanalytics_pageview_stream_serial_idx 
Index "public.siteanalytics_pageview_stream_serial_idx"
    Column     |  Type   |  Definition   
---------------+---------+---------------
 stream_serial | integer | stream_serial
btree, for table "public.siteanalytics_pageview"

shorty=# \d siteanalytics_pageview_visit_id_idx 
Index "public.siteanalytics_pageview_visit_id_idx"
  Column  | Type | Definition 
----------+------+------------
 visit_id | uuid | visit_id
btree, for table "public.siteanalytics_pageview"

shorty=#