(Generated by misc/db2html.pl script, Do not edit this file!)
Date: Fri Jul 10 14:59:46 CEST 2009
Schema version: 7
Build: 3311
1. Acquisitions
2. AnnotationSets
3. AnnotationTypeItems
4. AnnotationTypeOptions
5. AnnotationTypes
6. Annotations
7. BioMaterialEventSources
8. BioMaterialEvents
9. BioMaterialFiles
10. BioMaterials
11. BooleanValues
12. ClienDefaultSettings
13. Clients
14. ContextSettings
15. Contexts
16. DataProcessingSteps
17. DateValues
18. DigestParameters
19. Directories
20. DiskUsage
21. DoubleValues
22. Experiments
23. FileMaps
24. FileTypes
25. FileValues
26. Files
27. FloatValues
28. GlobalDefaultSettings
29. GroupGroups
30. GroupKeys
31. GroupProjects
32. Groups
33. Hardware
34. HardwareTypes
35. Hits
36. InheritedAnnotationSets
37. InheritedAnnotations
38. InputPeakListSets
39. InputPeakLists
40. InputSpectra
41. InstrumentConfigurations
42. IntegerValues
43. ItemValues
44. JobParameters
45. Jobs
46. Keys
47. Labels
48. LongValues
49. MascotParameterSetStorage
50. Messages
51. MimeTypes
52. Modifications
53. News
54. OMSSAParameterSetStorage
55. ParameterValues
56. Passwords
57. PeakListSets
58. PeakLists
59. Peaks
60. PlateEventTypes
61. PlateEvents
62. PlateGeometries
63. PlateMappings
64. PlateParents
65. PlateTypes
66. Plates
67. PluginConfigurationValues
68. PluginConfigurations
69. PluginDefinitionGuiContexts
70. PluginDefinitionTypes
71. PluginDefinitions
72. PluginTypes
73. PolyPeptides
74. Precursors
75. ProjectKeys
76. Projects
77. PropertyFilters
78. ProtocolTypes
79. Protocols
80. Quota
81. QuotaTypes
82. QuotaValues
83. ReferencedResults
84. RoleKeys
85. Roles
86. SchemaVersion
87. SearchDatabases
88. SearchResults
89. SeparationMethods
90. Sessions
91. Software
92. SoftwareTypes
93. SpectrumSearches
94. StringValues
95. TextValues
96. UserClientSettings
97. UserDefaultSettings
98. UserGroups
99. UserKeys
100. UserProjects
101. UserRoles
102. Users
103. Wells
104. XTandemParameterSetStorage

Acquisitions

Class: org.proteios.core.data.AcquisitionData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
acquisitionInstrumentInfo_idint(11)YESMULNULL
acq_numberint(11)YESNULL
peakListIdint(11)YESMULNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL
list_indexint(11)YESNULL

AnnotationSets

Class: org.proteios.core.data.AnnotationSetData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
item_typeint(11)NO

AnnotationTypeItems

FieldTypeNullKeyDefaultExtra
annotationtype_idint(11)NOMUL
item_typeint(11)YESNULL

AnnotationTypeOptions

FieldTypeNullKeyDefaultExtra
annotationtype_idint(11)NOPRI
valuevarchar(255)NO
namevarchar(255)NOPRI

AnnotationTypes

Class: org.proteios.core.data.AnnotationTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
multiplicityint(11)NO
required_for_miamebit(1)NO
is_enumerationbit(1)NO
heightint(11)NO
widthint(11)NO
default_valuevarchar(255)YESNULL
value_typeint(11)NO
enumerationvalues_idint(11)YESUNINULL
addedParameterTypevarchar(255)YESNULL
addedParameterNamevarchar(255)YESNULL
addedParameterValuevarchar(255)YESNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

Annotations

Class: org.proteios.core.data.AnnotationData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
annotationset_idint(11)NOMUL
annotationtype_idint(11)NOMUL
value_idint(11)NOUNI

BioMaterialEventSources

FieldTypeNullKeyDefaultExtra
biomaterial_idint(11)NOPRI
event_idint(11)NOPRI
used_quantityfloatYESNULL
dummyint(11)NO

BioMaterialEvents

