Skip to main content
Jump to: navigation, search

ProjectInfoAPI

Revision as of 09:29, 12 September 2007 by Nathan.gervais.eclipse.org (Talk | contribs) (New page: == ProjectInfo Schema == The following is the schema for a pair of tables to replace the existing project-info.xml system and other database and XML files associated with project data. ...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

ProjectInfo Schema

The following is the schema for a pair of tables to replace the existing project-info.xml system and other database and XML files associated with project data.

There is a master table (ProjectInfo) which stores all of the keys which link into the sub-table (ProjectInfoValues). The two tables are tied together by an auto-generated sequence ProjectInfoID which is created by inserting the record into the ProjectInfo table. Having a secondary table allows for multiple values to be associated with a single key. The values table can also contain SubKeys as necessary to further classify the value.

ProjectInfo can have multiple rows for each MainKey for each ProjectID, and ProjectInfoValues can have multiple rows for each row in ProjectInfo.


ProjectInfo.png

Back to the top