The project table is an on-disk index of the project details from GPMDB result files. It is used in dblist_gpmnotes.pl searches.
The contents of this table are updated incrementally as part of the updates procedure, which executes daily.
Columns:
- projectid: the unique identifier of a row of data.
- resultid: the unique identifier of a result file, from the result table.
- name: the content of the project name attribute from the data file (may be null).
- institution: the content of the project institution attribute from the data file (may be null).
- email: the content of the project email attribute from the data file (may be null).
- project: the content of the project title attribute from the data file (may be null).
- description: the content of the project description attribute from the data file (may be null).