Class: org.proteios.core.data.BioMaterialEventData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
discriminatorint(11)NO
versionint(11)NO
biomaterial_idint(11)YESMULNULL
used_quantityfloatYESNULL
user_idint(11)YESMULNULL
protocol_idint(11)YESMULNULL
entry_datedatetimeNO
event_datedatetimeYESNULL
commenttextYESNULL
separation_method_idint(11)YESMULNULL
previousBioMaterialEventIdint(11)YESMULNULL
annotated_file_idint(11)YESMULNULL
source_file_idint(11)YESMULNULL
hardware_settings_idint(11)YESMULNULL
software_settings_idint(11)YESMULNULL
stainvarchar(255)YESNULL

BioMaterialFiles

FieldTypeNullKeyDefaultExtra
biomaterial_idint(11)NOPRI
file_idint(11)NOPRI

BioMaterials

Class: org.proteios.core.data.BioMaterialData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
discriminatorint(11)NO
versionint(11)NO
external_idvarchar(255)YESNULL
storage_locationvarchar(255)YESNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL
parent_idint(11)YESMULNULL
concentrationfloatYESNULL
original_quantityfloatYESNULL
remaining_quantityfloatYESNULL
pooledbit(1)YESNULL
creationEventIdint(11)YESMULNULL
label_idint(11)YESMULNULL
intensityint(11)YESNULL
local_backgroundfloatYESNULL
normalized_volumefloatYESNULL
normalizedbit(1)YESNULL
pixel_radiusint(11)YESNULL
pixel_x_coordint(11)YESNULL
pixel_y_coordint(11)YESNULL
volumefloatYESNULL
apparent_massfloatYESNULL
laneint(11)YESNULL
apparent_pifloatYESNULL
lane_indexint(11)YESNULL

BooleanValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valuebit(1)NO

ClienDefaultSettings

Class: org.proteios.core.data.ClientDefaultSettingData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
client_idint(11)NOMUL
namevarchar(255)NO
valuetextNO

Clients

Class: org.proteios.core.data.ClientData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
external_idvarchar(255)NOUNI
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

ContextSettings

FieldTypeNullKeyDefaultExtra
context_idint(11)NOPRI
valuetextYESNULL
namevarchar(255)NOPRI

Contexts

Class: org.proteios.core.data.ContextData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
user_idint(11)NOMUL
client_idint(11)NOMUL
namevarchar(255)NO
item_typeint(11)NO
subcontextvarchar(255)NO
is_publicbit(1)YESNULL
rows_per_pageint(11)YESNULL
pageint(11)YESNULL
sort_propertyvarchar(255)YESNULL
sort_directionint(11)YESNULL
includeint(11)YESNULL

DataProcessingSteps

FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
completion_timedatetimeYESNULL
descriptionvarchar(255)YESNULL
software_idint(11)YESMULNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL
peakListSetIdint(11)YESMULNULL
list_indexint(11)YESNULL

DateValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valuedatetimeNO

DigestParameters

Class: org.proteios.core.data.DigestParameterData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
spectrumSearchIdint(11)YESMULNULL
missedCleavagesint(11)YESNULL
namevarchar(255)NOMUL
specificityvarchar(255)YESNULL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

Directories

Class: org.proteios.core.data.DirectoryData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
createddatetimeNO
namevarchar(255)NOMUL
system_idvarchar(255)YESNULL
parent_idint(11)YESMULNULL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

DiskUsage

Class: org.proteios.core.data.DiskUsageData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
locationint(11)NO
bytesbigint(20)NO
quotatype_idint(11)NOMUL
group_idint(11)YESMULNULL
user_idint(11)NOMUL

DoubleValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valuedoubleNO

Experiments

Class: org.proteios.core.data.ExperimentData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
diskusage_idint(11)NOUNI
bytesbigint(20)NO
authorstextYESNULL
affiliationstextYESNULL
abstracttextYESNULL
experiment_designtextYESNULL
experiment_typetextYESNULL
publicationtextYESNULL
pubmed_idvarchar(255)YESNULL
publication_datedatetimeYESNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

FileMaps

Class: org.proteios.core.data.FileMapData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NO
createdDatedatetimeNO
descriptiontextYESNULL
maptextYESNULL
projectint(11)NOMUL
removedbit(1)NO

FileTypes

Class: org.proteios.core.data.FileTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
system_idvarchar(255)YESNULL

FileValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valueint(11)NOMUL

Files

Class: org.proteios.core.data.FileData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
createddatetimeNO
namevarchar(255)NOMUL
diskusage_idint(11)NOUNI
sizebigint(20)NO
md5varchar(32)YESNULL
actionint(11)NO
locationint(11)NO
mimetypevarchar(255)YESNULL
directory_idint(11)NOMUL
filetype_idint(11)YESMULNULL
internalnamevarchar(255)YESNULL
uniformResourceIdentifiervarchar(255)YESNULL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

FloatValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valuefloatNO

GlobalDefaultSettings

Class: org.proteios.core.data.GlobalDefaultSettingData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOUNI
valuetextNO

GroupGroups

FieldTypeNullKeyDefaultExtra
parent_idint(11)NOPRI
child_idint(11)NOPRI

GroupKeys

FieldTypeNullKeyDefaultExtra
group_idint(11)NOPRI
key_idint(11)NOPRI
permissionint(11)NO

GroupProjects

FieldTypeNullKeyDefaultExtra
group_idint(11)NOPRI
project_idint(11)NOPRI
permissionint(11)NO

Groups

Class: org.proteios.core.data.GroupData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
system_idvarchar(255)YESNULL
quota_idint(11)YESMULNULL

Hardware

Class: org.proteios.core.data.HardwareData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
hardwaretype_idint(11)NOMUL
version_stringvarchar(255)YESNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

HardwareTypes

Class: org.proteios.core.data.HardwareTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
system_idvarchar(255)YESNULL

Hits

Class: org.proteios.core.data.HitData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
gelExternalIdvarchar(32)YESNULL
spotIdint(11)YESNULL
spectrumIdint(11)YESNULL
deltaMassfloatYESNULL
plateIdvarchar(32)YESNULL
wellPositionvarchar(8)YESNULL
localSampleIdvarchar(32)YESNULL
fractionIdvarchar(8)YESNULL
microPlatebit(1)YESNULL
searchDatedatetimeYESNULL
eValuefloatYESNULL
scorefloatYESNULL
scoreTypevarchar(32)YESNULL
proteinbit(1)YESNULL
externalIdvarchar(255)YESNULL
extraStringtextYESNULL
descriptiontextYESNULL
coveragefloatYESNULL
mwfloatYESNULL
pifloatYESNULL
matchedPeaksint(11)YESNULL
totalPeaksint(11)YESNULL
RMSErrorfloatYESNULL
totalIntensitydoubleYESNULL
experimentalMassfloatYESNULL
chargeint(11)YESNULL
projectint(11)NOMUL
peakListFileint(11)YESMULNULL
identificationResultFileint(11)YESMULNULL
spotXPixelfloatYESNULL
spotYPixelfloatYESNULL
combinedFDRfloatYESNULL
primaryCombinedbit(1)YESNULL
firstHitInCombinationint(11)YESMULNULL
spectrumStringIdvarchar(255)YESNULL
retentionTimefloatYESNULL

InheritedAnnotationSets

FieldTypeNullKeyDefaultExtra
annotationset_idint(11)NOPRI
inherited_idint(11)NOPRI

InheritedAnnotations

FieldTypeNullKeyDefaultExtra
annotation_idint(11)NOPRI
annotationset_idint(11)NOPRI

InputPeakListSets

FieldTypeNullKeyDefaultExtra
inputSpectra_idint(11)NOPRI
peaklistset_idint(11)NOPRI

InputPeakLists

FieldTypeNullKeyDefaultExtra
inputSpectra_idint(11)NOPRI
peaklist_idint(11)NOPRI

InputSpectra

Class: org.proteios.core.data.InputSpectraData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
file_idint(11)YESMULNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

InstrumentConfigurations

Class: org.proteios.core.data.InstrumentConfigurationData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
discriminatorint(11)NO
versionint(11)NO
date_timevarchar(255)YESNULL
protocolint(11)YESMULNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL
software_idint(11)YESMULNULL
hardware_idint(11)YESMULNULL
peakListSetIdint(11)YESMULNULL
list_indexint(11)YESNULL

IntegerValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valueint(11)NO

ItemValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
data_classvarchar(255)NO
data_class_idint(11)NO

JobParameters

FieldTypeNullKeyDefaultExtra
job_idint(11)NOPRI
value_idint(11)NOMUL
namevarchar(255)NOPRI

Jobs

Class: org.proteios.core.data.JobData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
typeint(11)NO
plugindefinition_idint(11)YESMULNULL
pluginconfiguration_idint(11)YESMULNULL
statusint(11)NO
status_messagetextYESNULL
execution_timeint(11)NO
percent_completeint(11)NO
priorityint(11)NO
project_idint(11)NO
blockerjob_idint(11)YESMULNULL
createddatetimeNO
starteddatetimeYESNULL
endeddatetimeYESNULL
servervarchar(255)YESNULL
ownerint(11)NOMUL

Keys

