| 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 | ||
| 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 | longtext | 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 | MUL | 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.PolyPeptideData | |||||
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| discriminator | int(11) | NO | NULL | ||
| version | int(11) | NO | NULL | ||
| accession_number | varchar(255) | YES | NULL | ||
| sequence | longtext | YES | NULL | ||
| lsid | varchar(255) | YES | NULL | ||
| searchResultId | 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 | |
| start_position | int(11) | YES | NULL | ||
| end_position | int(11) | YES | NULL | ||
| presequence | varchar(255) | YES | NULL | ||
| postsequence | varchar(255) | 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 | |