Class: org.proteios.core.data.AcquisitionData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
acquisitionInstrumentInfo_id | int(11) | YES | MUL | NULL | |
acq_number | int(11) | YES | NULL | ||
peakListId | int(11) | YES | MUL | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL | |
list_index | int(11) | YES | NULL |
Class: org.proteios.core.data.AnnotationSetData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
item_type | int(11) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
annotationtype_id | int(11) | NO | MUL | NULL | |
item_type | int(11) | YES | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
annotationtype_id | int(11) | NO | PRI | NULL | |
value | varchar(255) | NO | NULL | ||
name | varchar(255) | NO | PRI | NULL |
Class: org.proteios.core.data.AnnotationTypeData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
multiplicity | int(11) | NO | NULL | ||
required_for_miame | bit(1) | NO | NULL | ||
is_enumeration | bit(1) | NO | NULL | ||
height | int(11) | NO | NULL | ||
width | int(11) | NO | NULL | ||
default_value | varchar(255) | YES | NULL | ||
value_type | int(11) | NO | NULL | ||
enumerationvalues_id | int(11) | YES | UNI | NULL | |
addedParameterType | varchar(255) | YES | NULL | ||
addedParameterName | varchar(255) | YES | NULL | ||
addedParameterValue | varchar(255) | YES | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.AnnotationData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
annotationset_id | int(11) | NO | MUL | NULL | |
annotationtype_id | int(11) | NO | MUL | NULL | |
value_id | int(11) | NO | UNI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
biomaterial_id | int(11) | NO | PRI | NULL | |
event_id | int(11) | NO | PRI | NULL | |
used_quantity | float | YES | NULL | ||
dummy | int(11) | NO | NULL |
Class: org.proteios.core.data.BioMaterialEventData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
discriminator | int(11) | NO | NULL | ||
version | int(11) | NO | NULL | ||
biomaterial_id | int(11) | YES | MUL | NULL | |
used_quantity | float | YES | NULL | ||
user_id | int(11) | YES | MUL | NULL | |
protocol_id | int(11) | YES | MUL | NULL | |
entry_date | datetime | NO | NULL | ||
event_date | datetime | YES | NULL | ||
comment | longtext | YES | NULL | ||
separation_method_id | int(11) | YES | MUL | NULL | |
previousBioMaterialEventId | int(11) | YES | MUL | NULL | |
annotated_file_id | int(11) | YES | MUL | NULL | |
source_file_id | int(11) | YES | MUL | NULL | |
hardware_settings_id | int(11) | YES | MUL | NULL | |
software_settings_id | int(11) | YES | MUL | NULL | |
stain | varchar(255) | YES | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
biomaterial_id | int(11) | NO | PRI | NULL | |
file_id | int(11) | NO | PRI | NULL |
Class: org.proteios.core.data.BioMaterialData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
discriminator | int(11) | NO | NULL | ||
version | int(11) | NO | NULL | ||
external_id | varchar(255) | YES | NULL | ||
storage_location | varchar(255) | YES | NULL | ||
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL | |
parent_id | int(11) | YES | MUL | NULL | |
concentration | float | YES | NULL | ||
original_quantity | float | YES | NULL | ||
remaining_quantity | float | YES | NULL | ||
pooled | bit(1) | YES | NULL | ||
creationEventId | int(11) | YES | MUL | NULL | |
label_id | int(11) | YES | MUL | NULL | |
intensity | int(11) | YES | NULL | ||
local_background | float | YES | NULL | ||
normalized_volume | float | YES | NULL | ||
normalized | bit(1) | YES | NULL | ||
pixel_radius | int(11) | YES | NULL | ||
pixel_x_coord | int(11) | YES | NULL | ||
pixel_y_coord | int(11) | YES | NULL | ||
volume | float | YES | NULL | ||
apparent_mass | float | YES | NULL | ||
lane | int(11) | YES | NULL | ||
apparent_pi | float | YES | NULL | ||
lane_index | int(11) | YES | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | bit(1) | NO | NULL |
Class: org.proteios.core.data.ClientDefaultSettingData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
client_id | int(11) | NO | MUL | NULL | |
name | varchar(255) | NO | NULL | ||
value | longtext | NO | NULL |
Class: org.proteios.core.data.ClientData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
external_id | varchar(255) | NO | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
completion_time | datetime | YES | NULL | ||
description | varchar(255) | YES | NULL | ||
software_id | int(11) | YES | MUL | NULL | |
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL | |
peakListSetId | int(11) | YES | MUL | NULL | |
list_index | int(11) | YES | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | datetime | NO | NULL |
Class: org.proteios.core.data.DigestParameterData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
spectrumSearchId | int(11) | YES | MUL | NULL | |
missedCleavages | int(11) | YES | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
specificity | varchar(255) | YES | NULL | ||
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.DirectoryData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
created | datetime | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
system_id | varchar(255) | YES | NULL | ||
parent_id | int(11) | YES | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.DiskUsageData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
location | int(11) | NO | NULL | ||
bytes | bigint(20) | NO | NULL | ||
quotatype_id | int(11) | NO | MUL | NULL | |
group_id | int(11) | YES | MUL | NULL | |
user_id | int(11) | NO | MUL | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | double | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
featureFile | int(11) | YES | MUL | NULL | |
msFile | int(11) | YES | MUL | NULL | |
project | int(11) | NO | MUL | NULL | |
apexIntensity | float | YES | NULL | ||
apexRetentionTimeInMinutes | float | YES | NULL | ||
chargeState | int(11) | YES | NULL | ||
mz | double | YES | NULL | ||
startRetentionTimeInMinutes | float | YES | NULL | ||
endRetentionTimeInMinutes | float | YES | NULL | ||
integratedIntensity | float | YES | NULL | ||
signalToNoiseRatio | float | YES | NULL | ||
peptideSequence | varchar(255) | YES | NULL | ||
featureExternalId | int(11) | YES | NULL | ||
clusterId | bigint(20) | YES | NULL |
Class: org.proteios.core.data.FileTypeData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
system_id | varchar(255) | YES | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.FileData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
created | datetime | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
diskusage_id | int(11) | NO | UNI | NULL | |
size | bigint(20) | NO | NULL | ||
md5 | varchar(32) | YES | NULL | ||
action | int(11) | NO | NULL | ||
location | int(11) | NO | NULL | ||
mimetype | varchar(255) | YES | NULL | ||
directory_id | int(11) | NO | MUL | NULL | |
filetype_id | int(11) | YES | MUL | NULL | |
compressed | bit(1) | NO | NULL | ||
compressed_size | bigint(20) | NO | NULL | ||
internalname | varchar(255) | YES | NULL | ||
uniformResourceIdentifier | varchar(255) | YES | NULL | ||
annotationset_id | int(11) | YES | UNI | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | float | NO | NULL |
Class: org.proteios.core.data.GlobalDefaultSettingData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | UNI | NULL | |
value | longtext | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
parent_id | int(11) | NO | PRI | NULL | |
child_id | int(11) | NO | PRI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
group_id | int(11) | NO | PRI | NULL | |
key_id | int(11) | NO | PRI | NULL | |
permission | int(11) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
group_id | int(11) | NO | PRI | NULL | |
project_id | int(11) | NO | PRI | NULL | |
permission | int(11) | NO | NULL |
Class: org.proteios.core.data.GroupData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
system_id | varchar(255) | YES | NULL | ||
quota_id | int(11) | YES | MUL | NULL |
Class: org.proteios.core.data.HardwareData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
hardwaretype_id | int(11) | NO | MUL | NULL | |
version_string | varchar(255) | YES | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.HardwareTypeData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
system_id | varchar(255) | YES | NULL |
Class: org.proteios.core.data.HitData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
gelExternalId | varchar(32) | YES | NULL | ||
spotId | int(11) | YES | NULL | ||
spectrumId | int(11) | YES | NULL | ||
deltaMass | float | YES | NULL | ||
plateId | varchar(32) | YES | NULL | ||
wellPosition | varchar(8) | YES | NULL | ||
localSampleId | varchar(32) | YES | NULL | ||
fractionId | varchar(8) | YES | NULL | ||
replicateId | varchar(16) | YES | NULL | ||
microPlate | bit(1) | YES | NULL | ||
searchDate | datetime | YES | NULL | ||
eValue | float | YES | NULL | ||
score | float | YES | NULL | ||
scoreType | varchar(32) | YES | NULL | ||
protein | bit(1) | YES | NULL | ||
externalId | varchar(255) | YES | NULL | ||
extraString | varchar(2500) | YES | NULL | ||
description | longtext | YES | NULL | ||
coverage | float | YES | NULL | ||
mw | float | YES | NULL | ||
pi | float | YES | NULL | ||
matchedPeaks | int(11) | YES | NULL | ||
totalPeaks | int(11) | YES | NULL | ||
RMSError | float | YES | NULL | ||
totalIntensity | double | YES | NULL | ||
experimentalMass | float | YES | NULL | ||
charge | int(11) | YES | NULL | ||
project | int(11) | NO | MUL | NULL | |
peakListFile | int(11) | YES | MUL | NULL | |
identificationResultFile | int(11) | YES | MUL | NULL | |
spotXPixel | float | YES | NULL | ||
spotYPixel | float | YES | NULL | ||
combinedFDR | float | YES | NULL | ||
primaryCombined | bit(1) | YES | NULL | ||
firstHitInCombination | int(11) | YES | MUL | NULL | |
spectrumStringId | varchar(255) | YES | NULL | ||
retentionTime | float | YES | NULL | ||
precursorQuantity | float | YES | NULL | ||
feature | int(11) | YES | MUL | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
annotationset_id | int(11) | NO | PRI | NULL | |
inherited_id | int(11) | NO | PRI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
annotation_id | int(11) | NO | PRI | NULL | |
annotationset_id | int(11) | NO | PRI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
inputSpectra_id | int(11) | NO | PRI | NULL | |
peaklistset_id | int(11) | NO | PRI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
inputSpectra_id | int(11) | NO | PRI | NULL | |
peaklist_id | int(11) | NO | PRI | NULL |
Class: org.proteios.core.data.InputSpectraData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
file_id | int(11) | YES | MUL | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.InstrumentConfigurationData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
discriminator | int(11) | NO | NULL | ||
version | int(11) | NO | NULL | ||
date_time | varchar(255) | YES | NULL | ||
protocol | int(11) | YES | MUL | NULL | |
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL | |
software_id | int(11) | YES | MUL | NULL | |
hardware_id | int(11) | YES | MUL | NULL | |
peakListSetId | int(11) | YES | MUL | NULL | |
list_index | int(11) | YES | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | int(11) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
data_class | varchar(255) | NO | NULL | ||
data_class_id | int(11) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
job_id | int(11) | NO | PRI | NULL | |
value_id | int(11) | NO | MUL | NULL | |
name | varchar(255) | NO | PRI | NULL |
Class: org.proteios.core.data.JobData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
type | int(11) | NO | NULL | ||
plugindefinition_id | int(11) | YES | MUL | NULL | |
pluginconfiguration_id | int(11) | YES | MUL | NULL | |
status | int(11) | NO | NULL | ||
status_message | longtext | YES | NULL | ||
execution_time | int(11) | NO | NULL | ||
percent_complete | int(11) | NO | NULL | ||
priority | int(11) | NO | NULL | ||
project_id | int(11) | NO | NULL | ||
blockerjob_id | int(11) | YES | MUL | NULL | |
created | datetime | NO | NULL | ||
started | datetime | YES | NULL | ||
ended | datetime | YES | NULL | ||
server | varchar(255) | YES | NULL | ||
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.KeyData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
discriminator | int(11) | NO | NULL | ||
version | int(11) | NO | NULL | ||
name | varchar(255) | YES | MUL | NULL | |
description | longtext | YES | NULL | ||
item_type | int(11) | YES | NULL |
Class: org.proteios.core.data.LabelData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | bigint(20) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
parameterFile | int(11) | YES | MUL | NULL | |
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.MessageData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
to_user_id | int(11) | NO | MUL | NULL | |
from_name | varchar(255) | NO | NULL | ||
from_user_id | int(11) | YES | NULL | ||
time_sent | datetime | NO | NULL | ||
job_id | int(11) | YES | MUL | NULL | |
is_read | bit(1) | NO | NULL |
Class: org.proteios.core.data.MimeTypeData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
extension | varchar(255) | NO | UNI | NULL |
Class: org.proteios.core.data.ModificationData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
discriminator | int(11) | NO | NULL | ||
version | int(11) | NO | NULL | ||
substitutionModification | bit(1) | YES | NULL | ||
position | int(11) | YES | NULL | ||
averageMass | float | YES | NULL | ||
averageDeltaMass | float | YES | NULL | ||
monoisotopicMass | double | YES | NULL | ||
monoisotopicDeltaMass | double | YES | NULL | ||
diffFormula | varchar(255) | YES | NULL | ||
cvId | varchar(255) | YES | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL | |
spectrumSearchId | int(11) | YES | MUL | NULL | |
aaSpecificity | varchar(255) | YES | NULL | ||
terminalSpecificity | int(11) | YES | NULL | ||
fixed | bit(1) | YES | NULL | ||
modifiedAminoAcid | char(1) | YES | NULL | ||
polypeptideId | int(11) | YES | NULL |
Class: org.proteios.core.data.NewsData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
start_date | datetime | NO | NULL | ||
news_date | datetime | NO | NULL | ||
end_date | datetime | YES | NULL |
Class: org.proteios.core.data.OMSSAParameterSetStorageData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
parameterFile | int(11) | YES | MUL | NULL | |
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.ParameterValueData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
discriminator | int(11) | NO | NULL | ||
version | int(11) | NO | NULL |
Class: org.proteios.core.data.PasswordData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
md5password | varchar(32) | NO | NULL |
Class: org.proteios.core.data.PeakListSetData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
sample_id | int(11) | YES | MUL | NULL | |
otherInstrumentInfo_id | int(11) | YES | MUL | NULL | |
detector_id | int(11) | YES | MUL | NULL | |
instrument_id | int(11) | YES | MUL | NULL | |
ionisationSource_id | int(11) | YES | MUL | NULL | |
sourcefile_id | int(11) | YES | MUL | NULL | |
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.PeakListData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
peakListSetId | int(11) | YES | MUL | NULL | |
combination_method | varchar(255) | YES | NULL | ||
description | varchar(255) | YES | NULL | ||
mz_double_precision | bit(1) | NO | NULL | ||
int_double_precision | bit(1) | NO | NULL | ||
monoisotopic | bit(1) | NO | NULL | ||
mslevel | int(11) | NO | NULL | ||
total_intensity | float | YES | NULL | ||
base_peak_intensity | float | YES | NULL | ||
mzrange_start | float | YES | NULL | ||
mzrange_stop | float | YES | NULL | ||
spectrumid | int(11) | NO | NULL | ||
spectrumInstrument_id | int(11) | YES | MUL | NULL | |
time_in_minutes | float | YES | NULL | ||
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.PeakData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
mass_to_charge_ratio | double | YES | NULL | ||
intensity | double | YES | NULL | ||
peakListId | int(11) | YES | MUL | NULL | |
annotationset_id | int(11) | YES | UNI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
pluginconfiguration_id | int(11) | NO | PRI | NULL | |
value_id | int(11) | NO | MUL | NULL | |
name | varchar(255) | NO | PRI | NULL |
Class: org.proteios.core.data.PluginConfigurationData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
plugindefinition_id | int(11) | NO | MUL | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
plugindefinition_id | int(11) | NO | MUL | NULL | |
item_type | int(11) | YES | NULL | ||
context_type | int(11) | YES | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
plugindefinition_id | int(11) | NO | PRI | NULL | |
plugintype_id | int(11) | NO | PRI | NULL |
Class: org.proteios.core.data.PluginDefinitionData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
removed | bit(1) | NO | NULL | ||
class_name | varchar(255) | NO | UNI | NULL | |
jar_path | longtext | YES | NULL | ||
name | varchar(255) | NO | NULL | ||
plugin_version | varchar(255) | YES | NULL | ||
description | longtext | YES | NULL | ||
copyright | varchar(255) | YES | NULL | ||
contact | varchar(255) | YES | NULL | ||
varchar(255) | YES | NULL | |||
url | varchar(255) | YES | NULL | ||
type | int(11) | NO | NULL | ||
interactive | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.PluginTypeData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
interface_name | varchar(255) | NO | UNI | NULL | |
jar_path | longtext | YES | NULL |
Class: org.proteios.core.data.PrecursorData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
activation_id | int(11) | YES | MUL | NULL | |
chargeState | int(11) | NO | NULL | ||
ionSelection_id | int(11) | YES | MUL | NULL | |
mass_to_charge_ratio | float | YES | NULL | ||
intensity | float | YES | NULL | ||
mslevel | int(11) | NO | NULL | ||
spectrum_ref | int(11) | YES | NULL | ||
peakListId | int(11) | YES | MUL | NULL | |
list_index | int(11) | YES | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
project_id | int(11) | NO | PRI | NULL | |
key_id | int(11) | NO | PRI | NULL | |
permission | int(11) | NO | NULL |
Class: org.proteios.core.data.ProjectData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
project_directory_id | int(11) | YES | MUL | NULL | |
project_type | int(11) | YES | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
closed | bit(1) | NO | NULL | ||
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.ProtocolTypeData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
system_id | varchar(255) | YES | NULL |
Class: org.proteios.core.data.ProtocolData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
file_id | int(11) | YES | MUL | NULL | |
protocoltype_id | int(11) | NO | MUL | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.QuotaData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
removed | bit(1) | NO | NULL | ||
system_id | varchar(255) | YES | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL |
Class: org.proteios.core.data.QuotaTypeData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
system_id | varchar(255) | YES | NULL | ||
secondary_location | bit(1) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
quota_id | int(11) | NO | PRI | NULL | |
max_bytes | bigint(20) | NO | NULL | ||
location | int(11) | NO | PRI | NULL | |
quotaType_id | int(11) | NO | PRI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | |
resref_id | int(11) | NO | MUL | NULL | |
index | int(11) | NO | PRI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
role_id | int(11) | NO | PRI | NULL | |
key_id | int(11) | NO | PRI | NULL | |
permission | int(11) | NO | NULL |
Class: org.proteios.core.data.RoleData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
system_id | varchar(255) | YES | NULL |
Class: org.proteios.core.data.SchemaVersionData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
schema_version | int(11) | NO | NULL | ||
build | int(11) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
spectrumSearchId | int(11) | YES | MUL | NULL | |
name | varchar(255) | NO | MUL | NULL | |
number_of_entries | int(11) | YES | NULL | ||
number_of_entries_after_taxonomy | int(11) | YES | NULL | ||
number_of_residues | bigint(20) | YES | NULL | ||
taxonomy | varchar(255) | YES | NULL | ||
version_identifier | varchar(255) | YES | NULL | ||
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.SearchResultData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
index | int(11) | YES | NULL | ||
inputSpectrumId | int(11) | YES | NULL | ||
e_value | float | YES | NULL | ||
score | float | YES | NULL | ||
score_type | varchar(255) | YES | NULL | ||
peaklist_id | int(11) | YES | MUL | NULL | |
spectrumSearchId | int(11) | YES | MUL | NULL | |
spectrumStringId | varchar(255) | YES | NULL | ||
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.SeparationMethodData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
discriminator | int(11) | NO | NULL | ||
version | int(11) | NO | NULL | ||
external_id | varchar(255) | NO | UNI | NULL | |
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL | |
length | int(11) | YES | NULL | ||
piStart | int(11) | YES | NULL | ||
piEnd | int(11) | YES | NULL | ||
denaturatingAgent | varchar(255) | YES | NULL | ||
massStart | int(11) | YES | NULL | ||
massEnd | int(11) | YES | NULL | ||
percentAcrylamide | int(11) | YES | NULL | ||
proteinAssay | varchar(255) | YES | NULL | ||
sizeX | int(11) | YES | NULL | ||
sizeY | int(11) | YES | NULL | ||
solubilizationBuffer | varchar(255) | YES | NULL |
Class: org.proteios.core.data.SessionData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
user_id | int(11) | NO | MUL | NULL | |
login_time | datetime | NO | NULL | ||
logout_time | datetime | YES | NULL | ||
login_comment | longtext | YES | NULL | ||
impersonated | bit(1) | NO | NULL | ||
client_id | int(11) | YES | MUL | NULL | |
remote_id | varchar(255) | YES | NULL |
Class: org.proteios.core.data.SoftwareData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
softwaretype_id | int(11) | NO | MUL | NULL | |
version_string | varchar(255) | YES | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |
Class: org.proteios.core.data.SoftwareTypeData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
system_id | varchar(255) | YES | NULL |
Class: org.proteios.core.data.SpectrumSearchData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
analysis_time | datetime | YES | NULL | ||
resultFile | int(11) | YES | MUL | NULL | |
input_spectrum_filename | varchar(255) | YES | NULL | ||
software_id | int(11) | YES | MUL | NULL | |
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL | |
inputSpectra_id | int(11) | YES | MUL | NULL | |
peakListSetId | int(11) | YES | MUL | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | varchar(255) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | MUL | NULL | |
value | longtext | NO | NULL |
Class: org.proteios.core.data.UserClientSettingData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
user_id | int(11) | NO | MUL | NULL | |
client_id | int(11) | NO | MUL | NULL | |
name | varchar(255) | NO | NULL | ||
value | longtext | NO | NULL |
Class: org.proteios.core.data.UserDefaultSettingData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
user_id | int(11) | NO | MUL | NULL | |
name | varchar(255) | NO | NULL | ||
value | longtext | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
user_id | int(11) | NO | PRI | NULL | |
group_id | int(11) | NO | PRI | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
user_id | int(11) | NO | PRI | NULL | |
key_id | int(11) | NO | PRI | NULL | |
permission | int(11) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
user_id | int(11) | NO | PRI | NULL | |
project_id | int(11) | NO | PRI | NULL | |
permission | int(11) | NO | NULL |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
user_id | int(11) | NO | PRI | NULL | |
role_id | int(11) | NO | PRI | NULL |
Class: org.proteios.core.data.UserData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | |
version | int(11) | NO | NULL | ||
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
system_id | varchar(255) | YES | NULL | ||
multiuser_account | bit(1) | NO | NULL | ||
expiration_date | date | YES | NULL | ||
disabled | bit(1) | NO | NULL | ||
external_id | varchar(255) | YES | UNI | NULL | |
login | varchar(255) | NO | UNI | NULL | |
organisation | varchar(255) | YES | NULL | ||
address | varchar(255) | YES | NULL | ||
phone | varchar(255) | YES | NULL | ||
fax | varchar(255) | YES | NULL | ||
varchar(255) | YES | NULL | |||
url | varchar(255) | YES | NULL | ||
quotagroup_id | int(11) | YES | MUL | NULL | |
quota_id | int(11) | NO | MUL | NULL | |
homedirectory_id | int(11) | YES | MUL | NULL |
Class: org.proteios.core.data.XTandemParameterSetStorageData | |||||
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | NULL | auto_increment |
version | int(11) | NO | NULL | ||
parameterFile | int(11) | YES | MUL | NULL | |
annotationset_id | int(11) | YES | UNI | NULL | |
name | varchar(255) | NO | MUL | NULL | |
description | longtext | YES | NULL | ||
removed | bit(1) | NO | NULL | ||
itemkey_id | int(11) | YES | MUL | NULL | |
projectkey_id | int(11) | YES | MUL | NULL | |
owner | int(11) | NO | MUL | NULL |