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
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 | =20
| =20
| =20
| =20
---|---|---|---|
| =20
COLUMN NAME | =20
DATA TYPE | =20
DESCRIPTION | =20
PK | =20
C_INDEX | =20
VARCHAR(255) | =20
Unique index of workplace item | =20
| =20
C_NAME | =20
VARCHAR(255) | =20
Name of workplace item | =20
| =20
C_USER_ID | =20
VARCHAR(255) | =20
User id | =20
| =20
C_GROUP_ID | =20
VARCHAR(255) | =20
Project name | =20
| =20
C_SHARE_ID | =20
VARCHAR(255) | =20
(null) or "Y" or "N" | =20
| =20
C_PARENT_INDEX | =20
VARCHAR(255) | =20
Unique index of item's parent | =20
| =20
C_VISUALATTRIBUTES | =
=20
CHAR(3) | =20
Code representing which icon to display = td>=20 |
| =20
C_PROTECTED_ACCESS | =20
CHAR(1) | =20
(null) or "Y" or "N" | =20
| =20
C_TOOLTIP | =20
VARCHAR(255) | =20
i2b2Type: annotation (or name) | =20
| =20
C_WORK_XML | =20
CLOB | =20
DnD message contents | =20
| =20
C_WORK_XML_SCHEMA | =20
CLOB | =20
DnD schema contents | =20
| =20
C_WORK_XML_I2B2_TYPE | =20
VARCHAR(255) | =20
DnD i2b2 type | =20
| =20
C_ENTRY_DATE | =20
DATE | =20
(null) or specified | =20
| =20
C_CHANGE_DATE | =20
DATE | =20
(null) or specified | =20
| =20
C_STATUS_CD | =20
CHAR(1) | =20
(null) or "D" (deleted) | =20