msPurity spectral database schema
Thomas N. Lawson
2020-03-26
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_peaks
Table Default.c_peaks
Pk pk_c_peaks ( cid )
cid
cid * integer
Referred by c_peak_X_c_peak_group ( cid ) Referred by c_peak_X_s_peak_meta ( cid )
mz
mz real
#
mzmin
mzmin real
#
mzmax
mzmax real
#
rt
rt real
#
rtmin
rtmin real
#
rtmax
rtmax real
#
_into
_into real
#
intf
intf real
#
maxo
maxo real
#
maxf
maxf real
#
sn
sn real
#
fileid
fileid integer
References fileinfo ( fileid )
source
Table Default.source
Pk pk_source ( id )
id
id * integer
Referred by s_peak_meta ( souceid -> id )
name
name text
t
parsing_software
parsing_software text
t
metab_compound
Table Default.metab_compound
Pk pk_metab_compound ( inchikey_id )
inchikey_id
inchikey_id * integer
Referred by s_peak_meta ( inchikey_id )
name
name text
t
pubchem_id
pubchem_id real
#
chemspider_id
chemspider_id real
#
other_names
other_names text
t
exact_mass
exact_mass real
#
molecular_formula
molecular_formula text
t
molecular_weight
molecular_weight real
#
compound_class