Workplace data is distributed to project through the existence of independent databases (in SQL Server) or schemas (in Oracle). In order to support the i2b2 project distribution strategy, the user may be enrolled in numerous projects recorded within the i2b2 Project Management Cell. The logic for selecting the correct database or schema for a project is embodied in the following table:
WORK_DB_LOOKUP |
|
|
|
|---|---|---|---|
|
COLUMN NAME |
DATA TYPE |
DESCRIPTION |
PK |
C_DOMAIN_ID |
VARCHAR(255) |
Domain (or target location) |
PK |
C_PROJECT_PATH |
VARCHAR(255) |
'Project name'| |
PK |
C_OWNER_ID |
VARCHAR(255) |
User ID of owner |
|
C_DB_FULLSCHEMA |
VARCHAR(255) |
Full schema name of the workplace table |
|
C_DB_DATASOURCE |
VARCHAR(255) |
Data source pointing to the workplace table location |
|
C_DB_SERVERTYPE |
VARCHAR(255) |
Database type of workplace table (ORACLE or SQLSERVER) |
|
C_DB_NICENAME |
VARCHAR(255) |
Table name |
|
C_DB_TOOLTIP |
VARCHAR(255) |
Workplace tooltip |
|
C_COMMENT |
CLOB |
Optional comment |
|
C_ENTRY_DATE |
DATE |
(null) or specified |
|
C_CHANGE_DATE |
DATE |
(null) or specified |
|
C_STATUS_CD |
CHAR(1) |
(null) or "D" (deleted) |
