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_class