Class: org.proteios.core.data.KeyData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
discriminatorint(11)NO
versionint(11)NO
namevarchar(255)YESMULNULL
descriptiontextYESNULL
item_typeint(11)YESNULL

Labels

Class: org.proteios.core.data.LabelData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

LongValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valuebigint(20)NO

MascotParameterSetStorage

FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
parameterFileint(11)YESMULNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NO
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

Messages

Class: org.proteios.core.data.MessageData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
to_user_idint(11)NOMUL
from_namevarchar(255)NO
from_user_idint(11)YESNULL
time_sentdatetimeNO
job_idint(11)YESMULNULL
is_readbit(1)NO

MimeTypes

Class: org.proteios.core.data.MimeTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
extensionvarchar(255)NOUNI

Modifications

Class: org.proteios.core.data.ModificationData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
discriminatorint(11)NO
versionint(11)NO
substitutionModificationbit(1)YESNULL
positionint(11)YESNULL
averageMassfloatYESNULL
averageDeltaMassfloatYESNULL
monoisotopicMassdoubleYESNULL
monoisotopicDeltaMassdoubleYESNULL
diffFormulavarchar(255)YESNULL
cvIdvarchar(255)YESNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL
spectrumSearchIdint(11)YESMULNULL
aaSpecificityvarchar(255)YESNULL
terminalSpecificityint(11)YESNULL
fixedbit(1)YESNULL
modifiedAminoAcidchar(1)YESNULL
polypeptideIdint(11)YESMULNULL

News

Class: org.proteios.core.data.NewsData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
start_datedatetimeNO
news_datedatetimeNO
end_datedatetimeYESNULL

OMSSAParameterSetStorage

Class: org.proteios.core.data.OMSSAParameterSetStorageData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
parameterFileint(11)YESMULNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

ParameterValues

Class: org.proteios.core.data.ParameterValueData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
discriminatorint(11)NO
versionint(11)NO

Passwords

Class: org.proteios.core.data.PasswordData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
md5passwordvarchar(32)NO

PeakListSets

Class: org.proteios.core.data.PeakListSetData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
sample_idint(11)YESMULNULL
otherInstrumentInfo_idint(11)YESMULNULL
detector_idint(11)YESMULNULL
instrument_idint(11)YESMULNULL
ionisationSource_idint(11)YESMULNULL
sourcefile_idint(11)YESMULNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

PeakLists

Class: org.proteios.core.data.PeakListData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
peakListSetIdint(11)YESMULNULL
combination_methodvarchar(255)YESNULL
descriptionvarchar(255)YESNULL
mz_double_precisionbit(1)NO
int_double_precisionbit(1)NO
monoisotopicbit(1)NO
mslevelint(11)NO
total_intensityfloatYESNULL
base_peak_intensityfloatYESNULL
mzrange_startfloatYESNULL
mzrange_stopfloatYESNULL
spectrumidint(11)NO
spectrumInstrument_idint(11)YESMULNULL
time_in_minutesfloatYESNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

Peaks

Class: org.proteios.core.data.PeakData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
mass_to_charge_ratiodoubleYESNULL
intensitydoubleYESNULL
peakListIdint(11)YESMULNULL
annotationset_idint(11)YESUNINULL

PlateEventTypes

Class: org.proteios.core.data.PlateEventTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
platetype_idint(11)NOMUL
ordinalint(11)NO
protocoltype_idint(11)YESMULNULL

PlateEvents

Class: org.proteios.core.data.PlateEventData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
plate_idint(11)NOMUL
plateeventtype_idint(11)NOMUL
protocol_idint(11)YESMULNULL
user_idint(11)YESMULNULL
entry_datedatetimeNO
event_datedatetimeYESNULL
commenttextYESNULL

PlateGeometries

Class: org.proteios.core.data.PlateGeometryData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
rowsint(11)NO
columnsint(11)NO

PlateMappings

Class: org.proteios.core.data.PlateMappingData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
sourcegeometry_idint(11)NOMUL
destinationgeometry_idint(11)NOMUL
source_countint(11)NO
destination_countint(11)NO
imagevarchar(255)YESNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

PlateParents

FieldTypeNullKeyDefaultExtra
plate_idint(11)NOPRI
source_indexint(11)YESNULL
parent_idint(11)NOPRI

PlateTypes

Class: org.proteios.core.data.PlateTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
plategeometry_idint(11)NOMUL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

Plates

Class: org.proteios.core.data.PlateData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
platetype_idint(11)NOMUL
barcodevarchar(255)YESNULL
destroyedbit(1)NO
platemapping_idint(11)YESMULNULL
destination_indexint(11)NO
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

