Table "public.intsetmedia"
    Column     |  Type   | Modifiers 
---------------+---------+-----------
 interaction   | bigint  | not null
 set           | bigint  | not null
 media         | bigint  | not null
 objectid      | bigint  | not null
 objectversion | integer | not null
Indexes: intsetmedia_pkey primary key btree (objectid),
         intsetmedia_ism_index unique btree (interaction, "set", media),
         intsetmedia_media_index btree (media),
         intsetmedia_set_index btree ("set")


                    Table "public.interaction"
     Column     |          Type          |       Modifiers        
----------------+------------------------+------------------------
 intdesc        | character varying(256) | not null default ''
 state          | bigint                 | 
 inttype        | character varying(32)  | not null default ''
 number         | integer                | not null
 video          | bigint                 | 
 needsdatatable | boolean                | not null default false
 objectid       | bigint                 | not null
 objectversion  | integer                | not null
Indexes: interaction_pkey primary key btree (objectid)



                                       Table "public.set"
      Column      |            Type             |                    
Modifiers                     
------------------+-----------------------------+-----------------------
------------------+-----------------------------+---------------------------
 reference        | integer                     | not null
 activity         | bigint                      | not null
 scene            | bigint                      | 
 setdesc          | character varying(4000)     | not null default 'No set 
description available.'
 acttype          | bigint                      | not null
 menutype         | bigint                      | not null
 remediate        | boolean                     | default false
 normal           | boolean                     | default false
 playpractice     | boolean                     | default false
 firsttimeonly    | boolean                     | default false
 avetime          | integer                     | 
 menuimage        | character varying(256)      | default ''
 scores           | boolean                     | default false
 minrun           | integer                     | 
 maxrun           | integer                     | 
 ignoretype       | boolean                     | default false
 automaticity     | integer                     | 
 review           | boolean                     | default false
 learningobj      | character varying(256)      | default ''
 setname          | character varying(64)       | default ''
 objectid         | bigint                      | not null
 objectversion    | integer                     | not null
 icon             | character varying(64)       | 
 codestatus       | bigint                      | not null
 statuschangedate | timestamp without time zone | 
 considerations   | character varying(256)      | 
Indexes: set_pkey primary key btree (objectid),
         set_act_index btree (activity)




                         Table "public.media"
      Column      |            Type             |      Modifiers      
------------------+-----------------------------+---------------------
 mediatype        | bigint                      | not null
 mediachar        | bigint                      | 
 status           | character varying(30)       | not null default ''
 sort             | real                        | not null default 0
 format           | character varying(32)       | default ''
 filename         | character varying(256)      | not null default ''
 mediadesc        | character varying(4000)     | default ''
 medianame        | character varying(4000)     | not null default ''
 video            | bigint                      | 
 highlight        | integer                     | default 0
 highlighter      | character varying(32)       | default ''
 activity         | bigint                      | not null
 lastupdatedby    | character varying(30)       | default ''
 highlightedmedia | bigint                      | 
 arttype          | bigint                      | 
 waitsyncmedia    | bigint                      | 
 key              | character varying(32)       | default ''
 productioncount  | integer                     | default 0
 objectid         | bigint                      | not null
 objectversion    | integer                     | not null
 cvspathstatus    | bigint                      | not null
 updatedate       | timestamp without time zone | 
Indexes: media_pkey primary key btree (objectid),
         media_act_index btree (activity),
         media_fname_index btree (filename),
         media_mchar_index btree (mediachar),
         media_mname_index btree (medianame),
         media_mtype_index btree (mediatype)