Technical Overview, project table

Revision as of 22:20, 17 February 2009 (view source) WikiSysop (Talk | contribs) (New page: 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 conten...) ← Older edit

Latest revision as of 21:50, 7 April 2011 (view source) WikiSysop (Talk | contribs) m (Protected "Technical Overview, project table" ([edit=sysop] (indefinite) [move=sysop] (indefinite)))

---

Latest revision as of 21:50, 7 April 2011

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).