Message-ID: <404117900.7464.1711623340820.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7463_1999005426.1711623340816" ------=_Part_7463_1999005426.1711623340816 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html WORKPLACE Table

WORKPLACE Table

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.

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

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

=20

 

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)

=20



------=_Part_7463_1999005426.1711623340816--