The WORKPLACE table is organized by project and contains all the information needed to store and access workplace items. There is one table per project.
WORKPLACE TABLE |
|
|
|
|---|---|---|---|
|
COLUMN NAME |
DATA TYPE |
DESCRIPTION |
PK |
C_INDEX |
VARCHAR(255) |
Unique index of workplace item |
|
C_NAME |
VARCHAR(255) |
Name of workplace item |
|
C_USER_ID |
VARCHAR(255) |
User id |
|
C_GROUP_ID |
VARCHAR(255) |
Project name |
|
C_SHARE_ID |
VARCHAR(255) |
(null) or "Y" or "N" |
|
C_PARENT_INDEX |
VARCHAR(255) |
Unique index of item's parent |
|
C_VISUALATTRIBUTES |
CHAR(3) |
Code representing which icon to display |
|
C_PROTECTED_ACCESS |
CHAR(1) |
(null) or "Y" or "N" |
|
C_TOOLTIP |
VARCHAR(255) |
i2b2Type: annotation (or name) |
|
C_WORK_XML |
CLOB |
DnD message contents |
|
C_WORK_XML_SCHEMA |
CLOB |
DnD schema contents |
|
C_WORK_XML_I2B2_TYPE |
VARCHAR(255) |
DnD i2b2 type |
|
C_ENTRY_DATE |
DATE |
(null) or specified |
|
C_CHANGE_DATE |
DATE |
(null) or specified |
|
C_STATUS_CD |
CHAR(1) |
(null) or "D" (deleted) |
