/
PM_PROJECT_DATA Table

PM_PROJECT_DATA Table

Jan 28, 2019

  • 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