25 March 2011

    ------- MYSQL databases created for each session --- 

basic: Basic session info
   instrument, filelist, creation

servervars: Store varname as a serverVar:   (varname is key)
   varname, varvalue, modified

statusVars: Store varname as a statusVar  (varname is key)
   varname,varvalue, modified

clientstatus: Store client status (such as last requested variable)    (clientid is key)
   clientid , servertime, clienttime, state, message, varname, varvalue

submitted:   Store data "submitted" by clients (clientid, round, ct are keys)
   clientid, round, ct  , servertime,clienttime, notfinal ct, entry, comment
   
submitStatus: Store client submission status (time/comment of last submission (sStatus is key)
   sstatus,clienttime

simpleHistory:  store simple history information uploaded by clients (arow is key, auto incremented)
     arow, round, servertime, content, comment
     
clientIds: information about a client (clientid is key)
  clientid, clientName, refId, serverTime, content

assignCID: assigning unique client IDs  (used if server-side id assignation is enabled) (clientid is auto-incremented key)
   clientid, clientName, servertime

messages: store dSurvey messages
   clientId,  servertime ,content, subject, cTime, fromId,  fromName,  toList,  urgent,stuff

messagesAdmin : info on dsurveyMessages
   clientId, lastReadTime, newFlag


The next several xxxxData databases are used to store "archives" of results, by round.


generalData: store general data (round is key) -- one entry per round
  round int(4) not null ,
     PRIMARY KEY (round)  ,
  servertime int,
  entry text

participantsData: store participants data (round is key) -- one entry per round
  round int(4) not null ,
     PRIMARY KEY (round)  ,
  servertime int,
  entry text

usersData: store users  data (round is key) -- one entry, with records for many clients, per round
  round int(4) not null ,
     PRIMARY KEY (round)  ,
  servertime int,
  entry text

resultsData: store results data (round is key) -- one entry, with records for many clients, per round
  content text not null ,
  servertime int

historyData: store history data (round is key) -- one entry, with records for many clients, per round
  round int(4) not null ,
     PRIMARY KEY (round)  ,
  servertime int,
  entry text

notes: store notes submitted by administator (no key)  -- submitted as desired by administrator
  servertime int,
  entry text
  

customData: store custom data (possibly several kinds) (name and round is key) -- one entry, with records for many clients, per round
  round int(4) not null ,
  aname varchar(60) not null,
     PRIMARY KEY (aname,round)  ,
  servertime int,
  entry text

