WISE5 Notebook

Summary

A workgroup's Notebook contains the workgroup's notes, bookmarks, and questions. 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),
    content text,
    nodeId varchar(30),
    serverDeleteTime datetime,
    serverSaveTime datetime not null,
    title varchar(255),
    type varchar(30),
    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"
• content: the actual content of this notebook item.
• nodeId: id of the node this NotebookItem is for
• serverSaveTime: server timestamp when this NotebookItem was saved in db
• type: type of the notebook item. Current-supported types are "notes", "questions", and "bookmarks"
• 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.