1 Spectral database schema

spectral-database

spectral-database-schema

   by DbSchema


1 spectral-database Move the mouse over tables & columns to read the comments. Base XCMS Fk Fk_c_peak_X_s_peak_meta c_peak_X_s_peak_meta ref c_peaks ( cid ) cid Fk Fk_c_peak_X_s_peak_meta c_peak_X_s_peak_meta ref s_peak_meta ( pid ) pid Fk Fk_s_peak_meta s_peak_meta ref fileinfo ( fileid ) fileid Fk fk_s_peak_meta_source s_peak_meta ref source ( souceid -> id ) souceid Fk fk_s_peak_meta_metab_compound s_peak_meta ref metab_compound ( inchikey_id ) inchikey_id Fk Fk_s_peaks s_peaks ref s_peak_meta ( pid ) pid Fk Fk_c_peak_X_c_peak_group c_peak_X_c_peak_group ref c_peak_groups ( grpid ) grpid Fk Fk_c_peak_X_c_peak_group c_peak_X_c_peak_group ref c_peaks ( cid ) cid c_peaksTable Default.c_peaks Pk pk_c_peaks ( cid ) cidcid * integer Referred by c_peak_X_c_peak_group ( cid ) Referred by c_peak_X_s_peak_meta ( cid ) mzmz real # mzminmzmin real # mzmaxmzmax real # rtrt real # rtminrtmin real # rtmaxrtmax real # _into_into real # intfintf real # maxomaxo real # maxfmaxf real # snsn real # fileidfileid integer References fileinfo ( fileid ) sourceTable Default.source Pk pk_source ( id ) idid * integer Referred by s_peak_meta ( souceid -> id ) namename text t parsing_softwareparsing_software text t metab_compoundTable Default.metab_compound Pk pk_metab_compound ( inchikey_id ) inchikey_idinchikey_id * integer Referred by s_peak_meta ( inchikey_id ) namename text t pubchem_idpubchem_id real # chemspider_idchemspider_id real # other_namesother_names text t exact_massexact_mass real # molecular_formulamolecular_formula text t molecular_weightmolecular_weight real # compound_classcompound_class text t smilessmiles text t created_atcreated_at text t updated_atupdated_at text t c_peak_X_s_peak_metaTable Default.c_peak_X_s_peak_meta Pk pk_c_peak_X_s_peak_meta ( cXp_id ) cXp_idcXp_id * integer # pidpid integer References s_peak_meta ( pid ) cidcid integer References c_peaks ( cid ) s_peak_metaTable Default.s_peak_meta Pk pk_s_peak_meta ( pid ) pidpid * integer Referred by c_peak_X_s_peak_meta ( pid ) Referred by s_peaks ( pid ) seqNumseqNum real # acquisitionNumacquisitionNum real # precursorIntensityprecursorIntensity real # precursorScanNumprecursorScanNum real # retentionTimeretentionTime real # precursorNearestprecursorNearest real # aMzaMz real # aPurityaPurity real # apkNmapkNm real # iMziMz real # iPurityiPurity real # ipkNmipkNm real # inPkNminPkNm real # inPurityinPurity real # purity_pass_flagpurity_pass_flag text t namename text t collision_energycollision_energy text t ms_levelms_level text t accessionaccession text t resolutionresolution text t polaritypolarity text t fragmentation_typefragmentation_type text t precursor_typeprecursor_type text t instrument_typeinstrument_type text t instrumentinstrument text t copyrightcopyright text t columncolumn text t mass_accuracymass_accuracy text t mass_errormass_error text t originorigin text t splashsplash text t retention_indexretention_index text t retention_timeretention_time real # inchikey_idinchikey_id text References metab_compound ( inchikey_id ) souceidsouceid real References source ( souceid -> id ) precursor_mzprecursor_mz real # spectrum_typespectrum_type text t grpidgrpid text t fileidfileid integer References fileinfo ( fileid ) --more-- c_peak_groupsTable Default.c_peak_groups Pk pk_c_peak_groups ( grpid ) grpidgrpid * integer Referred by c_peak_X_c_peak_group ( grpid ) Referred by s_peaks ( grpid ) mzmz real # mzminmzmin real # mzmaxmzmax real # rtrt real # rtminrtmin real # rtmaxrtmax real # npeaksnpeaks real # grp_namegrp_name text t--more-- fileinfoTable Default.fileinfo Pk pk_fileinfo ( fileid ) fileidfileid * integer Referred by c_peaks ( fileid ) Referred by s_peak_meta ( fileid ) filenamefilename text t filepthfilepth text t nm_savenm_save text t classclass text t s_peaksTable Default.s_peaks Pk pk_s_peaks ( sid ) sidsid * integer # fileidfileid real # mzmz real # ii real # snrsnr real # rara real # typetype text t ra_pass_flagra_pass_flag text t snr_pass_flagsnr_pass_flag text t pass_flagpass_flag text t scanscan text t purity_pass_flagpurity_pass_flag text t intensity_pass_flagintensity_pass_flag text t clcl real # rsdrsd real # countcount real # totaltotal real # inPurityinPurity real # fracfrac real # minnum_pass_flagminnum_pass_flag text t minfrac_pass_flagminfrac_pass_flag text t grpidgrpid integer References c_peak_groups ( grpid ) pidpid integer References s_peak_meta ( pid ) c_peak_X_c_peak_groupTable Default.c_peak_X_c_peak_group Pk pk_c_peak_X_c_peak_group ( cXg_id ) cXg_idcXg_id * integer # idiidi real # bestpeakbestpeak real # grpidgrpid integer References c_peak_groups ( grpid ) cidcid integer References c_peaks ( cid )