Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

  • The PM_PROJECT_DATA table contains general information about the project.
  • There is only one row per PROJECT_ID; data with special tags that can occur once per project is also in that row.
  • The PROJECT_ID is a unique identifier.
  • The PROJECT_NAME is a shot human legible name for the project.
  • The PROJECT_KEY is the MD5 has for the project key used to encrypt data.
  • The PROJECT_WIKI contains a URL for the project wiki.
  • The PROJECT_PATH is used in queries to find the value for both cell and global parameters. Below is a more detailed explanation and example.
  • The PROJECT_DESCRIPTION is a long description that can be searched.



PM_PROJECT_DATA

 

 

PK

PROJECT_ID

varchar(50)

 

PROJECT_NAME

varchar(255)

 

PROJECT_KEY

varchar(255)

 

PROJECT_WIKI

varchar(255)

 

PROJECT_PATH

varchar(255)

 

PROJECT_DESCRIPTION

varchar(2000)



PROJECT_PATH

  • Represents a special string in the following format:

/PROJECT_NAME/sub-project_name/etc…

  • Used primarily to manage default parameters that the users will see in regards to the interactions they have with a cell.
  • It will be used in queries to find the value for both cell and global parameters.
  • The hive is initialized with default values for all parameters with a blank / null project, following which the parameters may be overridden by adding a project.
  • When the query returns, only one value for each parameter is returned, but that is the most specific available.



Example:

PROJECT_PATH

Value

/

Overall hive default

/ASTH

Asthma default

/HTN

Hypertension default

/ASTH/SNM0

Sub-project for Asthma


If the above table was queried by a member of the asthma project who is not a member of the SNM0 sub-project then "Asthma default" would be obtained. If the project "MDD" was to query the table as a member of the major depression project, the value of "Overall hive default" will be obtained because a more specific entry does not exist for the user.

  • No labels