PluginConfigurationValues

FieldTypeNullKeyDefaultExtra
pluginconfiguration_idint(11)NOPRI
value_idint(11)NOMUL
namevarchar(255)NOPRI

PluginConfigurations

Class: org.proteios.core.data.PluginConfigurationData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
plugindefinition_idint(11)NOMUL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

PluginDefinitionGuiContexts

FieldTypeNullKeyDefaultExtra
plugindefinition_idint(11)NOMUL
item_typeint(11)YESNULL
context_typeint(11)YESNULL

PluginDefinitionTypes

FieldTypeNullKeyDefaultExtra
plugindefinition_idint(11)NOPRI
plugintype_idint(11)NOPRI

PluginDefinitions

Class: org.proteios.core.data.PluginDefinitionData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
removedbit(1)NO
class_namevarchar(255)NOUNI
jar_pathtextYESNULL
namevarchar(255)NO
plugin_versionvarchar(255)YESNULL
descriptiontextYESNULL
copyrightvarchar(255)YESNULL
contactvarchar(255)YESNULL
emailvarchar(255)YESNULL
urlvarchar(255)YESNULL
typeint(11)NO
interactivebit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

PluginTypes

Class: org.proteios.core.data.PluginTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
interface_namevarchar(255)NOUNI
jar_pathtextYESNULL

PolyPeptides

Class: org.proteios.core.data.PolyPeptideData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
discriminatorint(11)NO
versionint(11)NO
accession_numbervarchar(255)YESNULL
sequencetextYESNULL
lsidvarchar(255)YESNULL
searchResultIdint(11)YESMULNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL
start_positionint(11)YESNULL
end_positionint(11)YESNULL
presequencevarchar(255)YESNULL
postsequencevarchar(255)YESNULL

Precursors

Class: org.proteios.core.data.PrecursorData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
activation_idint(11)YESMULNULL
chargeStateint(11)NO
ionSelection_idint(11)YESMULNULL
mass_to_charge_ratiofloatYESNULL
intensityfloatYESNULL
mslevelint(11)NO
spectrum_refint(11)YESNULL
peakListIdint(11)YESMULNULL
list_indexint(11)YESNULL

ProjectKeys

FieldTypeNullKeyDefaultExtra
project_idint(11)NOPRI
key_idint(11)NOPRI
permissionint(11)NO

Projects

Class: org.proteios.core.data.ProjectData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
project_directory_idint(11)YESMULNULL
filemap_idint(11)YESMULNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
ownerint(11)NOMUL
project_typeint(11)YESNULL
closedbit(1)YESNULL

PropertyFilters

FieldTypeNullKeyDefaultExtra
context_idint(11)NOPRI
operatorint(11)NO
value_typeint(11)NO
valuetextYESNULL
propertyvarchar(255)NOPRI

ProtocolTypes

Class: org.proteios.core.data.ProtocolTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
system_idvarchar(255)YESNULL

Protocols

Class: org.proteios.core.data.ProtocolData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
file_idint(11)YESMULNULL
protocoltype_idint(11)NOMUL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

Quota

Class: org.proteios.core.data.QuotaData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
removedbit(1)NO
system_idvarchar(255)YESNULL
namevarchar(255)NOMUL
descriptiontextYESNULL

QuotaTypes

Class: org.proteios.core.data.QuotaTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
system_idvarchar(255)YESNULL
secondary_locationbit(1)NO

QuotaValues

FieldTypeNullKeyDefaultExtra
quota_idint(11)NOPRI
max_bytesbigint(20)NO
locationint(11)NOPRI
quotaType_idint(11)NOPRI

ReferencedResults

FieldTypeNullKeyDefaultExtra
idint(11)NOPRI
resref_idint(11)NOMUL
indexint(11)NOPRI

RoleKeys

FieldTypeNullKeyDefaultExtra
role_idint(11)NOPRI
key_idint(11)NOPRI
permissionint(11)NO

Roles

Class: org.proteios.core.data.RoleData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
system_idvarchar(255)YESNULL

SchemaVersion

Class: org.proteios.core.data.SchemaVersionData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
schema_versionint(11)NO
buildint(11)NO

SearchDatabases

FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
spectrumSearchIdint(11)YESMULNULL
namevarchar(255)NOMUL
number_of_entriesint(11)YESNULL
number_of_entries_after_taxonomyint(11)YESNULL
number_of_residuesint(11)YESNULL
taxonomyvarchar(255)YESNULL
version_identifiervarchar(255)YESNULL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

