Changeset 3783
- Timestamp:
- Aug 23, 2010, 11:56:45 AM (13 years ago)
- File:
-
- 1 edited
-
trunk/doc/generated_schema.html (modified) (61 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/doc/generated_schema.html
r3358 r3783 17 17 <body> 18 18 <div id="gen">(<i>Generated by misc/db2html.pl script, Do not edit this file!</i>)</div> 19 Date: <b> Fri Jul 10 14:59:46 CEST 200920 </b><br/>Schema version: <b> 7</b><br/>Build: <b>331121 </b><br/><div id="index"><div>1. <a href="#Acquisitions">Acquisitions</a><br/>2. <a href="#AnnotationSets">AnnotationSets</a><br/>3. <a href="#AnnotationTypeItems">AnnotationTypeItems</a><br/>4. <a href="#AnnotationTypeOptions">AnnotationTypeOptions</a><br/>5. <a href="#AnnotationTypes">AnnotationTypes</a><br/>6. <a href="#Annotations">Annotations</a><br/>7. <a href="#BioMaterialEventSources">BioMaterialEventSources</a><br/>8. <a href="#BioMaterialEvents">BioMaterialEvents</a><br/>9. <a href="#BioMaterialFiles">BioMaterialFiles</a><br/>10. <a href="#BioMaterials">BioMaterials</a><br/>11. <a href="#BooleanValues">BooleanValues</a><br/>12. <a href="#ClienDefaultSettings">ClienDefaultSettings</a><br/>13. <a href="#Clients">Clients</a><br/>14. <a href="#ContextSettings">ContextSettings</a><br/>15. <a href="#Contexts">Contexts</a><br/>16. <a href="#DataProcessingSteps">DataProcessingSteps</a><br/>17. <a href="#DateValues">DateValues</a><br/>18. <a href="#DigestParameters">DigestParameters</a><br/>19. <a href="#Directories">Directories</a><br/>20. <a href="#DiskUsage">DiskUsage</a><br/> 21. <a href="#DoubleValues">DoubleValues</a><br/></div><div>22. <a href="#Experiments">Experiments</a><br/>23. <a href="#FileMaps">FileMaps</a><br/>24. <a href="#FileTypes">FileTypes</a><br/>25. <a href="#FileValues">FileValues</a><br/>26. <a href="#Files">Files</a><br/>27. <a href="#FloatValues">FloatValues</a><br/>28. <a href="#GlobalDefaultSettings">GlobalDefaultSettings</a><br/>29. <a href="#GroupGroups">GroupGroups</a><br/>30. <a href="#GroupKeys">GroupKeys</a><br/>31. <a href="#GroupProjects">GroupProjects</a><br/>32. <a href="#Groups">Groups</a><br/>33. <a href="#Hardware">Hardware</a><br/>34. <a href="#HardwareTypes">HardwareTypes</a><br/>35. <a href="#Hits">Hits</a><br/>36. <a href="#InheritedAnnotationSets">InheritedAnnotationSets</a><br/>37. <a href="#InheritedAnnotations">InheritedAnnotations</a><br/>38. <a href="#InputPeakListSets">InputPeakListSets</a><br/>39. <a href="#InputPeakLists">InputPeakLists</a><br/>40. <a href="#InputSpectra">InputSpectra</a><br/>41. <a href="#InstrumentConfigurations">InstrumentConfigurations</a><br/>42. <a href="#IntegerValues">IntegerValues</a><br/></div><div>43. <a href="#ItemValues">ItemValues</a><br/>44. <a href="#JobParameters">JobParameters</a><br/>45. <a href="#Jobs">Jobs</a><br/>46. <a href="#Keys">Keys</a><br/>47. <a href="#Labels">Labels</a><br/>48. <a href="#LongValues">LongValues</a><br/>49. <a href="#MascotParameterSetStorage">MascotParameterSetStorage</a><br/>50. <a href="#Messages">Messages</a><br/>51. <a href="#MimeTypes">MimeTypes</a><br/>52. <a href="#Modifications">Modifications</a><br/>53. <a href="#News">News</a><br/>54. <a href="#OMSSAParameterSetStorage">OMSSAParameterSetStorage</a><br/>55. <a href="#ParameterValues">ParameterValues</a><br/>56. <a href="#Passwords">Passwords</a><br/>57. <a href="#PeakListSets">PeakListSets</a><br/>58. <a href="#PeakLists">PeakLists</a><br/>59. <a href="#Peaks">Peaks</a><br/>60. <a href="#PlateEventTypes">PlateEventTypes</a><br/>61. <a href="#PlateEvents">PlateEvents</a><br/>62. <a href="#PlateGeometries">PlateGeometries</a><br/>63. <a href="#PlateMappings">PlateMappings</a><br/></div><div>64. <a href="#PlateParents">PlateParents</a><br/>65. <a href="#PlateTypes">PlateTypes</a><br/>66. <a href="#Plates">Plates</a><br/>67. <a href="#PluginConfigurationValues">PluginConfigurationValues</a><br/>68. <a href="#PluginConfigurations">PluginConfigurations</a><br/>69. <a href="#PluginDefinitionGuiContexts">PluginDefinitionGuiContexts</a><br/>70. <a href="#PluginDefinitionTypes">PluginDefinitionTypes</a><br/>71. <a href="#PluginDefinitions">PluginDefinitions</a><br/>72. <a href="#PluginTypes">PluginTypes</a><br/>73. <a href="#PolyPeptides">PolyPeptides</a><br/>74. <a href="#Precursors">Precursors</a><br/>75. <a href="#ProjectKeys">ProjectKeys</a><br/>76. <a href="#Projects">Projects</a><br/>77. <a href="#PropertyFilters">PropertyFilters</a><br/>78. <a href="#ProtocolTypes">ProtocolTypes</a><br/>79. <a href="#Protocols">Protocols</a><br/>80. <a href="#Quota">Quota</a><br/>81. <a href="#QuotaTypes">QuotaTypes</a><br/>82. <a href="#QuotaValues">QuotaValues</a><br/>83. <a href="#ReferencedResults">ReferencedResults</a><br/>84. <a href="#RoleKeys">RoleKeys</a><br/></div><div>85. <a href="#Roles">Roles</a><br/>86. <a href="#SchemaVersion">SchemaVersion</a><br/>87. <a href="#SearchDatabases">SearchDatabases</a><br/>88. <a href="#SearchResults">SearchResults</a><br/>89. <a href="#SeparationMethods">SeparationMethods</a><br/>90. <a href="#Sessions">Sessions</a><br/>91. <a href="#Software">Software</a><br/>92. <a href="#SoftwareTypes">SoftwareTypes</a><br/>93. <a href="#SpectrumSearches">SpectrumSearches</a><br/>94. <a href="#StringValues">StringValues</a><br/>95. <a href="#TextValues">TextValues</a><br/>96. <a href="#UserClientSettings">UserClientSettings</a><br/>97. <a href="#UserDefaultSettings">UserDefaultSettings</a><br/>98. <a href="#UserGroups">UserGroups</a><br/>99. <a href="#UserKeys">UserKeys</a><br/>100. <a href="#UserProjects">UserProjects</a><br/>101. <a href="#UserRoles">UserRoles</a><br/>102. <a href="#Users">Users</a><br/>103. <a href="#Wells">Wells</a><br/>104. <a href="#XTandemParameterSetStorage">XTandemParameterSetStorage</a><br/></div></div><br clear="all"/><a name="Acquisitions"></a><h2>Acquisitions</h2>19 Date: <b>Mon Aug 23 11:56:29 CEST 2010 20 </b><br/>Schema version: <b>10</b><br/>Build: <b>3676 21 </b><br/><div id="index"><div>1. <a href="#Acquisitions">Acquisitions</a><br/>2. <a href="#AnnotationSets">AnnotationSets</a><br/>3. <a href="#AnnotationTypeItems">AnnotationTypeItems</a><br/>4. <a href="#AnnotationTypeOptions">AnnotationTypeOptions</a><br/>5. <a href="#AnnotationTypes">AnnotationTypes</a><br/>6. <a href="#Annotations">Annotations</a><br/>7. <a href="#BioMaterialEventSources">BioMaterialEventSources</a><br/>8. <a href="#BioMaterialEvents">BioMaterialEvents</a><br/>9. <a href="#BioMaterialFiles">BioMaterialFiles</a><br/>10. <a href="#BioMaterials">BioMaterials</a><br/>11. <a href="#BooleanValues">BooleanValues</a><br/>12. <a href="#ClienDefaultSettings">ClienDefaultSettings</a><br/>13. <a href="#Clients">Clients</a><br/>14. <a href="#ContextSettings">ContextSettings</a><br/>15. <a href="#Contexts">Contexts</a><br/>16. <a href="#DataProcessingSteps">DataProcessingSteps</a><br/>17. <a href="#DateValues">DateValues</a><br/>18. <a href="#DigestParameters">DigestParameters</a><br/>19. <a href="#Directories">Directories</a><br/>20. <a href="#DiskUsage">DiskUsage</a><br/></div><div>21. <a href="#DoubleValues">DoubleValues</a><br/>22. <a href="#Experiments">Experiments</a><br/>23. <a href="#Features">Features</a><br/>24. <a href="#FileMaps">FileMaps</a><br/>25. <a href="#FileTypes">FileTypes</a><br/>26. <a href="#FileValues">FileValues</a><br/>27. <a href="#Files">Files</a><br/>28. <a href="#FloatValues">FloatValues</a><br/>29. <a href="#GlobalDefaultSettings">GlobalDefaultSettings</a><br/>30. <a href="#GroupGroups">GroupGroups</a><br/>31. <a href="#GroupKeys">GroupKeys</a><br/>32. <a href="#GroupProjects">GroupProjects</a><br/>33. <a href="#Groups">Groups</a><br/>34. <a href="#Hardware">Hardware</a><br/>35. <a href="#HardwareTypes">HardwareTypes</a><br/>36. <a href="#Hits">Hits</a><br/>37. <a href="#InheritedAnnotationSets">InheritedAnnotationSets</a><br/>38. <a href="#InheritedAnnotations">InheritedAnnotations</a><br/>39. <a href="#InputPeakListSets">InputPeakListSets</a><br/>40. <a href="#InputPeakLists">InputPeakLists</a><br/></div><div>41. <a href="#InputSpectra">InputSpectra</a><br/>42. <a href="#InstrumentConfigurations">InstrumentConfigurations</a><br/>43. <a href="#IntegerValues">IntegerValues</a><br/>44. <a href="#ItemValues">ItemValues</a><br/>45. <a href="#JobParameters">JobParameters</a><br/>46. <a href="#Jobs">Jobs</a><br/>47. <a href="#Keys">Keys</a><br/>48. <a href="#Labels">Labels</a><br/>49. <a href="#LongValues">LongValues</a><br/>50. <a href="#MascotParameterSetStorage">MascotParameterSetStorage</a><br/>51. <a href="#Messages">Messages</a><br/>52. <a href="#MimeTypes">MimeTypes</a><br/>53. <a href="#Modifications">Modifications</a><br/>54. <a href="#News">News</a><br/>55. <a href="#OMSSAParameterSetStorage">OMSSAParameterSetStorage</a><br/>56. <a href="#ParameterValues">ParameterValues</a><br/>57. <a href="#Passwords">Passwords</a><br/>58. <a href="#PeakListSets">PeakListSets</a><br/>59. <a href="#PeakLists">PeakLists</a><br/>60. <a href="#Peaks">Peaks</a><br/></div><div>61. <a href="#PlateEventTypes">PlateEventTypes</a><br/>62. <a href="#PlateEvents">PlateEvents</a><br/>63. <a href="#PlateGeometries">PlateGeometries</a><br/>64. <a href="#PlateMappings">PlateMappings</a><br/>65. <a href="#PlateParents">PlateParents</a><br/>66. <a href="#PlateTypes">PlateTypes</a><br/>67. <a href="#Plates">Plates</a><br/>68. <a href="#PluginConfigurationValues">PluginConfigurationValues</a><br/>69. <a href="#PluginConfigurations">PluginConfigurations</a><br/>70. <a href="#PluginDefinitionGuiContexts">PluginDefinitionGuiContexts</a><br/>71. <a href="#PluginDefinitionTypes">PluginDefinitionTypes</a><br/>72. <a href="#PluginDefinitions">PluginDefinitions</a><br/>73. <a href="#PluginTypes">PluginTypes</a><br/>74. <a href="#PolyPeptides">PolyPeptides</a><br/>75. <a href="#Precursors">Precursors</a><br/>76. <a href="#ProjectKeys">ProjectKeys</a><br/>77. <a href="#Projects">Projects</a><br/>78. <a href="#PropertyFilters">PropertyFilters</a><br/>79. <a href="#ProtocolTypes">ProtocolTypes</a><br/>80. <a href="#Protocols">Protocols</a><br/></div><div>81. <a href="#Quota">Quota</a><br/>82. <a href="#QuotaTypes">QuotaTypes</a><br/>83. <a href="#QuotaValues">QuotaValues</a><br/>84. <a href="#ReferencedResults">ReferencedResults</a><br/>85. <a href="#RoleKeys">RoleKeys</a><br/>86. <a href="#Roles">Roles</a><br/>87. <a href="#SchemaVersion">SchemaVersion</a><br/>88. <a href="#SearchDatabases">SearchDatabases</a><br/>89. <a href="#SearchResults">SearchResults</a><br/>90. <a href="#SeparationMethods">SeparationMethods</a><br/>91. <a href="#Sessions">Sessions</a><br/>92. <a href="#Software">Software</a><br/>93. <a href="#SoftwareTypes">SoftwareTypes</a><br/>94. <a href="#SpectrumSearches">SpectrumSearches</a><br/>95. <a href="#StringValues">StringValues</a><br/>96. <a href="#TextValues">TextValues</a><br/>97. <a href="#UserClientSettings">UserClientSettings</a><br/>98. <a href="#UserDefaultSettings">UserDefaultSettings</a><br/>99. <a href="#UserGroups">UserGroups</a><br/>100. <a href="#UserKeys">UserKeys</a><br/></div><div>101. <a href="#UserProjects">UserProjects</a><br/>102. <a href="#UserRoles">UserRoles</a><br/>103. <a href="#Users">Users</a><br/>104. <a href="#Wells">Wells</a><br/>105. <a href="#XTandemParameterSetStorage">XTandemParameterSetStorage</a><br/></div></div><br clear="all"/><a name="Acquisitions"></a><h2>Acquisitions</h2> 22 22 <table><tr><td colspan="6" class="jdoc">Class: <a href="http://www.proteios.org/htdocs/javadoc/core/org/proteios/core/data/AcquisitionData.html">org.proteios.core.data.AcquisitionData</a></td></tr><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> 23 23 <tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr> … … 27 27 <tr><td><a href="#PeakLists" title="PeakLists">peakListId</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 28 28 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 29 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>29 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 30 30 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 31 31 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 63 63 <tr><td>addedParameterValue</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 64 64 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 65 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>65 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 66 66 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 67 67 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 92 92 <tr><td>entry_date</td><td>datetime</td><td>NO</td><td></td><td></td><td></td></tr> 93 93 <tr><td>event_date</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 94 <tr><td>comment</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>94 <tr><td>comment</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 95 95 <tr><td><a href="#SeparationMethods" title="SeparationMethods">separation_method_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 96 96 <tr><td><a href="#BioMaterialEvents" title="BioMaterialEvents">previousBioMaterialEventId</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 113 113 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 114 114 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 115 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>115 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 116 116 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 117 117 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 147 147 <tr><td><a href="#Clients" title="Clients">client_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 148 148 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td></td></tr> 149 <tr><td>value</td><td> text</td><td>NO</td><td></td><td></td><td></td></tr>149 <tr><td>value</td><td>longtext</td><td>NO</td><td></td><td></td><td></td></tr> 150 150 </table><a name="Clients"></a><h2>Clients</h2> 151 151 <table><tr><td colspan="6" class="jdoc">Class: <a href="http://www.proteios.org/htdocs/javadoc/core/org/proteios/core/data/ClientData.html">org.proteios.core.data.ClientData</a></td></tr><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 154 154 <tr><td>external_id</td><td>varchar(255)</td><td>NO</td><td>UNI</td><td></td><td></td></tr> 155 155 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 156 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>156 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 157 157 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 158 158 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 162 162 <table><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> 163 163 <tr><td><a href="#Contexts" title="Contexts">context_id</a></td><td>int(11)</td><td>NO</td><td>PRI</td><td></td><td></td></tr> 164 <tr><td>value</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>164 <tr><td>value</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 165 165 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>PRI</td><td></td><td></td></tr> 166 166 </table><a name="Contexts"></a><h2>Contexts</h2> … … 206 206 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 207 207 <tr><td>specificity</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 208 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>208 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 209 209 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 210 210 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 219 219 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 220 220 <tr><td><a href="#Directories" title="Directories">parent_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 221 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>221 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 222 222 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 223 223 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 243 243 <tr><td><a href="#DiskUsage" title="DiskUsage">diskusage_id</a></td><td>int(11)</td><td>NO</td><td>UNI</td><td></td><td></td></tr> 244 244 <tr><td>bytes</td><td>bigint(20)</td><td>NO</td><td></td><td></td><td></td></tr> 245 <tr><td>authors</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>246 <tr><td>affiliations</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>247 <tr><td>abstract</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>248 <tr><td>experiment_design</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>249 <tr><td>experiment_type</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>250 <tr><td>publication</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>245 <tr><td>authors</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 246 <tr><td>affiliations</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 247 <tr><td>abstract</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 248 <tr><td>experiment_design</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 249 <tr><td>experiment_type</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 250 <tr><td>publication</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 251 251 <tr><td>pubmed_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 252 252 <tr><td>publication_date</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 253 253 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 254 <tr><td>description</td><td>text</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 255 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 256 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 257 <tr><td><a href="#Keys" title="Keys">projectkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 258 <tr><td><a href="#Users" title="Users">owner</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 254 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 255 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 256 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 257 <tr><td><a href="#Keys" title="Keys">projectkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 258 <tr><td><a href="#Users" title="Users">owner</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 259 </table><a name="Features"></a><h2>Features</h2> 260 <table><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> 261 <tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment</td></tr> 262 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 263 <tr><td><a href="#Files" title="Files">featureFile</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 264 <tr><td><a href="#Files" title="Files">msFile</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 265 <tr><td><a href="#Projects" title="Projects">project</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 266 <tr><td>apexIntensity</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 267 <tr><td>apexRetentionTimeInMinutes</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 268 <tr><td>chargeState</td><td>int(11)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 269 <tr><td>mz</td><td>double</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 270 <tr><td>startRetentionTimeInMinutes</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 271 <tr><td>endRetentionTimeInMinutes</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 272 <tr><td>integratedIntensity</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 273 <tr><td>signalToNoiseRatio</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 274 <tr><td>peptideSequence</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 275 <tr><td>featureExternalId</td><td>int(11)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 259 276 </table><a name="FileMaps"></a><h2>FileMaps</h2> 260 277 <table><tr><td colspan="6" class="jdoc">Class: <a href="http://www.proteios.org/htdocs/javadoc/core/org/proteios/core/data/FileMapData.html">org.proteios.core.data.FileMapData</a></td></tr><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 263 280 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td></td></tr> 264 281 <tr><td>createdDate</td><td>datetime</td><td>NO</td><td></td><td></td><td></td></tr> 265 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>266 <tr><td>map</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>282 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 283 <tr><td>map</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 267 284 <tr><td><a href="#Projects" title="Projects">project</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 268 285 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> … … 272 289 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 273 290 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 274 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>291 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 275 292 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 276 293 </table><a name="FileValues"></a><h2>FileValues</h2> … … 292 309 <tr><td><a href="#Directories" title="Directories">directory_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 293 310 <tr><td><a href="#FileTypes" title="FileTypes">filetype_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 311 <tr><td>compressed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 312 <tr><td>compressed_size</td><td>bigint(20)</td><td>NO</td><td></td><td></td><td></td></tr> 294 313 <tr><td>internalname</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 295 314 <tr><td>uniformResourceIdentifier</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 296 <tr><td>description</td><td>text</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 315 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 316 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 297 317 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 298 318 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 308 328 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 309 329 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>UNI</td><td></td><td></td></tr> 310 <tr><td>value</td><td> text</td><td>NO</td><td></td><td></td><td></td></tr>330 <tr><td>value</td><td>longtext</td><td>NO</td><td></td><td></td><td></td></tr> 311 331 </table><a name="GroupGroups"></a><h2>GroupGroups</h2> 312 332 <table><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 328 348 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 329 349 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 330 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>350 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 331 351 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 332 352 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> … … 339 359 <tr><td>version_string</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 340 360 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 341 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>361 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 342 362 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 343 363 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 349 369 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 350 370 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 351 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>371 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 352 372 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 353 373 </table><a name="Hits"></a><h2>Hits</h2> … … 370 390 <tr><td>protein</td><td>bit(1)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 371 391 <tr><td>externalId</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 372 <tr><td>extraString</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>373 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>392 <tr><td>extraString</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 393 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 374 394 <tr><td>coverage</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 375 395 <tr><td>mw</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> … … 391 411 <tr><td>spectrumStringId</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 392 412 <tr><td>retentionTime</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 413 <tr><td>precursorQuantity</td><td>float</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 414 <tr><td><a href="#Features" title="Features">feature</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 393 415 </table><a name="InheritedAnnotationSets"></a><h2>InheritedAnnotationSets</h2> 394 416 <table><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 413 435 <tr><td><a href="#Files" title="Files">file_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 414 436 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 415 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>437 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 416 438 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 417 439 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 427 449 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 428 450 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 429 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>451 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 430 452 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 431 453 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 455 477 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 456 478 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 457 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>479 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 458 480 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 459 481 <tr><td>type</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> … … 461 483 <tr><td><a href="#PluginConfigurations" title="PluginConfigurations">pluginconfiguration_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 462 484 <tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 463 <tr><td>status_message</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>485 <tr><td>status_message</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 464 486 <tr><td>execution_time</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 465 487 <tr><td>percent_complete</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> … … 478 500 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 479 501 <tr><td>name</td><td>varchar(255)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 480 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>502 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 481 503 <tr><td>item_type</td><td>int(11)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 482 504 </table><a name="Labels"></a><h2>Labels</h2> … … 485 507 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 486 508 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 487 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>509 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 488 510 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 489 511 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 500 522 <tr><td><a href="#Files" title="Files">parameterFile</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 501 523 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 502 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td> </td><td></td><td></td></tr>503 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>524 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 525 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 504 526 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 505 527 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 511 533 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 512 534 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 513 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>535 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 514 536 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 515 537 <tr><td><a href="#Users" title="Users">to_user_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> … … 524 546 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 525 547 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 526 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>548 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 527 549 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 528 550 <tr><td>extension</td><td>varchar(255)</td><td>NO</td><td>UNI</td><td></td><td></td></tr> … … 541 563 <tr><td>cvId</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 542 564 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 543 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>565 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 544 566 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 545 567 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 557 579 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 558 580 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 559 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>581 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 560 582 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 561 583 <tr><td>start_date</td><td>datetime</td><td>NO</td><td></td><td></td><td></td></tr> … … 569 591 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 570 592 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 571 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>593 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 572 594 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 573 595 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 596 618 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 597 619 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 598 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>620 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 599 621 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 600 622 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 638 660 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 639 661 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 640 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>662 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 641 663 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 642 664 <tr><td><a href="#PlateTypes" title="PlateTypes">platetype_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> … … 653 675 <tr><td>entry_date</td><td>datetime</td><td>NO</td><td></td><td></td><td></td></tr> 654 676 <tr><td>event_date</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 655 <tr><td>comment</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>677 <tr><td>comment</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 656 678 </table><a name="PlateGeometries"></a><h2>PlateGeometries</h2> 657 679 <table><tr><td colspan="6" class="jdoc">Class: <a href="http://www.proteios.org/htdocs/javadoc/core/org/proteios/core/data/PlateGeometryData.html">org.proteios.core.data.PlateGeometryData</a></td></tr><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 659 681 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 660 682 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 661 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>683 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 662 684 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 663 685 <tr><td>rows</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> … … 673 695 <tr><td>image</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 674 696 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 675 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>697 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 676 698 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 677 699 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 689 711 <tr><td><a href="#PlateGeometries" title="PlateGeometries">plategeometry_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 690 712 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 691 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>713 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 692 714 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 693 715 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 705 727 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 706 728 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 707 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>729 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 708 730 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 709 731 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 721 743 <tr><td><a href="#PluginDefinitions" title="PluginDefinitions">plugindefinition_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 722 744 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 723 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>745 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 724 746 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 725 747 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 741 763 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 742 764 <tr><td>class_name</td><td>varchar(255)</td><td>NO</td><td>UNI</td><td></td><td></td></tr> 743 <tr><td>jar_path</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>765 <tr><td>jar_path</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 744 766 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td></td></tr> 745 767 <tr><td>plugin_version</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 746 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>768 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 747 769 <tr><td>copyright</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 748 770 <tr><td>contact</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> … … 759 781 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 760 782 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 761 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>783 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 762 784 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 763 785 <tr><td>interface_name</td><td>varchar(255)</td><td>NO</td><td>UNI</td><td></td><td></td></tr> 764 <tr><td>jar_path</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>786 <tr><td>jar_path</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 765 787 </table><a name="PolyPeptides"></a><h2>PolyPeptides</h2> 766 788 <table><tr><td colspan="6" class="jdoc">Class: <a href="http://www.proteios.org/htdocs/javadoc/core/org/proteios/core/data/PolyPeptideData.html">org.proteios.core.data.PolyPeptideData</a></td></tr><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 769 791 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 770 792 <tr><td>accession_number</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 771 <tr><td>sequence</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>793 <tr><td>sequence</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 772 794 <tr><td>lsid</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 773 795 <tr><td><a href="#SearchResults" title="SearchResults">searchResultId</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 774 796 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 775 797 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 776 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>798 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 777 799 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 778 800 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 806 828 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 807 829 <tr><td><a href="#Directories" title="Directories">project_directory_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> 808 <tr><td><a href="#FileMaps" title="FileMaps">filemap_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>809 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr>810 <tr><td>description</td><td>text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>811 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr>812 <tr><td><a href="#Users" title="Users">owner</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr>813 830 <tr><td>project_type</td><td>int(11)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 814 <tr><td>closed</td><td>bit(1)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 831 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 832 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 833 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 834 <tr><td>closed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 835 <tr><td><a href="#Users" title="Users">owner</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 815 836 </table><a name="PropertyFilters"></a><h2>PropertyFilters</h2> 816 837 <table><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 818 839 <tr><td>operator</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 819 840 <tr><td>value_type</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 820 <tr><td>value</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>841 <tr><td>value</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 821 842 <tr><td>property</td><td>varchar(255)</td><td>NO</td><td>PRI</td><td></td><td></td></tr> 822 843 </table><a name="ProtocolTypes"></a><h2>ProtocolTypes</h2> … … 825 846 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 826 847 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 827 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>848 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 828 849 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 829 850 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> … … 835 856 <tr><td><a href="#ProtocolTypes" title="ProtocolTypes">protocoltype_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 836 857 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 837 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>858 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 838 859 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 839 860 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 847 868 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 848 869 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 849 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>870 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 850 871 </table><a name="QuotaTypes"></a><h2>QuotaTypes</h2> 851 872 <table><tr><td colspan="6" class="jdoc">Class: <a href="http://www.proteios.org/htdocs/javadoc/core/org/proteios/core/data/QuotaTypeData.html">org.proteios.core.data.QuotaTypeData</a></td></tr><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 853 874 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 854 875 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 855 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>876 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 856 877 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 857 878 <tr><td>secondary_location</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> … … 877 898 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 878 899 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 879 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>900 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 880 901 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 881 902 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> … … 897 918 <tr><td>taxonomy</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 898 919 <tr><td>version_identifier</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 899 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>920 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 900 921 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 901 922 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 916 937 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 917 938 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 918 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>939 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 919 940 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 920 941 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 948 969 <tr><td>login_time</td><td>datetime</td><td>NO</td><td></td><td></td><td></td></tr> 949 970 <tr><td>logout_time</td><td>datetime</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 950 <tr><td>login_comment</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>971 <tr><td>login_comment</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 951 972 <tr><td>impersonated</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 952 973 <tr><td><a href="#Clients" title="Clients">client_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 959 980 <tr><td>version_string</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 960 981 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 961 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>982 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 962 983 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 963 984 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 969 990 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 970 991 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 971 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>992 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 972 993 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 973 994 </table><a name="SpectrumSearches"></a><h2>SpectrumSearches</h2> … … 981 1002 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 982 1003 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 983 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>1004 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 984 1005 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 985 1006 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr> … … 995 1016 <table><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> 996 1017 <tr><td><a href="#ParameterValues" title="ParameterValues">id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 997 <tr><td>value</td><td> text</td><td>NO</td><td></td><td></td><td></td></tr>1018 <tr><td>value</td><td>longtext</td><td>NO</td><td></td><td></td><td></td></tr> 998 1019 </table><a name="UserClientSettings"></a><h2>UserClientSettings</h2> 999 1020 <table><tr><td colspan="6" class="jdoc">Class: <a href="http://www.proteios.org/htdocs/javadoc/core/org/proteios/core/data/UserClientSettingData.html">org.proteios.core.data.UserClientSettingData</a></td></tr><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 1003 1024 <tr><td><a href="#Clients" title="Clients">client_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 1004 1025 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td></td></tr> 1005 <tr><td>value</td><td> text</td><td>NO</td><td></td><td></td><td></td></tr>1026 <tr><td>value</td><td>longtext</td><td>NO</td><td></td><td></td><td></td></tr> 1006 1027 </table><a name="UserDefaultSettings"></a><h2>UserDefaultSettings</h2> 1007 1028 <table><tr><td colspan="6" class="jdoc">Class: <a href="http://www.proteios.org/htdocs/javadoc/core/org/proteios/core/data/UserDefaultSettingData.html">org.proteios.core.data.UserDefaultSettingData</a></td></tr><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 1010 1031 <tr><td><a href="#Users" title="Users">user_id</a></td><td>int(11)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 1011 1032 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td></td></tr> 1012 <tr><td>value</td><td> text</td><td>NO</td><td></td><td></td><td></td></tr>1033 <tr><td>value</td><td>longtext</td><td>NO</td><td></td><td></td><td></td></tr> 1013 1034 </table><a name="UserGroups"></a><h2>UserGroups</h2> 1014 1035 <table><tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr> … … 1034 1055 <tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr> 1035 1056 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 1036 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>1057 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 1037 1058 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 1038 1059 <tr><td>system_id</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr> … … 1067 1088 <tr><td><a href="#AnnotationSets" title="AnnotationSets">annotationset_id</a></td><td>int(11)</td><td>YES</td><td>UNI</td><td>NULL</td><td></td></tr> 1068 1089 <tr><td>name</td><td>varchar(255)</td><td>NO</td><td>MUL</td><td></td><td></td></tr> 1069 <tr><td>description</td><td> text</td><td>YES</td><td></td><td>NULL</td><td></td></tr>1090 <tr><td>description</td><td>longtext</td><td>YES</td><td></td><td>NULL</td><td></td></tr> 1070 1091 <tr><td>removed</td><td>bit(1)</td><td>NO</td><td></td><td></td><td></td></tr> 1071 1092 <tr><td><a href="#Keys" title="Keys">itemkey_id</a></td><td>int(11)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
Note: See TracChangeset
for help on using the changeset viewer.
