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)