SearchResults

Class: org.proteios.core.data.SearchResultData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
indexint(11)YESNULL
inputSpectrumIdint(11)YESNULL
e_valuefloatYESNULL
scorefloatYESNULL
score_typevarchar(255)YESNULL
peaklist_idint(11)YESMULNULL
spectrumSearchIdint(11)YESMULNULL
spectrumStringIdvarchar(255)YESNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

SeparationMethods

Class: org.proteios.core.data.SeparationMethodData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
discriminatorint(11)NO
versionint(11)NO
external_idvarchar(255)NOUNI
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL
lengthint(11)YESNULL
piStartint(11)YESNULL
piEndint(11)YESNULL
denaturatingAgentvarchar(255)YESNULL
massStartint(11)YESNULL
massEndint(11)YESNULL
percentAcrylamideint(11)YESNULL
proteinAssayvarchar(255)YESNULL
sizeXint(11)YESNULL
sizeYint(11)YESNULL
solubilizationBuffervarchar(255)YESNULL

Sessions

Class: org.proteios.core.data.SessionData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
user_idint(11)NOMUL
login_timedatetimeNO
logout_timedatetimeYESNULL
login_commenttextYESNULL
impersonatedbit(1)NO
client_idint(11)YESMULNULL
remote_idvarchar(255)YESNULL

Software

Class: org.proteios.core.data.SoftwareData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
softwaretype_idint(11)NOMUL
version_stringvarchar(255)YESNULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL

SoftwareTypes

Class: org.proteios.core.data.SoftwareTypeData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
system_idvarchar(255)YESNULL

SpectrumSearches

Class: org.proteios.core.data.SpectrumSearchData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
analysis_timedatetimeYESNULL
resultFileint(11)YESMULNULL
input_spectrum_filenamevarchar(255)YESNULL
software_idint(11)YESMULNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL
inputSpectra_idint(11)YESMULNULL
peakListSetIdint(11)YESMULNULL

StringValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valuevarchar(255)NO

TextValues

FieldTypeNullKeyDefaultExtra
idint(11)NOMUL
valuetextNO

UserClientSettings

Class: org.proteios.core.data.UserClientSettingData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
user_idint(11)NOMUL
client_idint(11)NOMUL
namevarchar(255)NO
valuetextNO

UserDefaultSettings

Class: org.proteios.core.data.UserDefaultSettingData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
user_idint(11)NOMUL
namevarchar(255)NO
valuetextNO

UserGroups

FieldTypeNullKeyDefaultExtra
user_idint(11)NOPRI
group_idint(11)NOPRI

UserKeys

FieldTypeNullKeyDefaultExtra
user_idint(11)NOPRI
key_idint(11)NOPRI
permissionint(11)NO

UserProjects

FieldTypeNullKeyDefaultExtra
user_idint(11)NOPRI
project_idint(11)NOPRI
permissionint(11)NO

UserRoles

FieldTypeNullKeyDefaultExtra
user_idint(11)NOPRI
role_idint(11)NOPRI

Users

Class: org.proteios.core.data.UserData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRI
versionint(11)NO
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
system_idvarchar(255)YESNULL
multiuser_accountbit(1)NO
expiration_datedateYESNULL
disabledbit(1)NO
external_idvarchar(255)YESUNINULL
loginvarchar(255)NOUNI
organisationvarchar(255)YESNULL
addressvarchar(255)YESNULL
phonevarchar(255)YESNULL
faxvarchar(255)YESNULL
emailvarchar(255)YESNULL
urlvarchar(255)YESNULL
quotagroup_idint(11)YESMULNULL
quota_idint(11)NOMUL
homedirectory_idint(11)YESMULNULL

Wells

Class: org.proteios.core.data.WellData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
annotationset_idint(11)YESUNINULL
plate_idint(11)NOMUL
rowint(11)NO
columnint(11)NO
parent_idint(11)YESMULNULL

XTandemParameterSetStorage

Class: org.proteios.core.data.XTandemParameterSetStorageData
FieldTypeNullKeyDefaultExtra
idint(11)NOPRINULLauto_increment
versionint(11)NO
parameterFileint(11)YESMULNULL
annotationset_idint(11)YESUNINULL
namevarchar(255)NOMUL
descriptiontextYESNULL
removedbit(1)NO
itemkey_idint(11)YESMULNULL
projectkey_idint(11)YESMULNULL
ownerint(11)NOMUL