WISE5 Notebook

Summary

A workgroup's Notebook consists of StudentWorkNotebookItem, StudentAssetsNotebookItem, and StudentIdeaNotebookItem for a particular workgroup in a run. These items can be retrieved and added from any step view or activity view during the run.

Schema Definition

create table notebookItems ( id integer not null auto_increment, clientDeleteTime datetime, clientSaveTime datetime not null, componentId varchar(30), description text, nodeId varchar(30), serverDeleteTime datetime, serverSaveTime datetime not null, title varchar(255), periodId bigint not null, runId bigint not null, studentAssetId integer, studentWorkId integer, workgroupId bigint not null, primary key (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

• id: unique id for this NotebookItem
• clientSaveTime: client timestamp when this NotebookItem was saved
• componentId: id of the component this NotebookItem is for
• componentType: type of the component this NotebookItem is for. e.g. "OpenResponse", "Draw"
• description: student-entered description for this NotebookItem, e.g. "This shows atoms and molecules bonding over coffee"
• nodeId: id of the node this NotebookItem is for
• serverSaveTime: server timestamp when this NotebookItem was saved in db
• title: student-entered title for this NotebookItem, e.g. "Atoms&Molecules"
• periodId: id of the period that this NotebookItem was created for (id of period of workgroup who created this NotebookItem)
• runId: id of the run that this NotebookItem was created for (id of run of workgroup who created this NotebookItem)
• studentAssetId: foreign-key reference to a row in the StudentAsset table
• studentWorkId: foreign-key reference to a row in the StudentWork table
• workgroupId: id of the workgroup that created this NotebookItem

If studentAssetId field is not null, it is a StudentAssetNotebookItem. If studentWorkId field is not null, it is a StudentWorkNotebookItem.