Server (Cells) Design
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • 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

  • 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

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.