| Field name | Description | Data type* | Null allowed? | Key status |
| projid | unique MPD id number identifying the project | int | no |
primary key;
|
| projsym | short project identifier, usually 1st author name (capitalized) followed by a uniqueness digit | | yes, for projects w/no data |
secondary key;
|
| pistring | principal investigator list, or an institution name | | no |
|
| title | project title | | no |
|
| compstatus | completion status, either "loaded" or "underway" | | no |
|
| correspondent | the person id of the corresponding author | int | yes, for institutional authorship |
foreign key on people
|
| pilist | comma-delimited list of person ids of PIs | | yes, for institutional authorship |
foreign key on people
|
| inv_order | comma-delimited list of integers controlling order that PIs are listed | | yes |
|
| allinvsameinst | if "y" indicates that all PIs are from same institution | | no |
|
| consortium | a consortium id | | yes |
foreign key on consortia
|
| otherpeople | freeform text string list of other participants | | yes |
|
| nstrains | number of strains tested | int | yes |
|
| genders | one of: females, males, unknown, elsewhere | | no |
|
| ages | freeform description of animal ages | | yes |
|
| instauthpfx | a nonsorting prefix (eg. The) if needed, for when project has institutional authorship. | | yes |
|
| acknowledgements | freeform text of project acknowledgements | | yes |
|
| funding | freeform text describing federal/NIH funding | | yes |
|
| url | a url belonging to the project or PIs | | yes |
|
| projyear | year of project labwork completion or major publication | | yes |
|
| privatefund | freeform text describing non-federal funding | | yes |
|
| mousenotes | freeform text describing mouse acquisition etc. | | yes |
|
| longdesc | longer description or notes | text | yes |
|
| primarypubs | comma-delimited list of pmids considered 'primary pubs' for project | | yes |
foreign key on journalcits
|
| relatedpubs | comma-delimited list of pmids considered 'related pubs' for project | | yes |
foreign key on journalcits
|
| _lockowner | for record locking | | yes |
|
| _locktime | for record locking | | yes |
|
Suggestion box
Hints